Sometimes when You change SQL DB Authentication method form SQL to Windows mode You can face with a problem.... To solve that problem you need to do few steps. I. Domain Controller Domain user wtich was used for SQL DB authentivs Windows authentication account must be in Administrator group. I have putted him into Domain Administrator group. II. Server where is SEPM. 1. Go to START -> Administrative Tools -> Internet Information Services (IIS) Manager 2. Go to Properties of Default Web Site. 3. Chose Directory Security Tab and press Edit button from Authentication and access control. 4. In User name write an account of user which you use for an SQL Windows Authentication (in my situation is account: pawel, domain: PABLOLAS). All options should be the same as in the picture. 5. Go to Properties of Symantec Web Server. 6. Chose Directory Security Tab and press Edit button from Authentication and access control. 7. In User name write an account of user which you use for an SQL Windows Authentication (in my situation is account: pawel, domain: PABLOLAS). All options should be the same as in the picture. After this reconfiguration, everything should work fine.
To solve that problem you need to do few steps.
Domain user wtich was used for SQL DB authentivs Windows authentication account must be in Administrator group. I have putted him into Domain Administrator group.
1. Go to START -> Administrative Tools -> Internet Information Services (IIS) Manager
2. Go to Properties of Default Web Site.
4. In User name write an account of user which you use for an SQL Windows Authentication (in my situation is account: pawel, domain: PABLOLAS).
All options should be the same as in the picture.
7. In User name write an account of user which you use for an SQL Windows Authentication (in my situation is account: pawel, domain: PABLOLAS).
After this reconfiguration, everything should work fine.