|
|
Posted by dagato2 on 05/16/06 15:59
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.
Navigation:
[Reply to this message]
|