SQL Server 2005 Connectivity

#1

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.

Quote:

Cannot connect to ISTCL-VSERVER\ISTCLSQL05.

------------------------------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection
to SQL Server) (Microsoft SQL Server, Error: 1326)

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

#2

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

"Ekrem Önsoy" <ekrem (AT) btegitim (DOT) com> wrote

Quote:

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

"Noor" <naissani (AT) hotmail (DOT) com> wrote in message
news:OH5KyTY8HHA.4612 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
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.

Cannot connect to ISTCL-VSERVER\ISTCLSQL05.

------------------------------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server.
When
connecting to SQL Server 2005, this failure may be caused by the fact
that
under the default settings SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection
to SQL Server) (Microsoft SQL Server, Error: 1326)

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL Server 2005 Connectivity

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

SQL Server 2005 Connectivity - 09-07-2007 , 02:26 PM

Re: SQL Server 2005 Connectivity - 09-08-2007 , 02:30 PM