Atlantis International
HomeAbout UsServicesProductsTech SupportContact UsHomePortMembers

Microsoft SQL 7 Server


Description:
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 7.0, Client Network Utility.
  2. Add a server alias as follows: On the General tab, click on the Add button. In the Server alias field, enter something like "AtlantisSQL7". Select "TCP/IP" as the Network library for this connection. Enter "sql7.atlantisnet.com" as the Computer name. Enter "1433" as the Port number. 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 7.0, 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. Under Connection Information, select "Use SQL Server authentication". Enter your Login Name and Password.
  7. Click on "OK".
  8. 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 7.0, Enterprise Manager.
  2. On the drop down menu, click on "Action".
  3. Select "New SQL Server Registration...". The "Register SQL Server Wizard" should appear.
  4. Click on "Next >".
  5. Under Available servers, you should see the server alias you created using the "SQL Server Client Network Utility" from above.
  6. Click on the server in #5 above, and then press the "Add >" button.
  7. Click on "Next >".
  8. Select "The SQL Server login information that was assigned to me by the system administrator. (SQL Server authentication).
  9. Click on "Next >".
  10. Select "Login automatically using my SQL Server account information.".
  11. Enter your Login Name.
  12. Enter your Password.
  13. Click on "Next >".
  14. Select the SQL Server Group.
  15. Click on "Next >".
  16. Click on "Finish".
  17. See if you get a status of "- Registered successfully".
  18. Click on "Close".
  19. Try to connect using this new connection,

SAMPLE ASP ADO DSN-LESS CONNECTION STRING:

Provider=SQLOLEDB;Password=password;Persist Security Info=True;User ID=userid;Initial Catalog=sqldbname;Data Source=sql7.atlantisnet.com;Network Library=dbmssocn

Copyright ©1996-2002 Atlantis International, LLC. All Rights Reserved.
Dolphin Photos Copyright ©1996 David Hofmann.