December 5, 2003 at 12:23 pm
We use mix login for SQL Server 2000. The network person has an account in the "test" database and can access the "test" database via query analyzer but does not have access to Enterprise Manager. The user is a DBO in his "test" database. He receives the following error while starting enterprise manager:
A connection could not be established on Sqlservertest
Reason: SELECT permission denied on column 'loginname' of
objects 'syslogins', database 'master', owner 'dbo'..
I have checked the master database and there are no select priviliges on syslogins for public, but no one else is having an issue and all of the rest of the SQL Server databases are setup the same way. Any ideas why this user can not get on Enterprise Manager?
December 5, 2003 at 1:19 pm
In Enterprise Manager check under Security/Logins. Find the user and see what the Default database is. It sounds as if you have it pointing to MASTER instead of Test.
Bonne Chance
Dr. Peter Venkman: Generally you don't see that kind of behavior in a major appliance.
Patrick
Quand on parle du loup, on en voit la queue
December 5, 2003 at 1:21 pm
His default database is set to "test" database.
December 5, 2003 at 6:41 pm
check the account login that EM is using
HTH
* Noel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply