June 4, 2012 at 2:55 pm
I have been using a domain account to log onto our SQL Server and into SSMS. I can connect to all system and user database and administer them. This domain account basically has the same SQL permissions as the 'sa' account. What I can't understand is that there is NO SQL Login listed for this domain account, nor can even add one. If I attempt to add the domain account as a login, the message I receive is
An object (User or Built-in security principal) with the following name cannot be found...
How is this even possible? I've searched around, but have not found anyone with this same setup.
BTW - I did not set up this server or install SQL Server. I inherited it.
Thank you for any help you might be able to provide.
June 4, 2012 at 10:55 pm
Run
exec xp_logininfo '<domain account'
It should provide you with the information as to what group the user resides in which provides the access which will help you track things down.
June 5, 2012 at 9:23 am
Thank you so much, this answered my question!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply