April 14, 2009 at 11:45 am
Interesting issue...
I just installed SQL 2005 on Windows Server 2008.
I can connect to the SQL instance using Windows authentication remotely from a server running Server 2003, but I can't connect to the instance from SSMS locally.
Both are on the domain, and I'm logging in with the same user on both. I know my Windows/Domain authentication is working because I can connect to shares and other resources just fine.
I've disabled the firewall just to rule it out, but no dice.
Any suggestions?
The Redneck DBA
April 14, 2009 at 12:29 pm
Are you getting an error?
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
April 14, 2009 at 12:33 pm
I was getting a login failed error.
Actually I just figured it out.
Apparently Server 2008 is like Vista and doesn't put admins in the sysadmin role automatically, you have to use that provisioning tool for Vista.
I'm not too sure how that is supposed to be more secure since it let me connect remotely just fine.
The Redneck DBA
April 14, 2009 at 12:38 pm
That was where I was heading - but needed to see the error message.
The problem usually does not show up with a connection (login) problem. Usually it shows up as a problem trying to start/stop services or any other administrator level activity.
Anyways, glad you figured it out.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply