How to connect to SQL 2005 express edition instance created by sharepoint services through SQL management studio
Posted on 2008-10-16
When Sharepoint services 3.0 is installed, it created an instance of SQL express edition by default.
When we tried to connect to this instance through SQL management studio,we get this error
"An error has occurred while establishing a conneciton to the server. when connecting to SQL server 2005, this failure may be casued the the fact that under the default settings SQL server does not allow remote connections. (provider: SQL Interfaces, error: 26- Error locating server/instance specified)