Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL Server 2005 - cannot log in to my "local" SQL Server

Posted on 2010-08-27
1
Medium Priority
?
241 Views
Last Modified: 2013-12-13
I am unable to connect to my "local" SQL Server.  When I try to connect, I get the following error message:

a network related or instance specific error occurred while establishing a connection to SQL Server.  The server was not found or was not accessible.  Verify that the instance name is correct and that SQL Server is configured to allow remote connections.  

I have started working more recently with PHP and MySQL, so I haven't worked on anything in SQL Server for many months.  However, I have not changed anything on my PC.  Why, suddenly, would it stop working?  I can connect to any remote sites - just not my PC.  

Do I need to reinstall and reconfigure SQL Server?  I hope this isn't the case...
0
Comment
Question by:ssailer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 16

Accepted Solution

by:
carsRST earned 2000 total points
ID: 33546718
See link below and try the section titled "Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition"

http://support.microsoft.com/kb/914277
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

715 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