We help IT Professionals succeed at work.
Get Started

How to solve SQL Server 2008 R2 error, cannot connect to SQLSERVER error 53

jd1991
jd1991 asked
on
5,115 Views
Last Modified: 2012-05-10
I have just install SQL Server 2008 R2 and the installation went perfectly.

But, I cannot access the Database with SQL Server Management Studio, I have it set to mixed mode (SQL Server authentication, and Windows Authentication) but neither work.

I have set TCP/IP and Named Pipes to enabled in the SQL Server Configuration Manager, and am no longer sure what to do.

When i try to login using either Windows Authentication or SQL Server Authentication the error I receive is:
"Cannot connect to MSSQLSERVER.
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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)"

I think my computer may not be finding the database, when I go to '<Browse for more...>' when choosing the 'Server name:' it does not find the database.

If anyone can help that would be a great help.

Thanks
Comment
Watch Question
C# ASP.NET Developer
Top Expert 2010
Commented:
This problem has been solved!
Unlock 1 Answer and 31 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE