sql server reporting services: Reporting Services Installation. -- sql server reporting services

Reporting Services Installation.

sqlchat
8/27/2004 11:31:02 PM

sql server reporting services: 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.

Re: Reporting Services Installation.

Daniel Reib [MSFT]
8/30/2004 12:25:52 PM

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.

[quoted text, click to view]