Connecting to Database
-
To connect to database (sql server) im using the following con = New SqlConnection("Network Library =DBMSSOCN; server =ipaddress; database = dvk; user id = sa; password ="";timeout = 60") where ipaddress is the server ipaddress and it is like this 20.0.0.200 but recently my server ip adress is changed and i replaced it in the connectionstring but it is not working it is showing that webserver not found. should i configure the sqlserver with new ipaddress
-
To connect to database (sql server) im using the following con = New SqlConnection("Network Library =DBMSSOCN; server =ipaddress; database = dvk; user id = sa; password ="";timeout = 60") where ipaddress is the server ipaddress and it is like this 20.0.0.200 but recently my server ip adress is changed and i replaced it in the connectionstring but it is not working it is showing that webserver not found. should i configure the sqlserver with new ipaddress
You have to make sure the SQL Server is configured properly to allow for remote access.
I know the language. I've read a book. - _Madmatt
-
To connect to database (sql server) im using the following con = New SqlConnection("Network Library =DBMSSOCN; server =ipaddress; database = dvk; user id = sa; password ="";timeout = 60") where ipaddress is the server ipaddress and it is like this 20.0.0.200 but recently my server ip adress is changed and i replaced it in the connectionstring but it is not working it is showing that webserver not found. should i configure the sqlserver with new ipaddress
This is a classic example of why you should not refer to your servers by IP address, if the network guys reconfigure your network, boom ! Your applications break. Let the network guys do their thing, let the developers do theirs. I'm getting off my soapbox now. :rose:
-
This is a classic example of why you should not refer to your servers by IP address, if the network guys reconfigure your network, boom ! Your applications break. Let the network guys do their thing, let the developers do theirs. I'm getting off my soapbox now. :rose:
While I agree that server names are better, I have had just as much trouble with Network guys F* up the DNS requiring the use of IP Addresses instead as the more reliable solution. There has been a noticeable increase in lazy sys-admins.
Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. I also do Android Programming as I find it a refreshing break from the MS. "And they, since they Were not the one dead, turned to their affairs" -- Robert Frost
-
To connect to database (sql server) im using the following con = New SqlConnection("Network Library =DBMSSOCN; server =ipaddress; database = dvk; user id = sa; password ="";timeout = 60") where ipaddress is the server ipaddress and it is like this 20.0.0.200 but recently my server ip adress is changed and i replaced it in the connectionstring but it is not working it is showing that webserver not found. should i configure the sqlserver with new ipaddress
Is it the same server or are you pointing to a new server? If it is a new server make sure it is configured to accept TCP connections and not just named pipes if you are going to specify the network library. Are you sure there are no firewalls in between your web server and SQL server that could be restricting traffic on port 1433? Oh and by the way NEVER EVER EVER EVER use the sa account.
-
This is a classic example of why you should not refer to your servers by IP address, if the network guys reconfigure your network, boom ! Your applications break. Let the network guys do their thing, let the developers do theirs. I'm getting off my soapbox now. :rose:
as u said,i given the server name instead of ipaddress like this con = New SqlConnection("Network Library =DBMSSOCN; server =server1ABN; database = dvk; user id = sa; password ="";timeout = 60") but i get this 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 - No such host is known.) all configurations are enabled to Sqlserver. only a ipadress of the server is changed. if ipadress of the server is changed then do we have to reconfigure the sqlserver with new ipadress from the past 1 week the website is running properly now the same server is configured with a new ipaddress This problem occurred with the changing of ipaddress can u help me
-
You have to make sure the SQL Server is configured properly to allow for remote access.
I know the language. I've read a book. - _Madmatt
im using SQLSERVER 2000 and it is configured to allow remote access till now i gone through connecting server using ip address can u tell me ,what settings to be made to server for connecting it through server name. my server name is BDPLServer1 and i have a small doubt regarding this if any one trying with the same server name and accessing my database is it possible
-
im using SQLSERVER 2000 and it is configured to allow remote access till now i gone through connecting server using ip address can u tell me ,what settings to be made to server for connecting it through server name. my server name is BDPLServer1 and i have a small doubt regarding this if any one trying with the same server name and accessing my database is it possible
If you can connect via the IP address but not using the DNS name, then it would seem to indicate you have an issue with you machine not being able to resolve the DNS. Contact your network people.
I know the language. I've read a book. - _Madmatt
-
If you can connect via the IP address but not using the DNS name, then it would seem to indicate you have an issue with you machine not being able to resolve the DNS. Contact your network people.
I know the language. I've read a book. - _Madmatt
i can access the sqlserver using the server name in my local system in my system there is no sqlserver installed and when i upload the page and run it on browser then it does not work.