May 31, 2011 at 12:45 pm
So on every Win2008R2 server that we have SQL2008R2 installed on, you have to open SSMS 'As Administrator' (right click the icon and select 'Run as Administrator') in order to use Windows Authentication to login on (local) or by qualifying the server\instance name. Anyone know why that may be? Has to be some OS level security thing in 2008 but not sure what.
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/
May 31, 2011 at 12:53 pm
I don't believe we've had that issue. However, we're typically connecting from remote. Do you mean when you're on the server and try to start up SSMS or do you mean connecting from a client workstation?
K. Brian Kelley
@kbriankelley
May 31, 2011 at 1:28 pm
This is the same issue you will see on Windows Vista or Windows 7. You are running into an issue with UAC - which is causing you some issues.
You can disable UAC (not recommended) - or you can disable UAC for SSMS.
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
May 31, 2011 at 1:40 pm
Jeffrey Williams-493691 (5/31/2011)
This is the same issue you will see on Windows Vista or Windows 7. You are running into an issue with UAC - which is causing you some issues.You can disable UAC (not recommended) - or you can disable UAC for SSMS.
Interesting. Do you know how to do that? I can give it a try and see if that's it.
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/
May 31, 2011 at 2:04 pm
This should get you started: http://technet.microsoft.com/en-us/library/cc709691(WS.10).aspx
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
May 31, 2011 at 4:35 pm
Jeffrey Williams-493691 (5/31/2011)
This should get you started: http://technet.microsoft.com/en-us/library/cc709691(WS.10).aspx
That worked, thanks!
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply