Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 2 down vote favorite

Hell all

I am new to windows server 2008 and we are trying to transfer our website from hosting to virtual server.

I installed SQL Server 2008 Express edition and I did the things like opening port and allowing them through the firewall but I can't log into to the remote server from my local machine.

I am not quite sure which IP address to use to connect to SQL Server from local machine whether is it servers IP address or will SQL give us a different IP address.

Please help.

Thanks

share|improve this question
1  
The Express editions don't support remote connections by default - you need to enable remote connections on SQL Server 2008 Express – marc_s Mar 12 '12 at 12:35

migrated from stackoverflow.com Mar 12 '12 at 12:58

2 Answers

up vote 2 down vote

You will be using the servername (DNS) or the IP address of the server. But if you have a named instance (as opposed to the default instance), your servername will be followed by \instanceName.

So, in other words unless you changed any SQL Server Express install defaults, you should connect to the server like this:

yourServerName\sqlexpress

SQL Server Express has a default named instance name of SQLEXPRESS. Also, since SQL Server Express is a named instance, you'll need to ensure that your SQL Server Browser service is running.

Another one. If you are trying to connect to SQL Server from a separate machine, you'll need to ensure that the TCP/IP protocol is enabled for SQL Server.

The above two points can be verified and configured in SQL Server Configuration Manager.

share|improve this answer
Also if you are connecting to a named instance remotely you will need to open up a firewall port for 1434 and make sure that the SQLBrowser service is running so it can translate the named instance into a port and then redirect your client connection. – Jason Cumberland Mar 13 '12 at 17:24
up vote 1 down vote

If you use Sql Management Studio to connect to your database server, all you need to do is to enable Sql Server Browser service on the Windows Server 2008. You will find that in Sql Server Configuration Manager -> Sql Server Services -> Sql Server Browser.

If it's a development machine or a VM you could disable windows firewall.

Also follow the steps from here: http://www.linglom.com/2007/08/31/enable-remote-connection-to-sql-server-2005-express/

share|improve this answer
thanks it iss working now – VBdev Mar 12 '12 at 15:41

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.