November 4, 2011 at 1:10 pm
Hi All,
I have MS SQL Server 2008R2 running on a remote server on my network, there are several databases set up on it. When I try to set up a data source to access the databases all I am able to link to is the master which has no tables. I've tried to type in the additional database I want to use, however it tells me it doesn't exist.
I'm using Windows Authentication to log in with an admin account for additional configuration options, but no matter what I do I only get the system database (master, msdb, tempdb) but not all the others I've created.
I hope this make sense.
Tia,
Tom
November 4, 2011 at 2:32 pm
It sounds like your Windows Authenticated login has connectivity permissions, but is not mapped to any user databases. Go the the Properties of the login, User Mapping, and check the 'Map' box next to the DBs you need to access.
_________________________________
seth delconte
http://sqlkeys.com
November 4, 2011 at 3:30 pm
OK, thanks, I mapped to everyone except user, once I mapped user I was able to select the db. I thought this was logging me in as administrator.
Now however, it's telling me I have no visible tables and fails.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply