October 27, 2010 at 11:37 am
Hi,
I was trying :cool:something on my machine (I have Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3) ) on my machine.
:crazy:By mistake I deleted all logins excluding 2 logins, SA and my windows id. SA is disabled now & my windows id has only public access on server. I can login to the box with my windows id but not able to enable SA to set the permissions.
Can any one help me out? is there any way other then Re-installations?
Thanks,
Sachin..
October 27, 2010 at 11:58 am
October 27, 2010 at 1:08 pm
This works!!
Thanks.. :w00t: :w00t: :w00t:
June 29, 2015 at 11:54 am
AlexSQLForums (10/27/2010)
http://deepakrangarajan.blogspot.com/2008/01/forgot-sa-password-in-sql-server-2005.html%5B/quote%5D
This link is no longer available. :crying:
June 29, 2015 at 6:13 pm
The best way to fix this is to restart SQL Server in single user mode (-g) and then log in with the DAC locally as a windows admin. You'll have sysadmin privileges.
June 30, 2015 at 6:11 am
Thank you Steve, it is clear that I can only do this on the up coming holiday when not one else is using the applications. I am still concerned that my Windows Login does not have the right privileges, you know that nagging feeling that says, you are going to get to that day and find out they didn't set your account up correctly.
Do you or any one else have a suggestion on how I would be able to very my windows account?
June 30, 2015 at 6:25 am
As Steve said, you need to be a Windows admin, in other words, a member of the local Administrators group on the server. If you are, you'll be able to do what he described.
John
June 30, 2015 at 7:57 am
Please see if this helps..
http://dbathings.com/get-access-sql-server-dont-sa-password-sysadmin-access/
June 30, 2015 at 8:52 am
okay, this is a domain controller. the Systems Admin claims he gave me the correct privileges.
I want too check behind him. since this is a domain controller I cannot look in computer management, the node for users and groups doesn't exist. I have never worked with a domain controller before, so I need to know HOW to check on my login's privileges.
June 30, 2015 at 9:03 am
You'd need to be a member of Domain Admins, I believe. I would strongly recommend that you plan to relocate this instance of SQL Server to a different computer as soon as possible. As you're seeing, it's a bad idea to share.
John
June 30, 2015 at 9:46 am
This whole thing is going away, but not soon enough for me.
I was told they made me a domain Admin, and a local admin and a system admin I just want to check behind them.
June 30, 2015 at 9:54 am
Well, if you're a domain admin, you should be able to log on to the domain controller, run the AD tools, and check that you are indeed a member.
John
June 30, 2015 at 10:13 am
I am in the domain Admin and Administration groups and 2 others. so I am hoping that is all I need.
Thanks again.
June 30, 2015 at 11:27 am
At a command prompt, fire the following command:
net user yourusername /domain
The list of groups you belong to will be included in the data returned. If you see Domain Admins listed in there, you've got it. Other than Exchange or modifying the AD structure, I don't think there's anything else to be had.
Just to make sure, have the cell phone number of a domain admin with you when you go to do the work.
Also, I think John hit the nail on the head. Sharing your SQL Server with other purposes is never fun. In this case, it's the domain controller. :w00t:
June 30, 2015 at 11:43 am
Please I only inherited :hehe: The data will soon be transitioned into a new place and this server will be repurposed, but until then I will have the headache.
Viewing 15 posts - 1 through 15 (of 27 total)
You must be logged in to reply to this topic. Login to reply