TestDirector:Connecting TestDirector 7.0i with MS SQL Server 7

pcl2004_27

Description

      Information needed when connection TestDirector 7.0i to a SQL Server 7.0 database


Solution

      To make your TestDirector 7.0i install go a little smoother you need to have some basic information about your SQL Server 7.0 database.

1. You need to know the Network Library (network protocol) used by your database. The default is Named Pipes (nbnmpntw.dll for client, ssnmpn70.dll for server) on the Windows NT platform. For TCP/IP the client DLL is dbmssocn.dll and the server DLL is ssmsso70.dll (using port 1433). Ask your DBA for this information or, if you have access to the SQL server, you can use REGEDIT.EXE and go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer and look at the "ListenOn" value to see what network libraries the server is using ("asking the DBA" option is easier!).

2. You need to know the server name or IP address the SQL Server database is located.

3. And depending on how your SQL Server security is set up, you may need the system administrator username/password for the database or you may not be able to connect to the database from the client-side (Try "sa" with no password - believe it or not, most people don't change the default when they install SQL).

Most of this information is in the Installation Guide, but it can still be a little confusing. I hope this helps.