Jeenyusx10
asked on
Accidentally deleted windows admin account for SQL Server 2008. How to add myself back?
I got to fooling around with stuff I shouldn't have been and deleted the Login ROB-PC..
Which you will probably recognize as the windows user account, which happens to be the only user account on this computer..
I can not connect to the server when I open SSMS..
I have never used mixed mode authentication.. if that matters.
Please help
Which you will probably recognize as the windows user account, which happens to be the only user account on this computer..
I can not connect to the server when I open SSMS..
I have never used mixed mode authentication.. if that matters.
Please help
ASKER
I dont have the password for SA.. I've never used mixed mode.. always windows authentication.. I don't do anything serious just learning at this point.
Tried the second tip. No go on that as well..
Tried the second tip. No go on that as well..
ASKER
I am thinking that in order to fix this, I need to disguise myself and log in as some other entity that SQL Server knows about - If that makes sense.. I just have no clue how to do this.
When in SSMS right before I did this, I clicked on Logins and there were a few in there.. one of which was the windows user, the one I deleted. But there has got to be a way to get in. SA not being an option, I don't know what the username or password is.
When in SSMS right before I did this, I clicked on Logins and there were a few in there.. one of which was the windows user, the one I deleted. But there has got to be a way to get in. SA not being an option, I don't know what the username or password is.
Try this for SA password
http://deepakrangarajan.blogspot.com/2008/01/forgot-sa-password-in-sql-server-2005.html
http://deepakrangarajan.blogspot.com/2008/01/forgot-sa-password-in-sql-server-2005.html
I have to agree, the only chance is a "sa" login, aka some login that has sysadmin fixed server role attached.
as you are learning, this will eventually result in you to have to reinstall sql server, but then simply reattach the databases (from the .mdf/.ldf files) which are not deleted by the uninstall
as you are learning, this will eventually result in you to have to reinstall sql server, but then simply reattach the databases (from the .mdf/.ldf files) which are not deleted by the uninstall
ASKER
Ok I will try the link you gave me, and if that does not work, I will learn my lesson the hard way.
The first task on that link is to log in @OS level. I am not sure what this means though.
Everything else makes sense.
The first task on that link is to log in @OS level. I am not sure what this means though.
Everything else makes sense.
ASKER
anyone, anyone?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I knew it would be something like that!!!
About 15 minutes too late now.. I have already uninstalled!
About 15 minutes too late now.. I have already uninstalled!
Or got to sql server configuration manager
right click on the sql server in question, go to the logon tab and try resetting your logon from there