I am working with 3 SQL 2000 Machines. I manage them by assigning Windows 2000 groups as logins. All of this is fine except that on one server, I belong to a Windows group which gives me certain rights.
I log into my Windows 2000 machine using my domain account which is in the Windows group, When I go into Enterprise Manager I get a message "unable to access default database" and I can not log in. If I put my Windows account into the SQL logins everything is OK. No one else has this problem and I only have it on one server. Anyone?Check the domain account default database. Maybe the account does not have access rights for the default database. (if not then map the account to that DB,or change the default database for another one which have the appropriate rights).
When you log in using Enterprise Manager, SQL checks only the login permission not the access rights, that's why the connection is allowed.
Originally posted by courtjs
I am working with 3 SQL 2000 Machines. I manage them by assigning Windows 2000 groups as logins. All of this is fine except that on one server, I belong to a Windows group which gives me certain rights.
I log into my Windows 2000 machine using my domain account which is in the Windows group, When I go into Enterprise Manager I get a message "unable to access default database" and I can not log in. If I put my Windows account into the SQL logins everything is OK. No one else has this problem and I only have it on one server. Anyone?|||Check with SP_HELPLOGINS.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment