Solved

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

Posted on 2008-10-16
1
753 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
Comment Utility
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
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…

771 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