July 11, 2007 at 6:49 am
Hi all,
you've probably all had this issue before with password changes. I'm recently training in SQL Admin and have taken over a SQL 2000 system with no sa password assigned. I need to change it, this isn't the issue, its the reporting service which uses the sa account. I've been directed to the rsconfig.exe utility. I have searched for it and found two locations.
Can someone advise me on what to do next please? Do I run it or what?
Cheers
July 11, 2007 at 8:08 am
Is sa account used for reporting services. First change that create a user and limit privileges and use that for reporting services. Also with reporting services try to use shared ODBC you can also do this with the reports website instead of doing it from the utility provided.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 11, 2007 at 8:08 am
Forgot to say change the password of sa and keep it safe else you are going to land in trouble.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 11, 2007 at 9:09 am
I have run a stored procedure sp_who and found some back groud services using the sa account. The reporting service does use the sa account and our 3rd party supplier (Achiever) directed me to rsconfig.exe. My experience in this area is limited.
July 12, 2007 at 12:02 am
You can change the password for the Datasource even in the reports website instead of using the utility. the url for the same is http://reporservername/reports
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply