Getting this error after installing certificate. Happens when trying to access https://machinename/reports
Possible SOAP version mismatch: Envelope namespace http://schemas.xmlsoap.org/wsdl/ was unexpected. Expecting http://schemas.xmlsoap.org/soap/envelope/. SQL Server Reporting Services 2005 on Windows Server 2003 R2.
We have just upgraded from an embedded browser hosted RS2000 system to the Microsoft.ReportViewer.Winforms control for RS2005 in our applications, and have encountered a SOAP / firewall problem again.
We were using an embedded browser to display the reports, as some of our client sites block or strip the SOAP wrapper from SOAP 1.1 commands that the old RS2000 control tried to use when the data passes through their firewall. We have no control over, or visability of their firewall configuration, as this is part of their own site security.
Is RS2005 still using the same older version of SOAP, or has it been moved up to version 1.2, which I believe does not trigger as many alarm bells in some firewall systems.
We have no problems makeing web service calls to our own applications through the firewall, so its only the report viewer control that gives us these problems.
I have not been able to explicitly clarify this down to the SOAP version, but it looks too close the our previous firewall problem to be anything else - comments invited !!!!!
As an aside, is there any way to trace the inbound request through IIS to ReportServer so I can see what hits the report server ? The IIS logs alone show a request has been made, but no qualifying data, and the report server logs only seem to show processing once the request has been accepted. What I want to to is see the inbound request, and then the outbound error message being returned so I can confirm my suspicions.
I have posted a similar thread on google groups for reporting services.
Hi.I'm trying to setup a publication but I received an error:The process could not bulk copy out of table 'cont20684C64E88B424BBBBE84921DEDFF77'.I used the log to get more specific info and I got the following:Microsoft SQL Server Snapshot Agent 8.00.760Copyright (c) 2000 Microsoft CorporationMicrosoft SQL Server Replication Agent: MyServer-MyMainDatabase-MyMainDatabase2MyTargetDatabase-4Connecting to Distributor 'MyServer'Connecting to Publisher 'MyServer.MyMainDatabase'Server: DBMS: Microsoft SQL ServerVersion: 08.00.0760user name: dboAPI conformance: 2SQL conformance: 1transaction capable: 2read only: Nidentifier quote char: "non_nullable_columns: 1owner usage: 31 max table name len: 128max column name len: 128need long data len: Ymax columns in table: 1024max columns in index: 16max char literal len: 524288max statement len: 524288max row size: 524288[8/3/2005 4:43:30 PM]MyServer.MyMainDatabase: sp_MSgetversionInitializing the publication 'MyMainDatabase2MyTargetDatabase'*** [Publication:'MyMainDatabase2MyTargetDatabase'] Publication view generation time: 201 (ms) ****** [Publication:'MyMainDatabase2MyTargetDatabase'] Make generation time: 100 (ms) ***Generating schema script for article '[ContactsCategories]'Generating conflict schema script for article '[ContactsCategories]'Generating referential integrity script for article '[ContactsCategories]'Generating trigger script for article '[ContactsCategories]'*** [Article:'ContactsCategories'] Time generating all schema scripts: 1762 (ms) ***Generating schema script for article '[Contacts]'Generating conflict schema script for article '[Contacts]'Generating referential integrity script for article '[Contacts]'Generating trigger script for article '[Contacts]'*** [Article:'Contacts'] Time generating all schema scripts: 1292 (ms) ****** [System table:'MSmerge_contents'] .SCH script generation time: 10 (ms) *** *** [System table:'MSmerge_tombstone'] .SCH script generation time: 20 (ms) *** *** [System table:'MSmerge_genhistory'] .SCH script generation time: 21 (ms) *** *** [System table:'sysmergesubsetfilters'] .SCH script generation time: 30 (ms) *** [8/3/2005 4:43:34 PM]MyServer.MyMainDatabase: select 1 from [dbo].[ContactsCategories] (TABLOCK HOLDLOCK) where 1=2 [8/3/2005 4:43:34 PM]MyServer.MyMainDatabase: select 1 from [dbo].[Contacts] (TABLOCK HOLDLOCK) where 1=2 Bulk copying snapshot data for system table 'MSmerge_contents'select * from cont20684C64E88B424BBBBE84921DEDFF77 where 1 = 2[8/3/2005 4:43:35 PM]MyServer.MyMainDatabase: select * from cont20684C64E88B424BBBBE84921DEDFF77 where 1 = 2SourceTypeId = 4SourceName = MyServerErrorCode = 0ErrorText = ODBCBCP/Driver version mismatchThe process could not bulk copy out of table 'cont20684C64E88B424BBBBE84921DEDFF77'.Disconnecting from Publisher 'MyServer' I have also found in another forum tha this is related with the files sqlsrv32.dll, sqlsrv32.rll and odbcbcp.dll. The versions of these drivers in my server are:sqlsrv32.dll: 85.1025sqlsrv32.rll: 81.9001odbcbcp.dll: 81.9031Is it really the problem in the versions of these files? Anyone knows how to update them and if there any risks by doing it?Thanks in advance...
Hi,I have a client that needs to issue soap calls to a third-party webservice from within a DTS package. Is this even possible? I'velooked everywhere and found the sqlxml, but that looks like itprovides a soap web service, not consumes one.Right now, we are consuming the same web service in an ASP.NETapplication and would love to use the same code, but am really justlooking for the best solution. Basically, the only firm requirementsare that the client needs to provide a text file of items that need tobe posted to the third-party via their web service. Right now, we usedts for the client to upload other text files, that's why I was hopingto use the same procedure, but if we need to go another route, I'msure I can convince them.Any suggestions?Trey
Hi,This is the first time I use SOAP. Dont really know the exact pictureyet. Hope you can shed some lights on me.May I know where should I start troubleshooting if I get the followinerror message when running SOAP on Windows 2003, SQL Server 2000 ?Error Code: 0 Error Source= Microsoft VBScript runtime error ErrorDescription: ActiveX component can't create object:'MSSOAP.SOAPClient' Error on Line 1. The step failed.Thanks.
I am sending request to the third party server EX:"Http://somesight.sight.net/company.asp?AC="1000"&Item="200"&DT=05/08/2007" I am getting file in soap format
I created my SOAP endpoint in SQL 2005 sp 2, I worte an ASP.NET 2.0 app to consume the exposed webmethod but how do you add the soap headers in the asp.net app? Basically I want to expose the application name property to set it to determine the actual caller in SQL Profiler. Can it be done without modifying the generated proxy code in ASP.net or is there a workaround ?
Is it possible to render a report with out usieng the SOAP API. I need to use a WCF web service instead of the ASMX web service that is made availible in SSRS. I would like to be able to to create a WCF that calls reporting services via a class library and not the web service interface.
I have created a simple webservice with a soap header and am trying to access it using an xml datasource in reporting services. The query works but I have no idea how to pass in a value for the UID on the host header. Any help? what XML would I add for the header?
This is what I have no that allows me to pass in parameters through the editor.
I posted this in the Sharepoint Designer forum, but did'nt get an answer...so trying here...Below is my soap endpoint in sql2005...works fine for InfoPath to consume the service...but when SharePoint Designer attempts to retieve data I get
"The server returned a non-specific error when trying to get data from the data source."
In SPD I can connect to the service and see the methods and parameters...but never get any data returned...wondering if it's in my endpoint setup. BTW-using Windows security by default in SQL2005...I've tried different types of logins without success...
I'm using a SQL-2005 DB to manage TFS Build Information. I need to create a SOAP web service call in response to an INSERT in the Builds table. I am, however, thoroughly confused about the most efficient way to do this. The best I can come up with is to create a CLR function that takes the build number from the DB Insert statement, creates the XML and sends the msg to my already published (and already being used) WebService. The CLR function would be called in a trigger set of by the insert.
I don't suppose there is a native way to generate outbound SOAP msgs based upon DML events?
Has anyone worked out how to trace SOAP/HTTP Endpoints in SQL 2005 SP 2?
I'm not having a particular problem, just want to know how things work, such as which layer is responsible for the HTTP Authentication. I've traced the HTTP.sys stack using logman.exe (see http://www.thelastpickle.com/2008/03/22/tracing-sql-soap-endpoints-through-httpsys/) .
I cannot see any SQL Profiler events, and I've tried setting trace 7801 and 7803 as described in http://www.sqljunkies.com/Article/5CCAC423-1407-4A36-AF71-ED6A67D9646A.scuk#_Toc52964195 but they do not result in any logging.
The web serivce for blogging to Community Server requires the username and password to be specified in the SOAP Header and not the body, I however can't access the soap header. How can I achieve this?
Is there any way to restore a database of higher version to lower version.
E.g. I have created a database in sql server 2012, created some tables & procedures in that.I took Full backup of that database. Can I restore it to sql 2008r2 or any lower version.
I know direct restore is not possible, I have to use either import or export option or generating script,but i want to know is there any easy step to do so.
Since some analysis services features are only available in Enterprise version , I have to upgrade my SQL 2005 server from standard edition to enterpise edition.
So I uninstall originial standard version of analysis service and install a Enterprise version. However, the analysis service is still a standard version after installation.
Is it possible to keep data engine as standard version and install a enterprise version of analysis service?
Hello,I have been searching and reading a lots of information on the microsoft website about the different version of SQL server, but still can not make my decision.In term of performance, is there a real big difference between the workgroup and the standard version? The workgroup is limited to 3 GB of RAM while the standard is unlimited, would that really change the performance if my server has 16Gb or RAM?The price difference is pretty substantial so if could only have to buy the workgroup , it would be better.One more question, regarding the type of licence, my server has 2 processors, could I avoid buying 2 licences and get the Server plus CAL instead. I am using this server to host 4 web-application running on SQL server. Each database is about 15 MB.Thanks in adavance for your advises.Arno
I am wondering if it is possible to change from SQL Server Enterprise Evaluation Version to Developer Version. The reason is because the Enterprise Evaluation version expires after 180 days. So if I create reports and cubes in Enterprise Evaluation I can import them into Developer Edition right? Should I remove the Enterprise Evaluation version after 180 days or leave it then install Developer Edition?
I have tried to attatch a database ,created by SQL server Express within a C# application , in SQL server 2005 Enterprise edition, but the following error message appears:
-----------------------------
TITLE: Microsoft SQL Server Management Studio ------------------------------
Attach database failed for Server 'MEDO'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft SQL Server&ProdVer=9.00.1187.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach database+Server&LinkId=20476
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The database 'E:X.MDF' cannot be opened because it is version 611. This server supports version 607 and earlier. A downgrade path is not supported. Could not open new database 'E:X.MDF'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)
------------------------------
so , how can I solve this problem , I need to reed the data resides in the tables of 'X' database , how can I do it?? please help me.
I have an ssis package that downloads a SQL Server 2000 database and restores it to a SQL 2005 server. Ninety-five percent of the time it runs just fine, but every so often the job fails and I get the following set of error messages in the log file. (I have had to delete some of the proprietary information for this message to satisfy my boss like putting in [Database name] in place of the actual name of the database in the error message).
OnError, Restore backup file to DB,,,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,Converting database [Database name] from version 539 to the current version 611. OnError,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,Converting database [Database name] from version 539 to the current version 611. OnError,Restore backup file to DB,,,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,Database [Database name] running the upgrade step from version 539 to version 551. OnError,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,Database [Database name] running the upgrade step from version 539 to version 551. OnError,Restore backup file to DB,,,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,The transaction log for database [Database name] is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases OnError,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,The transaction log for database [Database name] is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases OnError,SQL5,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,RESTORE could not start database [Database name]. OnError,SQL5,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,RESTORE could not start database [Database name]. OnError,SQL5,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,-1073548784,0x,Executing the query "RESTORE DATABASE [Database name] FROM DISK = '[Path to back up file]' WITH REPLACE, MOVE 'ASP_Live_Data' TO [Path to MDF file], MOVE 'ASP_Live_Log' TO [Path to LDF file]" failed with the following error: "RESTORE DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. OnError,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,-1073548784,0x,Executing the query "RESTORE DATABASE [Database name] FROM DISK = '[Path to backup file]' WITH REPLACE, MOVE 'ASP_Live_Data' TO [Path to MDF file]', MOVE 'ASP_Live_Log' TO [Path to LDF file]" failed with the following error: "RESTORE DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. OnTaskFailed,Restore backup file to DB,,,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,(null)
I have received the error message "Package migration from version 8 to version 6 failed".I have developed a SSIS package with Visual Studio 2013 which gives me PackageFormatVersion of 8. I then deploy my package to the ssisdb catalog that is running on a SQL Server 2012, this works fine but when I try to execute the package the error arises…due to SQL Server 2012 has a PackageFormatVersion of 6 and it can’t run something that has a greater version.I haven’t seen any good solution for this but one that would work for me would be to upgrade the Integration Services Server from 2012 to 2014, leaving everything else in 2012 (database, ssms, ssas, ssrs).Would this solve the package format problem? Would I then be able to execute my packages in the ssisdb catalog?
I've tried creating several Web Service Tasks and had no problems until I came across one that requires authentication. I have a standalone program to handle this Web Service, but I'm experimenting with SSIS to see if I can replace it.
This used to work just fine until about a week ago. We're not sure if there was a MS update that caused this behavior. If the user saves the report to a local disk instead of opening it, they can save it successfully and open it later.
Now, I checked and verified that my backup version of SQL Server is the same as the version installed on the computer I'm restoring too.
I have SQL Server on a production machine that I backed up and want to test a full restore on a dev machine to make sure it will work when I need it to.
Now that I've run the restore command on my tape backup and go to restart the SQL server service I receive:
Configuration block version 0 is not a valid version number. SQL Server is exiting. Restore the master database or reinstall.
I'm afraid I don't understand why this is happening. If the builds are the same, then shouldn't restoring the MASTER database have worked normally and I'd be able to restart the service now?
I have the trial version of SQL Server 2005 installed and have setup a couple of databases. This trial version will expire in another few weeks. I recently purchased a copy of the software and want to install it. Will I lose my databases, user info, etc? How do I go about installing without losing anything?
We have a 64bit os machine that we accidently loaded the 32 bit version of sql server on. We now want to upgrade it to 64 bit sql server, but we now have a production database on it. My understanding is that all I have to do is detach the production database, upgrade to 64bit sql server, then reattach the database. Is this really all I have to do?
I started this thread as the last attempt to sort the issue out.
I have an SSIS package that loads data from a .csv file into my database. It works fine on my developer machine. I start it programmatically or from Management Studio or from Visual Studio, and it works. Then I deploy it to the MSDB database on the computer on which it will have its final place. There again I can start it from Management Studio or from Visual Studio (using the source file), and it works. But when I start it programmatically, it just fails telling me:
Package Warnings: Package Errors: The version of component "****" (11773) is not compatible with this version of the DataFlow. Component "component "Derived Column" (13627)" could not be created and returned error code 0x80070005. Make sure that the component is registered correctly. The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "Flat File Source;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;1". component "Agreement File" (11773) failed validation and returned error code 0xC0048021. One or more component failed validation. There were errors during task validation.
Maybe the source of the problem is that this machine is a 64-bit one, while the developer machine is 32-bit one. But why does the package run fine when I start it from Management Studio?
Can some one here give me more insight about how to upgrade a SQL Server 2005 Standard Version (32 bits) to a SQL Server 2005 Enterprise Version (32 bits) as default instance on a Windows 2003 enterprise OS (32 bits). I want to know what is the easist way and what is the safest way. May I preserve some settings I have for the STD version, or I have to start from strach again to configure the server? Is there any catches, anything I should have attention to (We are using heavily about CLR and fulltext indexing)?
Hello All,I have a webservice uses a vb.net component that accesses thrid party dll to connect to a sqlserver dbase, username,dbase name ,server and password are passed to the third party dll for login purpose.This works fine in development evironment when pda client calls webservice, A soap error is thrown to the client "sqlserver does not exist or access denied" when the client calls the deployed webservice. I have tried the following 1. Added ASPNet user to the database 2.Added domian user to the database both has public and dbowner rightsCan any one help??[:'(]Thanks Regards
is message exchange between a .NET Webservice and a SQL stored procedure possible? And if, could you please explain me how? Or give me a tip where i can get more informations and maybe samples? thanks for your help