fail to login in sql authentication mode

[mhd sbt]

hi to all i want to login in sql server in windows authentication mode but i delete my user login(domanin\myname) how can i login without this user name in sql authentication mode ? thanks in advanced

[Mycroft Holmes]

Go to your SA and get them to re create your login again, prepare to be berated as an idiot! How do you expect to be able to logon if you have delete the credentials. If it is your server then use another set of creds (you do have the sa creds don't you) which have rights to security and recreate your integrated creds.

Never underestimate the power of human stupidity RAH

[mhd sbt]

ok but a forgot my sa password by anyway i re install sql server and recreate creds thanks anyway

[Mycroft Holmes]

mhd.sbt wrote:

ok but a forgot my sa password

Then yes the only solution is to re install. I think there may be a way to recover the sa but I don't know. First thing I do when setting up is create 2 sa users and put the creds into passwordsafe having lost the sa password in the past :-O

Never underestimate the power of human stupidity RAH

[Richard Deeming]

Mycroft Holmes wrote:

I think there may be a way to recover the sa but I don't know.

http://blogs.msdn.com/b/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx[^]

1. Stop the SQL service;
2. Start SQL in single-user mode with the -m parameter;
3. Log in using a local administrator account;
4. Add your account to the sysadmin role and/or reset the sa password;
5. Re-start SQL without the -m parameter;

---

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

[Mycroft Holmes]

I just know I am going to need that sometime in the future, thank you.

Never underestimate the power of human stupidity RAH