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 Benutzer fanden dies hilfreich
War diese Antwort hilfreich?

Related Articles

How is Linux Licensed?

Linus has placed the Linux kernel under the GNU General Public License, which basically means...

Restore a database on SQL Server using .mdf, .ldf and .ndf files?

You need to attach the database rather than perform a restore. Using Enterprise Manager: Expand...

ColdFusion DSN parameters are not updated

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

Finding what packages are installed on a Linux system

For distributions that use RPM format packages, use the command: $ rpm -qa You may want to...

How to Install MRTG

Solution Steps for MRTG installation are documented as MRTG Installation Make sure MRTG is NOT...