Microsoft SQL 2000 Server

AtlantisNet > Databases & SQL
All SQL administration is performed via Microsoft's isqlw utility (SQL Server Query Analyzer). You must connect to our SQL Server via a TCP/IP sockets connection using TCP port 1433.
 
To configure your machine for TCP/IP sockets, visit: http://support.microsoft.com/support/sql/content/connect/ClientIP.asp
 
Once connected using isqlw, you may setup and administer your database.
 
We will also be happy to restore an existing SQL Server backup database to our server for you at no charge.
 
ADD NEW SERVER ALIAS VIA NETWORK LIBRARY CONFIGURATION:
  1. Click on Start, Programs, Microsoft SQL Server, Client Network Utility.
  2. Add a server alias as follows: On the Alias tab, click on the Add button. In the Server alias field, enter something like "AtlantisSQL2000". Select "TCP/IP" as the Network library for this connection. Enter "sql2000.atlantisnet.com" as the Computer name. Check the "Dynamically determine port" check box. Click on "OK".
  3. Close the SQL Server Client Network Utility by clicking on the "OK" button.
  4. Click on Start, Programs, Microsoft SQL Server, Query Analyzer.
  5. On the Connect to SQL Server window, click on the button that has the 3 small dots "..." in it which is directly to the right of SQL Server drop down box.
  6. Select the alias you created in step #2 above (AtlantisSQL2000). Click on "OK".
  7. Under Connect using, select "SQL Server authentication". Enter your Login Name and Password.
  8. Click on "OK".
  9. You should now connect to the server and the DB drop down box should contain your database name
CONNECT VIA ENTERPRISE MANAGER:
(Although we do not support it, some customers have been able to connect to our SQL Server using Microsoft's Enterprise Manager.)
  1. Click on Start, Programs, Microsoft SQL Server, Enterprise Manager.
  2. Select a SQL Server Group.
  3. On the drop down menu, click on "Action".
  4. Select "New SQL Server Registration...". The "Register SQL Server Wizard" should appear.
  5. Click on "Next >".
  6. Under Available servers, you should see the server alias you created using the "SQL Server Client Network Utility" from above (AtlantisSQL2000).
  7. Click on the server in #6 above, and then press the "Add >" button.
  8. Click on "Next >".
  9. Select "The SQL Server login information that was assigned to me by the system administrator. (SQL Server authentication).
  10. Click on "Next >".
  11. Select "Login automatically using my SQL Server account information.".
  12. Enter your Login Name.
  13. Enter your Password.
  14. Click on "Next >".
  15. Select the SQL Server Group.
  16. Click on "Next >".
  17. Click on "Finish".
  18. See if you get a status of "- Registered successfully".
  19. Click on "Close".
  20. Try to connect using this new connection.
Article ID: 48, , Modified: 3/25/2020 at 7:38 PM

Was this article helpful?

Share this article