SQL Server Management Studio connection issue -


i using sql server 2008 enterprise on windows server 2008 enterprise. server runs sql server 2008 machine m1. have tried using sql server management studio on machine m2 connected m1. can not use machine m3 connect m1. ideas wrong? not sure whether issue @ m1 side or m3 side? check list?

error message is, provider: named pipeline provider program, error 40 -- can not open connection sql server (microsoft sql server: error 53).

thanks in advance, george

on m1 need enable tcp/ip in sql server configuration manager, under "protocols mssqlserver". in addition need open @ least port 1433 in windows firewall


Comments

Popular posts from this blog

windows - Why does Vista not allow creation of shortcuts to "Programs" on a NonAdmin account? Not supposed to install apps from NonAdmin account? -

c++ - How do I get a multi line tooltip in MFC -

unit testing - How to mock PreferenceManager in Android? -