Hi Chris,
If you are on HC6.1 server (
Tucano), use the following steps to connect to
SQL 2000 server:
Connecting to MS SQL DB via Enterprise Manager
How do I use Enterprise Manager to connect to my MsSQL DB?
If you are HC7 server (
Vigilant), use the following steps to connect to
SQL 2005 server:
You need to follow all the steps mentioned above except a small change, the DB server's IP should be set as '
IP\sqlexpress' (eg:
10.10.10.10\sqlexpress)
Regarding the connection strings, refer the following URL for more accurate details:
http://www.connectionstrings.com/?carrier=sqlserver
http://www.connectionstrings.com/?carrier=sqlserver2005
Let me know if you need any further help.
