Question for ASP.NET gurus....

[astronaut x]

So I am trying to connect a website to an SQL server database on the machine that is hosting the website.

I have managed to make the connection from my local application to a copy of the database also on my local machine.

I would assume, that when I deploy the web app to their server, that I just change the connection string in the web.config file. They supplied me with DSN, UID, and PWD variables but it seems to me I need more than that, or do I need something totalyl different?

Windows Server 2008 R2
SQL server 2008

What do I need to come up with the correct connection string?

[Ferus]

Should look like this. If it dont work, look at the eventlog on the SQL server, if you get a deny event, because your premissions is not set right

<connectionStrings>
    <add name="DefaultConnection" connectionString="Data Source=SERVERNAME\sqlINSTANCE;Initial Catalog=Databasename;User ID=sa;Password=sa" />
  </connectionStrings>

[astronaut x]

Originally Posted by Ferus

Should look like this. If it dont work, look at the eventlog on the SQL server, if you get a deny event, because your premissions is not set right

<connectionStrings>
    <add name="DefaultConnection" connectionString="Data Source=SERVERNAME\sqlINSTANCE;Initial Catalog=Databasename;User ID=sa;Password=sa" />
  </connectionStrings>

Is it possible it could be any of these other options?

https://www.connectionstrings.com/sql-server-2008/