|
Microsoft SQL Server
Microsoft SQL Server is a high-end database platform designed
to handle multiple concurrent users and high load environments. It is the
ideal replacement for your Microsoft Access database when your web site
out grows the capabilities of the Microsoft Access database engine.
Installing Microsoft SQL Server
Microsoft SQL Server can be installed using the SQL Server page, click
'Install Microsoft SQL Server'. You will be asked to specify the type
of server you wish to create the database upon, and the SQL Server database
password. Click on 'Next' to proceed. You will have the opportunity to
review your request before your Microsoft SQL Server database is created.
Click 'Install Microsoft SQL Server'.
Changing Microsoft SQL Server Password
You may modify the password for your Microsoft SQL Server database. Click
'Change Microsoft SQL Server Password' on the SQL Server page, enter the
new password into both boxes displayed and click 'Change Microsoft SQL
Server Password'. Your Microsoft SQL Server database password will be
updated immediately.
Uninstalling Microsoft SQL Server
If you have installed Microsoft SQL Server and no longer need it, it can
be uninstalled using the SQL Server page, click 'Remove Microsoft SQL
Server'. You will be asked to confirm the action before Microsoft SQL
Server is actually removed from your account. On confirmation your Microsoft
SQL Server database including all its contents will be erased.
Accessing Microsoft SQL Server
To access your Microsoft SQL Server database, use the following credentials.
| Username |
your provided username |
| Password |
The password you define when installing SQL Server |
| Database |
your provided database |
The database server hostname you connect to depends upon whether you
are accessing the database server from an ASP page on one of our web servers
or from an external machine outside our network.
When accessing the database server from an ASP page on our web server,
use the hostname 'mssqlX' where X is the number of the database server
your database is hosted on which you can obtain from the SQL Server page.
You should connect on the standard SQL server port number which generally
means there is no need to implicitly specify a port number. A suitable
ASP connection string would therefore be as follows.
"Provider=SQLOLEDB; Data Source=mssqlX; Initial Catalog=db;
User ID=userid; Password=PASSWORD; Network Library=dbmssocn;"
Using the abbreviated hostname as shown above for connections from ASP
pages ensures that traffic to and from your database travels over our
private switched network, yielding maximum performance and availability
for your database driven web pages.
When accessing the database server from an external machine, use the
hostname mssqlX.turbodns.co.uk where X is the number of the database server
your database is hosted on which you can obtain from the SQL Server page.
You should connect on the non default port number 5000. You cannot connect
to our SQL servers on the standard port number from outside our network
as it is blocked by a firewall for security. In Enterprise Manager you
can specify the port number by appending the hostname with a comma followed
by the port number, or you can change the default port number for your
PC using the Client Network Utility.
Notes on Microsoft SQL Server
You will be provided with 100 megabytes of data space. You will be provided
with one security login per database, this login will have the privileges
db_datareader, db_datawriter and db_ddladmin. You cannot create additional
user accounts for your database, nor can you add privileges additional
to those aforementioned. Any functionality of Microsoft SQL Server which
requires privileges not mentioned or non standard software components
including replication and XML will not be available.
|
