0

I am using Windows Server 2019 on AWS (using a EC2 instance) and want to connect my website to the RDS database I set up. I'm using IIS in WS2019 to modify the connection string to try and connect to my database but having trouble.

I can use SSMS to confirm that my database is accessible but when my app runs I get a database connection error.

I've tried modifying the connection strings in IIS. Currently it is SQLConnection='data source=tsidev.cl5cfu2wi9bq.ca-central-1.rds.amazonaws.com,1433;initial catalog=tsi;integrated security=True;User ID=XXXX;Password=XXXX' but doesn't connect.

What should my connection string be? (I left out the login/password info that follows the port 1433 in the connection string above).

The error I receive is: 'System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.'

smac
  • 23
  • 2
  • 6
  • What connection error are you getting? – Rich-Lang Apr 13 '19 at 13:22
  • I get a 'System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. – smac Apr 15 '19 at 12:46
  • Try changing integrated security=False – Rich-Lang Apr 15 '19 at 19:09
  • Thanks for the response Rich. I tried that, but get the same error. – smac Apr 15 '19 at 19:58
  • 1
    SOLVED: The connection strings application in the IIS on WS2019 was overwriting the web.config file for the website. The web.config contained a variable 'providerName' which was not entered in IIS. Thanks to all that looked/responded and hopefully this will help someone else in the future. – smac Apr 16 '19 at 19:40

0 Answers0