connection string with windows authentification sql serveur 2008 - Using Umbraco and getting started - our.umbraco.com

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

John ben 78 posts 293 karma points

Aug 02, 2017 @ 08:26
0

connection string with windows authentification sql serveur 2008
Hi

i was using sql authentification here is my connection string
```
<add name="umbracoDbDSN" connectionString="server=*****;database=*****;user id=sa;password='****'" providerName="System.Data.SqlClient" />
```
but when i switched to windows authentification with my client could'nt detect my database

here is my connection string
```
<add name="umbracoDbDSN" connectionString="server=*****;database=*****;Integrated Security=True; providerName="System.Data.SqlClient" /> 
```
Best regards
Copy Link
David Hutson 48 posts 379 karma points

Aug 02, 2017 @ 09:33

100

Hi,

There is not much to go on from your message but it's most likely a permissions issue.

Have you checked how the app pool identity is setup that is running the Umbraco site in IIS.

Take a look at these articles https://blogs.msdn.microsoft.com/ericparvin/2015/04/14/how-to-add-the-applicationpoolidentity-to-a-sql-server-login/

https://www.syncfusion.com/kb/6897/how-to-add-permission-for-iis-application-pool-to-access-sql-server-database

Hopefully this will help.

Dave

Copy Link
John ben 78 posts 293 karma points

Aug 02, 2017 @ 13:29

0

Thanks dude , great help

Just had to change my config in the pool so that it can access the database in my system.

Best regards

Copy Link
is working on a reply...

Please Sign in or register to post replies

Write your reply to:

Editor

Preview

Draft