SQL Server:
Setting Up and using SQL Enterprise Manager
Setting your Client to TCP/IP
Opening the Database Folder in SQL Server Enterprise Manager 2000 Takes a Long Time
What do I do when I get "the log file is full" error

Setting Up and using SQL Enterprise Manager
The following section explains how to setup SQL Enterprise Manager to administer your SQL Database on our servers.

Find Enterprise Manager on your computer and open it.

(Note: if you do not have a copy of Enterprise Manager, you can order an evaluation copy of MS SQL 2000 from microsoft.com)

1. Open Enterprise Manager and right click on SQL Server Group Icon and click "New Server Registration"

2. This will open start the "SQL Server Wizard"

3. At this screen, click "Next"
4. At the next screen you will need to type in our SQL Server address: YOUR SQL SERVER
5. Click the Add button to add the server YOUR SQL SERVER  to the Added servers section.

6. At the next screen check the option for The SQL Server Login information that was assigned to me. Click next

7. On the next screen check the option to "Login automatically using my SQL Server Account information.
8. Type in your username and password and click next.

9.On the next screen you want to check the option to add the SQL server to an existing SQL Group. Check this option and click next.

10. The next screen is the finish screen. Click finish and Enterprise Manager will connect.

Setting your Client to TCP/IP
Configuring the SQL Enterprise Manager to Use TCP/IP
The following section explains how to change the default setting of the SQL Enterprise Manger to use TCP/IP instead of the default named pipes.

First, click on the start button, Microsoft SQL Server, and Client Network Utility.

Next, highlight TCP/IP if it is in the left column. Click on the Enable button. If TCP/IP is in the right column, skip this step.

Then, highlight TCP/IP. Hit the up arrow until TCP/IP is at the top of the list.

When TCP/IP is on the top, hit "OK". You are done and ready to connect to your SQL database via the Enterprise Manager.

Opening the Database Folder in SQL Server Enterprise Manager 2000 Takes a Long Time
This is a known issue and can be resolved using SQL Server 2000 Service Pack 1. It must be resolved on client's machine. Please follow this link for instruction on how to resolve the problem: http://support.microsoft.com/support/kb/articles/Q282/4/16.ASP

What do I do when I get "the log file is full" error?
This error indicated that the log file for your SQL database is full. Try and run the following script in Query Analyzer:

dump tran databasename with no_log
Replacing databasename with the name of your database.

If after running that script and you still get the error, please contact support@OnlineSuites.com , please include your domain name, the database name and the SQL server that you connect to.