September 10, 2010 at 10:21 am
I have read tons of forum posts and articles here, but I still have not found my answer. I had an issue earlier with a server. I was granted Sysadmin but still couldn't get into the SQL Server 2005 instance. I assumed BuiltIn\Admins had been removed. I was able to right click SSMS and run as Admin and got in. When I did, I granted myself access (no DBA AD group exists) and noticed BuiltIn\Admins existed. Does anyone know why I wouldn't be able to connect to the SQL Server when I was Sysadmin and BuiltIn\Admins still existed?
September 10, 2010 at 10:41 am
If I need to clarify anything or post this differently, please let me know.:-)
September 10, 2010 at 7:43 pm
You were obviously able to connect to SQL Server - so, I am not sure what the problem you are experiencing is.
If you had to right-click and run as Administrator - then I have to assume that SQL Server is either running on Windows Server 2008, Windows 7 or Vista. If so, then this is an issue with UAC on those systems.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 13, 2010 at 9:38 am
I had access to the server and could see I was a member of the Admin group. However, when I tried to connect to SQL Server I could not. I did "run as admin" and was able to get into SQL Server. I thought the BuiltIn\Admin account would have been removed, however, it was still there with access. So, I did not know why I could not access SQL Server. Yes, you're right and I forgot to include this originally. Sorry...this would have helped. It is Windows Server 2008, SQL Server 2005. When you said, UAC, do you mean User Account Controls?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply