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.
change the setting of Named pipes and tcp/ip setting of your SQL server for connecting remotly
thanks for the response i did some sort of these settings but it says each time the connection timeout error
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
