 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Services / Reporting Services / July 2006Need help on Reporting Services in SQL Server 2005
Hello, I build a test report using SQL Server Business Intelligence Development Studio. Every thing went well also I can preview of the report. But when I wanted to deply it by right clicking it its throwing a message The first message I got was 'The project cannot be deployed because no target server is specified. Provide a value for the TargetServerURL property in the property pages for this project.' To over the above problem I created a URL, http://localhost/ReportServer in the property page . And again I tried deploying it and second I got this message : 'A connection could not be made to the report server http://localhost/ReportServer Additional Information: The attempt to connect to the report failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)' This is first time I am trying to get the reports. Could some one please help me how do proceed from here? Thanks -L My report server isnt called localhost, I had that problem at first until I realized I had to change localhost to something else. > Hello, > I build a test report using SQL Server Business Intelligence [quoted text clipped - 25 lines] > Thanks > -L Hi, test whether you are able to see the report manager by using the following URL: http://localhost/reports/Pages/Folder.aspx > Hello, > I build a test report using SQL Server Business Intelligence [quoted text clipped - 25 lines] > Thanks > -L No, I am not able to see it. My reports server is my servername/reports/Pages/Folder.aspx I dont use localhost > Hi, > test whether you are able to see the report manager by using the [quoted text clipped - 29 lines] >> Thanks >> -L Never mind to my last post. If what Sara said doesnt work, then it seems to me it is poing at a different server. > No, I am not able to see it. My reports server is my > servername/reports/Pages/Folder.aspx I dont use localhost [quoted text clipped - 32 lines] >>> Thanks >>> -L Hi Ben, For some reason I don't have ReportServer folder or any other folder under my wwwroot folder at all! Do I need to create them explicitly? I have no clue how could fire off the test report I have created. I think I do have BIDS installed and thats I could create a test report. But I don't have Report or ReportServer folders created under my wwwroot folder. May be I am beating around the bush. Could you please me here? Thanks -L > Never mind to my last post. If what Sara said doesnt work, then it seems to > me it is poing at a different server. [quoted text clipped - 35 lines] > >>> Thanks > >>> -L Hi Learner, This may sound a little weird but it is worth having a try. Check whether if your SQL Server agent is running. I usually turn it off when i don't need it as it consumes memory.So by chance it might have been stopped. After that, create a folder in your reporting manager and give that folder name in the property page of your solution. Let me know if it works. > Hi Ben, > For some reason I don't have ReportServer folder or any other folder [quoted text clipped - 44 lines] > > >>> Thanks > > >>> -L In addition, i believe you don't have a local report server and are using client. So, if you use either the host name or the ip you should be able to deploy the reports. > Hi Learner, > This may sound a little weird but it is worth having a try. [quoted text clipped - 55 lines] > > > >>> Thanks > > > >>> -L Hello Friends, I just did check wheather or not my Sql server agent is running it was stopped and I started it. But no luck yet. I guess like Bruce said may be I only have client tools and I should install the Reporting Server on my pc inorder to create a reporting server space. I will try giving a shot at it. I will keep it updated here. Please help me here. Thanks -L > In addition, i believe you don't have a local report server and are > using client. [quoted text clipped - 59 lines] > > > > >>> Thanks > > > > >>> -L Hello, Yes like Bruce has mentioned my machine didn't have Server edition of Reporting Services and just had client tools (may be it is called BIDS). So I just installed the Reporting Services on my local machine. I also have configured the "Configure the Rport Server" by creating the 'Report Server Virtual Directory', 'Report Manger Virtual Directory', 'Windows Service Identiy', 'Database setup' . But I haven't touched the Encryption part of it because I have no clue what it takes to. And then later on I created a sample Report from AdventureWorksDW. I could preview but when I try deploying it it is throwing a message with html tags. I will past the message below ************************************************************************************************ TITLE: Microsoft Report Designer ------------------------------ A connection could not be made to the report server http://localhost/ReportServer. ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title> SQL Server Reporting Services </title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.1399.00" /> <meta name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9" /> <meta name="CountryLocaleID" content="1033" /> <meta name="StackTrace" content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName) at Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location) at Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation) at Microsoft.ReportingServices.Library.Global.get_ConfigurationManager() at Microsoft.ReportingServices.WebServer.Global.StartApp() at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)" /> <style> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline} A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none} A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1> Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul> <li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li><ul> <li>Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\RSReportServer.config' is denied.</li> </ul> </ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span> </body> </html> --. (Microsoft.ReportingServices.Designer) ------------------------------ BUTTONS: OK ------------------------------ ************************************************************************************************** Am I still missing some thing here? I checked the IIS and I can see two folders got created 'ReportServer' and 'Reports' . I am not sure what else I need look at inorder to deploy it. Any inputs are greatly appreciated. Thanks -L > Hello Friends, > I just did check wheather or not my Sql server agent is running it [quoted text clipped - 67 lines] > > > > > >>> Thanks > > > > > >>> -L Back up a little. Before trying to deploy just try opening the website. http://yourcomputername/Reports/Pages/Folder.aspx First make sure the above works. You can try localhost and if that doesn't work put in the computername.  SignatureBruce Loehle-Conger MVP SQL Server Reporting Services > Hello, > Yes like Bruce has mentioned my machine didn't have Server edition of [quoted text clipped - 204 lines] >> > > > > >>> Thanks >> > > > > >>> -L Bruce, Yes I just tried the url by giving both localhost and the computer name in bot the cases I got the below error " Error The report server is not responding. Verify that the report server is running and can be accessed from this computer. Home " I checked the Sql Server Surface Area Configuration where I found both "Reporting Services" and "SQL Server Agent" are running. I do not what else to look. Can you help with the location where can I look to see if its running? Thanks -L > Back up a little. Before trying to deploy just try opening the website. > [quoted text clipped - 215 lines] > >> > > > > >>> Thanks > >> > > > > >>> -L Try the following: 1. Just in case, try a reboot. 2. Check that two databases have been created and exist (reportserver, reportservertempdb) 3. check that two websites have been created and exist (reports and reportserver) 4. Run the configuration tool and make sure everything is green. SignatureBruce Loehle-Conger MVP SQL Server Reporting Services > Bruce, > Yes I just tried the url by giving both localhost and the computer [quoted text clipped - 248 lines] >> >> > > > > >>> Thanks >> >> > > > > >>> -L Even after a re-boot of the machine, try to restart SQL Server Reporting Services (MSSQLSERVER). At times the status of this service is displayed as started but it needs a restart. Try this and let me know if it works. Sunny > Bruce, > Yes I just tried the url by giving both localhost and the computer [quoted text clipped - 234 lines] > > >> > > > > >>> Thanks > > >> > > > > >>> -L Greetings Friends, I rebooted the machine and when I tried dploying this time around I have got the error message 'Error 1 The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. 0 0 ' 1).Like Bruce suggested I also checke for the databases (ReportServer, ReportServerTempDB) but I couldn't find them under the databases node in the management studio. But I got the Reports and ReportServer websites created under the 'default web site' folder in IIS. 2).AS far as the configuration of the Report Server, I have got Server Status, Report Server Virtual Directory, Report Manager Virtual Directory, Windows Service Identity, Web Service Identity, Database Setup are turned green. But Encryption Keys is blue in color and finally Initialization is red in color. When I clicked on Encryption Keys I have got the Restore and Delete buttons are Enabled and rest of them are disabled. When I clicked on Intialization (which is in red color with x mark on it) its popping up a message box with the same information as above when I tried to deploy it! Hope fully this gives a little inside of whats happening here. I appreciate all of your valueble time. Thanks -L > Even after a re-boot of the machine, try to restart SQL Server > Reporting Services (MSSQLSERVER). [quoted text clipped - 244 lines] > > > >> > > > > >>> Thanks > > > >> > > > > >>> -L There is your problem. If you don't have those two databases something is seriously wrong. The install did not work. SignatureBruce Loehle-Conger MVP SQL Server Reporting Services > Greetings Friends, > I rebooted the machine and when I tried dploying this time around I [quoted text clipped - 316 lines] >> > > >> > > > > >>> Thanks >> > > >> > > > > >>> -L It sounds to me like you installed the client tools and you did not install the server. With the client tools you can create and preview a report but there is nowhere to deploy it. You need to install SQL Server Data Engine and SQL Reporting Services. SignatureBruce Loehle-Conger MVP SQL Server Reporting Services > Hi Ben, > For some reason I don't have ReportServer folder or any other folder [quoted text clipped - 49 lines] >> >>> Thanks >> >>> -L Then do I need to uninstall and reinstall the reporting services alone? like you have mentioned in one of your postings I need to have both SQL Server Data Engine and SQL Reporting Services. I guess I already have SQL Server Data Engine installed on my pc. I am not sure if it is the management studio or not. if it is I do have it. or in other words if I had management studion I already had SQL Server Data Engine. please correct me here. As far as the SQL Reporting Services I will uninstall and reinstall it once again. Please advise. Thanks -L > It sounds to me like you installed the client tools and you did not install > the server. With the client tools you can create and preview a report but [quoted text clipped - 59 lines] > >> >>> Thanks > >> >>> -L SQL Server database needs to be installed. You should see Master database, etc. RS adds two databases of its own. SignatureBruce Loehle-Conger MVP SQL Server Reporting Services > Then do I need to uninstall and reinstall the reporting services alone? > [quoted text clipped - 77 lines] >> >> >>> Thanks >> >> >>> -L Hello, I tried changing and reinstalling the Reporting services component from Add Remove Programs but unfortunately I couldn't install ReportServer, ReportServerTempDB databases. I am not sure if I am missing some thing here but couldn't install these databases. Is there any thing I need to select by clicking the advanced button and select in there? Please help me. Thanks -L > SQL Server database needs to be installed. You should see Master database, > etc. RS adds two databases of its own. [quoted text clipped - 84 lines] > >> >> >>> Thanks > >> >> >>> -L These databases should have been installed when you installed RS. I suggest uninstalling RS and then reinstalling. I assume you are an administrator on the machine you are installing on? If so, then your login will also have appropriate rights with SQL Server for these to be installed (if SQL Server is using integrated security). SignatureBruce Loehle-Conger MVP SQL Server Reporting Services > Hello, > I tried changing and reinstalling the Reporting services component [quoted text clipped - 104 lines] >> >> >> >>> Thanks >> >> >> >>> -L |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.