MS SQL Server Error: Unable To Create The SQL Server Object

Answer: If you are trying to install Hosting Controller on a machine where MS SQL server is not already installed then you will get error Unable to create the SQL Server object.

The reason for this error is that Hosting Controller uses MS SQL DMO for handling MS SQL operations. MS SQL DMO is not present on the machine if MS SQL server is not installed. In this case, you need to install SQL Server Client Utilities on the server.

SOLUTION
Install SQL Client Utilities on the server.

To install SQL Server 7.0 Client Utilities, follow these steps:

  1. Insert the SQL Server 7.0 compact disc into your CD-ROM drive.
  2. Click Install SQL Server 7.0 Components.
  3. Click Database Server – Desktop Edition.
  4. In the Select Install Method dialog box, click the appropriate option, and then click Next.
  5. When the Welcome dialog box appears, click Next.
  6. Read the License Agreement and, if you agree, click Yes.
  7. On the User Information dialog box, type your name and company name, and then click Next.
  8. On the Setup Type dialog box, click the Custom option, and then click Next.
  9. On the Select Components dialog box, clear the Server Components check box, but leave the Client Connectivity check box selected.

    Note Management Tools and Books Online are optional components, but it is recommended that you install them. If you want to install them, click to select both the Management Tools and Books Online check boxes.

    Click Next to accept these changes.

  10. To start copying the program files, click Next.
  11. To complete setup, click Finish.
  12. Click Exit.
  13. Restart your computer.
  • 31 Users Found This Useful
Was this answer helpful?

Related Articles

How To Create Tables / Move Data to SQL Server On Hosting Server?

First step is database creation on the host server. Follow these steps: Step 1: Create SQL...

When I try to add MS SQL database, I get error

This error occurs in two cases: MS SQL services are not running Hosting Controller is...

I am not able to perform action. Error-access denied for user - root@localhost (using password: YES)

 am trying to add mySQL database but getting this error: Error: 71400050 : Unable to...

What is MySQL, MS SQL, etc?

Answer: MySQL and MS SQL are database systems. Depending on what your host provides, you can use...

What is MySQL Database?

MySQL is an open-source RDBMS (Relational Database Management System) that relies on SQL for...

Powered by WHMCompleteSolution