Problem connecting SqlServer

[Alberto Vitiello]

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]

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" <alfav...@alfavictor.info> ha scritto nel messaggio
news:O#R80EC1K...@TK2MSFTNGP06.phx.gbl...

[Rick Byham, MSFT]

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
(Implies no warranty or rights)

"Alberto Vitiello" <alfav...@alfavictor.info> wrote in message
news:Oyk1RcD1...@TK2MSFTNGP06.phx.gbl...

[Alberto Vitiello]

Tks I will try

Alberto

"Rick Byham, MSFT" <ric...@microsoft.com> ha scritto nel messaggio
news:e6BcU2N1...@TK2MSFTNGP04.phx.gbl...