I created a new SQL user : ReportUser01, which only has the SELECT right on the Employees table of the XML_Test01 database.
I changed the “Persist Security Info” from False (default) to True.
Then, within Visual Studio, it didn’t ask me to enter User name and Password when I clicked the “Preview” tab.
However, in the Report Manager, it still ask me to enter Username and Password, how can I take away this screen ?
(Please see the attached Word file for details and related screens)