1-866-278-6243
Cannot Connect to Server - Unknown error or long pause of inactivity
Cannot Connect to Server - Unknown error or long pause of inactivity
All Orders 4.X
Description
Upon trying to Open a NC Version 4 Company, an error occurs saying 'cannot connect to server or there is a long pause of inactivity or an unknown error happens
Cause:
SQL SERVER Network Protocols are not enabled
Resolution:
1. Navigate to sub-folder C:\Program Files\Microsoft SQLServer\80\Tools\Binn
2. Double click SVRNETCN.exe.
You will see a screen thatlooks like this:
3. Make sure that in addition to Named Pipes, all protocols are Enabled, select them all on the left and click "Enable".
NOTE:
IF UPON CLICKING ON SVRNETCN.EXE YOU ENCOUNTER A 126 - MODULE NOT FOUND ERROR, even when the file is visible in the directory, do as follows:
go to START -> RUN -> type "REGEDIT" .....on the REGEDIT SCREEN MODIFY THE FOLLOWING KEY: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\ClientSetup
SQLPath=C:\\Program Files\\Microsoft SQL Server\\80\\Tool BY CHANGING 'Tool' TO 'tools'
THEN DO 1 THRU 3 AGAIN
4. STOP/RESTART SQL SERVER ON THIS COMPUTER (see little tower with white circle ICON on task bar) TO ENSURE THAT ALL SETTING ARE PROPERLY SET.
More questions?
Call to speak with a NumberCruncher Solutions Consultant at:
