How to connect to SQL 2005 express edition instance created by sharepoint services through SQL management studio

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)
Who is Participating?
jorge_torizConnect With a Mentor Research & Development ManagerCommented:
Use the named pipes protocol, you can see the connection string in your Sql Server Configuration Manager... go to SQL Server 2005 Network Configuration -> Protocolos for YOUR_INSTANCE -> choose named pipes and see its properties.

In "pipe name" you can see the string that you must put in your target server to connect... put it full
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.