Stupid bloody idiot
-
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 :mad:
Never underestimate the power of human stupidity RAH
-
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 :mad:
Never underestimate the power of human stupidity RAH
-
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 :mad:
Never underestimate the power of human stupidity RAH
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
-
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
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
