Connect to my MSSQL database via Enterprise Manager?

To connect to your MSSQL database using Enterprise Manager, please perform the following:
1. Bring up Enterprise Manager.
2. Go to menu “Action”->”New SQL Server registration”.
3. Use IP address for Server Name – for example “113.14.15.16″.
4. Use SQL Server authentication.
5. Login name = SQL username (this will be located in your control panel H-sphere -> MSSQL Server).
6. Password = SQL password
Then, navigate to your database using the provided database list.

Your SQL server must also be set to use TCP/IP as the default protocol. To do so, you will need to run the Client Configuration utility that comes with MSSQL Server.

  • Email, SSL
  • 0 Users Found This Useful
這篇文章有幫助嗎？

Related Articles

Installation of Geotrust True Site Icon

Installation of True Site icon: Per the subscriber agreement, you are required to install the...

Backing up and restoring a MySQL database from the command line

. Shell into your box as root, then: mysqldump -a -u USERNAME -p DATABASE > FILENAME.mysql...

Change the DNS servers for the network interfaces on Windows server

In Network Connections, right-click the local area connection, and then click Properties. In...

How does memory overcommit affect PostgreSQL?

In Linux 2.4 and later, the default virtual memory behavior is not optimal for PostgreSQL....

ColdFusion DSN parameters are not updated

SYMPTOMS New CF DSN records are created.  Even the set of parameters is tried to be updated...