Hosting >> Business >> Database >> MSSQL ServerConfiguration data MSSQL Server
The data configuration data of your MSSQL Server database can be recovered in the control panel clicking on the link "MSSQL Server" visible only if the service has been activated.
Typically the data are as follow:
Host Name: sqlx.7host.com
DB Name: xxxxx
DB username: xxxxx
Hosting >> Business >> Database >> MSSQL ServerHow to connect to MySQL DB using PHP or ASP
On 7Host servers you can connect to your MSSql Server database from PHP pages and from ASP pages.
Example of connection in PHP
$dbhost = "sqlx.7host.com";
$dbname = "Nome_DB";
$dbuser = "Nome_Utente";
$dbpassword = "Password";
$db = mssql_connect($dbhost, $dbuser, $dbpassword);
Example of connection in ASP
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString = "server=sqlx.7host.com;database=Nome_DB;" _
Hosting >> Business >> Database >> MSSQL ServerHow to manage your MSSQL Server DB
It is possible to connect to your MSSQL Server DB by using SQL Server Enterprise Manager, Query Analyzer or any SQL Database Manager consoles available in the market place such as EMS MSSQL Manager, that you can download for trial.
Hosting >> Business >> Database >> MSSQL ServerHow to setup a SQL Server DB
To activate your MSSQL Server DB it is necessary to upgrade your account to MSSQL Server service. It is possible to upgrade to MSSQL Server service in the control panel, clicking on the "Upgrade" button of the domain where the service is associated.
Once you receive the activation confirmation of the service, you can create the MSSQL Server DB through the control panel of the domain where you have activated the service, clicking on the link "Manage MSSQL Server", to insert the following data:
- DB Name
- DB Username
- DB Password
The activation could take a few hours.
Hosting >> Business >> Database >> MSSQL ServerUse of MSSQL DB for more web spaces
It is possible to use your MSSQL DB on other web spaces.
Please note that the renewal has to be done only if the web space to which it is linked is not expired. In this case, you can request to move the association of your MSSQL DB to another web space contacting us on the HelpDesk.