16 Ocak 2007 Salı

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing.

start cmd

Solution:
rsconfig -c -s < SQLSERVERNAME > -d reportserver -a Windows -u < MYDOMAIN\MYACCOUNT > -p < PASSWORD >
or
rsconfig -c -m < REMOTECOMPUTERNAME > -s < SQLSERVERNAME > -d reportserver -a SQL -u SA -p < SAPASSWORD >

rsconfig Utility

The rsconfig utility (Rsconfig.exe) encrypts and stores connection and account values in the RSReportServer.config file. Encrypted values include report server database connection information and account values used for unattended report processing.

Configuring a Report Server Connection

After installation, you may need to modify the user name, password, and authentication mode that the report server uses to connect to the report server database. These values are encrypted. Reporting Services includes rsconfig utility that you can use to modify encrypted connection information.
Connecting to a Report Server Database

A report server must access the report server database that stores the items and metadata managed by the server. Because the report server database is a SQL Server database, you can use either Windows Authentication or SQL Server Authentication.

The connection information used to establish the connection is initially defined during setup. However, if you want to modify the connection information, or if you are moving components to different computers, you can run rsconfig to correct it.
Running rsconfig

The rsconfig utility is a console application that you run from a command line. You can run this tool on a local or remote computer to modify the connection information used by a report server instance.

When you run the utility, you specify parameters to set connection information. These parameters change the values of the connection information stored in the configuration file on the local or remote computer. You can modify the user name, password, and authentication mode used by the report server to connect to the report server database. The tool manages connection information for a single instance of the report server.

links:
http://msdn2.microsoft.com/en-us/library/ms162837.aspx

http://msdn2.microsoft.com/en-gb/library/aa972232(SQL.80).aspx

http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=92&threadid=29121&STARTPAGE=1

6 yorum:

Adsız dedi ki...

You have to express more your opinion to attract more readers, because just a video or plain text without any personal approach is not that valuable. But it is just form my point of view

Adsız dedi ki...

I didn't understand the concluding part of your article, could you please explain it more?

Adsız dedi ki...

Fabulous, what a weblog it is! This weblog presents valuable facts to us, keep it up.


Stop by my blog post hotmail search

Adsız dedi ki...

Hi, I reaԁ your blоg lіκe evеry
week. Yоuг humoгistic style is wіtty, kеep it up!



Stop by my рagе :: facebook Cuenta Gratis

Adsız dedi ki...

Eνery weеkеnd i used to pay a quick vіsit thiѕ websitе, аs
i want еnjοymеnt, as thiѕ thіs
ωeb pagе cοnаtions genuinеly pleaѕаnt funny infoгmation toο.


Stop by mу ωeb blog ... facebook cuenta gratis

Adsız dedi ki...

I blog frеquently аnd Ι really thank you for your
сontеnt. Thе аrticle
haѕ really peaked mу inteгest. ӏ
will tаke a note οf your blog and kеep сhecking
for new informatiοn about once per weеk. I subscribed
to your RSS feed toο.

Ηeгe is my website ... crear facebook gratis