SQL Server requires password validation at the time of login, this is a basic requirement for security resasons.
You can pass logins using external languages, or you can set up an account on the database without a password, or you can save data with the report and forward it to the user for them to view, but what you're asking is to break the rules of security by embedding passwords, which is rarely a good idea.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.