Problems with remote conexion

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • dagato2@terra.es
    #1

    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

    Tags: None
    • Erland Sommarskog
      #2
      Re: Problems with remote conexion

      (dagato2@terra. es) writes:[color=blue]
      > 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?[/color]

      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\SQLEXPR ESS.


      --
      Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

      Books Online for SQL Server 2005 at
      http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

      Books Online for SQL Server 2000 at
      http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

        Comment

        • dagato2@terra.es
          #3
          Re: Problems with remote conexion


          Erland Sommarskog ha escrito:
          [color=blue]
          > (dagato2@terra. es) writes:[color=green]
          > > 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?[/color]
          >
          > 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\SQLEXPR ESS.
          >[/color]

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

            Comment

            • Erland Sommarskog
              #4
              Re: Problems with remote conexion

              (dagato2@terra. es) writes:[color=blue]
              > I found the problem, I didnt have enabled sql browser.[/color]

              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@sommarsk og.se

              Books Online for SQL Server 2005 at
              http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

              Books Online for SQL Server 2000 at
              http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

                Comment

                Previous template Next
                Working...