Support for Windows Accounts
A division of WAASI	For Standard Plans or Dedicated Servers please click here.

Windows Support Home > Connecting to your SQL database 

How the client works with the database.

Warning: As the client you are set to DB owner. This gives you full control of your database including delete.  MS SQL keeps the databases locked where they can't be backed up on tape. As DB owner you have the option of backing up your database through your enterprise manager.  We have no way to back it up, but you do. If you delete your database we won't have a backup of it.  It is your responsibility to backup your database from your enterprise manager.

The client connection. 

The following was created using SQL 2000 on a Windows 98 machine. In this case only the client tools are loaded. If you are using NT or Win 2000 server you will have a local SQL server running as well.  We used Win 98 to demonstrate that you can use even a desktop operating system and still be able to log into the remote SQL server. These instructions will also work with SQL 7.0.

Step 1: This step is very important.  Open the network client utility in your SQL program group on your local machine. Select the Alias tab as shown below.

Step 2:  Click TCP/IP on the left part of the screen. Enter the SQL servers main IP number. If you are unsure of this number ask technical support for the information.  Click the OK button and you will return to the main screen.  Click ok again to close the client network utility.

Step 3: Open your SQL Enterprise Manager on your local machine. As shown below. Right click on SQL server group and select New SQL Server Registration.

If you see the screen below, just click Next.

Step 4: On the screen below highlight the server IP you setup in the Client Network Utility and click the Add button, then click Next.

Step 5: Make sure that the screen below has SQL Server login as the authentication mode, then click Next.

Step 6:  Enter your login information and click Next.

Step 7:  When the screen below is shown make sure it looks as this one does and click Next. On the following screen click Finish.

Step 8: You are done with the connection. Click close to be returned to your Enterprise manager.

You will be able to open and work with the remote SQL server.  You will be able to do whatever you like with your database but only your database. You will not be able to work with other databases on the server.  You are set as the database owner of your database which means that you can even back it up when you like.

If the above instructions don't work for you make note of the error message you receive. Your ISP must allow traffic to pass on port 1433 in order to work with a remote MS SQL server. 

We do not provide training on how to work with SQL server to develop your database.  We would suggest that you visit your local library or book store as there are many good books on the subject. If you like we can refer you to an SQL developer.