The miraculous ‘1’


Hi...

 

you know sometimes a single 1 can eat your whole morning 🙂

I tried to make a user instance with MS SQL Express 2005 on my box and received the error that the machine is not configured to do so but use the command sp_configure 'user instances enabled'...

Since I did not want to do this with osql (I know I am getting old and tired) I installed Management Studio Express (find it here http://msdn.microsoft.com/vstudio/express/sql/download/), typed in the command, got no error back while executing but still the same error from Visual Studio...

OK, what I found now is that the sequence is...

Enabling user instances on MS SQL Express 2005

exec sp_configure 'user instance enabled', '1'

go

reconfigure with override

go

 

Thank you, who ever you are, for not spending the four additional bytes in your error message!!! It took my morning...but I learned a lot 😉

More on user insances here (http://msdn2.microsoft.com/en-us/library/bb264564.aspx)

Happy programming...

CU

0xff


Skip to main content