ClixNCash
ClixNCash

Reputation: 81

How To Connect To Remote Server IP Using MSSQL2005?

I have a following details provided by our mssql2005 database provider

Server IP : 100.20.255.34
Databaase name : insss
User: nas0
password : ymkv45SEv

i have the following connectionstring in my web.config file in my offline site as :

<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

I want

how to edit my web.config connection string mentioned above using the details provided above so that it connect to my MSSQl2005 hosting provider .... ?

I don't know how to edit connection string to do that !!

When i run my site www.vbi.volvobusesindia.com then the following error occurs in top of the page ...

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Upvotes: 1

Views: 1923

Answers (1)

Denis Ivin
Denis Ivin

Reputation: 5644

This should work just fine:

<add name="ConnectionString" connectionString="Data Source=100.20.255.34;Initial Catalog=insss;User ID=nas0;Password=ymkv45SEv;Integrated Security=False" providerName="System.Data.SqlClient"/>

Upvotes: 2

Related Questions