Problems with remote conexion

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(dagato2@.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, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Erland Sommarskog ha escrito:

> (dagato2@.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.|||(dagato2@.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, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspxsql