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.
May 7, 2008 3:23 PM
May 7, 2008 6:37 PM