deploying reports from vs2005 issue

I'm trying to deploy reports to development server that is running
mssql 2000 and a named instance of mssql 2005 but when I deploy I'm
running into authentication issues. From some articles I'm finding
that this can occur when using SSRS in mssql2000. Do I need to modify
the deployment path in visual studio to some how point to the named
mssql 2005 database, if so how? Also where do I find the
configuration in vs2005 to not overwrite the datasources when a report
is deployed?
Thanks,
JeffWhen you setup for deployment you give it the web address. If your report
server is working that is all you should need to do. For instance it would
look like this for TargetServerURL: http://yourserver/ReportServer
Now, to be able to deploy you need to have the rights to do so. This is
Reporting Services rights. It has nothing to do with SQL Server DB rights.
Can you run reports? First make sure of that.
If your domain account is in the local administrators group on the server
then you will automatically have all the rights you need. Again, this is
around your windows account, not your SQL Server access rights.
Also, the default in vs2005 is to NOT overwrite a datasource. Right mouse
click on the project, properties. This is where you set the targetserverurl
and also the overwritedatasources (which you want to be false).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jeffa" <Jeff.Arlt@.gmail.com> wrote in message
news:1183479523.437839.111440@.j4g2000prf.googlegroups.com...
> I'm trying to deploy reports to development server that is running
> mssql 2000 and a named instance of mssql 2005 but when I deploy I'm
> running into authentication issues. From some articles I'm finding
> that this can occur when using SSRS in mssql2000. Do I need to modify
> the deployment path in visual studio to some how point to the named
> mssql 2005 database, if so how? Also where do I find the
> configuration in vs2005 to not overwrite the datasources when a report
> is deployed?
> Thanks,
> Jeff
>