By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,414 Members | 1,586 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,414 IT Pros & Developers. It's quick & easy.

Problems with remote conexion

P: n/a
Hi all,
I have installed SQL SERVER 2005 EXPRESS but i cant do a remote login
with SQL Server Management Studio Express. I have deactivated Windows
XP firewall in the SQL SERVER side and I have activated tcp/ip
connections. Which can be the problem?
Thanks all

May 16 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
(da*****@terra.es) writes:
I have installed SQL SERVER 2005 EXPRESS but i cant do a remote login
with SQL Server Management Studio Express. I have deactivated Windows
XP firewall in the SQL SERVER side and I have activated tcp/ip
connections. Which can be the problem?


First of all, deactivating the Windows firewall sounds like a bad idea. You
may have to open the ports on which SQL Server listens, or list the
machine you are connecting from as an exception.

Next, I will have to ask you for clarification. On which machine have you
installed SQL Express? On which machine have you installed Mgmt Studio
Express? To which server instance do you try to connect?

Keep in mind that by default SQL Express installs as a named instance, so
if you install SQL Express on a machine named DAGATO2, you should connect
to DAGATO2\SQLEXPRESS.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
May 16 '06 #2

P: n/a

Erland Sommarskog ha escrito:
(da*****@terra.es) writes:
I have installed SQL SERVER 2005 EXPRESS but i cant do a remote login
with SQL Server Management Studio Express. I have deactivated Windows
XP firewall in the SQL SERVER side and I have activated tcp/ip
connections. Which can be the problem?


First of all, deactivating the Windows firewall sounds like a bad idea. You
may have to open the ports on which SQL Server listens, or list the
machine you are connecting from as an exception.

Next, I will have to ask you for clarification. On which machine have you
installed SQL Express? On which machine have you installed Mgmt Studio
Express? To which server instance do you try to connect?

Keep in mind that by default SQL Express installs as a named instance, so
if you install SQL Express on a machine named DAGATO2, you should connect
to DAGATO2\SQLEXPRESS.


I found the problem, I didnt have enabled sql browser.
Thanks for the answer.

May 16 '06 #3

P: n/a
(da*****@terra.es) writes:
I found the problem, I didnt have enabled sql browser.


Yeah that one as well! Thanks for posting back! Maybe one day I will
be able to remember all things that can go wrong with connection!
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
May 17 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.