TechBubbles Microsoft Technology BLOG

Enabling Remote Connections in SQL Server 2012

You  may get an error saying server was not accessible or not found  or remote connections may not be configured properly. You will receive this error when database server is down or SQL Server is not configured for remote connections. This post describes the steps to grant remote systems access to the server. In SQL Server default installation, it only allows local applications to connect but blocks the remote connections.

1. Open the SQL Server Configuration Manager from Microsoft SQL Server 2012 –> Configuration Tools Menu

image

2. Expand the SQL Server Network Configuration, from there locate your instance of SQL Server. After clicking on the desired instance of SQL Server then it displays the available protocols.

image 

Right click on Name Pipes protocol and choose enable if the status is in disabled mode. Also enable the status of TCP\IP protocol.

3. Restart the SQL Server and it should now allow incoming connections from remote machines.

About the author

Kalyan Bandarupalli

My name is kalyan, I am a software architect and builds the applications using Microsoft .NET technologies. Here I am trying to share what I feel and what I think with whoever comes along wandering to Internet home of mine.I hope that this page and its contents will speak for me and that is the reason I am not going to say anything specially about my self here.

Add Comment

TechBubbles Microsoft Technology BLOG

Follow me

Archives

Tag Cloud