Installation Problems : SQL and RS in diff domains

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
BofoHi,
I am also facing the same problem. pls help us
Thanks,
Raj
"bofobofo@.yahoo.com" wrote:
> 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
> Bofo
>|||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.
"Raj" <Raj@.discussions.microsoft.com> wrote in message
news:12BE2D5D-A6BE-4F0F-BDC9-617BAD05D107@.microsoft.com...
> Hi,
> I am also facing the same problem. pls help us
> Thanks,
> Raj
> "bofobofo@.yahoo.com" wrote:
>> 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
>> Bofo|||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