I am sync. for the first time (Merge Replication using SQL 2005 and Mobile) and this error keeps poping up on the emulator. I am tring out the tutorial. :) boss on my butt.
Does anyone have any ideas or a solution to this...your help is WELL APPRECIATED ...
Error code: -2147024809
zo
plz help me...
when establishing a connection to the server. when connecting to server 2005, this failure may be caused by the fact that under the default setting SQL Server does not allow remote connections.(provider: Named pipes provider, error:40 - could not open a connection to sqlserver)
I have the error above, but no error log. I can preview the sub report - but this main report fails after working this morning. This is for internal company reports and I rebuilt this one after converting from access.
I have looked where the error logs should be, but there are no error logs.
I rebuilt the query as I needed to change this, but this did not help.
Is there someone who could point me in the correct direction.
Thanks!
Terry
Hello All,
I'm developing pocket PC application.. when I want to replicate my data from pocket pc to development pc.. I've got this error on my pocket pc.. "An error has occurred on the computer running IIS"
Any ideas? Any help?
I'm using SQl Server 2000, SQL Server CE 2.0, VS.Net 2003
Thanks
Hi, i was following the tutorial in SQL Mobile Books online "Creating a Mobile Application with SQL Server Mobile ", but when i try to run the application using the pocket PC 2003 emulator, the got the following error, "An error has occurred on the computer running IIS, Try restarting the IIS server.", any idea why?
View 13 Replies View RelatedI have smilar kind of an issue with replication. I had sucessfully done replication with Sqlce2.0 on sql server 2000. In development machine I had VS 2003, sqlce development tools.
Now I use the same code done in VS 2003 into VS2005, it sucessfully converted the code.
In server machine (win 2003) I installed sql server 2000, sql server 2000 service pack 4, SP4 merge replication components, sql server 2005 mobile server tools and .Net framework 2.0. Created pubication sucessfuly. In this machine I configured IIS as per the web synchronization wizard. Gave anyonymous permissions. Virual direcory is created sucessfully. I tested the server agent in IE http://myservername/aliasname/sqlcesa30.dll.
SQL Server Mobile Server Agent 3.0 is shown
My application opened successfuly in windows mobile 5.0 Pocket PC emulator. When try to sync its dislays error "A request to send data to the computer running IIS is failed, see Hrresult"
No firewall in both development and server machines.
The same code works if its sqlce20 perfectly with vs2003 code. Not in this
Can anyone tell me whats wrong in this?
Regards
Arif
I have a looped query querying linked servers. When it cannot connect to a server, it errors out.
Error Message;
Server: Msg 6, Level 16, State 1, Line 2
Specified SQL server not found.
How can I handle this error message and continue the query?
Hiwhen i right click table and click design table then error occured(an unexpected error occured during this operation)If any one knows please let let me know your help would be appreciated .thankspardhi--Message posted via http://www.sqlmonster.com
View 1 Replies View RelatedI am getting the following error.A transport-level error has occurred when sending the request to theserver. (provider: Shared Memory Provider, error: 0 - The system cannotopen the file.)On performing the same operation again, it happens fine without anyerror.Please help.Regards,Shilpa
View 5 Replies View RelatedWe just starting receiving an error when we try to print our reports. "An error occured during printing. (0x800C0005)".
These same reports work fine on my localhost, our build server, and our beta server. This is only happening on our production server.
I have removed the activeX control and reinstalled it. It did not work.
We are ONLY running SSRS 2005. We never ran a BETA version. It was working up until recently.
Please HELP!
Thanks.
Hi,
I have installed SQL 2000 reporting services 2000 SP2.
When i try to print report by clicking print button in HTML tool bar i get error as "Error occured while printing 0x80040005"
I have turned on client print log, but there in no useful information
Regards
Shakeela
we r using the report viewer control of the reporting service 2000 , and it works fine
but when there is a huge report (around 1000 page) it gives the above error "An Error Occured During Printing (0X80070003)" after spoling of around half of the report around 500 page, and stops spoling the rest of the report
is it a problem with the reporting service or the server hardware ?
Hi All,
I am new to sql server 2005.
I tried to connect to reporting services configuration manager.
it gives an error
An Unknown error has occured in WMI provider.
error code 80040219.
so please help me out regarding this issue.
Hello,
The problem which i am facing in SQL Server 2005 is that, I have 2 database and the owner of both the databases is sa but when I go to database > security > users here I cannot find 'sa' as user. when I am going to add that user I get following error :
cannot use special principal 'sa'
also when I connect sa on other computer I will not connect
I have already checked following thing :
The Authontication mode of SQL is mixed mode
database owner is also sa
sa is also enable
Please can any one help me I am in big trouble
Thanks and Regards
Asif Fattah
ERP Consultant
I am new learner of ASP.NET and SQL server.So there might be any mistake in writing code.
When I tried to run my project I got following error.I am uisng SQL 2005 server.
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)
connection string used is
<add name ="ConnectionString" connectionString="Data Source=BLUESTAR\SQLEXPRESS;Initial Catalog=KnowledgeAssetManagement;Integrated Security=True"/>
I have also tried by setting local & remote connection options from the SQL server surface Area Configuration and connections option from server properties of sql server management studio.
Please help me ,my work get stucked due this problem.
SQL Server has stopped a critical task, with the following error log. I have executed the task again and the same symptons occur.
--
EXCEPTION_ACCESS_VIOLATION raised, attempting to create sympton dump
***BEGIN STACK TRACE***
0x0040DC1A in SQLSERVR.EXE, ubfree() + 0x009A
...
...
--
Has anyone any had a simliar experience or have any suggestions for investigation?
Cheers
Jasper
Hi folks,
I have been trying to figure out how to establish a remote connection to a database on SQL Server 2005, but no matter the approach, I'm met with this result: "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. error:26 - Could not open a connection to SQL Server."
The machine I have the server on is a OS Vista Ultimate, 2 gigs ram, 2.86 GHz processor.
I'm trying to access from another 2 types of machines - both laptops with Vista Ultimate.
I have run the configuration tool on the server machine to allow local and remote connections for the database engine, as well for the browser, but to no avail.
I have the developer version of SQL 2005 installed on all three machines, but don't know if that is a reason for not being able to establish a connection.
I've tried to connect via a test application; also via Visual Studio, and also directly from SQL Server on the machines.
None of the machines can access the database any of the others, regardless of the configuration.
They all display the very same error.
I'm really in need of some help with this, any ideas?
Thanks!
Gary
Hi all,
I am getting error message 'An internal consistency error occured sqlstate:42000" when i am trying to restore the database.
Regards,
Shashi.
hi,
I have enabled custom authorization in SQL server 2005 reporting services. If i try to view the reports thru report manager by using the url http://localhost/reports then i'm getting the error message as
"An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Get Online Help
The event log file is full"
If i try to view the reports by using reportserver url http://localhost/reportserver then its working fine. Please help me in resolving this issue.
The log file is as follows
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>India Standard Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServer__02_06_2007_13_59_07.log</Path>
<SystemName>BLRKEC21139D</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
aspnet_wp!webserver!1!2/6/2007-13:59:07:: i INFO: Reporting Web Server started
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
aspnet_wp!configmanager!1!2/6/2007-13:59:08:: w WARN: WebServiceAccount is not specified in the config file. Using default: BLRKEC21139DASPNET
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
aspnet_wp!resourceutilities!1!2/6/2007-13:59:08:: i INFO: Reporting Services starting SKU: Developer
aspnet_wp!resourceutilities!1!2/6/2007-13:59:08:: i INFO: Evaluation copy: 0 days left
aspnet_wp!runningjobs!1!2/6/2007-13:59:08:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
aspnet_wp!runningjobs!1!2/6/2007-13:59:08:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
aspnet_wp!runningjobs!1!2/6/2007-13:59:08:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
aspnet_wp!runningjobs!1!2/6/2007-13:59:08:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
aspnet_wp!library!1!02/06/2007-13:59:08:: i INFO: Catalog SQL Server Edition = Developer
aspnet_wp!webserver!1!02/06/2007-13:59:09:: i INFO: Processed folder '/'
aspnet_wp!library!6!02/06/2007-14:00:02:: i INFO: Call to GetPermissions:/
aspnet_wp!library!6!02/06/2007-14:00:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.ComponentModel.Win32Exception: The event log file is full
at System.Diagnostics.EventLog.InternalWriteEvent(UInt32 eventID, UInt16 category, EventLogEntryType type, String[] strings, Byte[] rawData, String currentMachineName)
at System.Diagnostics.EventLog.WriteEntry(String message, EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData)
at System.Diagnostics.EventLog.WriteEntry(String source, String message, EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData)
at System.Diagnostics.EventLog.WriteEntry(String source, String message, EventLogEntryType type)
at Microsoft.ApplicationBlocks.ExceptionManagement.DefaultPublisher.WriteToLog(String entry, EventLogEntryType type)
at Microsoft.ApplicationBlocks.ExceptionManagement.DefaultPublisher.Publish(Exception exception, NameValueCollection additionalInfo, NameValueCollection configSettings)
at Microsoft.ApplicationBlocks.ExceptionManagement.ExceptionManager.PublishInternalException(Exception exception, NameValueCollection additionalInfo)
at Microsoft.ApplicationBlocks.ExceptionManagement.ExceptionManager.Publish(Exception exception, NameValueCollection additionalInfo)
at Microsoft.ApplicationBlocks.ExceptionManagement.ExceptionManager.Publish(Exception exception)
at Infosys.ReportingServices.CustomAuthorization.Authorization.DeserializeAcl(Byte[] secDesc)
at Infosys.ReportingServices.CustomAuthorization.Authorization.GetPermissions(String userName, IntPtr userToken, SecurityItemType itemType, Byte[] secDesc)
at Microsoft.ReportingServices.Library.Security.GetCatalogItemPermissions(ItemType catItemType, Byte[] secDesc)
at Microsoft.ReportingServices.Library.GetPermissionsAction.GetPermissions(String item, StringCollection& Operations)
--- End of inner exception stack trace ---
aspnet_wp!library!6!02/06/2007-14:00:12:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!1!02/06/2007-14:03:53:: i INFO: Call to GetPermissions:/
aspnet_wp!library!1!02/06/2007-14:03:53:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.ComponentModel.Win32Exception: The event log file is full
at System.Diagnostics.EventLog.InternalWriteEvent(UInt32 eventID, UInt16 category, EventLogEntryType type, String[] strings, Byte[] rawData, String currentMachineName)
at System.Diagnostics.EventLog.WriteEntry(String message, EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData)
at System.Diagnostics.EventLog.WriteEntry(String source, String message, EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData)
at System.Diagnostics.EventLog.WriteEntry(String source, String message, EventLogEntryType type)
at Microsoft.ApplicationBlocks.ExceptionManagement.DefaultPublisher.WriteToLog(String entry, EventLogEntryType type)
at Microsoft.ApplicationBlocks.ExceptionManagement.DefaultPublisher.Publish(Exception exception, NameValueCollection additionalInfo, NameValueCollection configSettings)
at Microsoft.ApplicationBlocks.ExceptionManagement.ExceptionManager.PublishInternalException(Exception exception, NameValueCollection additionalInfo)
at Microsoft.ApplicationBlocks.ExceptionManagement.ExceptionManager.Publish(Exception exception, NameValueCollection additionalInfo)
at Microsoft.ApplicationBlocks.ExceptionManagement.ExceptionManager.Publish(Exception exception)
at Infosys.ReportingServices.CustomAuthorization.Authorization.DeserializeAcl(Byte[] secDesc)
at Infosys.ReportingServices.CustomAuthorization.Authorization.GetPermissions(String userName, IntPtr userToken, SecurityItemType itemType, Byte[] secDesc)
at Microsoft.ReportingServices.Library.Security.GetCatalogItemPermissions(ItemType catItemType, Byte[] secDesc)
at Microsoft.ReportingServices.Library.GetPermissionsAction.GetPermissions(String item, StringCollection& Operations)
--- End of inner exception stack trace ---
This is the SQLDumper file
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 3308
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x063C5860
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
02/05/07 16:10:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
02/05/07 16:10:45, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
02/05/07 16:10:45, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesSQLDmpr0001.mdmp
Regards
Uday.
Hi all,
Our application that uses Reporting Services for it's Reports.
On one customers build it appears to keep falling over.
Restarting the server seems to resolve the problem for a short period
and then it happens again.
The exception that is returned to our application is
"An unexpected error occured in report processing. (rsInternalError)"
The customer has sent me the log files from
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataReporting ServicesLogs
I've tied the time that the issue occurs to this section
w3wp!chunks!1!04/11/2008-10:27:35:: e ERROR: GetChunkPointerAndLength: System.Data.SqlClient.SqlException: Database 'ReportServerTempDB' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
and
w3wp!processing!1!04/11/2008-10:27:35:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.Data.SqlClient.SqlException: Database 'ReportServerTempDB' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
I doubt that the disk is full as our database is sitting on the same drive and presumably the whole system would have stopped working by now.
Any thoughts as to what the problem might be?
We've not seen this before.
Cheers,
Chris
Hey...
I am running a parent SSIS package (running sp2, 9.0.3042) that calls several child packages.
On our development server, we now cannot run this because we get 1 or more of these errors:
"Error 0x80004003 while preparing to load the package. Invalid pointer . "
"Error 0xC0011008 while preparing to load the package. Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored. . "
It is not occuring on the same packages. It varies every time it is run.
I can run every one of the child packages individually, using the same login ID that the parent is executed under.
The parent package works fine on my local machine and other servers running the same version of SSIS. Just not on this server.
Does anyone have any ideas???
Thanks
BobP
Hi there
I have small problem with the ADO 2.6 - 2.8 Command object.
I created a Stored procedure preforming some tasks within a tran.
whitin the tran i'm collecting the @@ERROR values and in the end (after tran closing )generating the correct error string - which will be send back to the caller
in the VB6 app, i'm using a command object with the next line:
Set MyRecordset= MyCommand.Execute
In all the cases and option, when i run the SP - the command preform the tasks and return closed recordset (with the currect answer) and i can't read it.
the only solution that worked until now: i need to call MyRecordset.Open which will requery the SP again and generate an error (User defined error).
It happens only when i run command.execute with SP that preforms multitasks and return result recordset.
CAN ANY ONE HELP ME
I have 2 xp machines one has the SQL EXPRESS Server with all the goodies on it and the other I just install the client stuff. I am using VB 6 to program with using the ADO. It works great on the server machine. The software pulls up great. I can't seem to get it to work on the client machine. I get "Login failed for user 'TIGGERLGuest'. I found the places to set the TCPIP setings on the server SQL Express to allow this even turned on the browser but nothing same error. I am using the same login on both machines and am pointed to the same workgroup. I used window authentication when I set them up. Not sure why it insists on using Guest.
This is a copy of the connection string I am using
"Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;AttachDBFileName="c:mpsdbmpswarehouse.mdf;Database=MPSDB;Data Source=tiggerlsqlexpress;Trusted_Connection=yes;"
Not sure if this is okay for connecting remote. Any help would be greatly appreciated
Rick
Hi all,
I'm new to .NET and VB2008 and trying to write my first database application. It runs fine on my development PC (Vista) but I decided to publish/install an early beta to my daughters XP computer and am getting an error reading: Unable to open database.
The CD drive on that pc has been giving us trouble so I deployed to a subdirectory on the dev pc and moved those files to a thumbdrive, copied to the same subdirectory on client pc and installed from there. I've installed it more than once, trying different paths for the installed version hoping that was the issue but have hit a wall. Can anybody help?
Thanks,
Dominic
Help, Had configuration error trying to set up reporting services. Uninstalled SQL Server and Reinstalled, but not all files were removed. How many files and directories do I have to remove to get Reporting Services to work?
Thanks!
Terry<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Standard Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServerService__main_01_31_2008_16_16_12.log</Path>
<SystemName>JPADESKTOP1</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!configmanager!4!1/31/2008-16:16:12:: w WARN: WebServiceAccount is not specified in the config file. Using default: JPADESKTOP1ASPNET
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!servicecontroller!9!1/31/2008-16:16:13:: Total Physical memory: 1055309824
Im getting this error when I try to synchronize my mobile client with SQL Server Compact 3.5 with my SQL Server 2005 database: "Authentication failed at the computer running iis"
Im debugging through a WM5-device in Device Manager 3.0. I have verified that Internet Explorer on the device manager can reach the synchronization agent. But the same credentials that I use there won´t work in my application.
Im using this code for the synchronization.
Dim repl As SqlCeReplication = New SqlCeReplication()
Try
repl.InternetUrl = "http://192.168.0.115/Sync/sqlcesa35.dll"
repl.InternetLogin = _txtUser.Text
repl.InternetPassword = _txtUser.Text
repl.Publisher = "Name"
repl.PublisherDatabase = "Mydatabase"
repl.PublisherLogin = _txtUser.Text
repl.PublisherPassword = _txtUser.Text
repl.Publication = "My Publicationl"
repl.Subscriber = "MySubscriber"
repl.SubscriberConnectionString = "Data Source=" + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase)) + "DataAppDatabase.sdf;" 'Persist Security Info=False"
repl.AddSubscription(AddOption.ExistingDatabase)
repl.Synchronize()
MessageBox.Show("Sync completed")
Catch SQLEx As SqlCeException
End Try
Hi Friends,
I am currently trying to develop a small Windows Mobile Application with SQL server Mobile edition.
To develop this , I followed this link http://msdn2.microsoft.com/en-us/library/aa454892.aspx
As I dint find Vendors.sdf database I created My own Database with student table. My database name is MyDB. I created both Mobile database (.sdf) and the same database in sql server 2005
when I run the application I can update the database upto the mobile with no problem. But when I try to Sync I am facing the following exception at the following code.
private void SyncVendors()
{
if (File.Exists(this.DataFileName))
{
this.SaveData();
_repl.Synchronize(); //exception is raised at this line
this.GetData();
}
else
MessageBox.Show("The subscription database has not yet been created. You must first select the Init Sync menu item.");
}
For the replication I used
private void InitReplication()
{
_repl.InternetUrl = @"http://XXXXXXXX/MyDB/sqlcesa30.dll";\ for security reasons I am not using my system name
_repl.Publisher = @"XXXXXXXXX";
_repl.PublisherDatabase = @"MyDB";
_repl.PublisherSecurityMode = SecurityType.NTAuthentication;
_repl.Publication = @"MyDB";
_repl.Subscriber = @"MyDB";
_repl.SubscriberConnectionString = this.DataSourceConnectionString;
_repl.LoginTimeout = 120;
//_repl.InternetLogin = "XXXXXXXXXXXXXXXXXXXX?; //Timely I used these 2
//_repl.InternetPassword = "XXXXXX?;
}
"An unhandled exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll
Additional information: Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect."
Or (Some times when I change the Directory Security in IIS)
An unhandled exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll
Additional information: Authentication failed on the computer running IIS
I tried in many ways like
Ă Resetting the firewalls ( to web server(http))
Ă In sql server I set " using both TCT/IP and named pipes
Ă In IIS virtual directory--> directory security Ă settings I used anonymous, base authentication, integrated Authentication. The same exception with any authentication.
Ă SQL Server Management studio Ă view Ă Registered Server Types Ă SQL Server Mobile. Here I added my data base MyDB.sdf.
Ă SQL Server CE Connectivity Management Ă selected my database Ă and select authentications
this is my log in virtual directory
2008/01/28 14:37:11 Hr=80004005 ERROR OpenDB failed getting pub version 28627
2008/01/28 17:05:08 Hr=80004005 ERROR OpenDB failed getting pub version 28627
2008/01/28 17:12:16 Hr=80004005 ERROR OpenDB failed getting pub version 28627
2008/01/28 17:33:35 Hr=80004005 ERROR OpenDB failed getting pub version 28627
can any one please help me?
Thanks in Advance.
Does anyone know whether or not both versions can be installed on the same machine?
View 1 Replies View RelatedI am about designing an access project file that connect to a SQL Server database : it could be either on the local computer or a remote workstation, this depending on where the front end is running.
Bypassing the default log on dialog box i have set my own form that users should use to connect on adp. Then using baseconnection string i connect the adp to sql server database.
My concern is how can i check from vba if the instance of SQL Server where my back end database is located is running in order to make
users knowing that due sql server service status off their connection
tentative will fail.
inform u i can check same from console management however i would to automate same controle from my adp and avoid that users have to operate such task...
Hello,
I am trying to complete the BOL sample "Creating a Mobile Application with SQL Server Mobile". Using SQL 2k5 and VS Team Suite. I have the emulator about to get on to the internet and can even get to the http://sqlce.domain.com/sqlmobile/sqlcesa30.dll url but when runing the vb.net code I get the error 28037 "A request to send data to the computer running IIS has failed. For more information, see HRESULT.". Any help would be greatly appreciated. No software firewalls are running. I have a dns entry that points to my laptop for testing. The sync function code is below.
Sub sync()
Dim repl As New SqlCeReplication()
repl.InternetUrl = "http://sqlce.domain.com/SQLMobile/sqlcesa30.dll"
repl.Publisher = "MY-LAPTOPDBSERVER"
repl.PublisherDatabase = "SQLMobile"
repl.PublisherSecurityMode = SecurityType.NTAuthentication
repl.Publication = "SQLMobile"
repl.Subscriber = "SQLMobile"
repl.SubscriberConnectionString = "Data Source='" + filename + "';Max Database Size=128;Default Lock Escalation =100;"
Try
repl.AddSubscription(AddOption.CreateDatabase)
repl.Synchronize()
Catch err As SqlCeException
MessageBox.Show(err.ToString)
End Try
End Sub
http://sqlce.domain.com/sqlmobile/sqlcesa30.dll?diag
SQL Server Mobile Server Agent Diagnostics
2006/04/04 15:28:51
General Information
Item
Value
Server Name
sqlce.domain.com
URL
/SQLMobile/sqlcesa30.dll
Authentication Type
Anonymous
Server Port
80
HTTPS
off
Server Software
Microsoft-IIS/5.1
Replication
Allowed
RDA
Allowed
Logging Level
1
Impersonation and Access Tests
Action
Status
ErrorCode
Impersonate User
SUCCESS
0x0
ReadWriteDeleteMessageFile
SUCCESS
0x0
SQL Server Mobile Modules Test
Module
Status
ErrorCode
Version
SQLCERP30.DLL
SUCCESS
0x0
3.0.5207.0
SQLCESA30.DLL
SUCCESS
0x0
3.0.5207.0
Reconciler Test
Reconciler
Status
ErrorCode
9.0 Database Reconciler
SUCCESS
0x0
8.0 Database Reconciler
SUCCESS
0x0
SQL Server Module Versions
Module
Version
sqloledb.dll
2000.85.1117.0
9.0 replrec.dll
2005.90.1399.0
9.0 replprov.dll
2005.90.1399.0
9.0 msgprox.dll
2005.90.1399.0
8.0 replrec.dll
2000.80.2039.0
8.0 replprov.dll
2000.80.2039.0
8.0 msgprox.dll
2000.80.2039.0
We have developed a Winmobile 5.0 application using VS2005 and Sql 2005 CE. We have successfuly installed the Server Agent on the web server and using the url 'http://websitename/rdatest/sqlcesa30.dll' have received an acknowledgement from the server agent. When we set up the Web Syncronization Wizard we kept things simple and opted for anonymous access. However, our Sql 2005 is based on a separate dedicated server which can be accessed by the web server. Our website, also written in VS2005, uses the following connection string to access the Sql 2005 database for our website.
"server=172.18.22.222; database=Audit; uid=steve; pwd=letmein"
When using the following code in our PDA application we have tried the above string as well as another interpretation with the same resulting error 'A request to send data to the computer running IIS has failed, for more information please see HResult'. The code we are using is..
Using rda As New SqlCeRemoteDataAccess()
Dim sCon As String = "Provider=SQLOLEDB;Data Source=172.18.22.222; Initial Catalog=Audit ; UserID=steve; Password=letmein"
Dim sCon As String = "server=172.18.22.222; database=Audit; uid=steve; pwd=letmein"
rda.InternetUrl = "http://websitename/rdatest/sqlcesa30.dll"
rda.LocalConnectionString = "Data Source=Program FilesTestSysTestdata.sdf"
Try
rda.Pull("Detail", "SELECT Details, Actions FROM Detail", sCon, RdaTrackOption.TrackingOff, "DtlErrors")
Catch sqlCeEx As SqlCeException
RecError( sqlCeEx.ToString)
End Try
End Using
Having tried both connection strings we feel the error is caused by something else possibly on our dedicated Sql server. Would really appreciate any help.
Hi,
I Have an application for Pocket PC 2003 developed in Visual Studio 2003(VB.Net , Smart Device App). I Use Sql Server CE as the database which Synchronizes with Sql Server 2000, SP4. The IIS and the Sql Server 2000 are in different Machines. I Have Installed the proper Sqlserver Ce in the IIS machine and created virtual directory with Basic authentication.I connect my device through Active Sync 3.7. I could browse the sscesa20.dll from Pocket IE and get the ' SQL Server CE Server Agent ' message. The PC to which my pocket PC is connected is under a Proxy.
When I tried the RDA.Pull() , the function fails and returns the error
" Error Code: 80072EE7
A request to send data to the computer running IIS has failed. For more information see HRESULT. [,,,,,]
Minor Error : 28037
Source: Sql Server 2000 Windows CE Edition. "
The same application works in other network which is not under a proxy.
Any clues ?
Thanks,
Jibu
eSystem Software
How can I identify the computer of the person running an SRS report? If I query HOST_NAME() it gives me the host of the reporting server, not the person browsing.So, for example, Melissa opens a browser from computer named AAA to the SRS and pulls up her report. How do I get that report to show that the user is browsing from AAA?
View 12 Replies View Related