September 15, 2006 at 4:07 pm
Greetings
I have Sql 2005 installed on Windows 2003 Standard server. I have no domain controller in my network. When i attempt to connect to the database engine with the management studio I receive this error:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476
I have check and TCP, Shared Memory and Named pipes are all enabled in the configuration manager. I have restarted the DB and restarted the server since any config changes were made.
The link with the error say essential no information available.
Thanks for the help
Marc
September 16, 2006 at 7:21 pm
did you install sp1 for sql server 2005 ? what it's version\edition?
Follow the instruction from http://www.microsoft.com/technet/prodtechnol/windowsserver2003/library/ServerHelp/e603c463-0636-4b85-8ada-c2b99f8555ac.mspx to enable Network DTC. If you have Windows Server 2003 SP1 installed, please also make sure that you open port for MSDTC to be connected remotely by either add MSDTC.exe to the allowed list or use the command line
netsh firewall set allowedprogram %windir%\system32\msdtc.exe MSDTC enable
-----------------------
Also:
<When i attempt to connect to the database engine
is it local "database engine " or remote sql server?
September 16, 2006 at 7:23 pm
1 more:
check SQL Server Configuration Manager if the protocols are enabled
October 13, 2006 at 2:36 pm
>>did you install sp1 for sql server 2005 ? what it's version\edition?
Here is the "about" info from management studio.
Microsoft SQL Server Management Studio 9.00.2047.00
Microsoft Analysis Services Client Tools 2005.090.2047.00
Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.3790.1830
Microsoft .NET Framework 2.0.50727.42
Operating System 5.2.3790
SQLServer 2005 SP1 is noted as 9.00.2047 so I believe I am on SP1.
Marc
October 13, 2006 at 2:41 pm
>> make sure that you open port for MSDTC
I checked and the DTC is enabled.
Marc
October 13, 2006 at 2:42 pm
>><When i attempt to connect to the database engine is it local >>"database engine " or remote sql server?
I am trying to access the sql engine on the same server that is running the management studio. (Not a remote SqlServer)
Marc
October 13, 2006 at 4:46 pm
<have check and TCP>
whattcp\ip port is it using?
can you access by using IP address instead of server name?
did you rename the box after sql server installation?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply