Connecting to SQL Server
Update: Helpful tips on troubleshooting connection error messages.
Before you can work with Teratrax Source Guard, you need to establish a
connection to SQL Server. To connect to SQL Server, you need the following
information:
- Server Name (name or IP address of the server
you are connecting to. For example, SQLServ or SQLServ\Instance2 for a
named instance)
- Username and Password (not needed if you are
using Windows Authentication)
The Connect Dialog Box
The Connect dialog box is used to connect to an instance of Microsoft SQL
Server. To establish a connection, select a server in Server Explorer and
click File->Connect.
In the Connect dialog box, enter the name of the database server in the
Server Name box. Use "(local)" for the local server. Use the format
servername\instancename for named instances.
Click Windows Authentication to connect using Windows Authentication.
-Or-
Click SQL Server Authentication to connect using SQL Server Authentication.
Use the Client Network Utility to configure client protocols and
aliases that Windows should use when connecting to the server. The Client
Network Utility is part of the Microsoft Data Access Components (MDAC) and
may look slightly different based on the version of MDAC you have on your
computer.
Attempting to connect to an instance of SQL Server version 7.0, running
on the same computer as Teratrax Source Guard and SQL Server 2000, may fail
under certain conditions. To avoid this problem, make sure the only
protocol enabled in the Client Network Utility is TCP/IP.
|
