I am not able to connect sql server with sql server management studio. Help me

@1anurag1 (3576)
India
June 1, 2010 11:46am CST
I am not able to connect sql server with sql server management studio. Help me I am not able to connect sql server installed on another pc. I have two computers connected via LAN and i want to connect using SQL server 2008 management studio to sql server 2005 installed on another system. But after some time it throws an error and not connected even the server is shown in network database. What should i do. Please help me.
1 response
faisale83
@faisale83 (198)
• India
17 Jun 10
change the setting of Named pipes and tcp/ip setting of your SQL server for connecting remotly
1 person likes this
1anurag1
@1anurag1 (3576)
• India
18 Jun 10
thanks for the response i did some sort of these settings but it says each time the connection timeout error
faisale83
@faisale83 (198)
• India
18 Jun 10
change your connection string of SQL server Data Source=(local)\sqlInstance change the local to your SQL machines IP Data Source={your SQL machine IP}\SQLinstance make sure that the IP getting ping