|
Question: How can I
test a SQL Server Connection with Windows ODBC?
Answer: You can test
a server or workstation connection to the SQL Server directly from
Windows by creating and testing an ODBC (Open Database Connectivity) .
Creating ODBC DSN
You
can test a computer's connectivity to the SQL Server and force a TCP/IP connection to the server by
creating an ODBC Data Source. On some computers (especially Windows 98),
it is necessary to force a manual TCP/IP connection one time to activate
the SQL communications. Try creating and testing an ODBC / DSN to ExpressMaintenance
by following the steps below:
-
Click on
Windows / Start / Control Panel
Double Click on Administrative Tools
(Note: some versions of windows, do not require this step)
Double Click on Data
Sources (ODBC)
Click the System DSN
tab
Click the Add Button
Scroll to the bottom of
the driver list and click SQL Server
Click the Finish button
Type ExpressMaintenance
in the Name & Description fields
In the Server field,
type the name of the SQL Server or the IP address if the IP is
permanent
Click the Next button
Click the "With SQL
Server authentication ..." option
Click the Client
Configuration button
Click TCP/IP option for
the network library
Make sure the Server
Alias and Server Name fields have the IP address of your server
Click the Ok button
Click the "Connect to
SQL server to obtain..." option
Enter "sa" (no quotes)
for the user name,
Use the password
of 'welcome' unless you assigned another password for 'sa' during
installation
Click the Next button
Click on "Change the
default database to:..." option
Click the Database drop
down list and select ExpressMaintenance
Click the Next button
Click the Finish button
Click the Test Data
Source button
Note the results
Repeat the
process except in steps 16 & 17 use the login of 'etuser' with a
password of 'etrik22'
Note: You can also try connecting to
the "Master" database in step 21
Note the results
If you communicate
with our support department, please provide details of results.
|
