Deployment to Production problems

Somewhat newbie here trying to deploy my first Report. Production machine is
on Windows 2003 - finally got around the reporting service prompting for
windows authentication and now I'm trying to deploy my report through VS
2003. Which reports successful deployment.
If I press the "Run" button in VS 2003 it displays a web page:
[To Parent Directory]
Tuesday, March 29, 2005... Name of my report
No fancy Reporting Service front end, just a hyperlink. If I click on the
link, it displays my report.
If I navigate to http://[servername]/Reports/Pages/Folder.aspx it displays
the web page of SQL Server Reporting Services Home (with the appropriate
GUI), but no folders are listed.
There's obviously some extra step I need to do with 2003 that I didn't need
to setup on my local XP system that I developed and debugged on.Sounds like you haven't given permissions for anyone to see the reports. By
default, only admins can see contents of the server.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"dtaylor" <dtaylor@.discussions.microsoft.com> wrote in message
news:F158F5D6-E52B-40F6-9F31-31C49358C33D@.microsoft.com...
> Somewhat newbie here trying to deploy my first Report. Production machine
> is
> on Windows 2003 - finally got around the reporting service prompting for
> windows authentication and now I'm trying to deploy my report through VS
> 2003. Which reports successful deployment.
> If I press the "Run" button in VS 2003 it displays a web page:
> [To Parent Directory]
> Tuesday, March 29, 2005... Name of my report
> No fancy Reporting Service front end, just a hyperlink. If I click on the
> link, it displays my report.
> If I navigate to http://[servername]/Reports/Pages/Folder.aspx it displays
> the web page of SQL Server Reporting Services Home (with the appropriate
> GUI), but no folders are listed.
> There's obviously some extra step I need to do with 2003 that I didn't
> need
> to setup on my local XP system that I developed and debugged on.sql

Deployment of analysis services on windows 2003(Very urgent Please)

I have window 2000 as my development machine. I am using visual studio 2003 and sql server 2000.
I was able to develop a web application which uses the pivot table componant.
Every thing was working fine with out any problem.

I deployed my Project to windows 2003.
I am able to see the pivot table control.
I am not able to get any data into my pivot table.

I am not sure what is going wrong.
Is there anything I need to take care in windows 2003 specifically.

I don't have microsoft office on windows 2003.
Does it make a difference?

Please help!!!

Anil

Help Please|||

If you are using MSOWC for your pivot table component and if yout new server do not have riyhrt MSOWC installled or Office instaled,then you will not be able to view the data.

|||

MSOWC is already available on that machine.
I think the webservice is not able to contact the iis properly.
I have already setup the virtual directory for olap on IIS.

Any ideas

|||

Are you using the HTTP connection to Analysis Services or are you connection directly?

If you are connecting directly, what is the version of the MSOLAP80.dll? You may have to upgrade it to a service pack for Analysis Services.

Copy the MDX Sample Application exe to the 2003 machine and see if it can connect.

David

|||

Finally we narrow down the error it is with the fieldsets for the pivot table.

The web service is working fine if we remove the accessing fieldsets code.

When ever we tried to access the fieldsets in the cube we are getting error.

The error message is "Interop.OWC10 - Unspecified error ".

We installed service pack 4 on sql server.

I reinstalled the owc10 dll again.

I gave the permissions to the user machinename_iuser....

But nothing has solved my problem.

Please help.

|||

Hello. I have some doubts about if OWC:s work with HTTP unless you write some code to make them work. OWC are ActiveX controls and they use tcp/ip.

If you disable the SSAS Olap connection and publish an excel OWC OLAP- report in a folder on your IIS machine, will this work? This is to make sure that nothing else is causing these problems.

It is not recommended to develop on an older O/S than the server O/S, but you are probably aware of that now.

Also check that you are allowed to run programs in your IIS folder on Windows 2003.

In IIS/ Win2003 you can check what web service extensions that are allowed.

Regards

Thomas Ivarsson

|||

i am not sure how to disable the SSAS Olap connection and publish an excel OWC OLAP- report in a folder on your IIS machine.

Yes I am member in administrator group. I can run programs in my IIS folder.

Webservice has extensions allowed in iis are
Active Server Pages
ASP.Net v1.1.4322
Front Page server extensions
HwsMessages HttpReceive
Windows Sharepoint Services.

Regards
Anil

|||

Hello. Build a report from SSAS2000 in Excel and publish it to a webfolder on your IIS. I see that you have Sharepoint services. Upload your Excel SSAS2000 report to Sharepoint on Win2003 server.

Regards

Thomas Ivarsson

|||

I published it on iis and I am able to see all dimension but I am not able to see the fact table values.
I don't know what else to do.

Thanks So much for your help

Anil

|||

Here is link to a kb with your keywords(http://support.microsoft.com/kb/331400)

Regards

Thomas Ivarsson

Deployment of a C# Windows Application connected to SQL Server 2005 Database

Hello all,
I need to consult you in the following problem:
I am developing a windows application in Visual C# 2005 , connected to
an SQL Server 2005 database ,
I want to make deployment for the application so that the user can
have a copy of the application and the database and use it on his
machine even if they dont install the sql server or the visual
studio , i made it using Setup Projects. It was built successfully ,
and created Setup project, when i tested it on another machine ,it
displays the installation wizard ,but it displays an error when trying
to make connection to the database .. the error is:
An error has occurred while establishing a connection to a server ,
when connecting to SQL server 2005,...Could not open a connection to
sql server 2005..
also i logically feel that it is wrong to write an sqlconnection
statement with the name of my machine as the data source , and how to
copy SQL database to the user machine ?
What shall i do? Please Reply...(compjor@.yahoo.com) writes:
> I am developing a windows application in Visual C# 2005 , connected to
> an SQL Server 2005 database ,
> I want to make deployment for the application so that the user can
> have a copy of the application and the database and use it on his
> machine even if they dont install the sql server
Eh? An SQL Server database without SQL Server installed is quite much
a useless piece of bytes.

> i made it using Setup Projects. It was built successfully ,
> and created Setup project, when i tested it on another machine ,it
> displays the installation wizard ,but it displays an error when trying
> to make connection to the database .. the error is:
> An error has occurred while establishing a connection to a server ,
> when connecting to SQL server 2005,...Could not open a connection to
> sql server 2005..
You don't connect to the database. You connect to SQL Server which
will then access the database. But if there is no database to connect to?

> also i logically feel that it is wrong to write an sqlconnection
> statement with the name of my machine as the data source , and how to
> copy SQL database to the user machine ?
There are two possible scenarios:
1) The user already has SQL Server installed on his machine, and don't
want another instance. In this case, give him the option to attach
the database to his server.
2) Bundle SQL Express with your setup, install SQL Express as part of your
setup and attach the database to it.
In both cases you would include the database file in your setup. (Actually,
I would rather use a backup, that the data files directly.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Deployment issues

Hi All,

I am running SQL RS 2005 on Windows Server 2003

My client is XP sp2 with .NET 2005 Team

When I try to deploy a RS report to my web server I get an error;

Error 4 The permissions granted to user 'MyDomain\MyUser' are insufficient for performing this operation.

What folders/user/permissions need to be opened on the server so that I can deploy reports from my client machine?

regards,

Bill

Did you install SP1 for windows 2003 server?|||

I did.

SP1 for SQL Server as well.

Thing is, I had everything working fine a week ago. We had to uninstall SQL Server 2005. I put it back on today. No issues at all in the setup except for this.

|||Can no one tell me what permissions I need to deploy reports to the server, or is this really a rare issue?

Deployment issue SSRS 2000 reports on Production server

Hi All,
I am facing the issue while deploying Reporting Services 2000 Reports in
Production environment (Windows NT Server and SQL Server 2000) in our
application.
Background: I developed few reports using SQL Server Reporting Services 2000
and are able to deploy in Development environment and those reports are
working fine without any issues.
When we are trying to deploy the same in our Production environment, then we
are facing some issue during the deployment time and not able to deploy those
reports into it. We are followed 3 ways to deploy the same as mentioned below:
Method 1: From Application or report manager screen
(http://servername/reports or http://localhost/reports ) we are trying to
deploy / uploads all the reports one by one, then we are getting the error at
the time of upload as â'The underlying connection was closed: Could not
establish trust relationship with remote server.â'
Method 2: From Reports Designer window, we set build mode as â'Productionâ'
and set all the project environments as Production environment and made a
build and then made deploy. After that we are getting an error as "A
Connection could not be made to the report server
http://servername/reportserver". Later we manually copying all the reports
into Production environment and trying to open the reports, then we are not
able to open / call those reports from our application. Here we could not
able to connect or do not know what to do after copying of the reports into
physical environment of the application.
Method 3: We search thru google and few forums, and then we got to know that
we can deploy reports from the script also. So we tried to do the same as per
their instructions, then we got the error in command prompt as below:
E:\New Folder\Files\Dev2.0\ProfessionalServices\REPORTS>rs -i ps_reports.rss
â's http://servername/reportserver -v parentfolder="DBDReports"
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The command completed successfully
Kindly help us to resolve this issue and thanks in advance for your help.
Regards,
nsbThe best way to work this out is from the development environment. You can
deploy a single report by doing a right mouse click on the report and
deploy. What error if any are you getting? Do you have the rights to
publish? One easy thing to try in that regard is to add your user to the
local adminstrators group on the server.
I am betting that you are not part of the administrators group and you were
on the development server. You need to have someone who is in that group to
add you to the appropriate roll in RS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"nsb" <nsb@.discussions.microsoft.com> wrote in message
news:8327C9F9-4320-4D0B-84F2-B636A0CAC04C@.microsoft.com...
> Hi All,
> I am facing the issue while deploying Reporting Services 2000 Reports in
> Production environment (Windows NT Server and SQL Server 2000) in our
> application.
> Background: I developed few reports using SQL Server Reporting Services
> 2000
> and are able to deploy in Development environment and those reports are
> working fine without any issues.
> When we are trying to deploy the same in our Production environment, then
> we
> are facing some issue during the deployment time and not able to deploy
> those
> reports into it. We are followed 3 ways to deploy the same as mentioned
> below:
> Method 1: From Application or report manager screen
> (http://servername/reports or http://localhost/reports ) we are trying to
> deploy / uploads all the reports one by one, then we are getting the error
> at
> the time of upload as "The underlying connection was closed: Could not
> establish trust relationship with remote server."
> Method 2: From Reports Designer window, we set build mode as "Production"
> and set all the project environments as Production environment and made a
> build and then made deploy. After that we are getting an error as "A
> Connection could not be made to the report server
> http://servername/reportserver". Later we manually copying all the reports
> into Production environment and trying to open the reports, then we are
> not
> able to open / call those reports from our application. Here we could not
> able to connect or do not know what to do after copying of the reports
> into
> physical environment of the application.
> Method 3: We search thru google and few forums, and then we got to know
> that
> we can deploy reports from the script also. So we tried to do the same as
> per
> their instructions, then we got the error in command prompt as below:
> E:\New Folder\Files\Dev2.0\ProfessionalServices\REPORTS>rs -i
> ps_reports.rss
> -s http://servername/reportserver -v parentfolder="DBDReports"
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The command completed successfully
> Kindly help us to resolve this issue and thanks in advance for your help.
> Regards,
> nsb

deployment issue

Hi,
I'm running windows 2000 server with analysis services
with sp3 installed for both.. I didnt have the vs.net
installed in my mc. Now i installed reporting services in
my machine... My doubt is does the report manager work
with out vs.net '
can i make the rs work with out vs.net installed in my mc.
if so, how can it be possible.. cos its showing error msg
to me now...
Thanks in advanceReport Manager does not require VS.NET. Report Designer does. Check the
System Requirements for details:
http://www.microsoft.com/sql/reporting/productinfo/sysreqs.asp.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"alex" <anonymous@.discussions.microsoft.com> wrote in message
news:33ce01c47185$14227c90$a401280a@.phx.gbl...
> Hi,
> I'm running windows 2000 server with analysis services
> with sp3 installed for both.. I didnt have the vs.net
> installed in my mc. Now i installed reporting services in
> my machine... My doubt is does the report manager work
> with out vs.net '
> can i make the rs work with out vs.net installed in my mc.
> if so, how can it be possible.. cos its showing error msg
> to me now...
> Thanks in advance
>
>

Deployment

Hi All,
After deploying a VB.NET windows project with a CrystalReportViewer on the client's machine I'm getting the following error:
"Cannot Find keycodev2.dll, or invalid keycode"
Any help will be appreciated,
thanks.
mzainalDid you check the users machine to make sure that dll was there and registered properly?|||Thanks for your reply, but how do you go about doing that ? Do you have a list of required DLLs ? How do you register them ?

thanks.|||Did you create a setup file before you deployed, or did you just give the user a copy of the exe? If you just gave the user a copy of the exe, then there's you're problem. You should create a setup so that all the necessary files can be installed on the users machine.

The list of required dlls is different depending on what part of Crystal you're using. CrystalReportViewer is not the only part of Crystal that's being used.

I use Crystal Reports 8.5. That version comes with a file called runtime.hlp which contains a list of all the Crystal Files required for deployment. You can search on www.google.com or Crystal's website (http://support.businessobjects.com/search/advsearch.asp) to try and find a list of the files that you need.

Also, look here. I found this by typing in keycodev2.dll into Google and hitting the search button.

http://www.dotnetforums.net/t75112.html

Deploying with sql server express

I have developed a windows mobile 5.0 application that is currently syncing with sql server 2005. I want to deploy the application with sql server express for the client. What do I need to do to make this work?

Thank you.

It depends on how you're syncing. If you're using manual implementation via SQL Client on device, that would work with properly configured SQL 2005 Express as well.

If you using SQL Mobile RDA or replication, you would have to implement manual sync using SQL Client as Express offers no RDA/Replication support.

|||I am using replication. Can you direct me to some reference material that can assist me in changing to manual sync?|||Also, to test with sql server express will I need to install it on my computer? I am running sql 2005 and visual studio 2005. Can I load express in addition to what I have installed. I do not want to un-install anything that I have currently. What is your suggestion?|||

I'm not aware of any reference materials on that. The idea is very simple - you go through all records in one db and compare them with records in another db. If they are different, you'd need to synchronize them as appropriate in your particular case. For example:

Before:

SQL Mobile SQL Express Action

1-foo 1-foo Same data, do nothing

2-bar 2-foobar Data changed, copy from Express to Mobile

2-some <nothing> Record deleted, delete from Mobile

(or is it added on device? - that's for you to track)

Before:

SQL Mobile SQL Express

1-foo 1-foo

2-foobar 2-foobar

As far as I know you can run SQL Express and SQL Server side by side, though you would need to use nonstandard port.

|||

some honest, non-politically correct advice - I wouldn't install SQL Server 2005 and SQL Express on the same machine. it can cause you a lot of difficult issues - I'm not saying it can't be made to work, but you're asking for a day of searching newsgroups to resolve the issues that this introduces. either remove SQL Server and re-run the VS2005 setup, choosing SQL Express as an optional install component, or use a separate box to run SQL Express on.

-Darren

Deploying with custom Forms Security enabled

I have recently enabled a custom Forms Security on my Windows 2003 Server w/ SQL Server 2005 Reporting Services. All the functionality I would expect is working properly, except for the ability to deploy to the reports server from inside my Visual Studio 2005 Reports Project.

The 'Reporting Services Login' window opens, prompting me for a username and password. Regardless of what is supplied, the window keeps reappearing, and I am unable to deploy. I am able to upload the files from within the Report Manager, but that is time consuming and inelegant.

Any help would be greatly appreciated!

Anyone? This is pretty peculiar, and it looks like there was a similar issue with SQL Server 2000 and its reporting services. Has any experienced anything like this?|||

I too am stuck:

I have setup Forms Authentication on RS2005 and the report manager is working
swell it redirects to a log in page, authenticates against our data
source/ldap server and returns to the report manager with the appropriate
roles/authorizations.
However, I don't know how to deploy the reports/models to the report server. I no longer have a prompt in Visual Studio after we enabled the
forms authenticaiton; keeping in mind with forms authentication you aren't
using windows authorization/active directory. How do I continue to deploy
reports or report models to the report server/manager with forms
authentication. Specific configuration steps would be helpful. Currently we
get an error something to the effect that user '' doesn't have permissions to
the destination. So basically without a prompt window it doesn't seem to know
who I am anymore. How would I login or use/create a cookie to tell it who I
am if I don't have a login prompt inside the Visual Studio 2005?
Thanks!

|||no idea. it doesnt make sense that the prompt in visual studio would disapper, however, since the reports could be deployed to any server...|||I had the same problem: I was prompted for username/password in my Report Model and Report Server projects. Deploying the Report Server project worked fine, but the Report Model project sent an empty username string to the logon function.

I finally figured out that the two project types handle the username string differently. For getting the Report Model to deploy correctly, you must specify an authority before the username even if you don't use one in your custom security extension. (i.e. ANYTHING\username or .\username, \username doesn't work). Done so, the username string gets parsed correctly and the deployment works fine.|||bump.... I'm not even getting a dialog...|||

Not sure if anyone out there is still struggling with the continual login dialog or not. I was and found out what my problem was. I was trying to deploy to "http:\localhost\reports" instead of http:\localhost\ReportServer"!

ugh!

Anyway, hope this helps someone!

Deploying with custom Forms Security enabled

I have recently enabled a custom Forms Security on my Windows 2003 Server w/ SQL Server 2005 Reporting Services. All the functionality I would expect is working properly, except for the ability to deploy to the reports server from inside my Visual Studio 2005 Reports Project.

The 'Reporting Services Login' window opens, prompting me for a username and password. Regardless of what is supplied, the window keeps reappearing, and I am unable to deploy. I am able to upload the files from within the Report Manager, but that is time consuming and inelegant.

Any help would be greatly appreciated!

Anyone? This is pretty peculiar, and it looks like there was a similar issue with SQL Server 2000 and its reporting services. Has any experienced anything like this?|||

I too am stuck:

I have setup Forms Authentication on RS2005 and the report manager is working
swell it redirects to a log in page, authenticates against our data
source/ldap server and returns to the report manager with the appropriate
roles/authorizations.
However, I don't know how to deploy the reports/models to the report server. I no longer have a prompt in Visual Studio after we enabled the
forms authenticaiton; keeping in mind with forms authentication you aren't
using windows authorization/active directory. How do I continue to deploy
reports or report models to the report server/manager with forms
authentication. Specific configuration steps would be helpful. Currently we
get an error something to the effect that user '' doesn't have permissions to
the destination. So basically without a prompt window it doesn't seem to know
who I am anymore. How would I login or use/create a cookie to tell it who I
am if I don't have a login prompt inside the Visual Studio 2005?
Thanks!

|||no idea. it doesnt make sense that the prompt in visual studio would disapper, however, since the reports could be deployed to any server...|||I had the same problem: I was prompted for username/password in my Report Model and Report Server projects. Deploying the Report Server project worked fine, but the Report Model project sent an empty username string to the logon function.

I finally figured out that the two project types handle the username string differently. For getting the Report Model to deploy correctly, you must specify an authority before the username even if you don't use one in your custom security extension. (i.e. ANYTHING\username or .\username, \username doesn't work). Done so, the username string gets parsed correctly and the deployment works fine.
|||bump.... I'm not even getting a dialog...

|||

Not sure if anyone out there is still struggling with the continual login dialog or not. I was and found out what my problem was. I was trying to deploy to "http:\localhost\reports" instead of http:\localhost\ReportServer"!

ugh!

Anyway, hope this helps someone!

Deploying with custom Forms Security enabled

I have recently enabled a custom Forms Security on my Windows 2003 Server w/ SQL Server 2005 Reporting Services. All the functionality I would expect is working properly, except for the ability to deploy to the reports server from inside my Visual Studio 2005 Reports Project.

The 'Reporting Services Login' window opens, prompting me for a username and password. Regardless of what is supplied, the window keeps reappearing, and I am unable to deploy. I am able to upload the files from within the Report Manager, but that is time consuming and inelegant.

Any help would be greatly appreciated!

Anyone? This is pretty peculiar, and it looks like there was a similar issue with SQL Server 2000 and its reporting services. Has any experienced anything like this?|||

I too am stuck:

I have setup Forms Authentication on RS2005 and the report manager is working
swell it redirects to a log in page, authenticates against our data
source/ldap server and returns to the report manager with the appropriate
roles/authorizations.
However, I don't know how to deploy the reports/models to the report server. I no longer have a prompt in Visual Studio after we enabled the
forms authenticaiton; keeping in mind with forms authentication you aren't
using windows authorization/active directory. How do I continue to deploy
reports or report models to the report server/manager with forms
authentication. Specific configuration steps would be helpful. Currently we
get an error something to the effect that user '' doesn't have permissions to
the destination. So basically without a prompt window it doesn't seem to know
who I am anymore. How would I login or use/create a cookie to tell it who I
am if I don't have a login prompt inside the Visual Studio 2005?
Thanks!

|||no idea. it doesnt make sense that the prompt in visual studio would disapper, however, since the reports could be deployed to any server...|||I had the same problem: I was prompted for username/password in my Report Model and Report Server projects. Deploying the Report Server project worked fine, but the Report Model project sent an empty username string to the logon function.

I finally figured out that the two project types handle the username string differently. For getting the Report Model to deploy correctly, you must specify an authority before the username even if you don't use one in your custom security extension. (i.e. ANYTHING\username or .\username, \username doesn't work). Done so, the username string gets parsed correctly and the deployment works fine.
|||bump.... I'm not even getting a dialog...

|||

Not sure if anyone out there is still struggling with the continual login dialog or not. I was and found out what my problem was. I was trying to deploy to "http:\localhost\reports" instead of http:\localhost\ReportServer"!

ugh!

Anyway, hope this helps someone!

Deploying with custom Forms Security enabled

I have recently enabled a custom Forms Security on my Windows 2003 Server w/ SQL Server 2005 Reporting Services. All the functionality I would expect is working properly, except for the ability to deploy to the reports server from inside my Visual Studio 2005 Reports Project.

The 'Reporting Services Login' window opens, prompting me for a username and password. Regardless of what is supplied, the window keeps reappearing, and I am unable to deploy. I am able to upload the files from within the Report Manager, but that is time consuming and inelegant.

Any help would be greatly appreciated!

Anyone? This is pretty peculiar, and it looks like there was a similar issue with SQL Server 2000 and its reporting services. Has any experienced anything like this?|||

I too am stuck:

I have setup Forms Authentication on RS2005 and the report manager is working
swell it redirects to a log in page, authenticates against our data
source/ldap server and returns to the report manager with the appropriate
roles/authorizations.
However, I don't know how to deploy the reports/models to the report server. I no longer have a prompt in Visual Studio after we enabled the
forms authenticaiton; keeping in mind with forms authentication you aren't
using windows authorization/active directory. How do I continue to deploy
reports or report models to the report server/manager with forms
authentication. Specific configuration steps would be helpful. Currently we
get an error something to the effect that user '' doesn't have permissions to
the destination. So basically without a prompt window it doesn't seem to know
who I am anymore. How would I login or use/create a cookie to tell it who I
am if I don't have a login prompt inside the Visual Studio 2005?
Thanks!

|||no idea. it doesnt make sense that the prompt in visual studio would disapper, however, since the reports could be deployed to any server...|||I had the same problem: I was prompted for username/password in my Report Model and Report Server projects. Deploying the Report Server project worked fine, but the Report Model project sent an empty username string to the logon function.

I finally figured out that the two project types handle the username string differently. For getting the Report Model to deploy correctly, you must specify an authority before the username even if you don't use one in your custom security extension. (i.e. ANYTHING\username or .\username, \username doesn't work). Done so, the username string gets parsed correctly and the deployment works fine.|||bump.... I'm not even getting a dialog...|||

Not sure if anyone out there is still struggling with the continual login dialog or not. I was and found out what my problem was. I was trying to deploy to "http:\localhost\reports" instead of http:\localhost\ReportServer"!

ugh!

Anyway, hope this helps someone!

Deploying with custom Forms Security enabled

I have recently enabled a custom Forms Security on my Windows 2003 Server w/ SQL Server 2005 Reporting Services. All the functionality I would expect is working properly, except for the ability to deploy to the reports server from inside my Visual Studio 2005 Reports Project.

The 'Reporting Services Login' window opens, prompting me for a username and password. Regardless of what is supplied, the window keeps reappearing, and I am unable to deploy. I am able to upload the files from within the Report Manager, but that is time consuming and inelegant.

Any help would be greatly appreciated!

Anyone? This is pretty peculiar, and it looks like there was a similar issue with SQL Server 2000 and its reporting services. Has any experienced anything like this?|||

I too am stuck:

I have setup Forms Authentication on RS2005 and the report manager is working
swell it redirects to a log in page, authenticates against our data
source/ldap server and returns to the report manager with the appropriate
roles/authorizations.
However, I don't know how to deploy the reports/models to the report server. I no longer have a prompt in Visual Studio after we enabled the
forms authenticaiton; keeping in mind with forms authentication you aren't
using windows authorization/active directory. How do I continue to deploy
reports or report models to the report server/manager with forms
authentication. Specific configuration steps would be helpful. Currently we
get an error something to the effect that user '' doesn't have permissions to
the destination. So basically without a prompt window it doesn't seem to know
who I am anymore. How would I login or use/create a cookie to tell it who I
am if I don't have a login prompt inside the Visual Studio 2005?
Thanks!

|||no idea. it doesnt make sense that the prompt in visual studio would disapper, however, since the reports could be deployed to any server...|||I had the same problem: I was prompted for username/password in my Report Model and Report Server projects. Deploying the Report Server project worked fine, but the Report Model project sent an empty username string to the logon function.

I finally figured out that the two project types handle the username string differently. For getting the Report Model to deploy correctly, you must specify an authority before the username even if you don't use one in your custom security extension. (i.e. ANYTHING\username or .\username, \username doesn't work). Done so, the username string gets parsed correctly and the deployment works fine.|||bump.... I'm not even getting a dialog...|||

Not sure if anyone out there is still struggling with the continual login dialog or not. I was and found out what my problem was. I was trying to deploy to "http:\localhost\reports" instead of http:\localhost\ReportServer"!

ugh!

Anyway, hope this helps someone!

Deploying too many reports causes error in report manager

sql reporting services (sp2)
windows 2003 server
Sql 200 sp4
all on one server (iis & sql server)
I have about 30 reports which I deploy from my local environment to our
reporting server. If I deploy about 10 of the reports everything is fine,
all reports deployed work. However, the more reports I deploy I notice the
slower the report manager screen takes to load. After I deploy about 15 of
my reports I will eventually get an error on report manager screen:
There is an error in XML document (1, 4078)
I have tried to deploy differnent reports to see if it is a specific report
that may be causing this, but this does not seem to be the case.
Any help with this would be greatly appreciated, as I am out of ideas and
resources to figure this out.
Regards,
Troygensx100 wrote:
> sql reporting services (sp2)
> windows 2003 server
> Sql 200 sp4
> all on one server (iis & sql server)
> I have about 30 reports which I deploy from my local environment to our
> reporting server. If I deploy about 10 of the reports everything is fine,
> all reports deployed work. However, the more reports I deploy I notice the
> slower the report manager screen takes to load. After I deploy about 15 of
> my reports I will eventually get an error on report manager screen:
> There is an error in XML document (1, 4078)
> I have tried to deploy differnent reports to see if it is a specific report
> that may be causing this, but this does not seem to be the case.
> Any help with this would be greatly appreciated, as I am out of ideas and
> resources to figure this out.
> Regards,
> Troy
sounds strange ,30 reports not a lot at all .|||gensx100 wrote:
> sql reporting services (sp2)
> windows 2003 server
> Sql 200 sp4
> all on one server (iis & sql server)
> I have about 30 reports which I deploy from my local environment to our
> reporting server. If I deploy about 10 of the reports everything is fine,
> all reports deployed work. However, the more reports I deploy I notice the
> slower the report manager screen takes to load. After I deploy about 15 of
> my reports I will eventually get an error on report manager screen:
> There is an error in XML document (1, 4078)
> I have tried to deploy differnent reports to see if it is a specific report
> that may be causing this, but this does not seem to be the case.
> Any help with this would be greatly appreciated, as I am out of ideas and
> resources to figure this out.
> Regards,
> Troy
Troy, i may test your reports in your environment just
to verify nothing is really wrong with them, if you
wish.
We have our own tool to deploy reports, so this could
be useful - to deploy them at once but slightly
another way...
I just need your .rdls to do so.
Let me know.
Cheers

Deploying System DSN to Multiple PCs

Is there any way to deploy System DSNs to multiple PCs?
I'm in a windows xp client environment with sql server 2000 running on a
windows server 200 box.
Thanks for any help.
System DSNs are stored in the registry under
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI. Try exporting the registry node
for the data source and run it on another computer to see if it works.
Roman
Roman Rehak, MCSD, MCDBA, MCSA
SQL Server Specialist
Competitive Computing
http://sqljunkies.com/WebLog/Roman
"Josh" <Josh@.discussions.microsoft.com> wrote in message
news:FA14A0DA-A2C4-4779-ADDC-49F79016EF6E@.microsoft.com...
> Is there any way to deploy System DSNs to multiple PCs?
> I'm in a windows xp client environment with sql server 2000 running on a
> windows server 200 box.
> Thanks for any help.
|||Thanks for replying but that didn't work. I was thinking maybe there might
be a way to create a vbscript to create the system dsns.
"Roman Rehak" wrote:

> System DSNs are stored in the registry under
> HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI. Try exporting the registry node
> for the data source and run it on another computer to see if it works.
> Roman
>
> Roman Rehak, MCSD, MCDBA, MCSA
> SQL Server Specialist
> Competitive Computing
> http://sqljunkies.com/WebLog/Roman
>
> "Josh" <Josh@.discussions.microsoft.com> wrote in message
> news:FA14A0DA-A2C4-4779-ADDC-49F79016EF6E@.microsoft.com...
>
>
|||These articles might help you get going with this:
How To Create and Remove a DSN in Visual Basic
http://support.microsoft.com/?id=171146
How To Programmatically Create a DSN for SQL Server with VB
http://support.microsoft.com/?id=184608
-Sue
On Sun, 27 Feb 2005 21:47:01 -0800, "Josh"
<Josh@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Thanks for replying but that didn't work. I was thinking maybe there might
>be a way to create a vbscript to create the system dsns.
>
>"Roman Rehak" wrote:

Deploying reports in SQL Reporting Services 200

I am using Visual Studio 2003, SQL Reporting Services 2000. Windows XP on client(development) machine and Windows 2003 on Server. I am trying to deploy a report from a client machin to Reporting Server. I got the following error message:

d:\development pardeep\forexreports\TxnBeyondValue.rdl The underlying connection was closed: Could not establish trust relationship with remote server.

Hi,

You might not have proper permissions to deploy to that report server. Try adding that report using report manager manually and resolve any security issues, and then deploy it using VS.

Deploying a Windows Application that involves Crystal Reports

I have created a database in visual studio .NET 2003 that uses two crystal reports. When I go through the basic deployment steps for a windows application and then intall the program on a differant computer (that runs XP and only has the .NET Framework 1.1) I get a Keycode.dll error. I then tryed excluding all dependencies and including CrystalReports10_NET_EmbeddedReporting.msm. This gives me an unhandleable exception Windows.Form error after I install on the same different computer and try to access the reports? I just want to create a setup project that will allow me to install on a different computer and have my crystal reports work. What should I do? Thanks!Try this:

http://support.businessobjects.com/communityCS/TechnicalPapers/crnet_deployment.pdf

I just typed in 'keycode.dll' in Google and came across this pdf file on Crystal's website. I didn't read through it or anything, so I'm not sure if it will help. If it's not what you're looking for or if it doesn't help, try doing a search for keycode.dll or for the specific error number that you're getting.

Sorry I couln't help more.

Deployed reports have javascript errors?

Hello-

I have developed a number of reports on Win XP with VS2005. They run on our development server, which is running Windows Server 2003 32-bit. I then deploy these reports on our production server, which is running Windows Server 2003 64-bit edition.

Accessing any of the reports from Report Manager results in javascript errors, such as 'Line 41 Error: 'RSClientController' is undefined'

I get these errors also when invoking these reports through a form post.

It appears that some javascript code generated by the report server is missing. Could this be a 32-bit vs 64-bit issue? Report Manager seems to work fine; it is only when I run a report that I have this problem. This is the first time I've tried to deploy reports to this server.

Thanks.Solution!

The problem is the .axd file extention which is generated by the sql server on the fly when one tries to run a report.

There is an IIS setting that needs to be changed. Open IIS and go to the properties of the Reports website. Under the directory tab, click on the Configuration button. Find the .axd extension in the Mappings tab and double-click to get to its properties. Uncheck the 'Check that file exists' option, save, and that is it.

This is a known issue and MS hasn't yet written a KB article for it.|||Excellent analysis. This solved my problem with reports and the WebResource.axd file.|||

What if I'm having the same "'RSClientController' is undefined" issue, but when I go to the .axd extension properties, "verify that file exists" is already unchecked?

This is on a clean install of SQL 2k5 on Server 2k3 SP1.

Thanks.

|||

On IIS v 6.0, on the Virtual Directory tab of the ReportServer, I chose configuration, then on the mappings tab I needed to edit the Wildcard application to uncheck the box to "verify file exists"

Thanks again;)

|||Anyone found a solution for this ?|||

If you website is using forms authentication, you have to grant access to authenticated users to Reserved.ReportViewerWebControl.axd.

After I added the following location entry in my web.config file I no longer received "RSClient Controller is not defined messages".

<location path="Reserved.ReportViewerWebControl.axd">

<system.web>

<authorization>

<allow roles="RoleA, RoleB">

</allow>

</authorization>

</system.web>

</location>

Deployed reports have javascript errors?

Hello-

I have developed a number of reports on Win XP with VS2005. They run on our development server, which is running Windows Server 2003 32-bit. I then deploy these reports on our production server, which is running Windows Server 2003 64-bit edition.

Accessing any of the reports from Report Manager results in javascript errors, such as 'Line 41 Error: 'RSClientController' is undefined'

I get these errors also when invoking these reports through a form post.

It appears that some javascript code generated by the report server is missing. Could this be a 32-bit vs 64-bit issue? Report Manager seems to work fine; it is only when I run a report that I have this problem. This is the first time I've tried to deploy reports to this server.

Thanks.
Solution!

The problem is the .axd file extention which is generated by the sql server on the fly when one tries to run a report.

There is an IIS setting that needs to be changed. Open IIS and go to the properties of the Reports website. Under the directory tab, click on the Configuration button. Find the .axd extension in the Mappings tab and double-click to get to its properties. Uncheck the 'Check that file exists' option, save, and that is it.

This is a known issue and MS hasn't yet written a KB article for it.
|||Excellent analysis. This solved my problem with reports and the WebResource.axd file.|||

What if I'm having the same "'RSClientController' is undefined" issue, but when I go to the .axd extension properties, "verify that file exists" is already unchecked?

This is on a clean install of SQL 2k5 on Server 2k3 SP1.

Thanks.

|||

On IIS v 6.0, on the Virtual Directory tab of the ReportServer, I chose configuration, then on the mappings tab I needed to edit the Wildcard application to uncheck the box to "verify file exists"

Thanks again;)

|||Anyone found a solution for this ?|||

If you website is using forms authentication, you have to grant access to authenticated users to Reserved.ReportViewerWebControl.axd.

After I added the following location entry in my web.config file I no longer received "RSClient Controller is not defined messages".

<location path="Reserved.ReportViewerWebControl.axd">

<system.web>

<authorization>

<allow roles="RoleA, RoleB">

</allow>

</authorization>

</system.web>

</location>

Deployed reports have javascript errors?

Hello-

I have developed a number of reports on Win XP with VS2005. They run on our development server, which is running Windows Server 2003 32-bit. I then deploy these reports on our production server, which is running Windows Server 2003 64-bit edition.

Accessing any of the reports from Report Manager results in javascript errors, such as 'Line 41 Error: 'RSClientController' is undefined'

I get these errors also when invoking these reports through a form post.

It appears that some javascript code generated by the report server is missing. Could this be a 32-bit vs 64-bit issue? Report Manager seems to work fine; it is only when I run a report that I have this problem. This is the first time I've tried to deploy reports to this server.

Thanks.
Solution!

The problem is the .axd file extention which is generated by the sql server on the fly when one tries to run a report.

There is an IIS setting that needs to be changed. Open IIS and go to the properties of the Reports website. Under the directory tab, click on the Configuration button. Find the .axd extension in the Mappings tab and double-click to get to its properties. Uncheck the 'Check that file exists' option, save, and that is it.

This is a known issue and MS hasn't yet written a KB article for it.
|||Excellent analysis. This solved my problem with reports and the WebResource.axd file.|||

What if I'm having the same "'RSClientController' is undefined" issue, but when I go to the .axd extension properties, "verify that file exists" is already unchecked?

This is on a clean install of SQL 2k5 on Server 2k3 SP1.

Thanks.

|||

On IIS v 6.0, on the Virtual Directory tab of the ReportServer, I chose configuration, then on the mappings tab I needed to edit the Wildcard application to uncheck the box to "verify file exists"

Thanks again;)

|||Anyone found a solution for this ?|||

If you website is using forms authentication, you have to grant access to authenticated users to Reserved.ReportViewerWebControl.axd.

After I added the following location entry in my web.config file I no longer received "RSClient Controller is not defined messages".

<location path="Reserved.ReportViewerWebControl.axd">

<system.web>

<authorization>

<allow roles="RoleA, RoleB">

</allow>

</authorization>

</system.web>

</location>