Database

View All Threads First Prev Next

Stupid bloody idiot Mycroft Holmes18-Nov-12 21:25 Mycroft Holmes 18-Nov-12 21:25  Yeah that's me, I have sql server express installed on my local machine so I can test stuff without polluting the development server. So I have not needed it for ages, not trying anything new on a database level recently. Well now I want to create a test database and I mislaid the blasted sa password and I don't have enough rights on the dammed thing. Apparently the only was is to re install the database Gggrrrr Never underestimate the power of human stupidity RAH Re: Stupid bloody idiot J4amieC18-Nov-12 22:39 J4amieC 18-Nov-12 22:39  Which is why you dont use SQL Authentication. I feel your pain. Been there. Re: Stupid bloody idiot Richard Deeming19-Nov-12 1:46 Richard Deeming 19-Nov-12 1:46  Alternatively, if you're a local administrator, you can restart SQL in single-user mode, log in using Windows authentication, and either reset the sa password or add yourself to the sysadmin role. 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[^] "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer Re: Stupid bloody idiot Mycroft Holmes19-Nov-12 11:43 Mycroft Holmes 19-Nov-12 11:43  Now that I did not know, have 5 for he link, thank you, you have justified the rant... Never underestimate the power of human stupidity RAH

Last Visit: 31-Dec-99 18:00     Last Update: 18-Apr-24 13:00 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.