SQL SERVER – Resolving SQL Server Connection Errors – SQL in Sixty Seconds #030 – Video

Posted by pinaldave on SQL Authority See other posts from SQL Authority or by pinaldave
Published on Wed, 24 Oct 2012 01:30:40 +0000 Indexed on 2012/10/24 5:15 UTC
Read the original article Hit count: 1140

One of the most famous errors related to SQL Server is about connecting to SQL Server itself. Here is how it goes, most of the time developers have worked with SQL Server and knows pretty much every error which they face during development language. However, hardly they install fresh SQL Server. As the installation of the SQL Server is a rare occasion unless you are DBA who is responsible for such an instance – the error faced during installations are pretty rare as well.

I have earlier written an article about this which describes how to resolve the errors which are related to SQL Server connection. Even though the step by step directions are pretty simple there are many first time IT Professional who are not able to figure out how to resolve this error. I have quickly built a video which is covering most of the solutions related to resolving the connection error.

In the Fix SQL Server Connection Error article following workarounds are described:

  1. SQL Server Services
  2. TCP/IP Settings
  3. Firewall Settings
  4. Enable Remote Connection
  5. Browser Services
  6. Firewall exception of sqlbrowser.exe
  7. Recreating Alias

Related Tips in SQL in Sixty Seconds:

What would you like to see in the next SQL in Sixty Seconds video?

Reference: Pinal Dave (http://blog.sqlauthority.com)

Filed under: Database, Pinal Dave, PostADay, SQL, SQL Authority, SQL in Sixty Seconds, SQL Query, SQL Scripts, SQL Server, SQL Server Management Studio, SQL Tips and Tricks, T SQL, Technology, Video Tagged: Excel

© SQL Authority or respective owner

Related posts about database

Related posts about Pinal Dave