SQL Server 2005 Connectivity -- sql server clients

Noor
9/7/2007 3:26:16 PM

Dear Professional,

I would really appreciate if any one help me out.

I have a Windows 2003 RS Service Pack 2 Server that has SQL Server 2000
installed on Default instance and SQL Server 2005 Named Instance.

I enable all the Protocol, Add the SQLBrowser, SQLServ.exe into Exception
List in Firewall as well as enable remote connectivity.

I connected SQL Server 2005 and SQL Server 2000 from one of
our XP client through SQL Server Management Studio, works perfactly fine.

I have another box that has Windows 2003 installed as well as SQL
Server 2005 client installed when I tried to connect to SQL Server 2000 from
SQL Server Management Studio it works fine but when I tried to connect to
SQL Server 2005, I got the following error.

[quoted text, click to view]

I would really appreciate if any one can guide me, may be when Server to
Server talk we have to enable any thing as Web Server has Windows 2003
installed and Database Server also has Windows 2003 installed?
I also updated the MDAC 2.8 on all the boxes but failed to connect. Please
advice.

Thanks

Ekrem_Önsoy
9/8/2007 12:30:46 AM

Can you tell me what Edition of SQL Server 2005 do you use?

Because in SQL Server 2005 Express Edition and Standard Edition, remote
connections are not allowed by default. So if you are using on of these
Editions then you will need to make appropriate configuration settings from
SQL Server Surface Area Configuration.

--
Ekrem Önsoy
MCBDA, MCTS: SQL Server 2005, MCSD.Net, MCSE, MCT

[quoted text, click to view]

Noor
9/8/2007 3:30:56 PM

I am using SQL Server 2005 Developer edition and I am successfully connected
from one of Xp box as I mentioned in my post.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clients

sql server clients : SQL Server 2005 Connectivity