1,745 questions
there are several possible issues
1) login failure - app pool account does not have access
2) invalid connection string - syntax error
3) firewall rules block access
4) sqlserver not configured for remote access
Published aspnet website fails to connect to the sql server database using IIS
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 16%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
Lerato_Dev
1
Reputation point
Published aspnet website fails to connect to the sql server database using IIS, i am using local host.
Windows development Internet Information Services
Developer technologies ASP.NET ASP.NET Core
4,815 questions
SQL Server Other
14,494 questions
{count} votes
-
Olaf Helper 47,436 Reputation points2021-12-08T14:28:12.337+00:00 That's really to less on information; please provide more details.
By just one short sentence no one can analyse the problem.Which error do you get, how does the connection string look like, is it a remote database server or on the same machine as IIS, which authentication mode is used .. and so on?
Sign in to comment
2 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com) 77,686 Reputation points Volunteer Moderator2021-12-08T16:23:53.573+00:00 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 82%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBZ%3C/text%3E%3C/svg%3E)
Bruce Zhang-MSFT 3,771 Reputation points2021-12-09T02:12:22.05+00:00 Hi @Lerato_Dev ,
Please show more information about fail connection. Screenshoots, error code and error message.
In most cases, the connection problems I have encountered are caused by permissions. So please check if the application pool is set to have permission to access the database. You can set permissions according to the following steps.
- Open cmd with administrator rights.
cd C:\Program Files\Microsoft SQL Server\xxx\Tools\Binn. Findsqllocaldb.exe. - Execute statements
sqllocaldb.exe create xxxx. -
sqllocaldb.exe share xxxx. -
sqllocaldb.exe start xxxx. - Open this instance, the servername is
(LocalDb)\.\xxxx, select security-logins, right click to add a user. - Login name is
IIS APPPOOL\application pool name, windows authentication, check public and sysadmin in server role, and create a new login nameNT AUTHORITY\SYSTEMin the same way.
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.Best regards,
Bruce Zhang - Open cmd with administrator rights.