Tuesday, March 20, 2012

Cant Access a Database via the Database Explorer

Hi,

I have been able to view the databases and all of their tables but now when I cilck the "+" next to the database or try to connect a new one i get an error message:

"Generating user instances in SQL Server is disabled. Use sp_configure 'user Instances enabled' to generate user instances"

I don't know what I have done and I don't know how to fix it, Please help me!

Best regards,

Elliot

I would do a backup first, before trying anything! Two backups!

It sounds like Sql Server wants you to enter the following command in a query window:

exec sp_configure 'user Instances enabled'

But you might want to google on that first...

|||

Thanks you didn't answer it 100% but I googled it and found the answer in another forum:http://www.mydatabasesupport.com/forums/sqlserver-faq/339672-generating-user-instances-sql-server-disabled.html

Thanks for your help,

Elliot

No comments:

Post a Comment