Knowledge Base

Result search in category MSSQL-Server New Search
Hosting >> Business >> Database >> MSSQL Server
Configuration 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
Password: xxxxx
Port: 1433

 
Hosting >> Business >> Database >> MSSQL Server
How 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);
mssql_close($db);
?>

Example of connection in ASP
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString = "server=sqlx.7host.com;database=Nome_DB;" _
"uid=Nome_Utente;pwd=Password;driver=DRIVER={SQL Server}"
Conn.Open
%>

 
Hosting >> Business >> Database >> MSSQL Server
How 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 Server
How 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 Server
Use 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.

 
New Search
This website uses cookies. Some of these cookies have been set already. More information can be read in our privacy policy.
You can accept our cookies by clicking here or by continuing to use the site