Search code examples
asp.netweb-configdatabase-connectionconnection-stringdatabase-server

web.config connection string to different database server

I have two conn strings in my web.config The second of them connects to external database - the database is on different server than the current website.

  1. Is it possible?
  2. How do I write my connection string?

I have this now:

<add name="newConn" connectionString="server=www.somedomain.com;database=dbname;user id=dbuser;password=dbpass" providerName="MySql.Data.MySqlClient" />

But I'm getting error saying:

Access denied for user 'dbuser'@'currentdnsserver.com' (using password: YES)

Thanks

Solution

  • The connection I wanted to establish was between different hosting server (one on Windows, another on Linux).

    My hosting provider told me it's not possible to connecto from Windows .NET website to Linux MySQL db. Not sure why but not possible.

    Would be possible on the same hosting they said.

    Thank you for trying to help @T McKeown