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 not working

I have a freshly installed reporting server/sql server and I have an older
visual studio reporting project.
Now I wanted to change the deployment url to the new server, but whenever I
try to deploy I get the message: "The permissions granted to user 'user' are
insufficient for performing this operation."
What permissions and where do I need to change to get this right?Give the user 'user' the Content Manager role on the folder to which you
want to deploy.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Servé La" <blabla@.bestaatniet.nl> wrote in message
news:O0%23tvvk$EHA.2580@.TK2MSFTNGP15.phx.gbl...
>I have a freshly installed reporting server/sql server and I have an older
> visual studio reporting project.
> Now I wanted to change the deployment url to the new server, but whenever
> I
> try to deploy I get the message: "The permissions granted to user 'user'
> are
> insufficient for performing this operation."
> What permissions and where do I need to change to get this right?
>

deployment error

A report runs well in Visual Studio environment. Once it is deployed to the local report server, got an #Error indication without an actual message. The report has an embedded code with a database connection in it. Any idea what the problem is?

Thank you very much!

Could be a security issue regarding the database connection. If i understand you correctly, you connect to a database in custom code? If you have trusted connection in your custom code, maybe it is not the same user that makes the database call when the report runs in ReportServer as in Visual Studio and you get an exception?|||

Thanks for your response. I thought it could be a security issue too. So I enabled trusted connection and tried using specific uid and pwd too. Neither of them worked.

|||What dp you get if you do a try/catch and return the exception text to a textbox in the report?

What does this custom code do? What does it do with the report? The reason i am asking is that there might be some other way to solve it.|||

The custom code retrieves and outputs another set of data based on the dynamic id outputted from the first set of data.

I'll see what text message I'll get if I use try/catch and let you know.

Thanks for your help.

|||I found out it has something to do with the Code Access Security in .NET. I did some research and found this article was very helpful: http://www.devx.com/codemag/Article/33656/1954?pf=true. Once I followed it step by step, the problem was resolved. Just wanted to share with the community, in case if there is anybody encountered the same problem as I did.

deployment error

A report runs well in Visual Studio environment. Once it is deployed to the local report server, got an #Error indication without an actual message. The report has an embedded code with a database connection in it. Any idea what the problem is?

Thank you very much!

Could be a security issue regarding the database connection. If i understand you correctly, you connect to a database in custom code? If you have trusted connection in your custom code, maybe it is not the same user that makes the database call when the report runs in ReportServer as in Visual Studio and you get an exception?|||

Thanks for your response. I thought it could be a security issue too. So I enabled trusted connection and tried using specific uid and pwd too. Neither of them worked.

|||What dp you get if you do a try/catch and return the exception text to a textbox in the report?

What does this custom code do? What does it do with the report? The reason i am asking is that there might be some other way to solve it.|||

The custom code retrieves and outputs another set of data based on the dynamic id outputted from the first set of data.

I'll see what text message I'll get if I use try/catch and let you know.

Thanks for your help.

|||I found out it has something to do with the Code Access Security in .NET. I did some research and found this article was very helpful: http://www.devx.com/codemag/Article/33656/1954?pf=true. Once I followed it step by step, the problem was resolved. Just wanted to share with the community, in case if there is anybody encountered the same problem as I did.sql

Deploying SQL Reports

I am new to SQL reports ..I have couple of questions.
I have created coupld of SQL reports using SQL server business intelligence
studio on my local box and deployed it in my local machine [datbase is also
local] .It works fine.
Then I tried to point to another database on another machine [ a DB in a
virtual server] using Report Service configuration settings. But nowthe
report is not showing up.
How do I point to another Database from my Reporting server...?
Is there any tool for deploying reports on a server other than the one it
created the report ?
Please let me know..
Thanks
RajeshYou should do it using data source only.
Amarnath, MCTS
"PEEYAR" wrote:
> I am new to SQL reports ..I have couple of questions.
> I have created coupld of SQL reports using SQL server business intelligence
> studio on my local box and deployed it in my local machine [datbase is also
> local] .It works fine.
> Then I tried to point to another database on another machine [ a DB in a
> virtual server] using Report Service configuration settings. But nowthe
> report is not showing up.
> How do I point to another Database from my Reporting server...?
> Is there any tool for deploying reports on a server other than the one it
> created the report ?
> Please let me know..
> Thanks
> Rajesh

Deploying Reports with WSS 3.0 integrated mode

Hi ,

I am trying to deploy reports through visual studio. In the Target server URL, specified the url of the report server as http://<localhost>:<portnumber>/reportserver/Shared Documents/. But
When i deploy it asks for username and password. when i provide them, again login screen appears. Finally deployment fails when i press cancel.

Did anybody face this kind of problem ?

Thanks & Regards,
Kiran Kumar

For deploying reports to a Report Server in SharePoint Integrated mode use the updated Report Designer that ships with SQL 2005 SP2 CTP3. Additionally, it is reco'd to deploy to the SharePoint Document Library with settings as follows:
TargetDataSourceFolder: http://<MyServer>/<mySharePointsite>/Shared Documents/
TargetReportFolder: http://<MyServer>/<mySharePointsite>/Shared Documents/
TargetServerURL: http://<MyServer>/<mySharePointsite>/

Hope this helps.

thanx,
Prash

|||

Can you also check for the following in the web.config file of the SharePoint web site:

- Do you see multiple entries looking like (?):

<location path="_vti_bin/ReportServer/ReportServiceAuthentication.asmx">
<system.web>
<authorization>
<allow users="*" />
</authorization>
</system.web>
</location>

There should be only one such entry for the ReportServiceAuthentication.asmx in the web.config. Please ensure there is only one such entry and retry deploying.

This is a bug that we are working on fixing for RTM.

Deploying reports to the server

Hi,
Currently, i use Visual studio to depoly my reports to QA server. Is there
any way to deploy the reports to server without using visual studio, because
i can not use studio to deploy my reports to production.Sure - use rs.exe script. There is an example script for publishing reports
that Microsoft provide with the installation media called
RublishSampleReports.rss
Taken from page 132 of the Hitchhiker's Guide to SQL Server 2000 Reporting
Services:
"
NOTE Install the Sample Reports Using RS A script execution tool (rs) can be
used to simplify the process of installing the sample reports. The script
PublishSampleReports.rss is located in the \Program Files\ Microsoft SQL
Server\MSSQL\ Reporting Services\Samples\Scripts folder. These scripts are
Visual Basic .NET programs that can be run with rs from the command prompt
as:
rs -i PublishSampleReports.rss -s https://<Server>/reportserver -v
parentFolder="Sample Reports".
"
Peter Blackburn
Windows Server Systems - SQL Server MVP
Hitchhiker's Guide to SQL Server Reporting Services
http://www.sqlreportingservices.net
"Mayur Patel" <mayurworld@.yahoo.com> wrote in message
news:%23DomNF1yEHA.3808@.tk2msftngp13.phx.gbl...
> Hi,
> Currently, i use Visual studio to depoly my reports to QA server. Is
> there any way to deploy the reports to server without using visual studio,
> because i can not use studio to deploy my reports to production.
>
>

Deploying reports on 2000 Reporting Serve

We have RS 2000 runing. Can we create reports in RS 2000 using Visual Studio 2005?No, the editor in VS 2005 uses the new RDL schema. VS 2003 and 2005 should run side by side.

Deploying Reports in Visual Studio

About half the time I try to deploy a report in Visual Studio, I do not get
prompted for a user name or password and then get a message that says the
user does not have sufficient rights. Sometimes rebooting the computer will
help but not always. I was told that it is a credential caching problem.
Does anyone know how to get around this problem?try to save/reopen the report. If that doesn't work. close and re-run BIDs.
There are still some issues to be worked out with the dev environment.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Dave banker" wrote:
> About half the time I try to deploy a report in Visual Studio, I do not get
> prompted for a user name or password and then get a message that says the
> user does not have sufficient rights. Sometimes rebooting the computer will
> help but not always. I was told that it is a credential caching problem.
> Does anyone know how to get around this problem?

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 Reports

Are there any tools outside of Visual Studio and the new 2005 Business
Intelligence Studio for deploying Sql Server Reports? I need to pass
the deployment responsibilities to a separate IT team but can not give
them Visual Studio.
Thank you
TomAnother MVP wrote a scripting tool. The tool builds on what you can do
yourself. You can deploy via commandline. The Books Online tells more.
Reporting Services Scripter
http://www.sqldbatips.com/showarticle.asp?ID=62
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<tberry@.vhb.com> wrote in message
news:1138897611.311594.306840@.g43g2000cwa.googlegroups.com...
> Are there any tools outside of Visual Studio and the new 2005 Business
> Intelligence Studio for deploying Sql Server Reports? I need to pass
> the deployment responsibilities to a separate IT team but can not give
> them Visual Studio.
> Thank you
> Tom
>

Deploying report to another server

Hi,
We have some SQL reporting server reports created on my machine using SQL
Server 2000 and Visual Studio .Net 2003.
The reports are created on my local machine against a test database, I now
need to deploy the finished reports to a seperate reporting server at a
clients premises. I cannot access their server from my local machine so am
unable to deploy them from my machine using the path to their server in
Visual Studios deployment section.
Is there any way I can export the reports from my machine and import them on
their server through the reporting services interface and create a data
source with the same name as I'm using or do I need to find a way to connect
to their network and deploy the reports through visual studio for them to
work properly?
Thanks, SteveIf you get access to their Reports website ie
http://theirsite/Reports/Pages/Folder.aspx
you can simply Upload a File. Simply point to your .rdl file and
upload the report. You still have to have permission as a content
manager to do this and then point the report to the correct data
source, but it means you don't have to use the Visual Studio Deploy
method.
HTH
Weelin
IMGroup Senior Consultant
www.imgroup.com
Steve wrote:
> Hi,
> We have some SQL reporting server reports created on my machine using SQL
> Server 2000 and Visual Studio .Net 2003.
> The reports are created on my local machine against a test database, I now
> need to deploy the finished reports to a seperate reporting server at a
> clients premises. I cannot access their server from my local machine so am
> unable to deploy them from my machine using the path to their server in
> Visual Studios deployment section.
> Is there any way I can export the reports from my machine and import them on
> their server through the reporting services interface and create a data
> source with the same name as I'm using or do I need to find a way to connect
> to their network and deploy the reports through visual studio for them to
> work properly?
> Thanks, Steve

Deploying RDLs & RDSs without VS .NET or ReportManager

I was asked to design and deliver SQL Reporting Services reports to a
customer; just the RDLs and RDSs. The customer will not have Visual Studio
.NET (or any other .NET IDE) loaded on their computer. So, I have a couple
of questions:
1. How can I programmatically deploy all the RDLs and RDSs to the
ReportServer without an IDE?
2. If, after the initial deployment, changes are made to the RDLs and/or
RDSs, how can I programmatically re-deploy these "fixed" items without
having VS .NET on the computer?
Thanks.There is a SOAP API you can use:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_ref_soapapi_service_ak_1xfd.asp
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"PTurley" <pturley@.nospam.com> wrote in message
news:Od34GdwDFHA.392@.TK2MSFTNGP14.phx.gbl...
>I was asked to design and deliver SQL Reporting Services reports to a
> customer; just the RDLs and RDSs. The customer will not have Visual
> Studio
> .NET (or any other .NET IDE) loaded on their computer. So, I have a
> couple
> of questions:
> 1. How can I programmatically deploy all the RDLs and RDSs to the
> ReportServer without an IDE?
> 2. If, after the initial deployment, changes are made to the RDLs and/or
> RDSs, how can I programmatically re-deploy these "fixed" items without
> having VS .NET on the computer?
> Thanks.
>|||At my company, ICCO (www.icco.com), we have designed a tool in VB.NET that
does precisely that. We use it to deploy reports to our new customers, or
update batches of reports to existing customers. I will sell it to you for
$150 if you are interested. I can be reached at (954) 5471293.
"PTurley" wrote:
> I was asked to design and deliver SQL Reporting Services reports to a
> customer; just the RDLs and RDSs. The customer will not have Visual Studio
> ..NET (or any other .NET IDE) loaded on their computer. So, I have a couple
> of questions:
> 1. How can I programmatically deploy all the RDLs and RDSs to the
> ReportServer without an IDE?
> 2. If, after the initial deployment, changes are made to the RDLs and/or
> RDSs, how can I programmatically re-deploy these "fixed" items without
> having VS .NET on the computer?
> Thanks.
>
>

Deploying RDL and RDS to customer without Visual Studio

I was asked to design and deliver SQL Reporting Services reports to a
customer. The customer will not have Visual Studio on their network. I've
read that you can script the deployment of reports and shared datasources
using RS.EXE but have not been able to figure it out with the instructions in
the documentation.
Can anyone provide an example of how I would do this?I posted this message earlier today, but let me try one more time:
Why not use the upload file buttom of the Report Manager
(http://yourreportsite/reports) to do the deployment?
a) Upload the rdl;
b) Create the db connection manually again within the Report Manager.
Tao
"AdamB" wrote:
> I was asked to design and deliver SQL Reporting Services reports to a
> customer. The customer will not have Visual Studio on their network. I've
> read that you can script the deployment of reports and shared datasources
> using RS.EXE but have not been able to figure it out with the instructions in
> the documentation.
> Can anyone provide an example of how I would do this?|||I will do that for now, thanks. But I was hoping to create an ASP.Net
application where I could select an rdl or rds file and call the web service
to add the selected resource behind the scenes
"Tao Zuo" wrote:
> I posted this message earlier today, but let me try one more time:
> Why not use the upload file buttom of the Report Manager
> (http://yourreportsite/reports) to do the deployment?
> a) Upload the rdl;
> b) Create the db connection manually again within the Report Manager.
> Tao
>
> "AdamB" wrote:
> > I was asked to design and deliver SQL Reporting Services reports to a
> > customer. The customer will not have Visual Studio on their network. I've
> > read that you can script the deployment of reports and shared datasources
> > using RS.EXE but have not been able to figure it out with the instructions in
> > the documentation.
> >
> > Can anyone provide an example of how I would do this?|||Do you still require assistance regarding thiis topic. Have you tried
running the PublishSampleReports.rss script from the command window. Or have
you not reached that far as yet. If you have not then search for "sample
scripts" in Visual Studio.Net help. There is a link "Script for Publishing
Sample Reports". Click on the link and then read the instructions that
follow. If you are still unclear as to what to do, then i will try and help
u further.
Cheers
"AdamB" <AdamB@.discussions.microsoft.com> wrote in message
news:6E73D669-1411-4440-8DDB-EFD7AA0615AD@.microsoft.com...
>I will do that for now, thanks. But I was hoping to create an ASP.Net
> application where I could select an rdl or rds file and call the web
> service
> to add the selected resource behind the scenes
> "Tao Zuo" wrote:
>> I posted this message earlier today, but let me try one more time:
>> Why not use the upload file buttom of the Report Manager
>> (http://yourreportsite/reports) to do the deployment?
>> a) Upload the rdl;
>> b) Create the db connection manually again within the Report Manager.
>> Tao
>>
>> "AdamB" wrote:
>> > I was asked to design and deliver SQL Reporting Services reports to a
>> > customer. The customer will not have Visual Studio on their network.
>> > I've
>> > read that you can script the deployment of reports and shared
>> > datasources
>> > using RS.EXE but have not been able to figure it out with the
>> > instructions in
>> > the documentation.
>> >
>> > Can anyone provide an example of how I would do this?|||Thanks, I'll check it out. What about deploying data sources. I see that
the Web Service has a CreateDataSource class. Do you know if this is pretty
straightforward?
"Sanjeev" wrote:
> Do you still require assistance regarding thiis topic. Have you tried
> running the PublishSampleReports.rss script from the command window. Or have
> you not reached that far as yet. If you have not then search for "sample
> scripts" in Visual Studio.Net help. There is a link "Script for Publishing
> Sample Reports". Click on the link and then read the instructions that
> follow. If you are still unclear as to what to do, then i will try and help
> u further.
> Cheers
> "AdamB" <AdamB@.discussions.microsoft.com> wrote in message
> news:6E73D669-1411-4440-8DDB-EFD7AA0615AD@.microsoft.com...
> >I will do that for now, thanks. But I was hoping to create an ASP.Net
> > application where I could select an rdl or rds file and call the web
> > service
> > to add the selected resource behind the scenes
> >
> > "Tao Zuo" wrote:
> >
> >> I posted this message earlier today, but let me try one more time:
> >>
> >> Why not use the upload file buttom of the Report Manager
> >> (http://yourreportsite/reports) to do the deployment?
> >>
> >> a) Upload the rdl;
> >> b) Create the db connection manually again within the Report Manager.
> >>
> >> Tao
> >>
> >>
> >>
> >> "AdamB" wrote:
> >>
> >> > I was asked to design and deliver SQL Reporting Services reports to a
> >> > customer. The customer will not have Visual Studio on their network.
> >> > I've
> >> > read that you can script the deployment of reports and shared
> >> > datasources
> >> > using RS.EXE but have not been able to figure it out with the
> >> > instructions in
> >> > the documentation.
> >> >
> >> > Can anyone provide an example of how I would do this?
>
>

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.

Deploying a Reporting Services 2005 Report to a SQL 2000 Report Server ..

Does anyone know if it is possible to deploy a RS2005 report created in Visual Studio .NET 2005 to a SQL 2000 Report Server ? If so, online references would be greatly appreciated.

Please read this related thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=344701&SiteID=1

The short answer is: you cannot directly publish a RS 2005 report definition on a RS 2000 report server.

-- Robert

|||Thank you Robert for the concise answer and related thread.

Deploying a managed code trigger

I am working on a managed code trigger using visual studio 2005 and SQL 2005
.
When I try to deploy it I get the following error:
Incorrect syntax near 'EXTERNAL'. You may need to set the compatibility
level of the current database to a higher value to enable this feature. See
help for the stored procedure sp_dbcmptlevel.
I have set the assembly permission level to safe.
The database I am using is one I restored from SQL 2000 into SQL 2005. I
tried setting the datbase compatibility level to 8, and then to 7, and still
get the same error. Any ideas?
Ron Coffee, MCSD> The database I am using is one I restored from SQL 2000 into SQL 2005. I
> tried setting the datbase compatibility level to 8, and then to 7, and
> still
> get the same error. Any ideas?
CLR triggers were introduced in SQL 2005. Have you tried setting the
database compatibility level to 90 (SQL 2005)?
Hope this helps.
Dan Guzman
SQL Server MVP
"Ron_Coffee" <Ron_Coffee@.discussions.microsoft.com> wrote in message
news:181E0D5F-D699-477C-B266-31D2AE5B464E@.microsoft.com...
>I am working on a managed code trigger using visual studio 2005 and SQL
>2005.
> When I try to deploy it I get the following error:
> Incorrect syntax near 'EXTERNAL'. You may need to set the compatibility
> level of the current database to a higher value to enable this feature.
> See
> help for the stored procedure sp_dbcmptlevel.
>
> I have set the assembly permission level to safe.
> The database I am using is one I restored from SQL 2000 into SQL 2005. I
> tried setting the datbase compatibility level to 8, and then to 7, and
> still
> get the same error. Any ideas?
> --
> Ron Coffee, MCSD|||You'll need compatibility level 9 -- SQL 2005 is version 9.0
"Ron_Coffee" wrote:

> I am working on a managed code trigger using visual studio 2005 and SQL 20
05.
> When I try to deploy it I get the following error:
> Incorrect syntax near 'EXTERNAL'. You may need to set the compatibility
> level of the current database to a higher value to enable this feature. Se
e
> help for the stored procedure sp_dbcmptlevel.
>
> I have set the assembly permission level to safe.
> The database I am using is one I restored from SQL 2000 into SQL 2005. I
> tried setting the datbase compatibility level to 8, and then to 7, and sti
ll
> get the same error. Any ideas?
> --
> Ron Coffee, MCSD|||Thanks! That solved it
--
Ron Coffee, MCSD
"Dan Guzman" wrote:

> CLR triggers were introduced in SQL 2005. Have you tried setting the
> database compatibility level to 90 (SQL 2005)?
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Ron_Coffee" <Ron_Coffee@.discussions.microsoft.com> wrote in message
> news:181E0D5F-D699-477C-B266-31D2AE5B464E@.microsoft.com...
>
>

Deployed reports fail

Help!
I have created some reports in the Visual Studio client, here they work ok
and I can preview the output. But when I deploy them to the reportserver
although the client reports all is well...
Deploying data source '/IODINE Reporting Project/Projectserver'.
Deploying report '/IODINE Reporting Project/Official Milestones - Drill Down'.
Deploying report '/IODINE Reporting Project/Official Milestones - Matrix'.
Deploy complete -- 0 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ========== ========== Deploy: 1 succeeded, 0 failed, 0 skipped ========== ... I can see them on the server, but when I try to run them I get...
An error has occurred during report processing.
Cannot create a connection to data source 'Projectserver'.
For more information about this error navigate to the report server on the
local server machine, or enable remote errors
Anybody any ideas?Hi,
This might be because the data source credentials are not persisting
in the reportserver. Enter the credentials in the data source using the
report manager or set the option to persist the user name and password
by selecting "allow saving password" in the datalink screen.|||Hi Raghu,
Thanks, but we are using Windows Authentication (Integrated Security)
Cheers,
Geoff
"Raghu" wrote:
> Hi,
> This might be because the data source credentials are not persisting
> in the reportserver. Enter the credentials in the data source using the
> report manager or set the option to persist the user name and password
> by selecting "allow saving password" in the datalink screen.
>

Deploy SQL Server Management Studio

Hello,

I need to deploy Server Management Studio by Active directory and I will like to know where I can find the MSI do it. (I didn't find it on the CD)

Thank you for your help

There is no separate msi file for SQL Server 2005 Management Studio. Instead, SQL Server Management Studio is packed in SqlRun_Tools.msi under tools directory.

Deploy single report with keyboard shortcut?

Is it possible to deploy a single report from Visual Studio 2003 with a
keyboard shortcut? I can do it by right clicking in the Solution Explorer,
but it would be nice to just press "some combination of buttons" to make my
current report get deployed to the server.
Kaisa M. Lindahl LervikYou can use Tools\Options and Environment(Keyboard) settings to set shortcut
keys. There is a Build.DeploySelection command, but my attempts show that it
deploys the entire project and that you have to be in Solution Explorer for
the shortcut to activate. You can try for other combinations though.
Rodney Landrum
"Kaisa M. Lindahl Lervik" <kaisaml@.hotmail.com> wrote in message
news:uiTk6z7VGHA.2760@.TK2MSFTNGP11.phx.gbl...
> Is it possible to deploy a single report from Visual Studio 2003 with a
> keyboard shortcut? I can do it by right clicking in the Solution Explorer,
> but it would be nice to just press "some combination of buttons" to make
> my current report get deployed to the server.
> Kaisa M. Lindahl Lervik
>