I am developing an application with an ADO connection. I need to run a query on two different databases on the same server using an application role. When I run the query I get an error domainusername does not have a logon on database (referring to the second database). Is there any way around it? I have tried to create the same app role in both databases and it did the same.
Software/Hardware used:
ASKED:
May 7, 2008 3:23 PM
UPDATED:
May 7, 2008 6:37 PM
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.