GoFuckYourself.com - Adult Webmaster Forum - Question for ASP.NET gurus....

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)

- Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)

- - Question for ASP.NET gurus.... (https://gfy.com/showthread.php?t=1273417)

astronaut x

07-28-2017 01:31 PM

Question for ASP.NET gurus....

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

07-28-2017 02:30 PM

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

Code:

<connectionStrings>

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

  </connectionStrings>

astronaut x

07-28-2017 04:41 PM

Quote:

Originally Posted by Ferus (Post 21919528)

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

Code:

<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/

All times are GMT -7. The time now is 07:49 AM.