Deployment Security Problem

Hi,
I am trying to deploy my reports to a new server running reporting
services w/ SQL Server 2000 on the local machine. The ReportServer web site
has anonymous access NOT checked and Windows Integration selected. I'm
logged onto my machine with my domain account and when I try to deploy my
reports in VS 2003 I get "The underlying connection was closed: Could not
establish trust relationship with remote server." I do NOT have "Require
SSL" turned on and I know it has something to do with the way my credentials
are being passed (or not passed). If I turn on the option to allow
anonymous access to the reportserver site then I get a message that my
IUSR_<machinename> has insufficient privleges to perform the actions, which
is fine I don't want anonymous access on anyway.
How do I resolve deploying reports to the report server with my domain
account? I used the same domain account to install SQL Server and Reporting
Services and I am a local administrator on the server.
Thanks, ChrisIn addition to what I've discovered...
I can take the same URL I'm using for the TargetServerURL property and
browse to the report server. I get a pop-up dialog box to input my
credentials and I'm authenticated fine. Based on Microsoft Knowledge Base
Article - 842517 it would seem that the login dialog box should appear, but
it doesn't and just the error "Could not
> establish trust relationship with remote server." appears. The local
administrators are "content managers" for reporting services and I am a
member of that group, though I don't think the deployment process is making
it that far.
Thanks, Chris
"Chris" <chrisf@.unr.edu> wrote in message
news:u03AZPxfEHA.3536@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am trying to deploy my reports to a new server running reporting
> services w/ SQL Server 2000 on the local machine. The ReportServer web
site
> has anonymous access NOT checked and Windows Integration selected. I'm
> logged onto my machine with my domain account and when I try to deploy my
> reports in VS 2003 I get "The underlying connection was closed: Could not
> establish trust relationship with remote server." I do NOT have "Require
> SSL" turned on and I know it has something to do with the way my
credentials
> are being passed (or not passed). If I turn on the option to allow
> anonymous access to the reportserver site then I get a message that my
> IUSR_<machinename> has insufficient privleges to perform the actions,
which
> is fine I don't want anonymous access on anyway.
> How do I resolve deploying reports to the report server with my domain
> account? I used the same domain account to install SQL Server and
Reporting
> Services and I am a local administrator on the server.
> Thanks, Chris
>|||Chris:
In IE's security settings for the zone, is User Authentication set to
automatic logon or prompt? You might want to check here (Tools ->
Options -> Security -> Custom Level (for the zone your report server
is in).
--
Scott
http://www.OdeToCode.com
On Tue, 10 Aug 2004 12:54:27 -0700, "Chris" <chrisf@.unr.edu> wrote:
>Hi,
> I am trying to deploy my reports to a new server running reporting
>services w/ SQL Server 2000 on the local machine. The ReportServer web site
>has anonymous access NOT checked and Windows Integration selected. I'm
>logged onto my machine with my domain account and when I try to deploy my
>reports in VS 2003 I get "The underlying connection was closed: Could not
>establish trust relationship with remote server." I do NOT have "Require
>SSL" turned on and I know it has something to do with the way my credentials
>are being passed (or not passed). If I turn on the option to allow
>anonymous access to the reportserver site then I get a message that my
>IUSR_<machinename> has insufficient privleges to perform the actions, which
>is fine I don't want anonymous access on anyway.
>How do I resolve deploying reports to the report server with my domain
>account? I used the same domain account to install SQL Server and Reporting
>Services and I am a local administrator on the server.
>Thanks, Chris
>|||Hey Scott,
The IE zone setting changes don't have any affect. Visual Studio
continues to report the trust relationship error. I've tried both secure
and non-secure TargetServerURL properties.
Chris
"Scott Allen" <bitmask@.[nospam].fred.net> wrote in message
news:jp1jh0dq2m82lm982j8rab8flnjjde59o2@.4ax.com...
> Chris:
> In IE's security settings for the zone, is User Authentication set to
> automatic logon or prompt? You might want to check here (Tools ->
> Options -> Security -> Custom Level (for the zone your report server
> is in).
> --
> Scott
> http://www.OdeToCode.com
> On Tue, 10 Aug 2004 12:54:27 -0700, "Chris" <chrisf@.unr.edu> wrote:
> >Hi,
> > I am trying to deploy my reports to a new server running reporting
> >services w/ SQL Server 2000 on the local machine. The ReportServer web
site
> >has anonymous access NOT checked and Windows Integration selected. I'm
> >logged onto my machine with my domain account and when I try to deploy my
> >reports in VS 2003 I get "The underlying connection was closed: Could not
> >establish trust relationship with remote server." I do NOT have "Require
> >SSL" turned on and I know it has something to do with the way my
credentials
> >are being passed (or not passed). If I turn on the option to allow
> >anonymous access to the reportserver site then I get a message that my
> >IUSR_<machinename> has insufficient privleges to perform the actions,
which
> >is fine I don't want anonymous access on anyway.
> >
> >How do I resolve deploying reports to the report server with my domain
> >account? I used the same domain account to install SQL Server and
Reporting
> >Services and I am a local administrator on the server.
> >
> >Thanks, Chris
> >
>|||Well, I changed the security on the web site to require secure connections
and installed the certificate from the server into my machine's certificate
store and the deploy worked. I don't quite fully understand why non-ssl
connections don't work, but turning ssl on and making sure the CA was
trusted fixed the problem. Could this have been a bug or is there some
requirement that a secure connection be used to deploy reporting service
objects?
Chris
"Scott Allen" <bitmask@.[nospam].fred.net> wrote in message
news:jp1jh0dq2m82lm982j8rab8flnjjde59o2@.4ax.com...
> Chris:
> In IE's security settings for the zone, is User Authentication set to
> automatic logon or prompt? You might want to check here (Tools ->
> Options -> Security -> Custom Level (for the zone your report server
> is in).
> --
> Scott
> http://www.OdeToCode.com
> On Tue, 10 Aug 2004 12:54:27 -0700, "Chris" <chrisf@.unr.edu> wrote:
> >Hi,
> > I am trying to deploy my reports to a new server running reporting
> >services w/ SQL Server 2000 on the local machine. The ReportServer web
site
> >has anonymous access NOT checked and Windows Integration selected. I'm
> >logged onto my machine with my domain account and when I try to deploy my
> >reports in VS 2003 I get "The underlying connection was closed: Could not
> >establish trust relationship with remote server." I do NOT have "Require
> >SSL" turned on and I know it has something to do with the way my
credentials
> >are being passed (or not passed). If I turn on the option to allow
> >anonymous access to the reportserver site then I get a message that my
> >IUSR_<machinename> has insufficient privleges to perform the actions,
which
> >is fine I don't want anonymous access on anyway.
> >
> >How do I resolve deploying reports to the report server with my domain
> >account? I used the same domain account to install SQL Server and
Reporting
> >Services and I am a local administrator on the server.
> >
> >Thanks, Chris
> >
>|||I am using integrated security without ssl. I did have a problem once where
I went through an install without unchecking ssl and I was messed up. Don't
remember how I got out of the hole. However, I have done a couple of
installs since then and made sure to un-check ssl and everything went
smoothly.
Bruce L-C
"Chris" <chrisf@.unr.edu> wrote in message
news:%23hQmER7fEHA.140@.TK2MSFTNGP12.phx.gbl...
> Well, I changed the security on the web site to require secure connections
> and installed the certificate from the server into my machine's
certificate
> store and the deploy worked. I don't quite fully understand why non-ssl
> connections don't work, but turning ssl on and making sure the CA was
> trusted fixed the problem. Could this have been a bug or is there some
> requirement that a secure connection be used to deploy reporting service
> objects?
> Chris
> "Scott Allen" <bitmask@.[nospam].fred.net> wrote in message
> news:jp1jh0dq2m82lm982j8rab8flnjjde59o2@.4ax.com...
> > Chris:
> >
> > In IE's security settings for the zone, is User Authentication set to
> > automatic logon or prompt? You might want to check here (Tools ->
> > Options -> Security -> Custom Level (for the zone your report server
> > is in).
> >
> > --
> > Scott
> > http://www.OdeToCode.com
> >
> > On Tue, 10 Aug 2004 12:54:27 -0700, "Chris" <chrisf@.unr.edu> wrote:
> >
> > >Hi,
> > > I am trying to deploy my reports to a new server running reporting
> > >services w/ SQL Server 2000 on the local machine. The ReportServer web
> site
> > >has anonymous access NOT checked and Windows Integration selected. I'm
> > >logged onto my machine with my domain account and when I try to deploy
my
> > >reports in VS 2003 I get "The underlying connection was closed: Could
not
> > >establish trust relationship with remote server." I do NOT have
"Require
> > >SSL" turned on and I know it has something to do with the way my
> credentials
> > >are being passed (or not passed). If I turn on the option to allow
> > >anonymous access to the reportserver site then I get a message that my
> > >IUSR_<machinename> has insufficient privleges to perform the actions,
> which
> > >is fine I don't want anonymous access on anyway.
> > >
> > >How do I resolve deploying reports to the report server with my domain
> > >account? I used the same domain account to install SQL Server and
> Reporting
> > >Services and I am a local administrator on the server.
> > >
> > >Thanks, Chris
> > >
> >
>

Deployment Problem

I get the following error while deploying on my local machine with my machin
e name or ip
A connection could not be established to the ReportServer http://machinename/Repor
tServer
If i deploy with localhost instead of machinename it works.
Any ideas why that happens.
Help would be appreciated.
ThanksI suggest you check your IIS configuration. Check the properties - web site
tab - advanced button of the Default website in IIS and see if you have
anything other than just "Default 80" under "Multiple identities for this
web site"
Tunji
"ReportFaqGuy" <anonymous@.discussions.microsoft.com> wrote in message
news:8160D89C-32CE-40C4-9A31-6066893C2048@.microsoft.com...
> I get the following error while deploying on my local machine with my
machine name or ip
> A connection could not be established to the ReportServer
http://machinename/ReportServer
> If i deploy with localhost instead of machinename it works.
> Any ideas why that happens.
> Help would be appreciated.
> Thanks
>sql

Deployment of Server Reports

HI,
We have Server Reports in our application deployed on the Report
Server(local host). What all steps need to be done when we make an MSI of the
project for deplying reports on the new server? Do we need to first deploy
the reports on new server and then make an MSI? Need help.
Thanks in Advance.
ParimalYou do not/cannot use MSI to deploy reports. There are three ways to deploy
reports.
1. Use the IDE to deploy reports to production server (that is what I do).
2. Copy reports to server and then use Report Manager to add reports
3. Write a script. Search Books Online under scripting, samples
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Parimal" <Parimal@.discussions.microsoft.com> wrote in message
news:FC5A0A06-B81B-4183-83F4-98C4414A1B0A@.microsoft.com...
> HI,
> We have Server Reports in our application deployed on the Report
> Server(local host). What all steps need to be done when we make an MSI of
> the
> project for deplying reports on the new server? Do we need to first
> deploy
> the reports on new server and then make an MSI? Need help.
> Thanks in Advance.
> Parimal

Deployment of Rdl files and datasource to Production Server

Hi All,
I have develoded the SRS report using vs.net , and deployed to my local
sever using vs.net all works fine.
No i need to deploy these reports to a production server where vs.net is
not present.
So can any one tell me how to automate this process of deployment to
production server insteed of mannualy uploading the rld files and creating
data source in report manager.
Can set up be made for this scenarion to my production server.
Please help me it's urgent,
Thanks in advanceYou can create a deployment script with the rss utility in RS. Please
refer to the two scripts that ship with the product and customize it to
deploy to your production server. Command line arguments can be
specified for the datasource, connection string , report server url
etc.|||You have here the code for deploy the report on any SQLRS server
http://www.rdlcomponents.com/ASPExamples/default.aspx
Jerry
"RN" wrote:
> You can create a deployment script with the rss utility in RS. Please
> refer to the two scripts that ship with the product and customize it to
> deploy to your production server. Command line arguments can be
> specified for the datasource, connection string , report server url
> etc.
>

Deployment from SQL 2000 to SQL 2005

I will be moving my website from my local dev server to the live environment soon. I've been using SQL 2000 to develop, but the live DB is SQL 2005. My app uses exclusively stored procedures for all data access.

What suprises are in store for me when I migrate the site?!

Thanks, Jamie

If you don't have any DTS, scheduled tasks to worry about. Then the migration is very straight forward, personally, I have not encounter any problems. What I did is to script the entire DB's table def, indexes, sp, udf. Then run it once on 2005.

This article contains step-by-step process:http://www.aspfree.com/c/a/MS-SQL-Server/Moving-Data-from-SQL-Server-2000-to-SQL-Server-2005/

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

Deployment and Configuration

Hi:

I have a SSIS package on my local machine, and would like to deploy it to DEV server. Which files should i be moving to the SQL DEV Server? and where? How do I modify connection managers or is there a way to do that from the Management Studio or some other way? Thanks and I would definitely appreciate some prompt advise.

Someone will provide more information, I'm sure, but have you searched this forum for "deploy"?|||

Yes, I have checked out some posts on Deployment, but havent ran into anything standard. There seems to be more than one way of deploying. I would like to follow best practices. Thanks.

|||That's the beauty of SSIS. There are many ways to accomplish one task. The "best practice" is usually best determined on your own so that it fits your way of life. We each have our own requirements/standards so what my best practices are may not be Jamie's, or Rafael's, or.....|||

I prefer to have my packages as File system files (.dtsx); then all I have to do is to move (copy the files) them into a folder in the server. I use SQL Server table based package configurations to change connection strings at run time (and any other required property). I know there is a Deployment wizard in BIDS but I have never looked into that; so you do the research. Some times I use the SET option in the execution command line to override properties in the packages while testing.

As Phil points out; the best practice sometimes depends in your preferences, IT standards, etc....

|||

Lets say I would like to use the "copy over the files" method. What files am I moving over? and where on the server? Also for changing connection strings, how do i set the properties? Where? Thanks.

|||

Only the .dtsx files are required. In case you are using package configurations based on a XML file; you need to copy and secure it as appropriate. You choose the location; just keep in mind that that location needs to be accessible to the user running the packages.

To set connection strings; you can use package configurations; I use a combination of XML file to set the connection string of my SQL server based configuration table. If you search for 'Package configurations' you will find a lot of info. Jamie Thomson's blog, http://www.sqlis.com/ and BOL have some good info.

|||

The package I have will be scheduled daily, although, the connection strings config is only meant for Deployment Process, because the DTSX has to go thru DEV, QA, BETA, and onwards to PROD. Thanks.

|||

MA2005 wrote:

The package I have will be scheduled daily, although, the connection strings config is only meant for Deployment Process, because the DTSX has to go thru DEV, QA, BETA, and onwards to PROD. Thanks.

Your scenario is a very common one. SQL Server agent will be your best bet for scheduling your packages. I too, like Rafael, prefer to store my packages in the file system, versus storing them in MSDB.|||

If the only thing that needs to be changed/configured is a single connection string, and you have only one package (no parent package calling child packages)...you may want to use the SET option of the package execution command line instead of package configurations. I don’t like that approach when I have many packages that need to be configured in the same way; as I have to maintain every command line, as opposed of maintaining an entry in a config file/table

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 Reporting Services

Hi,

I've installed reporting services and reporting services sp2 on my local computer and I have admin rights on this computer.

But when I am trying to deploy reports in the report server, It is asking for login and password. If I give my machine login and password, it is not taking.

Even if type http://localhost/reportserver or http://localhost/reports it is giving an error saying

"CS0016: Could not write to output file 'c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reportserver\1bbf2d18\2968d42e\App_global.asax.2trocnva.dll' -- 'Access is denied. "

I've been trying to fix it for past few days but I couldn't.

Can anyone help me on this., Please.

Thanks in advance

Kusuma

Hi,

Check this link:http://blogs.msdn.com/astebner/archive/2005/04/08/406671.aspx

Thanks

|||

The solution from this thread below worked for me. I had to add write access to the Network Service account to the c:\winnt\temp directory.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=588823&SiteID=1

Deploying Reporting Services

Hi,

I've installed reporting services and reporting services sp2 on my local computer and I have admin rights on this computer.

But when I am trying to deploy reports in the report server, It is asking for login and password. If I give my machine login and password, it is not taking.

Even if type http://localhost/reportserver or http://localhost/reports it is giving an error saying

"CS0016: Could not write to output file 'c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reportserver\1bbf2d18\2968d42e\App_global.asax.2trocnva.dll' -- 'Access is denied. "

I've been trying to fix it for past few days but I couldn't.

Can anyone help me on this., Please.

Thanks in advance

Kusuma

Hi,

Check this link:http://blogs.msdn.com/astebner/archive/2005/04/08/406671.aspx

Thanks

|||

The solution from this thread below worked for me. I had to add write access to the Network Service account to the c:\winnt\temp directory.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=588823&SiteID=1

Deploying Report Server to a Shared Server

I wish to deploy reporting capability on a web page with a ReportViewer to a shared server environment. On my local server, all works fine when IU view the aspx page, I can see my report on my aspx page, images and all.

However, when I deploy to my shared server, I can not get the page to work. Googling, I heard that I needed to copy three files to the bin folder, which I did. I copied:

Microsoft.ReportViewer.Common.dll
Microsoft.ReportViewer.WinForms.dll
Microsoft.ReportViewer.ProcessingObjectModel.dll

But now I get the error when accessing everything but the default page:

"Exception Details: System.Security.Policy.PolicyException: Required permissions cannot be acquired."

Any help would be appreciated,

Thank you,

Paolo

I assume that your local server has Visual Studio installed but your shared server does not. In that case you need to install the Report Viewer Redistributable on your shared server. You can download the redistributable package from here: http://www.microsoft.com/downloads/details.aspx?FamilyID=8a166cac-758d-45c8-b637-dd7726e61367&DisplayLang=en

-Albert

|||

Thank you. Correct assumption.

I just learned that my hosting provider prohibits deploying "reporting software", so I will be looking at one that does. (what is different between a dataset needed to supply a webform and a reporting object ?) But will any shared provider allow installation of the redistributable?

Thanks again,

Paolo

Deploying MSSQL 2005 Express DB to MSSQL 2005 WKGP Errors

DB is developed on local computer with MSSQL 2005 Express. My host is on MSSQL 2005 workgroup. Are they compatible, because I am getting errors? Is my approach wrong?

I have tried several approaches.

A) I created a backup of database on my local, then placed a copy on the server. Then I tried to restore through Server Management Studio. I get this error.

TITLE: Microsoft SQL Server Management Studio

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

ADDITIONAL INFORMATION:

The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database.

RESTORE FILELIST is terminating abnormally. (Microsoft SQL Server, Error: 3169)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.2039&EvtSrc=MSSQLServer&EvtID=3169&LinkId=20476

BUTTONS:

OK

B: I also have tried copying the database. I put it in the same path as the other databases that can be read with server management studio on the server. Then, tried to get to it through server managements studio and it did not appear. So I tried to attach it. Then I received this error:

TITLE: Microsoft SQL Server Management Studio

Attach database failed for Server 'MROACH1'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Could not find row in sysindexes for database ID 10, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.

Could not open new database 'LodgingDB'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476

BUTTONS:

OK

C: I have also tried opening the Database, and back up file through Server Management Studio. without success.

D: I also tried Windows and Software update at microsoft update, but no updates were recommended for Version on Server.

I'm surprised this is so hard. My original data base was created in same family of software. 2005 MS SQL Express. I could use some direct help from someone experienced with this. Am I doing it wrong or are the DB versions incompatible.

Mark Roach

Hi Mark,

The first error you mention would indicate that your hosting company is using SQL 2000 not SQL 2005. Database files are not backward compatible. You should verify with your host what version of SQL Server they have, or if they have both 2000 and 2005, that they are pointing you to a 2005 server.

Mike

|||

Thanks Mike,

The host machine is on MSSQL 2005 WorkGroup.

|||

Actually, you may be incorrect about what is running on the hosting system.

The error message from the restore:

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.2039&EvtSrc=MSSQLServer&EvtID=3169&LinkId=20476

indicates (ProdVer=08.00.2039) that it is running SQL 2000, not SQL 2005. Also, the error message talking about versions of databases indicates the same.

All SKUs/editions of SQL databases of the same version are compatible. There are no diffences in database format between Express and Workgroup as long as both are the same version.

|||

Hi there,

I got the same error when I tried to restore the SQL 2005 DB to SQL 2005 DB.

Were you able to figure this one out? If so, could you please let me know?

Thanks in advance,

SG.

Deploying MSSQL 2005 Express DB to MSSQL 2005 WKGP Errors

DB is developed on local computer with MSSQL 2005 Express. My host is on MSSQL 2005 workgroup. Are they compatible, because I am getting errors? Is my approach wrong?

I have tried several approaches.

A) I created a backup of database on my local, then placed a copy on the server. Then I tried to restore through Server Management Studio. I get this error.

TITLE: Microsoft SQL Server Management Studio

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

ADDITIONAL INFORMATION:

The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database.

RESTORE FILELIST is terminating abnormally. (Microsoft SQL Server, Error: 3169)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.2039&EvtSrc=MSSQLServer&EvtID=3169&LinkId=20476

BUTTONS:

OK

B: I also have tried copying the database. I put it in the same path as the other databases that can be read with server management studio on the server. Then, tried to get to it through server managements studio and it did not appear. So I tried to attach it. Then I received this error:

TITLE: Microsoft SQL Server Management Studio

Attach database failed for Server 'MROACH1'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Could not find row in sysindexes for database ID 10, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.

Could not open new database 'LodgingDB'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476

BUTTONS:

OK

C: I have also tried opening the Database, and back up file through Server Management Studio. without success.

D: I also tried Windows and Software update at microsoft update, but no updates were recommended for Version on Server.

I'm surprised this is so hard. My original data base was created in same family of software. 2005 MS SQL Express. I could use some direct help from someone experienced with this. Am I doing it wrong or are the DB versions incompatible.

Mark Roach

Hi Mark,

The first error you mention would indicate that your hosting company is using SQL 2000 not SQL 2005. Database files are not backward compatible. You should verify with your host what version of SQL Server they have, or if they have both 2000 and 2005, that they are pointing you to a 2005 server.

Mike

|||

Thanks Mike,

The host machine is on MSSQL 2005 WorkGroup.

|||

Actually, you may be incorrect about what is running on the hosting system.

The error message from the restore:

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.2039&EvtSrc=MSSQLServer&EvtID=3169&LinkId=20476

indicates (ProdVer=08.00.2039) that it is running SQL 2000, not SQL 2005. Also, the error message talking about versions of databases indicates the same.

All SKUs/editions of SQL databases of the same version are compatible. There are no diffences in database format between Express and Workgroup as long as both are the same version.

|||

Hi there,

I got the same error when I tried to restore the SQL 2005 DB to SQL 2005 DB.

Were you able to figure this one out? If so, could you please let me know?

Thanks in advance,

SG.

Deploying a SSAS solution from File location using C#

Hi all,
i have created a SSAS solution using BIDS . I have saved the project on local hard disk. Now i need to deploy the solution through C# and not use C#. Can i do that ? if how how?

Regards..
Girija Shankar

Could you describe your goals a bit more? When you create an SSAS solution with BIDS, a script file is created that can be used to deploy a database to SSAS. You could also use the ASCMD application to submit scripts or execute a script via AMO. (I believe the Server object's Execute method handles this.)

B.

|||

Hi Bryan,

Thanks for the reply. The scenario is as folows:

1. I create a SSAS solution. i create the datasource,DSv,cubes and dimensions and Roles.I donot deploy that to the server but save the file to a local drive location.

2. If i go to the local directory path where I saved the solution i will find files such as .database, .cube,.partitions, .dim etc

3. i need to deploy the full solution from this file location to the server. After deployement i can process the cubes one by one using AMO. The processing part is clear to me using AMO but how to deploy from file location i am not able to figure out . All this has to be done through code (C#).

Regards...

Girija Shankar

|||

So, the file in the BIN folder is a complete or near-complete script. You should be able to use standard techniques to read the file (it's just XML though I would read it as a simple text file). With the script in memory, you can then submit it as a string through the AMO Server object's Execute method.

You may also want to review the ASCMD project that comes with the SSAS samples. I believe it has the functionality built in to read a file and execute it like I'm describing. It's also written in C#.

B.

|||

Bryan,

There are four files in bin folder . i suppose i would be using .asdatabase file. read that,envolope that with the create and Object Tags and execute that on server. Is this correct?

Regards...

Girija Shankar

|||

Hi, Another question.

There are some read only tags such as CreatedTimestamp, should i remove them while reading that?

Regards...
Girija Shankar

|||Another option is to use the Deployment Wizard (launched from the Start menu under Microsoft SQL Server->Analysis Services). This wizard has the option to generate a deployment script which is just an XMLA

command that can be sent the the server to deploy and optionally process the cube. This script deployment can be done using Adomd.Net, an XMLA Query in SQL Management Studio, or using the ASCMD.exe command line utilility available at http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en.

Deploying a SSAS solution from File location using C#

Hi all,
i have created a SSAS solution using BIDS . I have saved the project on local hard disk. Now i need to deploy the solution through C# and not use C#. Can i do that ? if how how?

Regards..
Girija Shankar

Could you describe your goals a bit more? When you create an SSAS solution with BIDS, a script file is created that can be used to deploy a database to SSAS. You could also use the ASCMD application to submit scripts or execute a script via AMO. (I believe the Server object's Execute method handles this.)

B.

|||

Hi Bryan,

Thanks for the reply. The scenario is as folows:

1. I create a SSAS solution. i create the datasource,DSv,cubes and dimensions and Roles.I donot deploy that to the server but save the file to a local drive location.

2. If i go to the local directory path where I saved the solution i will find files such as .database, .cube,.partitions, .dim etc

3. i need to deploy the full solution from this file location to the server. After deployement i can process the cubes one by one using AMO. The processing part is clear to me using AMO but how to deploy from file location i am not able to figure out . All this has to be done through code (C#).

Regards...

Girija Shankar

|||

So, the file in the BIN folder is a complete or near-complete script. You should be able to use standard techniques to read the file (it's just XML though I would read it as a simple text file). With the script in memory, you can then submit it as a string through the AMO Server object's Execute method.

You may also want to review the ASCMD project that comes with the SSAS samples. I believe it has the functionality built in to read a file and execute it like I'm describing. It's also written in C#.

B.

|||

Bryan,

There are four files in bin folder . i suppose i would be using .asdatabase file. read that,envolope that with the create and Object Tags and execute that on server. Is this correct?

Regards...

Girija Shankar

|||

Hi, Another question.

There are some read only tags such as CreatedTimestamp, should i remove them while reading that?

Regards...
Girija Shankar

|||Another option is to use the Deployment Wizard (launched from the Start menu under Microsoft SQL Server->Analysis Services). This wizard has the option to generate a deployment script which is just an XMLA

command that can be sent the the server to deploy and optionally process the cube. This script deployment can be done using Adomd.Net, an XMLA Query in SQL Management Studio, or using the ASCMD.exe command line utilility available at http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en.

Deploying a report services application to the local host; error:A connection could not be made

I installed SQL reporting services 2005 and successfully configured reporting services.After designing the report using Bussiness Intelligence Studio, i tried to deploy my reporting services application to the localhost , I got the below mentioned error :

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/ReportServer.

ADDITIONAL INFORMATION:

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)

The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)

Can anybody provide a solution for this issue....

Thanks in advance

Nirupa

Hi Nirupa,

Can you check your Reporting Services Configuration Manager and see what the status of Report Server is?

Start>>All Programs>>MS SQL Server 2005>>Configuration Tools>>Reporting Services Configuration.

|||

Hello Viral,

Report server status in configuration manger is configured i.e report sever is connected

Thanks

Nirupa

|||

Hello Viral,

Though sql reporting manager configuration is configured correctly and reporting server status

shows "running".Except "E-mail settings" all other are showing green in color in configuration lancher page.

Still I am not able to deploy an reporting services application. It is giving same error as I previously

mentioned.

can you suggest what shall be done.

Thanks,

Nirupa

|||Have you tried opening the page http://localhost/reportserver in your browser?

Deploying a report services application to the local host; error:A connection could not be made

I installed SQL reporting services 2005 and successfully configured reporting services.After designing the report using Bussiness Intelligence Studio, i tried to deploy my reporting services application to the localhost , I got the below mentioned error :

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/ReportServer.

ADDITIONAL INFORMATION:

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)

The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)

Can anybody provide a solution for this issue....

Thanks in advance

Nirupa

Hi Nirupa,

Can you check your Reporting Services Configuration Manager and see what the status of Report Server is?

Start>>All Programs>>MS SQL Server 2005>>Configuration Tools>>Reporting Services Configuration.

|||

Hello Viral,

Report server status in configuration manger is configured i.e report sever is connected

Thanks

Nirupa

|||

Hello Viral,

Though sql reporting manager configuration is configured correctly and reporting server status

shows "running".Except "E-mail settings" all other are showing green in color in configuration lancher page.

Still I am not able to deploy an reporting services application. It is giving same error as I previously

mentioned.

can you suggest what shall be done.

Thanks,

Nirupa

|||Have you tried opening the page http://localhost/reportserver in your browser?

Deployement to a local machine

Hi,

I have developped a program with VB 2005 with a DB using sql server and I would like to know if I use this program on another computer what's the minimum requirement.

Dotnet 2.0 and sql server? But do I have to install the full sql server version or just a patch to be able to run that kind of program?

Thx in advance

I do think that to deploy a VB.NET 2005 application, the client computer must have the .NET 2.0 framework installed.

If the application will access a remote SQL Server that is all that is necessary.

If the application will require that a SQL Server be also installed, then a 'licensed' edition of SQL Server must also be installed. Depending upon the requirements, the 'free' SQL Server 2005 Express may be sufficient. Check here for information about which SQL Server edition may best fit your needs.

Deployed report fails to start

VS2005 project with imbedded SQL Server reports works fine in VS IDE going agianst a network SQL Server 2005 or the local SQL Server 2005. However, when the application is deployed (to another computer). the application starts and connects successfully to the network SQL Server 2005. Everything works until the user tries to produce a report. Then the following error is generated:

Named Pipes Provider, error: 0 - No process is on the other end of the pipe (the verbose part of the error message is left out). SQL Server agent is running both on the file server and the local computer. Also, named pipes and shared memory are enabled in file server and local computer (TCP and VIA protocoles are disabled). Same is done for Client protocoles.

Any suggestions are greatly appreciated.

Go to SQL Surface are configuration -&gt; Surface Area configuration for services and connections -&gt;; Datsbase engine -&gt; remote connections and check if remote connections using TCP/IP and named pipes is enabled.gatharia|||

Have you enabled remote network connections?

http://codebetter.com/blogs/sahil.malik/archive/2005/11/05/134318.aspx

|||

Tks for suggestion. Both on the file server and the local computer I have set the Surface Area ... to TCP/IP and Named Pipes. Please note that the access to and use of the SQL server database engine is not a problem. Everything works. The problem is related to the SSRS. That is the problem occurs when the report program tries to access the database.Maybe in the way the report dataset or datasource is defined. But then why does it work from within IDE?

|||

Yes I have. Connecting to database engine is no problem. Failure occurs when the report function tries to access the database.

|||Are you using integrated security for your datsets? I recommend using sql login.