Hello,
To encounter the problem of entering the user id password every time we access a report, I created another login in the SQL DB and assigned tables under SELECt role. I chose 'Set Location' and made it point to another DSN which is configured to the DB with the new user created.
In set location although the DSN is reflected it is still showing that the Userid is 'sa'.
How can I change the user id. While configuring the DSN in control pannel I have mentioned the new user id.
Please help asap
To encounter the problem of entering the user id password every time we access a report, I created another login in the SQL DB and assigned tables under SELECt role. I chose 'Set Location' and made it point to another DSN which is configured to the DB with the new user created.
In set location although the DSN is reflected it is still showing that the Userid is 'sa'.
How can I change the user id. While configuring the DSN in control pannel I have mentioned the new user id.
Please help asap