Microsoft SQL (MSSQL) - Creation and management of database

Úvod > Hosting and servers > Database > Microsoft SQL (MSSQL) - Creation and management of database

MSSQL Server is powerful database system from Microsoft company. Database MSSQL can be used by virtual servers running on platform Linux and Microsoft Windows Server.

It's possible to create it on webhosting package Complet and in multi hosting packages Firm and Expert or on VMS virtual servers.

What version of database we currently offer can be found with other technical information on address versions.active24.com.

 

How to create new database? 
 

  1. Log in to Control panel.
  2. Choose hosting, on which you want to create the database  (Services/Servers and hosting/Details). 
  3. In Detail of server click in category Database MSSQL on Create button.
  4. Login information to new MSSQL database will be created automatically and will be show right after the database is created. By clicking on Create button the database will start to create.

Detailed walkthrough:

  1. Using your login information log in to Control panel. Or you can ask for a new password.
  2. After you are logged in, choose virtual server, where you want to create the database (Services/Servers and hosting/Details).
  3. In Detail of server click in category Database MSSQL on Establish button.
  4. Login information to new MSSQL database will be created automatically and will be shown right after the database is created. By clicking on Create button the database will start to create.
  5. Database is now creating, as soon as the database is created, it's ready to use. You can see it in Detail of server in list of databases (within 30 minutes).
     

Change of password


Passwords to databases are encrypted, so it's not possible to simply show the ones in use.

For new password to MSSQL database can be asked by authorized request. 

 

How can I fill database with data?


The database can be accessed through web administration or by remote access. 

For connection to MSSQL database you can also use ASP script (example):

name of database server "msdb.domena.cz"  *)
name of database "databasename"
user "username"
password "passwordxxx":

ConnString = "Provider=SQLOLEDB;Server=msdb.domain.cz;Database=jmenodatabaze;User Id=username;Password=passxxx;"
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.open ConnString
SQL = "SELECT * FROM tabulka WHERE id=1" Set RS = Conn.Execute(SQL,,1)

This string is used for example by applications installed through Webmatrix, web.config contains connection:

<connectionStrings>

<clear/>

<add name="CMSConnectionString" connectionString="Persist Security Info=False;database=databasename;server=msdb.domain.cz;
user id=username;password=password;Current Language=English;Connection Timeout=240;"/>

 </connectionStrings>
NOTE: Database can be used only for services ordered at company Active24.

If you don´t have A DNS record "msdb.domain.com", use the name of your database server, the name was sent to you when the service was created, e.g. cartman.globenet.cz etc.

Remote access to database - adding IP address 
 

If you plan to manage database from your own computer remotely and not by web administration, it's necessary to allow your IP address at your chosen MSSQL, which has to be public (static). This requirement ensures the proper functioning of the database connection. 

The assignment of IP addresses to MSSQL database, you can apply through an authorized request.

 

 

 

Aktualizováno:

Ostatní články