August 25, 2012 at 12:10 am
I got a new machine fully loaded with all software installed which are required for development/QA. In these software I have SQL Server (2008 developer edition - may be) also installed on my local machine, services are running but when i try to login with my windows credentails it does not login by saying login failed for myCompanyDomain\MyLoginId, I don't have sql user loginId and pwd. The guy who installed this SQL Server no longer available in this company now. How do I connect to SQL Server? Is there any way to assign sa rights to my windows user or can i get reset sa password? plz. help
Shamshad Ali.
August 25, 2012 at 3:27 am
On connect to server screen you can choose server name as local and Authentication as "Windows Authentication" to login.
Lohith
August 25, 2012 at 3:29 am
As i mentioned earlier in detail that Windows authentication is not working.
Shamshad Ali
August 25, 2012 at 8:29 am
with sql server 2008 there is a back door, if you have admin on your machine you can start sql server in single user mode and then add an account with sa rights
•log on ato the machine as an account with local admin
•stop sql server
•at the command prompt, start sql in single user mode (-m flag)
•open up a command prompt and use sqlcmd to add an account with sa rights
•stop sql server (ctrtl-c in command window), restart sql in normal mode.
---------------------------------------------------------------------
August 25, 2012 at 10:35 am
Thanks, this is what I was looking for. I used this technique atleast 10 years ago with SQL server 2000 but forgot these steps. I will try it on Monday in office. Thanks a lot.
Shamshad Ali.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply