|
|
How to enable user instance in SQL Server
Sat, 03/20/2010 - 03:20
I was facing a problem with my SQL server, message was like this
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed
I searched for solutions and was able to find that this can be done by enabling user instance in SQL server.How can we enable user instance in SQL server.
Similar entries
- How to resolve "Failed to generate a user instance of SQL Server due to failure in
- SQL Server does not allow remote connections Error 26
- No process is on the otherend of the pipe Microsoft SQL Server Error: 233
- Data Source Name(DSN) Connection to database in ASP using DSN
- Cookies for session management in ASP.NET
- 500 - Internal server error generic error message in ASP pages
- solution to Access to the path is denied asp.net
- How to remove read only attribute of shared folders
- Howto enable remote desktop in windows XP.
- solution to winsock error
in order to enable user instance in SQL server, Simply go to query window and run the following query
exec sp_configure 'user instances enabled', 1.
Go
Reconfigure
dont forget to restart your SQL server after running this query