How can I remote access SQL Server 2000/2005 Databases?
Top : General Technical Support : Microsoft SQL Server
| Article ID: |
 |
000007 |
| Rating: |
|
4.2 / 5.0 (26 votes)
|
| Views: |
|
9877 |
|
How can I remote access SQL Server 2000/2005 Databases?
|
1. Create Your MSSQL Database First
Please login to your Helm control panel and go to Domains > yourdomain.com > Database Manager. You can create your MSSQL databases and users from there. You can also take a look at Create a Database in Helm Flash Tutorial.
2. Find MSSQL Server IP for your database
You can find the server IP from Domains > Database Manager > yourdatabase in Helm.
3. Access SQL Server 2005 Database via Microsoft SQL Server Management Studio
You need to use SQL Server Management Studio to manage your 2005 databases. Here is a free one SQL Server Management Studio Express. Please always specify IP address and port number in "Server name" box.
4. Access SQL Server 2000 Database via Microsoft SQL Server Enterprise Manager
Please always specify port number in "Server" box.
5. Access SQL Server 2000 Database via SQL Web Data Administrator.
SQL Web Data Administrtator cannot work with SQL Server 2005 database. Please always specify IP and port number in "Server" box.
6. Access MSSQL Database in ASP/ASP.NET Programs.
Connection String: "SERVER=xxx.xxx.xxx.xxx,####; DATABASE=yourdatabasename; UID=yourusername; PWD=yourpassword"
|
