MPClient to singleseat using SQL express 2008 (1 Viewer)

[Rob Thomson]

Hi

Ive installed a single seat installation on win7 64 box, and a client on a win764 box. The single seat is using sql express 2008. When the client tries to connect, it fails, the logs say check the connection string, which is right. The "server" is pingable has a static ip, Ive run the firewall batch file to double check and on the client any is allowed through on 1433 and 1434 if Ive got those right, anyway the sql ports..

Is there anything else I should try, or how should I debug this, was thinking of putting management studio on and seeing if I can talk to the server db that way

Any advice on ways to proceed. Incidentally when I was using MySQL it worked first time..

TIA

 

[Jay_UK]

Hi there,

Have you checked in SQL Config Manager to ensure TCP/IP is enabled (Native Client Configuration & Server Network Configuration)?

J.

 

[Rob Thomson]

Thanks for the advice, I will have a look

 

[Rob Thomson]

Yep that fixed it although it was named pipes not tcpip....thanks again for your help

 

[Jay_UK]

Cool...

Has been a while since I had the issue and made the change.

J.