November 15, 2010 at 10:06 am
I'm a programmer at a new company. I took over a machine with MSSQL Server 2008 already installed locally. I removed the account of the old user and created one for myself and have admin rights. I run SSMS as administrator and try to connect. I'm sure I have no account set up in the server for windows authentication and can't seem to connect using SQL Server Authentication using SA and empty password. I use the name of the computer for the Server Name. That said is there a way for me to set up an account i can use to connect to the database or do I need to uninstall and reinstall the server which I hope to avoid. Its a small company and as far as I can tell we have no DBA plus most the guys are out of town anyway. Appreciate any advice/feedback.
Thanks
John
November 15, 2010 at 1:31 pm
I did not understand why you are trying to connect using SA with empty password. Back in the bad old days, everyone left the password of SA account blank. Did you install the SQL Server or did someone else install it for you? You should check with the person who installed it what is the Password for SA.
It would be wise to create windows authenticated accounts into your Local DB and then always connect using the Windows account.
-Roy
November 15, 2010 at 1:36 pm
If you don't have a SQL login with sysadmin available to you (don't know the SA password), and your domain account is not an admin..well you're a bit hosed then. You're basically looking at a reinstall.
Once you reinstall, grant sysadmin to your local administrators group..SQL 2005 did this by default but it was disabled in 2008. For a local instance, IMO, it should be there.
November 15, 2010 at 1:48 pm
One thing you can look at is to see under which account your SQL Service is running. If it is running under a windows account, you are in luck. You can login to the system with the service account and connect to the instance and add yourself as a sysadmin or reset your SA password.
-Roy
November 15, 2010 at 1:54 pm
Roy Ernest (11/15/2010)
One thing you can look at is to see under which account your SQL Service is running. If it is running under a windows account, you are in luck. You can login to the system with the service account and connect to the instance and add yourself as a sysadmin or reset your SA password.
Does that work? I could've sworn I tried that one time and I still couldn't connect under a similar circumstance..although this could've been with SQL 2000 since it was a long time ago.
November 16, 2010 at 5:50 am
But, if you are an admin of the local system, then it should allow you to connect using the windows authentication!
Regards,
Pravasis
November 16, 2010 at 6:04 am
pravasis (11/16/2010)
But, if you are an admin of the local system, then it should allow you to connect using the windows authentication!
No it wont. In SQL 2008, Local admin or domain admin does not have a login in SQL Server 2008 by default. You have to add the user explicitly.
-Roy
November 16, 2010 at 6:06 am
Derrick Smith (11/15/2010)
Roy Ernest (11/15/2010)
One thing you can look at is to see under which account your SQL Service is running. If it is running under a windows account, you are in luck. You can login to the system with the service account and connect to the instance and add yourself as a sysadmin or reset your SA password.Does that work? I could've sworn I tried that one time and I still couldn't connect under a similar circumstance..although this could've been with SQL 2000 since it was a long time ago.
If I am not mistaken, yes it will work. But you have to make sure that the Service account has the rights to login locally to the box.
-Roy
November 17, 2010 at 10:34 am
Roy
"One thing you can look at is to see under which account your SQL Service is running. If it is running under a windows account, you are in luck. You can login to the system with the service account and connect to the instance and add yourself as a sysadmin or reset your SA password."
Looking in the services dialog. Where do I figure out if its running under a windows account?
The guy who installed this server has left the company a long time ago so I don't have his log in info. There is no admin account other then mine.
November 17, 2010 at 10:57 am
Go to Services, Click on the SQL Server service, and take properties. You can see if it is running under domain account or local system.
-Roy
November 17, 2010 at 11:24 am
local system radio button is selected. don't suppose I can select this account and put my account in.
November 17, 2010 at 11:28 am
You can try to do it and then restart the system. It could wreck everything up but I do not see any other way you can get in unless you have your SA password.
-Roy
November 17, 2010 at 11:50 am
Thanks for your help Roy. If it works I'll post it. Take care.
November 17, 2010 at 9:43 pm
Thanks Roy. I have mostly worked on 2005. So, I was thinking, its the same in 2008. Thanks for the clarification.
Regards,
Pravasis
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply