Hello,
I believe that Remote connection is enabled on MSSql10 ... When I'm trying to connect to the server using the Connection String (ASP.NET 2.0 C#) ... it's giving me the following error:
I have tried all possible connection methods which I could find ... typically speaking ... the string which I have used is something like:
<connectionStrings>
<add name="connection" connectionString="Data Source=64.187.103.158,1433;Network Library=DBMSSOCN;Initial Catalog=xxxxxxx;uid=xxxxxx;pwd=xxxxxxxxxxx"></add>
</connectionStrings>
<connectionStrings>
<add name="connection" connectionString="Data Source=64.187.103.158,1433;Database=xxxxxxx;uid=xxxxxx;pwd=xxxxxxxxxxx"></add>
</connectionStrings>
... and so on ...
What I am trying to do is program a page which would be hosted elsewhere but can access the database resting on mssql10 !!!
ANY SUGGESTIONS - HELP - ASSISTANCE !!! ... PLS
Regards,
Ani
I believe that Remote connection is enabled on MSSql10 ... When I'm trying to connect to the server using the Connection String (ASP.NET 2.0 C#) ... it's giving me the following error:
Server Error in '/' Application.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A socket operation was attempted to an unreachable host.)
I have tried all possible connection methods which I could find ... typically speaking ... the string which I have used is something like:
<connectionStrings>
<add name="connection" connectionString="Data Source=64.187.103.158,1433;Network Library=DBMSSOCN;Initial Catalog=xxxxxxx;uid=xxxxxx;pwd=xxxxxxxxxxx"></add>
</connectionStrings>
<connectionStrings>
<add name="connection" connectionString="Data Source=64.187.103.158,1433;Database=xxxxxxx;uid=xxxxxx;pwd=xxxxxxxxxxx"></add>
</connectionStrings>
... and so on ...
What I am trying to do is program a page which would be hosted elsewhere but can access the database resting on mssql10 !!!
ANY SUGGESTIONS - HELP - ASSISTANCE !!! ... PLS
Regards,
Ani