| Author |
Topic |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2011-08-04 : 09:21:45
|
| i have SSRS 2005i create shared datasource and give user name and password in "Credentials stored securely in the report server"the problem is user name and password is deleted from the report manager.why is it? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-04 : 09:33:00
|
| did you mess with report server dbs?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2011-08-04 : 09:47:39
|
| no, but what do you say? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-04 : 09:56:08
|
| i mean reportserverdb------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2011-08-07 : 01:12:17
|
| no, i didnt mess with tha, how can i know if it corrupted? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-08 : 04:37:51
|
| can you check if you can create and run a report using local datasource first? once it runs succesfully, try deploying to server and running it from there------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2011-08-08 : 06:41:29
|
| the problem is ,when i deploy report to server, the shared data source ,is lost the username and password |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-08 : 07:29:01
|
| ok. but you can still open the report in manager and then go to datasources tab and point it to datasource deployed to server rite?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2011-08-09 : 00:54:24
|
| yes,but after a few days it is lost the password and userName.so users start to shout.i choose option in dataSource in report manager:"Credentials stored securely in the report server"why the password and userName disappear? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-09 : 10:10:32
|
| that might be because you might have set expiration for the password.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
Credentials stored securely in the report server