Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / .NET Framework / New Users / March 2007

Tip: Looking for answers? Try searching our database.

SQL Server does not allow remote connections

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gudni G. Sigurdsson - 29 Mar 2007 10:20 GMT
Hi.
I recently had to remove SQL Server 2005 and SQL Server 2005 Express from my
system.  Then, I reinstalled the express edition.  This works locally, but
when I try to connect to a database on this computer from another computer on
my local network, I get the message:

System.Data.SqlClient.SqlException: An error has occurred while establishing
a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the fact
that under the default settings
SQL Server does not allow remote connections. (provider: SQL Network
Interfaces,
error: 26 - Error Locating Server/Instance Specified)

The message in itself is clear, but where do I change the default settings
of SQL Server?

Regards,
Gudni
Rory Becker - 29 Mar 2007 12:20 GMT
> The message in itself is clear, but where do I change the default
> settings of SQL Server?

SQL Server Surface Area Configuration

In "All Programs\Microsoft SQL Server 2005\Configuration" on my machine

Then visit "Surface Area Configuration for services and connections"

Select "Remote Connections" and  Enable things as you see fit

--
Ror
Roy Soltoff - 29 Mar 2007 16:38 GMT
I believe the other poster's comments related to SQL Server, not SQL Server
Express. Look at MSDN Article ID 555585 for the solution for SQL 2005
Express Server. You may need to install the Express Edition Management
Studio as discussed in the document.

> Hi.
> I recently had to remove SQL Server 2005 and SQL Server 2005 Express from
[quoted text clipped - 18 lines]
> Regards,
> Gudni

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.