Knowledgebase

Conection String to MS SQL 2008 DB - example

In order to connect to SQL Server 2008 from Management Studio, Enterprise Manager, Query Analyzer or other client software you can use the following SQL Server address:

mssql2008R2.aspnethosting.co.uk, 14330 or mssql.aspnethosting.co.uk, 14330

 

 

If you are using mssql2008R2.aspnethosting.co.uk you may also use SQL Server address above in your application connection strings, for example:

Server=mssql2008R2.aspnethosting.co.uk;Database=databaseName;Uid=userName;Password=password;

 


If you are using mssql.aspnethosting.co.uk you may also use SQL Server address above in your application connection strings, for example:

 

Server=mssql.aspnethosting.co.uk;Database=databaseName;Uid=userName;Password=password;

Was this answer helpful?

 Print this Article

Also Read

What is the aspnet_client Folder?

ASP.net developers should be aware of the aspnet_client folder in their web space. This folder...

How to send email from classic asp / CDOSYS /

<%Dim ObjSendMailSet ObjSendMail = CreateObject("CDO.Message")  'This section provides the...

How to enable remote IIS management for my site?

Login to your hosting control panel here http://cp.aspnethosting.co.uk then click on Web - Web...

What is FTP hostname/server address for Windows servers?

FTP server address/host name is ftp.yourdomain and port 21