Connecting Sql Server
-
hai i have a problem in connecting sqlserver my connection string is con = New SqlConnection("Network Library =DBMSSOCN; server = 210.211.225.48; database = CarDb; user id = sas; password =poi098;timeout = 60") but it is giving the following error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) please help me Thanks in advance Vijay Kumar
-
hai i have a problem in connecting sqlserver my connection string is con = New SqlConnection("Network Library =DBMSSOCN; server = 210.211.225.48; database = CarDb; user id = sas; password =poi098;timeout = 60") but it is giving the following error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) please help me Thanks in advance Vijay Kumar
Hi, at first you should check your connection string (the 'network library'-key seems not necessary to me). Have a look at http://www.connectionstrings.com/sql-server-2005[^] to verify. If this does not work check if the sql server allows remote connection. To do this, connect to the server (RDP) and open the network configuration of the sql server. There you should specify the allowed protocols. Also open the server in the management view and check if the flag is set to allow remote connections. For more details, have a look here: http://support.microsoft.com/?scid=kb%3Ben-us%3B914277&x=12&y=4[^] Regards Sebastian
It's not a bug, it's a feature! Check out my CodeProject article Permission-by-aspect. Me in Softwareland.
-
Hi, at first you should check your connection string (the 'network library'-key seems not necessary to me). Have a look at http://www.connectionstrings.com/sql-server-2005[^] to verify. If this does not work check if the sql server allows remote connection. To do this, connect to the server (RDP) and open the network configuration of the sql server. There you should specify the allowed protocols. Also open the server in the management view and check if the flag is set to allow remote connections. For more details, have a look here: http://support.microsoft.com/?scid=kb%3Ben-us%3B914277&x=12&y=4[^] Regards Sebastian
It's not a bug, it's a feature! Check out my CodeProject article Permission-by-aspect. Me in Softwareland.
thanks for u r reply but i m not using SQL server 2005 im using sql server 2000 and how should i configure -- allowed protocols and remote connection
-
thanks for u r reply but i m not using SQL server 2005 im using sql server 2000 and how should i configure -- allowed protocols and remote connection
Have a look here: http://www.sqlservercentral.com/Forums/Topic441949-5-1.aspx[^]
It's not a bug, it's a feature! Check out my CodeProject article Permission-by-aspect. Me in Softwareland.
-
Have a look here: http://www.sqlservercentral.com/Forums/Topic441949-5-1.aspx[^]
It's not a bug, it's a feature! Check out my CodeProject article Permission-by-aspect. Me in Softwareland.
even it not solved the problem every thing is ok, remote connection is also allowed is there any thing else
-
even it not solved the problem every thing is ok, remote connection is also allowed is there any thing else
Did you tried to use another connection string (without the network library)? Check if you can access the server from your client by using the management application of sql server.
It's not a bug, it's a feature! Check out my CodeProject article Permission-by-aspect. Me in Softwareland.
-
hai i have a problem in connecting sqlserver my connection string is con = New SqlConnection("Network Library =DBMSSOCN; server = 210.211.225.48; database = CarDb; user id = sas; password =poi098;timeout = 60") but it is giving the following error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) please help me Thanks in advance Vijay Kumar
-
have you allowed sql server to make remote connection?
Please don't forget to mark 'Good Answer', if you find it really a good one! Kashif
hi thanks for u r reply i allowed sqlserver to make remote connection but i have a doubt my server ip address is changed then should i do any settings to sqlserver 2000 regarding this ip address How the new ip address will be connected to sqlserver 2000
-
hi thanks for u r reply i allowed sqlserver to make remote connection but i have a doubt my server ip address is changed then should i do any settings to sqlserver 2000 regarding this ip address How the new ip address will be connected to sqlserver 2000