Hi,

Can you connect to SQL 2005 if you're not part of the domain the server is
installed in?

I installed the client and it can see my SQL 2000 server but not the SQL
2005 server.

Is it because the laptop I installed it on is not part of the domain?

If so, beside having it join the domain, is there a way to connect to it?

Thanks!
Simon

Hi,

this is not easy tell. Is SQL Server 2005 installed on the same box as SQL
Server 2000 ? Does it have a default port or any other than the 1433 port ?
If using a dynamic or any other port, do you have SQL Browser started on the
2k5 box ? If you can´t start SQL Browser for some reason, did you try to
specify the port number after the server name to make the connection using
Servername,Portnumber as the servername within your connection dialogues ?

Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

"Simon Renshaw" <simon (AT) benchmarkconsulting (DOT) com> wrote

No, 2005 and 2000 are installed on different machines. And I used the
standard ports.

By the client I meant the SQL Server Management Studio. Sorry for the
confusion.

On my station (which is part of the domain), I can access the 2005 server
using SQL Server Management Studio.

On the laptop, I cannot access the 2005 server using SQL Server Management
Studio.

"Jens K. Suessmeyer" <Jens (AT) NoSpamhere-sqlserver2005 (DOT) de> wrote