Rasmus Haslund

Virtualize everything!

  • LinkedIn
  • RSS
  • Twitter
  • YouTube
  • Home
  • Videos
  • Practice Exams
    • VMCE practice exam – Veeam Certified Engineer
  • EqualLogic
  • Veeam
  • VMware
  • About

Unable to remotely connect to new Microsoft SQL server

2012-12-28 by Rasmus Haslund Leave a Comment

I rarely do configuration of Microsoft SQL server, as usually someone else will already have installed and configured it before I arrive.

Yesterday however, I arrived at a customer with a new Microsoft Small Business Server SQL server. The installation wizard has been completed but nothing else.

I tried to connect using SQL Management Studio but recieved the following error:
SQL_Management_Studio_Error

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: 5)

As the error suggests, we need to configure the SQL Server to allow remote connections.

Simply open SQL Server Configuration Manager:
SQL_Management_Studio_Fix

Browse to SQL Server Network Configuration -> Protocols for MSSQLSERVER and change TCP/IP from Disabled to Enabled. Then restart the SQL service for the change to take effect.

As always, if this helped you please leave a comment 🙂

Filed Under: Fix IT, SQL Tagged With: fix, sql

Subscribe
Connect with
Login
I allow to create an account
When you login first time using a Social Login button, we collect your account public profile information shared by Social Login provider, based on your privacy settings. We also get your email address to automatically create an account for you in our website. Once your account is created, you'll be logged-in to this account.
DisagreeAgree
Notify of
I allow to create an account
When you login first time using a Social Login button, we collect your account public profile information shared by Social Login provider, based on your privacy settings. We also get your email address to automatically create an account for you in our website. Once your account is created, you'll be logged-in to this account.
DisagreeAgree
Please login to comment
0 Comments
Inline Feedbacks
View all comments

Sponsors

wpDiscuz