SQL Server Reporting Services Installation - Urgent

Hi all,
Wondering even any can help out with the problem below -

I am getting an error when I am installing Sql Reporting Services on my web server. The error it gives is 'The domain account that you specified cannot be validated. Verify that the user name and password are correct, and that the account has permission to log on to this computer'

Some Back ground Information -
-  The machine am installing it on is outside my network.
-  The sql server is inside my network which is using AD (Active Directory).
-  They both can see each other just fine.
-  They both are running windows 2003 Server.
- One is a pure sql server and the other is a pure web server.
-  The account in question is good - It can log on to sql server which is within the domain and it has the ability to create databases as it has the sysadmin role assgned to it.
  - SQL Server 2000 sp3

The questions I have -
1. Has any one ever seen this error before and what have you done to solve it
2. Has anyone tried this type of configuration before DId it work
3. Is there a way to get your sql server instance name form Sql Server (Questioning whether the sql server instance name I have typed in is incorrect.)

I have also tried using the service account option which give me the error that it can't connect and the sql login which also gives me a connection error...

Answer this question

SQL Server Reporting Services Installation - Urgent

Yahooadam
Then from what I understand and have read -
I have to install the RS using the command line -
setup.exe /settings c:\mysettings.ini /qn
making sure that I specify all the settings in the setting template.ini file and I should have a smooth install..
Chevy
Sorry for not answering your three questions but here's some information that may help. To connect to your SQL box using windows account RS needs to logon that user locally. Since your RS box is outside the domain, the user account you are trying to use is not known to RS box, hence the error. I'd say you won't be able to use windows authentication across boxes in this case if you don't have trust relationships between the boxes.

To feel better what's happenning try running Query Analyzer on your RS box and try to connect to your SQL box. You should get the same error.

The solution is to either establish trust relationships between boxes or use SQL authentication.
Robert Frye
In SQL 2000 Reporting Services, this is not possible to do via the setup GUI. You have to run setup from the command line and specify the SQL account name and credentials. In SQL 2005, this is handled with the RS configuration tool.
rsknowles
Hey thanks for the info.

I actually tried out what you said and I was able to connect to my sql server using the query analyzer and a sql login account. But I was not able to install sql reporting services successfully when it times connect to sql box and make sure the user has the right privilages... THe user account that I setup is in the sys admin role and the create database role... Also would terminal services on my sql box be causing this also (I saw an article that said to turn terminal services off while installing the RS.) Any suggestions

Thanks
Girija
OK....I have gotten sql reporting services installed finally...Thanks for every one's help...I just have one last question - Am now getting the error - the request failed with http status 403: forbidden... Not sure what this is about but does any one have suggestions to fix

thanks in advance!
Genady Beryozkin

Thank you...

If I use sql authentication.I need to establish some security around it right

DGaddy
SQL Server Reporting Services Installation - Urgent

Answer this question