When I browse to http://localhost/Reports/Pages/Folder.aspx I am getting "Unable to communicate with report server. Please verify that the report server is operational". The http://localhost/ReportServer runs fine in the browser. Also the config files have the correct urls. I don't have any other service like Sharepoint installed on the machine
Any ideas?
Thanks
I want to send table values from MS SQL Server to MySQL. For example if any row is inserted or deleted or updated in MS SQL Server database then the same has to be reflected in a similar table in MySQL so that the both the database table are in synch with each other. it would be of gr8 help if anyone could suggest something regarding this. Thanks in advance....
dinesh
Hi,
Just need some help on a job issue.
The job in question gives the below mentioned error when run
Error 22022: Unable to post notification to SQL
ServerAgent (reason: OpenFileMapping()returned error
2, 'The system cannot find the file specified')
This seems to have started after I changed the owner for the Agent and MSSQL service from local service to a domain ID.
FYI, I have also changed the job owner from sa to the domain ID and have tried restarting the agent service in the hope that the Job can speak to the agent .. but it doesnt :(
Microsoft suggests to change some registry entries but I am not sure if that'd work
http://support.microsoft.com/default.aspx?scid=kb;en-us;911841&sd=rss&spid=2852
The server on which this job is hosted is a production box .. so am a litle apprehensive about making any registry changes
Any Suggestions ?
Thanks.
Warm Regards,
Ranjit.
Hello,
I've enabled full-text indexing on one of my tables, and the following query used to work:
SELECT *
FROM TempAttachment
WHERE CONTAINS(attachment, 'text')
However, now I get the following error:
Msg 9955, Level 16, State 1, Line 1
SQL server failed to communicate with Full-Text Service (msftesql). The system administrator must make sure that same service account is used for both services and the service account has the permission to auto start the full-text service.
I've checked the configuration and verified that both accounts are the same. I've restarted the services, and tried rebooting, and still no luck. I did a search on this error, and found this page from MSDN, which doesn't help me much: http://msdn2.microsoft.com/en-us/library/aa337365.aspx.
Has anybody come across this before? Any help would be greatly appreciated!
Hi!
I have the report server in Share Point integrated mode.
When I Deploy a report from a VS Report Server project by running
Visual Studio on the machine where reporting servicers is running, everything works fine.
But if I try the same thing on any other machine on the network, I get the following message:
TITLE: Microsoft Report Designer
------------------------------
A connection could not be made to the report server http://test/.
------------------------------
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml' ( and so on....)
Do I need to install sp2 on the machine I'm trying to deploy from?
//C
I get a Report server login pop up Is there a default login and password for a default install of the report server? I am trying to deploy my report from my computer to our server. I can upload from my computer but can not deploy to the server.
View 1 Replies View Related
Hi Guys,
After installing SQL Server 2005 Reporting Services, I got the following errors:
1. When I tried to open http://localhost/reports/ , I got the following error message
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
2. When I tried to open http://localhost/reportserver/ , I got the following error message
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
Access to the path 'C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerRSReportServer.config' is denied.
Is there any clue for this technical problem?
Immediate response is appreciated.
--Amde
I have unable to deploy Sql Server Report as I am getting an error while deployment "A connectin could not be made to the report server http://localhost/reportServer" where as i have created virtual directory for repotServer in IIS . Can anyone plz help me out to resolve this problem ?
View 8 Replies View Related1) I uninstalled Advanced SQL with Report Server to install 2005 SQL Developers Editions.
2) For some reason I am unable to completely uninstall Express Report Server.
3) Configuration Manager is still showing SQL Exp Report Server, even though I uninstalled Advanced Server.
4)I tried to remove though A/R programs (using my 2005 DE) - I see it listed but I receive the following error:The setup failed to read IISmime maptable the error code is -2147024893.
5) When I try to use 2005 Report Service Config Manager, I receive the following error: An unknown error in WMI Provider Error code 80040219 wmi provider.
So I am unable to setup my 2005 SQL DE Report Server.
Any ideas on uninstalling Express Report Server...This might be part of my problem.
Thanks
Hi,
I am using SQL server 2000, Crystal Reports 8.5. I dont see any problem with accessing thro' VB Coding(ADODB).
Crystal Report connection thro ODBC also working fine.
But when i try to connect to database thro "More data sources" -> SQL server , i was thrown out with an error "Unable to connect to SQL server servernam"
I have uninstalled & Reinstalled both SQL server and Crystal Report. Still not working.
I have been struggling with this problem for quite a long time.
Can any one give me the solution for this ??
Regards
SRagghu
hi,
I created ReportServer by reporting services configuration and i gave the local and remote permissions using surface
area cofiguration using tcp/ip only. But when i browse the reportserver i got the below mentioned error.
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable)
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Hello Everyone,
I have a Report Server setup on my laptop (XP Pro SP2). I have developed a report which I would like to view from a Windows Forms Application (VB.NET) using a ReportViewer. When I try it from the local machine it works correctly, but if I try to connect and preview the same report from my other PC (Vista Home Premium) I am getting the "Unable to connect to the remote server. A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because the connected host failed to respond." error.
I have setup the Processing mode to Remote and correctly setup the ReportPath and ReportServerUrl using:
With rptRetEmp
.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote
.ServerReport.ReportServerUrl = New Uri("http://192.168.1.2/CPMReports")
.ServerReport.ReportPath = "/CPM_Reports/Test"
.ServerReport.Refresh()
.RefreshReport()
End With
Where CPMReports is the Report Server virtual directory and CPM_Reports is the folder where the report Test resides.
I do not know if this has anything to do with the fact that Vista Home does not have Report Services enabled or it is just a permissions problem. I have red several posts that describe similiar problems, but I could not find a solution.
Thank you for your help.
Daniel D.
Hi all,
I have been using the reportviewer control to display my ssrs reports. However, i'm facing issues in displaying Server reports in the control. The following error show up whenevr i click on View Report.
Execution 'aaxe3ke5k34l5355qbup0rvo' cannot be found
Please help if anyone has come across something similar
I have done the following and a domain user would not access report created a login to the SQL server to the user (this SQL Server is where data source DB is)went to site setting in Report Manager and made this use a system userright clicked on report folder and made this user in the browser roleeven checked that in the report in question, the user is already in the browser role Still the user would not access the report! "User .......... does not have required permission" is the error message I am getting.
View 6 Replies View Related
Hi,
I am unable to launch report builder from the report manager from a client machine. But I am able to launch from the localhost.
Even I am able to launch report builder by clicking reportbuilder.exe on the local machine.
Please help !!
OS - Windows XP professional
SQL Reporting Services 2005.
I was able to log in to SSRS report manager. But i was unable to run a report i designed on report builder.
It prompts for login when i wanted to run the report and i used the same windows authentication to sign in
It will show me the parameters but when i click on view report it gives this error
"Data source 'DataSource1': An error has occurred.
Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'DataSource1'. ---> System.Data.SqlClient.SqlException: Login failed for user 'Acc-11Admin'."
Hi,
I have environment that use SSRS 2005 ad hoc reporting.
One of the users (out of 200) is unable to open or save reports in the report builder.
the user succeed to open the report builder, when he try to save report that he build from shema he get error. as well when he try to open an existing report that build in the report builder he also get an error,
On open the error is:
The numeric portion of 2pt cannot be parsed as a unit of the type point.
The Initilizer for 'Microsoft.ReportingServices.Design.Constants' threw an exception
On Save the error is:
System.IO.StreamReader: Deserialization failed: The type initializer for 'Microsoft.ReportingServices.Design.Constants' threw an exception. Line 2, position 2
Please note that I succeed with second user to create ad hoc report on the first user
computer. I also failed to with the first user to create ad hoc on another computer.
It seems like permissions issue
Thanks,
Assaf
Hello,
I am using 'SQL Server 2005 Reporting Service' in my project. I am using sub-reports in many cases. Whenever I export such reports containing sub-reports to 'Excel' format which is the major client requirement in our project, the exported excel file shows 'Subreports within table/matrix cells are ignored.'
Can anybody tell me the solution for this? If not possible in reporting service then is there any other way to get data in excel format?
Thanks.
-Salil
I have two sql servers, A and B. each one has one database, A and B. I am trying to write a stored porcedure in database A to retrieve the data in database B. how do I do it? can you give me a simple example. (like "select")
View 6 Replies View Relatedhi,
I want tomake wcf and service broker communicate with each other,Are there some resources about that?
thanks in advance
I have a C# windows application which i've developed that uses an embedded SQL CE DB.
When i deployed the project, It worked fine for many PCs.
But for some PCs it seems it cannot (The application) communicate with the DB.
Why i am saying that ? That's because the application itself opens . but at the first task where the applciation requests the DB for information, It just CAN'T do that, And stands as if no action has happened (i.e. no button has been pressed)...
Any ideas ?
So SQLDependencies failed to do what I wanted them to do for my Cache Invalidating, so i'm going to humor another possibility for a half day - Triggers on my database table that communicate messages to my C# inside my ASP.NET App. Any advice on how to tap into a message queue with C#? I'm thinking that my messages could be 1 of about 100 different strings as far as what occurred on the Database Tables
View 3 Replies View Related-> Communicate with WebService from MS SQL 2005 CLR Procedure, Quick Steps
1- Create SQL project in V.S 2005.
2- Add new Trigger Class, right click on project select Add -> New Item.
3- Add Web Service reference.
4- Use impersonation technique to communicate with Service.
Example:
using (WindowsIdentity id = SqlContext.WindowsIdentity)
{
WindowsImpersonationContext context = id.Impersonate();
/////////////////////////////
proxy = new WebServiceProxy();
proxy.Credentials = System.Net.CredentialCache.DefaultNetworkCredentials;
proxy.HelloWorld();
/////////////////////////////
context.Undo();
}
5- Set SQL Project Permission Level to External, change from the project properties Database Tab
"Permission Level Select the permission level from the drop-down list to specify a set of code
access permissions granted to the assembly when accessed by Microsoft SQL Server. The value can be
Safe, External, or Unsafe; these values correspond to the SQL Server permission sets SAFE,
EXTERNAL_ACCESS, and UNSAFE, respectively. Safe is the default.
This setting corresponds to the PERMISSION_SET argument for the SQL Server CREATE ASSEMBLY command.
" MSDN
6- "The TRUSTWORTHY database property is used to indicate whether the instance of SQL Server trusts
the database and the contents within it. By default, this setting is OFF, but can be set to ON by
using the ALTER DATABASE statement.
Note:
To set this option, you must be a member of the sysadmin fixed server role." MSDN
ALTER DATABASE [Database Name] SET TRUSTWORTHY ON
.
7- Build and Deploy assembly.
8- The web service reference generates XmlSerializers assembly, there are many ways to resolve
this issue, a quick way would be to add the XmlSerializers assembly to the database where the
main CLR assembly is deployed.
From "SQL Server Management Studio" select the target database, goto "Programmability" then ->
"Assemblies", there right click "New Assembly" and specify reference.
Hope this is helpful to others.
Regards
Rabeeh Abla
Getting the following warning in SSIS - SQL 2012:
[SSIS.Pipeline] Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console.
Microsoft had a fix for SQL Server 2008.
How to get around this in SQL 2012?
I am getting the following warning for my SSIS08 package: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console. I did check Warning in SSIS 2008 , but didn't find any solution. The package processes data and executes fine , but why do I see this warning? When I run this package on my machine, I see no such warning, it's only when I deploy it to our DEV SSIS server, I get this warning.
View 7 Replies View RelatedHI,
I am using msde 2000. while working with crystal reports, when i connect to one database, it is opening the report. while when i try to run same report on other machine (connecting to similar database in other machine), it is failed to open the connection.
thank you
I've created a report and have the role of a 'global admin' however, when I try and deploy the report, I get an error message that I don't have permissions.
What other permissions do I need?
Thanks
Susan
I encountered the following error after I deployed a report . The deployment process was successful, however, when I try to run the reports from the remote machine, It gives me an error message saying:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'SessionOLAP'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
On the other hand, I deployed this report on the local machine where the reportserver resides and it is running perfect.
Do you have any idea how to deal with this problem?
I deployed a report i'd been practicing on and it worked fine. I then attempted to deploy it to production and was asked for user name and password. On the server i used for production I am an admin yet my credentials did nothing, just keeps asking for user and pass again.
Along the same lines I want to know how to allow people within our network to view production reports without needing to type in credentials.
Howdy!
My first attempt to deploy a report from SQL Server Reporting Services failed and I'm not sure what to change to fix the problem.
The error message reads: "A connection could not be made to the report server http://localhost/ReportServer."
Then under Additional INformation, it reads: "Client found response content type of 'text/html; charset=utf8', but expected 'text/xml'."
I also had a problem after I configured the Reporting Services. To confirm that the ReportServer database had been created, I tried to access http://localhost/Reports from Internet Explorer. The error message I get is: "The XML page cannot be displayed" Then it says that "a name was started with an invalid character. Error processing resource 'http://localhost/reports/'. Line 1, Postition 2."
I'm assuming that the latter problem is causing the former, but I don't know what to do to correct it. Can you help me out?
Thanks!
Mark
Hi all,
When I run the SSRS report in development mode, it is working fine. When I run in deployed localhost, I faced an error message as below:
The permissions granted to user 'FAROUKYEWNOTEBOASPNET' are insufficient for performing this operation. (rsAccessDenied)
Hope someone can enlighten me on this.
Regards,
Farouk Yew
I had an SSRS 2005 report that had the lowest level grouped instead of printing a detail line (the reports display summary tables that have all the necessary grouping already applied). Every time I tried to clear the grouping, the report designer crashed. In the end I created the report again from scratch.
Should I have been able to clear the grouping or is the conversion from a detail line to grouping, a one-way process?