I can not log in to SQL Server database after deployment

Question

I have an asp.net site that stores information from textboxes to a database. It works fine when I run it from visual studio, but once I deploy it to IIS I get the following error message

[SqlException (0x80131904): Login failed for user 'LORENZNT\TLC08$'.]

This is my connection string.

Data Source=tlc08;Initial Catalog=SingableSolutions.com;Integrated Security=true

I have been through dozens of forums and tried everything I can think of. If anyone could help me out, I would greatly appreciate it. Thanks.

Ross Presser · Accepted Answer · 2016-08-12 16:40:20Z

4

When you run under IIS, if the application pool is set to use "Application Identity" then it will the IIS computer's account to try to log into SQL Server. If you have not created a User in SQL Server corresponding to that computer account, then access will be denied.

You can either create a User in SQL Server for that account, or you can change your IIS Application Pool so it runs using a domain user account, or you can change your connectionstring to use a SQL account instead of Integrated Security.

edited Aug 12, 2016 at 16:40

answered Aug 12, 2016 at 15:49

Ross Presser

6,3082 gold badges38 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

I can not log in to SQL Server database after deployment

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related