Reporting Services Installation.

We are installing Sql Reporting Services 2000 Evaluation Edition. During the
setup we are selecting the Remote Sql Server Instance (On the same network
and it is an enterprise edition) as the Reporting Server Database. Locla
system has IIS and ASP.NET installed, so it will be used as Report
Server/Manager. Doing so we are getting the following error during
installation:
Cannot access Sql server on instance ("Instance Name")
Login Failed for ("NT login name"). We are providing Sql login credentials
which has full permissions to create database on the remote sql instance.
What is the issue here. Any help will be of great use!!!Setup uses the user running setup to talk to the DB server during setup.
This user must have sa privileges. If you want you can use command line
arguments to have setup use SQL auth instead. These are documented in the
template.ini file.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"sqlchat" <sqlchat@.discussions.microsoft.com> wrote in message
news:17E31891-3D13-4F49-A109-E44538D6CC49@.microsoft.com...
> We are installing Sql Reporting Services 2000 Evaluation Edition. During
the
> setup we are selecting the Remote Sql Server Instance (On the same network
> and it is an enterprise edition) as the Reporting Server Database. Locla
> system has IIS and ASP.NET installed, so it will be used as Report
> Server/Manager. Doing so we are getting the following error during
> installation:
> Cannot access Sql server on instance ("Instance Name")
> Login Failed for ("NT login name"). We are providing Sql login credentials
> which has full permissions to create database on the remote sql instance.
> What is the issue here. Any help will be of great use!!!