Solved

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

Posted on 2008-10-16
1
755 Views
Last Modified: 2013-11-27
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)
0
Comment
Question by:malarAbs
1 Comment
 
LVL 15

Accepted Solution

by:
jorge_toriz earned 250 total points
ID: 22732149
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
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now