Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SSRS Deplpy problems on Vista machine

Author  Topic 

bh0526
Yak Posting Veteran

71 Posts

Posted - 2009-09-28 : 16:29:48
Hi all,

I have been struggling for a week now with SSRS deployment issues. I created a project using SQL Server Business Intelligence Development Studio in Visual Studio. I created a few reports. The reports work great. I am using Vista on this PC and I suspect this is causing a lot of my problems.

Now I want to deploy these reports since I want to be able to access these reports from my ASP.Net 3.5 web site. In my SSRS project, I right-click on the project name and then click Properties. Here is what I have under Deployment:

OverwriteDataSources False
TargetDataSourceFolder Data Sources
TargetReportFolder GameReports
TargetServerURL http://localhost/ReportServer

I then right-click on the project name and click Deploy. I now get a pop-up window with the following info:

Reporting Services Login

Server: http://localhost/ReportServer
User Name: _____________ (textbox)
Password: _____________ (textbox)

But I have no idea what user name and password to enter here. I tried my SQL Server user name and password but that did not work. I don't remember setting up a name and password. Maybe I did and forgot. What am I doing wrong?

Thanks,

Bob

rohitkumar
Constraint Violating Yak Guru

472 Posts

Posted - 2009-09-28 : 16:47:37
goto http://localhost/Reports and create a user id and password for youself with full rights.
Go to Top of Page

bh0526
Yak Posting Veteran

71 Posts

Posted - 2009-09-29 : 07:20:34
Thanks for the reply. I am not sure how to set-up the user name and password for http://localhost/ReportServer. Can you help get me started?

Thanks,

Bob
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-09-29 : 07:26:38
http://msdn.microsoft.com/en-us/library/ms156034.aspx
Go to Top of Page

bh0526
Yak Posting Veteran

71 Posts

Posted - 2009-09-29 : 09:31:25
I think my problems are with my SQL configuration. I started following the instructions in the link you provided. I got a link that was for Vista users. The instructions had me load my SQL Server 2005 CD. I then went to Add/Remove Programs, SQL Server 2005, and then "Change". After clicking thru a few "Next", I got to the Microsoft SQL Server 2005 Setup screen. But here, the Reporting Services checkbox was out of focus. I could not click it. So I think I have to take a big step backwards.

Can anyone help me get past this step?

Thanks,

Bob
Go to Top of Page
   

- Advertisement -