sql server reporting services: Installation Problems : SQL and RS in diff domains -- sql server reporting services

Installation Problems : SQL and RS in diff domains

bofobofo NO[at]SPAM yahoo.com
1/25/2005 6:33:09 PM

sql server reporting services:

Hello,

I have been trying to install RS for a while now. I was able to
install it successfully when I had the SQL server running locally.
But I need to make to work having the SQL server on a different
machine.

Here is my scenario.

1. SQL server 2000 is running on a Win2003 Server which is NOT in my
domain
2. Reporting services will run on my machine which is also running
Win2003 Server

My options during installation are
Windows Authenication and
for the reportServer a Service account (default) option

At the end of the installation I get a message saying that Reporting
Services cannot be initalized

I try to access the localhost/Reports

and I get the following error message
=============
The report server cannot open a connection to the report server
database. A connection to the database is required for all requests
and processing. (rsReportServerDatabaseUnavailable) Get Online Help
Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.
=============

I would like to know if the problem is due to the fact that the SQL
server is running outside my domain ?

Also I would appreciate what are the best options to choose for the
account types, I read diff docs and each give a different opinion.

Thanks

RE: Installation Problems : SQL and RS in diff domains

Raj
1/26/2005 3:47:02 PM

Hi,
I am also facing the same problem. pls help us

Thanks,
Raj

[quoted text, click to view]

Re: Installation Problems : SQL and RS in diff domains

Lukasz Pawlowski [MSFT]
1/26/2005 7:39:45 PM

Hi folks,

The primary issue here is that across domains (that are not trusted) the
windows context is not valid. Typically you encounter this in a DMZ
scenario.

Since windows identities are out of the question, you'll need to use SQL
Auth to authenticate between report server and the SQL Server it uses.

What you need are:
1) tell setup to use SQL Auth when creating the database
2) tell RS to use SQL Auth when connecting to the database

For 1), you can use the RSSETUPACCOUNT and RSSETUPPASSWORD command line
flags. Supply an admin level SQL Login.
For 2), on the database dialog in setup, choose Credentials Type SQL Login,
and specify the SQL user the report server is to use to communicate with the
report server. Needless to say, the credentials for 1 and 2 should be
different :-).

Hope that helps,

-Lukasz

--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Re: Installation Problems : SQL and RS in diff domains

RemoteDeploy
2/10/2005 5:48:46 PM

Hello Lukasz

I am tryin to deploy to a remote server which is within a DMZ. I am
using SQL authentication. I have identical usernames and password for a
Windows account and a SQL account.

When I open <server>/reportServer, after passwd auth, i get the list of

all reports and I can click on them and they are functioning.
But when I open <server>/reports, after passwd auth, i get to the Home
screen with the folder containing the reports. But when I click any
report in that page, I get a
'Cant display Page' in that frame.

I am unable to find whats causing the problem.

1. All reports working when I browse them on the server machine.
2. When I try to access http://<server>/reports, I am prompted for a
passwd/user
I enter an username/passwd that has admin priv on Windows and also dba
admin on the SQL server
3. I pass that phase and go on to see the firstpage of the reports
which shows a folder containing all the reports.
I can view and change all links like the properties, security etc.
4. When I clic any report .rdl file, I get the browser page 'action
cancelled' IE message.

The SQL database is using the mixed mode of auth

----------
But I can access all the reports from my machine when i use the
http://<server>/reportserver URL.

Has anyone faced such a problem

any help will be appreciated
Thanks
Bofo

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.