Problem connecting SqlServer

Discussion in 'microsoft.public.sqlserver.connect' started by Alberto Vitiello, Apr 4, 2010.

  1. Situation:
    BOX A - Win xp Pro Sp3 with Sql Server Dev Edition
    BOX B - Win xp Pro Sp3 with application that have to connect to Sql
    Server on BOX A

    Sql Server with mix authentication. When I try to connect to Box A I have
    the error code 26.
    If I ping the box A from box B all is OK.

    Protocol Shared Memory and TCP/IP actived; Name Pipe and VIA disabled.

    I use the following connection string:

    txtConnection = "Data Source=x.xx.xxx.xx\SQL2K8IT; Initial Catalog=yyyyyyyy;
    Integrated Security=True; Pooling=False"

    The IP address of Box A is correct, so the Sql Instance Name and database
    name.

    Any idea? TIA

    Alberto
     
    Alberto Vitiello, Apr 4, 2010
    #1
    1. Advertisements

  2. Following. If I try to create a new Data Connection from Visual Studio 2008
    in Box B I can see the server but I cannot see the Sql Instance

    Alberto
     
    Alberto Vitiello, Apr 4, 2010
    #2
    1. Advertisements

  3. Possible problems.
    1. Windows firewall on Box A is blocking the TCP port used by SQL Server.
    Since SQL Server is a named instance, SQL Server is probably using dynamic
    ports, meaning it picks the port number at time of startup. The SQL Server
    error log will list the port. Open the TCP port in the firewall.
    2. Since Box A is a named instance, the SQL Server Browser service on Box A
    must be started, to tell Box B what the port number is. So also open UDP
    port 1434 in the firewall of Box A.
    See http://msdn.microsoft.com/en-us/library/ms345318(SQL.90).aspx for a
    short tutorial that covers this in more depth.
     
    Rick Byham, MSFT, Apr 5, 2010
    #3
  4. Tks I will try

    Alberto

     
    Alberto Vitiello, Apr 8, 2010
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.