Networks

Ask something
Question Locked

Windows vista connect to SQL server 2005

0 helpful
4 replies

by inneed

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi!

The SQL server 2005 is installed on a windows 2003 DC.
I also have a 2003 workstation (on the domain) for test and i have installed SQL 2005 and msde 2000.

I'm using windows vista SP1 32/64 machines to connect to sql server.

I cannot connect to all the SQL 2005 instances, from the vista machines.
(the management studio express - error: 26 cannot find server/instance)
(OSQL error- 53 cannot find path)

I can connect to the MSDE 2000 from vista.
i can connect to SQL 2005 (and msde 2000) from XP.

it's not the firewall, the DNS its OK, the path, server and instance names are ok.

I really don?t know what to do to find the source of the problem.

thanks for the help.

Inneed4help

4 replies

by robo_dev

In order for this to work, port 1433 must be open on the firewall, if the port is not open, then this command would fail

telnet yourservername 1433

if telnet can connect, then the port is open

OSQL can rule out ODBC issues and look for open port 1433

by 45geek

Welcome to Vista...you have to physically open the port for SQL use administrator privilages in VISTA and open port 1433 with an allow to ANY....that will fix your problem.

That way vista will accept the handshake from SQL.

by tony hopkinson

By default SQL2005 only sets up for connections by named pipe. For remote connections you need to use the 'Surface Area' tool and set them up for TCP/IP as well.

This discussion is closed to new replies.