Back

Topic

[KB428]How to connect to a SQL Server instance

Tags: MSSqlServer, SQL, SQL Server

System
14 years ago
By ACHT
Options
Print
Applies to:

PcVue all versions.
Summary:

This article is a reminder about how to connect to an SQL server 2008 R2 instance.
Details:

Here are the correct formats to connect to a local instance of SQL Server:

–          .

–          (local)
–          localhost
–          <IPAddress>
–          <ServerName>
–          .\<InstanceName>
–          localhost\<InstanceName>
–          <IPAddress>\<InstanceName>
–          <ServerName>\<InstanceName>

Do not use “.\”. This syntax is not correct.

For more details search the Micorsoft website for the document “Creating a Valid Connection String Using TCP IP”

Created on: 22 Feb 2011 Last update: 04 Sep 2024