Newbie Question - Getting rid of SA 1

[tonykblen]

Hi,

I have inherited a number of reports that require the user to enter SA and the SQL Server admin password in order to run the report. How do I stop this from happening? Do I need to change the reports, SQL Server or both?

Many thanks,
Tony.

 

[synapsevampire]

Learn what connectivity is being used, and then change the default user to another SQL Server login or use Windows security.

Check under Database->Set Location.

If it's using ODBC, you can change the ODBC settings to use Windows Authentication which just passes the user login on to the database, or use another SQL Server defined user.

Databases require a login, so you'll have to change the login to some other user, or use a trusted connection (Windows authentication).

-k

 

[tonykblen]

Many thanks for your prompt reply. If I then want to distribute a report I write to another user, how do I accomodate the different user account?

Thanks again,

Tony.

 

[synapsevampire]

If you use Windows Authentication, the user account is maintained by the admins, as long as they have privileges, it should be fine.

-k

 

[tonykblen]

Hi k,

Just to say a sincere thanks for that as at the moment I had to run all the reports due to the sensitivity of the sa account. This advice will allow users here to run the reports on a more frequent basis.

Again many thanks,
Tony.