January 21, 2010 at 7:00 am
I have a user that set up a SQL server by themself, when I learned about it I hopped in to make sure the server was set up correctly. 1st thing I noticed is that SSMS was not installed, and I was told remote connections was set to 0. Today they cannot log in, I have never been able to log in using our AD accounts, and they said that they did not install SQL Authentication only Windows. And the Built in Admin group was deleted after install.
I installed SSMS on the server, and attempted to do a run as the service account that is running the db engine can see the service is started, I can see the service account running it. However Windows 2008 only has a run as administrator option, not a run as, and then you log on with the account.
I tried SQLCMD, but that did not work either, and I could not get the command prompt to run in the run as mode either.
I could uninstall and reinstall, but was curious if there was a way to get in that I hadn't thought of
Any suggestions?
Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field
January 21, 2010 at 7:25 am
Hi,
Try logging onto the machine with the LOCAL administrator account and adding a your domain logon to the locally installed sql group. It will take the format of something like this...
SQLServer2005MSSQLUser$SERVERNAME$INSTANCE
I think this will put your domain logon into the sysadmin role.
Other than that the SQLCMD isn't always a straightforward thing to master, I found. What error did you get?
I hope that helps.
Reagdrs,
Paul
January 21, 2010 at 7:57 am
Hey Paul,
Thanks for the suggestion. Sorry i forgot to post that I had tried that one as well already. I was somewhat hopeful on it as well, because the AD service account was listed in the SQLServer2005MSFTEUser$"SERVERNAME"$MSSQLSERVER group. I added my own and still no dice.
Or at least that was what I thought, I just did the sqlcmd -e, and was able to log in, and I'm now in through SSMS as well. Not sure if it requried a reboot, but I'm in Thanks!!!
Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field
January 21, 2010 at 3:07 pm
If you don't add a windows login\group at install of SQL 2008 you will get locked out of you didn't set up the SA PW, the local windows admin group does not get BUILTIN\Administrators role as in previous versions. A way to remedy this, is to stop the SQL service and change the start up credentials to a windows account you know, your own for example, restart the service and you will then be able to login and then add the necessary windows accounts\groups and SQL accounts. After finishing you can then change the service to then use whatever account was being used before.
Andrew
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply