Deployment Help

I'm trying to test my ASP.NET application. Everything is working to the point of getting to my login page to open. When I try to login I receive and error that the database does not exist or access is denied. I used the developer version of SQL Server to create the database and installed the MSDE on my test PC. Then I copied the mdf and ldf files to the new PC. Is there something else I should be doing? Or any suggestions?

Thank you,::Then I copied the mdf and ldf files to the new PC

did you "attach" the database ??

hth|||The test PC only has the MSDE installed. I don't know of a way to run the attach sp without query analyzer, is there a way?

Thank you,|||I tested, and I can connect the SQL Server database to a Access adp. Would this mean that I should be able to connect to my ASP.NET web pages? Could there be a problem with my connection string when I moved the app to the new PC? What is the simplest connect string to a SQL Server database, so I can test it?

Thanks you any suggestions,|||Can you install SQL Server tools (only)?
That would be easier to attach a db via Enterprise Manager (right-click DB / all tasks).|||I was trying to do this as if those tools were not available. I read that it was possible, but I cannot find the listing again.

Thank you,sql

Deploying SSRS

I am trying to get SSRS to work and am having trouble getting it to go.
When I go to IIS and browse, it won't let me see the page, it reads "This
page cannot be displayed". The internet has connectivity because I can get
on my email and other sites.
When I try to deploy the report, I am having issues as well with
connectivity. I get an error that reads "A connection could not be made to
the report server http://localhost/ReportServer"
I went to services on the server and verified that SSRS was running and so
was IIS.
Any thoughts?Check the access (security) rights on the ReportServer.
David
"Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
news:ED56B7A0-274E-4345-914C-3AAFA0B4CF59@.microsoft.com...
>I am trying to get SSRS to work and am having trouble getting it to go.
> When I go to IIS and browse, it won't let me see the page, it reads "This
> page cannot be displayed". The internet has connectivity because I can
> get
> on my email and other sites.
> When I try to deploy the report, I am having issues as well with
> connectivity. I get an error that reads "A connection could not be made
> to
> the report server http://localhost/ReportServer"
> I went to services on the server and verified that SSRS was running and so
> was IIS.
> Any thoughts?|||David,
Do you mean the ReportServer db database in SQL management studio? What
security are you referring to?
Thanks,
Ryan
"David C" wrote:
> Check the access (security) rights on the ReportServer.
> David
> "Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
> news:ED56B7A0-274E-4345-914C-3AAFA0B4CF59@.microsoft.com...
> >I am trying to get SSRS to work and am having trouble getting it to go.
> > When I go to IIS and browse, it won't let me see the page, it reads "This
> > page cannot be displayed". The internet has connectivity because I can
> > get
> > on my email and other sites.
> >
> > When I try to deploy the report, I am having issues as well with
> > connectivity. I get an error that reads "A connection could not be made
> > to
> > the report server http://localhost/ReportServer"
> >
> > I went to services on the server and verified that SSRS was running and so
> > was IIS.
> >
> > Any thoughts?
>
>|||Go into the Report Manager from your browser. Select the folder that holds
your reports, click the Properties tab and then the Security link. Users
should have at least Browser (I think) to run the reports.
Use the "New Role Assignment" button to add users or groups. I suggest you
use an Active Directory (or local) group as it will be easier to manage.
David
"Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
news:AB4F831D-1CBB-4786-80B4-5747988BA44F@.microsoft.com...
> David,
> Do you mean the ReportServer db database in SQL management studio? What
> security are you referring to?
> Thanks,
> Ryan
> "David C" wrote:
>> Check the access (security) rights on the ReportServer.
>> David
>> "Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
>> news:ED56B7A0-274E-4345-914C-3AAFA0B4CF59@.microsoft.com...
>> >I am trying to get SSRS to work and am having trouble getting it to go.
>> > When I go to IIS and browse, it won't let me see the page, it reads
>> > "This
>> > page cannot be displayed". The internet has connectivity because I can
>> > get
>> > on my email and other sites.
>> >
>> > When I try to deploy the report, I am having issues as well with
>> > connectivity. I get an error that reads "A connection could not be
>> > made
>> > to
>> > the report server http://localhost/ReportServer"
>> >
>> > I went to services on the server and verified that SSRS was running and
>> > so
>> > was IIS.
>> >
>> > Any thoughts?
>>|||David,
That is the problem, I can't even get the browser page to show up. When I
try to deploy a report, it isn't connecting to the report server. Not sure
what is going on. IIS is on and so is SSRS services.
Any other thoughts?
Ryan
"David C" wrote:
> Go into the Report Manager from your browser. Select the folder that holds
> your reports, click the Properties tab and then the Security link. Users
> should have at least Browser (I think) to run the reports.
> Use the "New Role Assignment" button to add users or groups. I suggest you
> use an Active Directory (or local) group as it will be easier to manage.
> David
> "Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
> news:AB4F831D-1CBB-4786-80B4-5747988BA44F@.microsoft.com...
> > David,
> > Do you mean the ReportServer db database in SQL management studio? What
> > security are you referring to?
> >
> > Thanks,
> > Ryan
> >
> > "David C" wrote:
> >
> >> Check the access (security) rights on the ReportServer.
> >>
> >> David
> >> "Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
> >> news:ED56B7A0-274E-4345-914C-3AAFA0B4CF59@.microsoft.com...
> >> >I am trying to get SSRS to work and am having trouble getting it to go.
> >> > When I go to IIS and browse, it won't let me see the page, it reads
> >> > "This
> >> > page cannot be displayed". The internet has connectivity because I can
> >> > get
> >> > on my email and other sites.
> >> >
> >> > When I try to deploy the report, I am having issues as well with
> >> > connectivity. I get an error that reads "A connection could not be
> >> > made
> >> > to
> >> > the report server http://localhost/ReportServer"
> >> >
> >> > I went to services on the server and verified that SSRS was running and
> >> > so
> >> > was IIS.
> >> >
> >> > Any thoughts?
> >>
> >>
> >>
>
>|||Hi,
It seems to be a problem to hit the web server.
Have you check IIS logs ? Do you see connection attempts ? What is the HTTP
status code ?
Does SSRS and IIS on the same server ?
Jean-Pierre
"Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
news:CCE4F651-B458-4435-9FCA-0EFAE4235594@.microsoft.com...
> David,
> That is the problem, I can't even get the browser page to show up. When I
> try to deploy a report, it isn't connecting to the report server. Not
> sure
> what is going on. IIS is on and so is SSRS services.
> Any other thoughts?
> Ryan
> "David C" wrote:
>> Go into the Report Manager from your browser. Select the folder that
>> holds
>> your reports, click the Properties tab and then the Security link. Users
>> should have at least Browser (I think) to run the reports.
>> Use the "New Role Assignment" button to add users or groups. I suggest
>> you
>> use an Active Directory (or local) group as it will be easier to manage.
>> David
>> "Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
>> news:AB4F831D-1CBB-4786-80B4-5747988BA44F@.microsoft.com...
>> > David,
>> > Do you mean the ReportServer db database in SQL management studio?
>> > What
>> > security are you referring to?
>> >
>> > Thanks,
>> > Ryan
>> >
>> > "David C" wrote:
>> >
>> >> Check the access (security) rights on the ReportServer.
>> >>
>> >> David
>> >> "Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
>> >> news:ED56B7A0-274E-4345-914C-3AAFA0B4CF59@.microsoft.com...
>> >> >I am trying to get SSRS to work and am having trouble getting it to
>> >> >go.
>> >> > When I go to IIS and browse, it won't let me see the page, it reads
>> >> > "This
>> >> > page cannot be displayed". The internet has connectivity because I
>> >> > can
>> >> > get
>> >> > on my email and other sites.
>> >> >
>> >> > When I try to deploy the report, I am having issues as well with
>> >> > connectivity. I get an error that reads "A connection could not be
>> >> > made
>> >> > to
>> >> > the report server http://localhost/ReportServer"
>> >> >
>> >> > I went to services on the server and verified that SSRS was running
>> >> > and
>> >> > so
>> >> > was IIS.
>> >> >
>> >> > Any thoughts?
>> >>
>> >>
>> >>
>>

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 a report

I am new to Reporting services and have created just a layout page.

no datasets or data sources are present. This is just a cover page.

I need to show this page through a url. Can i deploy this on my local machine rather than showing some-one through the preview mode.

What would be the local host configuration settings.

Thanks.

Do you have the report catalog databased and report server installed on your local machine?

If so and you'd like to deploy from visual studio, go to your project properties, find the target url property and put in "http://localhost/reportserver". Next right click and try "Deploy".

You can also easily deploy from SQL Server Management Studio.|||

Hello,

I dont think I have the reportserver installed on my machine.

When i try doing the localhost/reportserver it shows an error saying underlying connection failed.

I tried deploying from SQL server management studio trying bto make sense of the $MYSORIAN. that failed too http://aspalliance.com/819

Any help documentation etc?

thanks

|||

Hi, I assume you are using BI to build your report. If so, right click on the project and select properties and setup Deployment parameters as follows:

TargetReportFolder TestReport (your report folder name if you want to store the report in a separate folder other than

default Home folder)

TargetServerURL http://ReportServerPC/ReportServer(If the report server was installed using default settings)

or

http://ReportServerPC/ReportServer$NameoftheReportServer(If the report server was installed as named instance)

For example if the name of your report server instance is ABC and it was installed on a server 123 then it would be

http://123/ReportServer$ABC

Please note you have to use https, if the report server is configured to use SSL.

After setting up the parameters, right click on your report and select deploy.

Hope this helps!

|||

Hello,

In this setup how would i be able to replace local host. I do not know if the ReportServer is installed on my machine and i do not ahve access to any other server.

TargetServerURL http://ReportServerPC/ReportServer(If the report server was installed using default settings)

Thanks

|||

Hi,

There are couple ways you can check whether you have report server on your machine or not.

Check your program files folder: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services Check in your IIS management console whether you have a virtual directory called ReportServer under default website Copy the url http://localhost/ReportServer paste into your web browser and if you can see the folders in ReportServer web folder then you have reporting services on your PC.

Deployed Report Fials with Multiple Pages

Using SQL RS 2000
My report runs fine in the designer but when deployed to the server it will
only display the first page. When move to page 2 or the last page it gives
the error:
"An unexpected error occurred in Report Processing. (rsUnexpectedError) "
Also, the report calls a subreport and if I remove the subreport it works
fine.
Any ideas?
ThanksI am having a very similar problem in RS 2005.
When I include a subreport, the main report will only display the first page
(correctly) but gives me the same error when navigating to another page.
This is occurring on one particular report only so far - a reasonably
complex report.
I have raised a technical support issue with Microsoft but they have not yet
been able to solve it.
Colin
"Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
news:O$Ek5eGgGHA.3996@.TK2MSFTNGP03.phx.gbl...
> Using SQL RS 2000
> My report runs fine in the designer but when deployed to the server it
> will only display the first page. When move to page 2 or the last page it
> gives the error:
> "An unexpected error occurred in Report Processing. (rsUnexpectedError) "
> Also, the report calls a subreport and if I remove the subreport it works
> fine.
> Any ideas?
> Thanks
>

deploy shared data source

I have modified a shared data source and when I deployed it, the data source
on the Report Manager page did not change. I then deleted the data source
from the Report Manager and redeployed the data source. Then the reports
errored with a data source not found error, so I redeployed the entire
project, but now, even thought the shared data source is in it's original
location all of my reports (50) say that The shared data source reference is
no longer valid. I have redeployed my project again with the same results.
Any help would be appreciatedAre you doing this with RS 2000 or RS 2005?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Robert Willhite" <RobertWillhite@.discussions.microsoft.com> wrote in
message news:2D8DD698-0E6A-463F-92B2-86EF2BE3C2D0@.microsoft.com...
>I have modified a shared data source and when I deployed it, the data
>source
> on the Report Manager page did not change. I then deleted the data source
> from the Report Manager and redeployed the data source. Then the reports
> errored with a data source not found error, so I redeployed the entire
> project, but now, even thought the shared data source is in it's original
> location all of my reports (50) say that The shared data source reference
> is
> no longer valid. I have redeployed my project again with the same
> results.
> Any help would be appreciated
>|||I am doing this with RS 2000
"Bruce L-C [MVP]" wrote:
> Are you doing this with RS 2000 or RS 2005?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Robert Willhite" <RobertWillhite@.discussions.microsoft.com> wrote in
> message news:2D8DD698-0E6A-463F-92B2-86EF2BE3C2D0@.microsoft.com...
> >I have modified a shared data source and when I deployed it, the data
> >source
> > on the Report Manager page did not change. I then deleted the data source
> > from the Report Manager and redeployed the data source. Then the reports
> > errored with a data source not found error, so I redeployed the entire
> > project, but now, even thought the shared data source is in it's original
> > location all of my reports (50) say that The shared data source reference
> > is
> > no longer valid. I have redeployed my project again with the same
> > results.
> >
> > Any help would be appreciated
> >
>
>|||First, so you can understand what happened along the way. When you deploy
the default is that the shared datasource does not overwrite. The reason is
so you can have a shared data source when developing that points to a
development database and then when deployed the datasource points to
production. So deleting and deploying again works (you can also force the
deploy to overwrite but I have never done that). Usually when re-deploying a
datasource the issue that comes up are the credentials. In report manager
open up the data source and make sure the credentials are correct.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Robert Willhite" <RobertWillhite@.discussions.microsoft.com> wrote in
message news:34B4224C-6043-4527-83B3-D216414B1A9B@.microsoft.com...
>I am doing this with RS 2000
> "Bruce L-C [MVP]" wrote:
>> Are you doing this with RS 2000 or RS 2005?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Robert Willhite" <RobertWillhite@.discussions.microsoft.com> wrote in
>> message news:2D8DD698-0E6A-463F-92B2-86EF2BE3C2D0@.microsoft.com...
>> >I have modified a shared data source and when I deployed it, the data
>> >source
>> > on the Report Manager page did not change. I then deleted the data
>> > source
>> > from the Report Manager and redeployed the data source. Then the
>> > reports
>> > errored with a data source not found error, so I redeployed the entire
>> > project, but now, even thought the shared data source is in it's
>> > original
>> > location all of my reports (50) say that The shared data source
>> > reference
>> > is
>> > no longer valid. I have redeployed my project again with the same
>> > results.
>> >
>> > Any help would be appreciated
>> >
>>

Deploy a database and ASP.NET site to GoDaddy.com

I have a vb.net web page which I created (a shopping cart). I created this site using vb.net 1.1 and SQL 2000 on my laptop. On my laptop everything works properly, but when I tried moving it to GoDaddy (http://currahee3-506.org/px/default.aspx). In the code, each query to the SQL server is done using stored procedures.

When you first go the page, a drop down is presented. When you select "Shirt" from the category drop down. A second drop down menu is then displayed and will let you select what type of shirt you are interested in purchasing. Select Polo Shirt Without Pocket. Upon doing so, I receive an error message:

Invalid object name 'tbl_LookupCategory'.
Invalid object name 'tbl_pxProducts'.
Invalid object name 'tbl_LookupColor'.
Invalid object name 'tbl_LookupSizes'.
Invalid object name 'tbl_pxQtySold'.
Invalid object name 'tbl_pxImages'.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: Invalid object name 'tbl_LookupCategory'.
Invalid object name 'tbl_pxProducts'.
Invalid object name 'tbl_LookupColor'.
Invalid object name 'tbl_LookupSizes'.
Invalid object name 'tbl_pxQtySold'.
Invalid object name 'tbl_pxImages'.

Source Error:

Line 143: sqlCommand.Parameters.AddWithValue("@.str_ItemName", Trim(DDL_Items.SelectedItem.Text))Line 144:Line 145: Dim dataReader As SqlDataReader = sqlCommand.ExecuteReader(CommandBehavior.CloseConnection)Line 146:Line 147: dl_Description.DataSource = dataReader

Source File:d:\hosting\currahee\px\default.aspx Line:145

Keep in mind the Stored Procedure works in my testing environment, but not on GoDaddy. I moved the selected statement into a view on the GoDaddy SQL server, and the view worked perfectly. The tables do exist on the GoDaddy SQL Server.

This is the Stored Procedure:

CREATE PROCEDURE [dbo].[sp_GetItemInfo]

@.str_ItemName VarChar(50)

AS

SELECT TOP 100 PERCENT
tbl_pxProducts.int_ItemID,
tbl_pxProducts.str_ItemName,
tbl_pxProducts.int_RetailPrice,
tbl_pxImages.str_SmallImageURL,
tbl_pxImages.str_MediumImageURL,
tbl_pxImages.str_MediumImageBackURL,
tbl_pxImages.str_LargeImageBackURL,
tbl_pxImages.str_LargeImageUrl,
tbl_pxImages.str_SmallImageBackURL,
tbl_pxProducts.int_Quantity - tbl_pxQtySold.int_QtySold AS int_QtyAvailable,
tbl_LookupCategory.str_Category,
tbl_pxProducts.Int_SizeID,
tbl_LookupSizes.str_Size,
tbl_pxProducts.Int_ColorID,
tbl_LookupColor.str_Color

FROM
tbl_LookupCategory
INNER JOIN
tbl_pxProducts
ON
tbl_LookupCategory.int_CategoryID = tbl_pxProducts.int_CategoryID
INNER JOIN
tbl_LookupColor
ON
tbl_pxProducts.Int_ColorID = tbl_LookupColor.int_ColorID
INNER JOIN
tbl_LookupSizes
ON
tbl_pxProducts.Int_SizeID = tbl_LookupSizes.int_SizeID
LEFT OUTER JOIN
tbl_pxQtySold
ON
tbl_pxProducts.int_ItemID = tbl_pxQtySold.int_ItemID
LEFT OUTER JOIN
tbl_pxImages
ON
tbl_pxProducts.int_ItemID = tbl_pxImages.int_ItemID

WHERE
(tbl_pxProducts.int_Quantity - tbl_pxQtySold.int_QtySold > 0)
AND
(tbl_pxProducts.str_ItemName = @.str_ItemName)

ORDER BY
tbl_LookupSizes.str_Size

Does anybody have any suggestions as to why this stored procedure is failing?

If you are sure that the tables exist then make sure you have the permissions to view/manage these tables.

The best what you can do here is to contact godaddy's support.

Regards