Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Unable to communicate with reporting component after changing SQL Database authentication method from SQL to Windows mode.

Updated: 13 Nov 2009 | 1 comment
sezam's picture
+3 3 Votes
Login to vote

 Sometimes when You change SQL DB Authentication method form SQL to Windows mode You can face with a problem....

                                                                   1.JPG

 

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.JPG 

 


2.       Go to Properties of Default Web Site.

3.JPG 


               3.       Chose Directory Security  Tab and press Edit button from Authentication and access control.

 4.JPG

 

 

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.JPG 

               5.       Go to Properties of Symantec Web Server.

 6.JPG

                   6.       Chose Directory Security  Tab and press Edit button from Authentication and access control.

 

 7.JPG

   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.

 

 

8.JPG 

 

After this reconfiguration, everything should work fine.

9.JPG

 

Comments

shp's picture
15
Nov
2009
0 Votes 0
Login to vote

Thanks for sharing.... 

Thanks for sharing.... 

Regards,
Srinivas H.P.
HCL Infosystems Ltd