Installing Web Server and Database Server not in the same DOMAIN

Hello All,
I'm installing the RS using the "Standard Deployment Model" suggested
by BOL, which uses one Web Server as the Report Server and the Report
Manager and another as the Report Server Database.
According to BOL:
"The SQL Server instance hosting the report server database must be in
the same domain as the report server or in a trusted domain with the
report server."
Although, in my case, these two machines are not in the same domain,
neither could be. Is there any workaround for it'
It's quite urgent because while I was testing RS in DEV, wich has just
one machine, everything was fine, but now that I'm deploying RS to
Production, I realized that I don't have both Prd machines on the same
domain.
I'd appreciate any help.
Thanks in advance,
Vinicius BellinoThe workaround is laid out right there -- create a domain trust.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Vinicius Bellino" <vbellino@.uol.com.br> wrote in message
news:93d12908.0503021209.165adea4@.posting.google.com...
> Hello All,
> I'm installing the RS using the "Standard Deployment Model" suggested
> by BOL, which uses one Web Server as the Report Server and the Report
> Manager and another as the Report Server Database.
> According to BOL:
> "The SQL Server instance hosting the report server database must be in
> the same domain as the report server or in a trusted domain with the
> report server."
> Although, in my case, these two machines are not in the same domain,
> neither could be. Is there any workaround for it'
> It's quite urgent because while I was testing RS in DEV, wich has just
> one machine, everything was fine, but now that I'm deploying RS to
> Production, I realized that I don't have both Prd machines on the same
> domain.
> I'd appreciate any help.
> Thanks in advance,
> Vinicius Bellino|||Do you realize that you have to have a SQL Server license for the web server
and then one for SQL Server. My feeling is to have SQL Server on the web
server even if it is just as the object store (i.e. the data being reported
off of is somewhere else). SQL Server is very good at managing it's
resources and I have had no problem doing this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vinicius Bellino" <vbellino@.uol.com.br> wrote in message
news:93d12908.0503021209.165adea4@.posting.google.com...
> Hello All,
> I'm installing the RS using the "Standard Deployment Model" suggested
> by BOL, which uses one Web Server as the Report Server and the Report
> Manager and another as the Report Server Database.
> According to BOL:
> "The SQL Server instance hosting the report server database must be in
> the same domain as the report server or in a trusted domain with the
> report server."
> Although, in my case, these two machines are not in the same domain,
> neither could be. Is there any workaround for it'
> It's quite urgent because while I was testing RS in DEV, wich has just
> one machine, everything was fine, but now that I'm deploying RS to
> Production, I realized that I don't have both Prd machines on the same
> domain.
> I'd appreciate any help.
> Thanks in advance,
> Vinicius Bellino|||"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message news:<OjYvW22HFHA.1476@.TK2MSFTNGP09.phx.gbl>...
> Do you realize that you have to have a SQL Server license for the web server
> and then one for SQL Server. My feeling is to have SQL Server on the web
> server even if it is just as the object store (i.e. the data being reported
> off of is somewhere else). SQL Server is very good at managing it's
> resources and I have had no problem doing this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Vinicius Bellino" <vbellino@.uol.com.br> wrote in message
> news:93d12908.0503021209.165adea4@.posting.google.com...
> > Hello All,
> >
> > I'm installing the RS using the "Standard Deployment Model" suggested
> > by BOL, which uses one Web Server as the Report Server and the Report
> > Manager and another as the Report Server Database.
> >
> > According to BOL:
> >
> > "The SQL Server instance hosting the report server database must be in
> > the same domain as the report server or in a trusted domain with the
> > report server."
> >
> > Although, in my case, these two machines are not in the same domain,
> > neither could be. Is there any workaround for it'
> >
> > It's quite urgent because while I was testing RS in DEV, wich has just
> > one machine, everything was fine, but now that I'm deploying RS to
> > Production, I realized that I don't have both Prd machines on the same
> > domain.
> >
> > I'd appreciate any help.
> >
> > Thanks in advance,
> >
> > Vinicius Bellino
Bruce,
I've thought about installing SQL Server in my Web Server as well, but
the only point was the supposed new SQL Server's license. Now I have
no more reasons not to do this. So, thank you!
Regards,
Vinicius Bellinosql