Application Crashes When Calling Sql Server Routine In Debug Mode.
Mar 23, 2008
I use Microsof Visual Studio 2005 to write a c# aplication for my compact device (Dell Axim).
I also use Sql Server Compact Edition to handle my database.
Everything worked OK but suddenly I get an exception on the first call to fill command of a table in my database (Any table) This exception is happenning only when I debug the application if i run the application without debug everything is workink OK.
The exception details are :
System.Data.SqlServerCe.SqlCeException was unhandled
Message="Unspecified error [ sqlceqp30.dll ]"
HResult=-2147467259
NativeError=25123
Source="SQL Server Compact Edition ADO.NET Data Provider"
StackTrace:
at System.Data.SqlServerCe.SqlCeConnection.ProcessResults()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at System.Data.Common.DbDataAdapter.QuietOpen()
at System.Data.Common.DbDataAdapter.FillInternal()
at System.Data.Common.DbDataAdapter.Fill()
at System.Data.Common.DbDataAdapter.Fill()
at Ness300.NessDBDataSetTableAdapters.UsersTableAdapter.Fill()
at Ness300.LoginPanel.DoLogin()
at Ness300.LoginPanel.OKButton_Click()
at NL300Controls.BmpButton.L300Button_MouseUp()
at System.Windows.Forms.Control.OnMouseUp()
at System.Windows.Forms.Control.WnProc()
at System.Windows.Forms.ContainerControl.WnProc()
at System.Windows.Forms.Control._InternalWnProc()
at Microsoft.AGL.Forms.EVL.EnterMainLoop()
at System.Windows.Forms.Application.Run()
at Ness300.Program.Main()
I tried to run the application from the mobile device in order to connect to it doing "Attch to running process" from visual studio.
But just running the application on the device with the resgistry value:
HKEY_LOCAL_MACHINESOFTWAREMicrosoft.NETCompactFrameworkManaged DebuggerAttachEnabled
set to 1 caused the crash when I set it back to 0 everything works fine.
It worked for me before I do not know what happened.
Is it a security problem ?
Can any one helpi me with this because this problem do not give me a way to debug my application.
View 3 Replies
ADVERTISEMENT
Mar 19, 2008
I have an application that manage an sql srever compact edition database it worked OK until I got the following problem:
Only when debuging the application ("Start Debugging" from visual studio). In the first call to an sql server routine I get an exception "Unspecified error [ sqlceqp30.dll ]"
My code:
this.usersTableAdapter.Fill(this.nessDBDataSet.Users);
The line with the exception:
[global:ystem.Diagnostics.DebuggerNonUserCodeAttribute()]
[global:ystem.ComponentModel.DataObjectMethodAttribute(global:ystem.ComponentModel.DataObjectMethodType.Fill, true)]
public virtual int Fill(NessDBDataSet.UsersDataTable dataTable) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable); //Here I get the exception
return returnValue;
}
The Exception:
Unspecified error [ sqlceqp30.dll ]
Again if I do "Run Without Debugging" Evrything is working.
Can any one help me with this
Thanks
Ofer
View 2 Replies
View Related
Apr 16, 2008
I have a sql server ce db file that I use in my pocket pc application. It seems to be working until I try to edit my .sdf file in SQL Server (2005) Managment Studio. After this I cannot open modified file in my application.
I receive native exception error when I call Open method for Connection object:
ExceptionCode: 0xc0000005
ExceptionAddress: 0x03f8aaac
Reading: 0x00000010
When I edit .sdf file in another pc it's all working.
My config is:
windows vista business
.net compact framework 2.0 sp2
sql server 2005
sql server 2005 compact edition
sql server 2005 compact edition server tools
sql server 2005 compact edition tools for visual studio 2005
Best regards
View 1 Replies
View Related
Feb 17, 2006
Will the database get locked if my ASP.Net application that is calling a stored procedure in which a HOLDLOCK for table1 is issued to SQL Server, suddenly crashes just after the stored procedure is called?
View 3 Replies
View Related
Mar 30, 2004
Is it possble to automatically call an application when another application makes an INSERT from inside sql server? If its possible - how do I do that?
Thx in advance
/MiZza
View 2 Replies
View Related
Oct 10, 2007
I'm having problems getting a package that I'm trying to develop to run consistently.
This package is using and IBM OLE DB Provider for DB2 connection manager to move data from a remote DB2 for Windows source to a Native OLE DBSQL Native Client connection manger for a SQL 2005 destination.
Sometimes the package works. Sometimes it doesn't. When it doesn't, a command window briefly flashes in Visual Studio before execution "completes". There are no error messages even though the job aborts and no data is moved. The only indication of failure is that the data flow task never changes to green and the output reports that the package was "Canceled". Here's the debug output I'm getting:
Information: 0x40016041 at Integrity_Report_ABD: The package is attempting to configure from the XML file "O:JrsfilesScriptsSSISConfigDB.dtsConfig".
Information: 0x40016040 at Integrity_Report_ABD: The package is attempting to configure from SQL Server using the configuration string ""SSISConfiguration";"[dbo].[SSISConfigurations]";"DMS.EDW.EtlData";".
Information: 0x40016040 at Integrity_Report_ABD: The package is attempting to configure from SQL Server using the configuration string ""SSISConfiguration";"[dbo].[SSISConfigurations]";"FG.DCS.ABD";".
SSIS package "Integrity_Report_ABD.dtsx" starting.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning.
SSIS package "Integrity_Report_ABD.dtsx" finished: Canceled.
This is the first time we've tried to connect to our WinDB2 servers with SSIS. I'm thinking that I may need to move away from this type of connection and revert back to something like ODBC.
Thoughts?
Thanks,
Bryan
View 8 Replies
View Related
Jan 8, 2007
Exception ex.Message I am getting in debug mode calling AcquireConnection is much shorter than the logged message in run time because all the errors come to output window in debug. Is there any way to get all these errors description from exception object in debug time to be able to parse it?
Thanks.
View 5 Replies
View Related
Apr 24, 2007
Hi,
I am passing some /SET commands on the command line when I execute packages I created in SSIS and have run from the SQL Server Job manager. When I put these same /SET commands on the command line arguments section of the project properties page I would expect they would be passed into the executed package when it is run thru BIDS. But the variables still have their defined values when the packages executes.
Is there a trick to getting command line arguments to work in the debugger for SSIS/BIDS??
DaveM
View 4 Replies
View Related
Apr 7, 2006
Maybe I'm missing something, but I can't find how to run multiple tasks in sequence while in Visual Studio debug mode. In DTS design mode I grew accustomed to right-clicking tasks one-at-a time, but in SSIS I find the additional step of having to exit Debugging mode after every task gets old after a while.
There must be a way to start execution at a certain task and have the package continue all the way to some other specified task. It would also be nice to have every task in a Group execute in sequence and stop (even if connections continue beyond the group). I could even settle for repeatedly clicking the Continue button in Debug mode, but it's always grayed out when the current task is finished!
Can this be achieved by setting breakpoints?
View 3 Replies
View Related
Aug 11, 2006
Hello!
I am specifically looking for a KB article, best practice, white paper etc, that states it is not recommended that SQL Server (either 2000 or 2005) is installed on a WIndows 2003 Server that is also running Terminal Services in application mode.
Is there such a document or reference?
Thanks,
David Noal
MCP
View 3 Replies
View Related
Apr 15, 2008
Hi,
I'm writing an application with Visual Studio 2005 (Visual Basic .NET 2.0) which uses a SQL Compact Edition 3.5 database. On my HTC Touch with Windows Mobile 6.1 installed the application crashes, without any error message, if I try to open a connection. But...On the Windows Mobile 6 Pro emulator the connection opens normaly. The whole application runs perfect.
On both "devices" are the same dll's, of version 3.5.0.0.
I'm using the following code to open the connection:
Code Snippet
Private mySQLce_strConnection As String = "Data Source ='" & App_Path() & "MControl_SQLce.sdf" & "';"
Dim localConnection As New SqlCeConnection(mySQLce_strConnection)
localConnection.Open()
I tried so many things but without any success. But...I'm able to open the database (MControl_SQLce.sdf) with the Query Analyzer 3.5 on the Mobile. No problem.
This is my configuration:
Dev PC:
Windows XP SP2
Visual Studio 2005 Pro
.NET Framework 2.0 SP1
.NET Compact Framework 2.0
SQL Server Compact Edition 3.5 (this version I reference to in my VS project)
Mobile Device (HTC Touch):
Windows Mobile 6.1
SQL Server Compact Edition 3.5
Any suggestions? I can't figure this out.
View 8 Replies
View Related
Feb 7, 2006
Does anyone know why this happens? When I run one of the packages in my project (by hitting the play button in the designer), all of the other packages in that project open before it starts running?
Thank you.
View 6 Replies
View Related
Feb 11, 2008
I receive the following error when i call report server web service from an asp.net application:
"The request failed with HTTP status 401: Unauthorized."
Here are the IIS logs on the reporting services server. When i open IE and browse to the web service i provide my user credentials and i can access the web service just fine. However when i call the web service via my asp.net application it looks like my credentials are not being passed??
Browsing web services via internet explorer.
2008-02-11 21:26:13 W3SVC1836052065 HQSQLDEV1 10.69.21.140 GET /Reports/images/16fold.gif - 8080 triwestdbloom 10.69.21.140 HTTP/1.1 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+WOW64;+SV1;+.NET+CLR+2.0.50727;+.NET+CLR+1.1.4322) 10.69.21.140:8080 200 0 0 15
Call from ASP.NET App
2008-02-11 21:26:13 W3SVC1836052065 HQSQLDEV1 10.69.21.140 GET /Reports/images/16fold.gif - 8080 - 10.69.21.140 HTTP/1.1 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+WOW64;+SV1;+.NET+CLR+2.0.50727;+.NET+CLR+1.1.4322) 10.69.21.140:8080 401 1 0 0
Here is my code:
RSWebService.ReportingService rs = new RSWebService.ReportingService();
rs.Credentials = new System.Net.NetworkCredential(@"triwestdbloom",
"blah", "triwest");
//rs.PreAuthenticate = true;
//Get all folders
RSWebService.CatalogItem[] allItems = rs.ListChildren("/", false);
//Get only folders not hidden to the user.
List<RSWebService.CatalogItem> visibleItems = new List<RSWebService.CatalogItem>();
foreach (RSWebService.CatalogItem item in allItems)
{
Response.Write(item.Name.ToString());
}
Any ideas?
View 2 Replies
View Related
Mar 10, 2008
I just had this happen twice in a row. The data flow task is showing a number of records almost twice as high as the actual data that is going into the table. This happened to me in two different DFT's with different data.
I am using an OLEDB source which uses a query something like:
select * from functiona()
In the DataFlowTask I see it had around 400,000 Rows go through the path all the way to the deastionation..
However I know that isn't right. If I do:
select count(*) from functiona() I get 200000 rows. Now the weird thing is if I check the table that it inserted to, it has the right number of rows, 200,000. (Numbers are not exact).
Anyone else had this happen?
View 6 Replies
View Related
Jan 18, 2007
Hi,
Can any one please tell me how to get the complete error description for example when i dont Redirect Row for Error in OLEDB Source i get a detailed error message with column name as
[RCheck [385]] Error: There was an error with input column "CHECK_STATUS" (456) on input "OLE DB Destination Input" (398). The column status returned was: "The value could not be converted because of a potential loss of data.".
But when I set Redirect Row for error and use the Script component to log them into a Table with ErrorDescription based on ErrorColumnID it only gives me this.
The data value cannot be converted for reasons other than sign mismatch or data overflow.
Thanks
Sat
View 1 Replies
View Related
Aug 16, 2006
Hello
When running a package in VS you can see something like this in the output window:
SSIS package "logging.dtsx" starting.
Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning.
Information: 0x402090DC at Data Flow Task, Flat File Source [1]: The processing of file "C: est ssis loggingad_data1.txt" has started.
Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning.
Warning: 0x8020200F at Data Flow Task, Flat File Source [1]: There is a partial row at the end of the file.
Information: 0x402090DE at Data Flow Task, Flat File Source [1]: The total number of data rows processed for file "C: est ssis loggingad_data1.txt" is 477.
Information: 0x402090DF at Data Flow Task, OLE DB Destination [1011]: The final commit for the data insertion has started.
Information: 0x402090E0 at Data Flow Task, OLE DB Destination [1011]: The final commit for the data insertion has ended.
Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning.
Information: 0x402090DD at Data Flow Task, Flat File Source [1]: The processing of file "C: est ssis loggingad_data1.txt" has ended.
Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "DataReaderDest" (87)" wrote 0 rows.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "OLE DB Destination" (1011)" wrote 1 rows.
SSIS package "logging.dtsx" finished: Success.
This is exactly when I need when a package is running but I want to be able to see it without using Visual Studio.
I would do it in Reporting Services but I need to find out to get the information. The SSIS logging feature in a package does not provide that kind of info.
Did someone try this already?
Thanks!
Mop
View 6 Replies
View Related
Mar 12, 2008
This would actually be funny if I weren't under serious time constraints right now. I have an SSIS project with several script tasks in the control flow. I put breakpoints in one of them to allow me to step through and see whats going on. However, when I start the project, the IDE brings up the script editor for a different script task. The breakpoints in this task are actually on the same line numbers as the task I need to debug but the code is all wrong. I checked the task for which the code is being displayed and there are no breakpoints there.
Thanks for the assist!
Don
View 11 Replies
View Related
Oct 30, 2006
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedSource Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [OdbcException (0x80131937): ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +35
System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle) +131
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +98
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.Odbc.OdbcConnection.Open() +37
DBConnection.open() +12
ASP.global_asax.Session_Start(Object sender, EventArgs e) +35
System.Web.SessionState.SessionStateModule.RaiseOnStart(EventArgs e) +2163182
System.Web.SessionState.SessionStateModule.CompleteAcquireState() +154
System.Web.SessionState.SessionStateModule.BeginAcquireState(Object source, EventArgs e, AsyncCallback cb, Object extraData) +542
System.Web.AsyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +90
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42 ODBC version 3.526.1830.0strconn = "DSN=testserver;uid=tester;pwd=tester;DATABASE=Test_Database"I've Test_Database on 2 machines (same data in both machines), one is in SQL 2005 server and another one is in SQL 2000 server.When the website was published, it can't work. (with both database). But it work in debug mode in Visual Studio2005.The website can't work when use ODBC connection but it work when use SqlClient.Help me solve this problem please. T_T Thanks in advance,
View 8 Replies
View Related
Feb 8, 2008
Hi All,
I have problem in calling the SP from ASP.NET application
@DefApp nvarchar(255)= '' ,@DefBusFunction nvarchar(255)= '' ,@DefImpact nvarchar(255) = '',AS Begin declare @sql nvarchar(4000)declare @whereClause nvarchar(4000)DECLARE @return_value intdeclare @sqlWhere nvarchar(4000) select @sql = 'SELECT DefApp, DefBusFunction, DefImpact FROM Def LEFT JOIN ZFunction ON (def.DefApp = ZFunction.App) AND (Def.DefBusFunction = ZFunction.BusFunction)' if @DefImpact <> '' Set @whereClause = ' where DefImpact ' SET @whereClause = @whereClause + ' = ''' + @DefImpact + '''' set @sqlWhere=@sql + @WhereClauseEXEC @sqlWhereEnd
and i am calling this SP from my ASP.net application to fill the SSRS report. I have written code in ASP.NET like:
sqlCmd = new SqlCommand("subbusample", conn);
sqlCmd.CommandType = CommandType.StoredProcedure;sqlCmd.Parameters.Add(new SqlParameter("@DefImpact", SqlDbType.NVarChar, 255, txtValue3.Text.ToString()));
sqlCmd.Parameters.Add(new SqlParameter("@DefBusFunction", SqlDbType.NVarChar, 255, txtValue1.Text.ToString()));
sqlCmd.Parameters.Add(new SqlParameter("@DefApp", SqlDbType.NVarChar, 255, txtValue2.Text.ToString()));
RptViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
RptViewer.ServerReport.ReportServerUrl = new System.Uri("http://servername/ReportServer");RptViewer.ShowParameterPrompts = false;
RptViewer.ServerReport.ReportPath = "/folder name/Subbu_Sample";
when i execute it, i am not able to fill the report with data.
Please let me know what i am doing wrong.
Thanks,
SR.
View 6 Replies
View Related
Jul 20, 2005
I have an ODBC/C program and I want to call the stored proceduressp_addlogin and sp_adduser in it. Can someone please provide me withsome sample code showing the best way to do this.
View 2 Replies
View Related
Oct 3, 2007
Hello
I have a SSIS-Package stored in the SQL Server. This package works fine when i execute it from the SQL Server. But if I try to execute the package from a COM+-Application, nothing happens.
Here is my code snipped:
Public Function ExecutePackage €¦
Dim myPackage As New Package
Dim app As New Application
Dim pkgResults As DTSExecResult
'----- Execute the package from SQL Server
myPackage = app.LoadFromSqlServer("\PackageName", "ServerInstance", Nothing, Nothing, Nothing)
pkgResults = myPackage.Execute()
€¦
End Function
In a Windows Forms Application I can execute the package with this code snipped succesfully. Therefor I think that the problem is my COM+-Application.
Can anybody help me?
Thank's
Jürgen Paulus
View 4 Replies
View Related
Apr 3, 2008
Can you put is a call withing a Data Flow that will call an External Application and pass a parameter to that application IE say a command line app and then take the output and assign it to back to the flow as a "column" or whatever for that row... IE I want to take a value push it to an external app and then the output from that app I want to insert it into another field for that row in the new table I am moving the data to.
View 4 Replies
View Related
Jul 20, 2005
Hi,In SQL Books Online in the section on @@Error it gives the followingexample:-- Execute the INSERT statement.INSERT INTO authors(au_id, au_lname, au_fname, phone, address,city, state, zip, contract) values(@au_id,@au_lname,@au_fname,@phone,@address,@city,@state,@zip,@contract)-- Test the error value.IF @@ERROR <> 0BEGIN-- Return 99 to the calling program to indicate failure.PRINT "An error occurred loading the new author information"RETURN(99)ENDELSEBEGIN-- Return 0 to the calling program to indicate success.PRINT "The new author information has been loaded"RETURN(0)ENDGOHow do I access the value returned by the RETURN statement (i.e. 99 or0) in my asp application that called the stored proc.Sometimes rather than just return an integer signifying success orfailure I've seen examples where the id of the newly added item isreturned on success and perhaps -1 if the operation fails. Theseexamples make use of ouput parameters to achieve this. If theoperation succeeds then then the output parameters value is set to thenew id and this is accessed from the calling application.E.g.IF @@ERROR <> 0BEGIN-- Return -1 to the calling program to indicate failure.PRINT "An error occurred loading the new author information"SELECT @MyOuptputParameter = -1ENDELSEBEGIN-- Return id to the calling program to indicate success.PRINT "The new author information has been loaded"SELECT @MyOuptputParameter = @@IDENTITYENDWhy go to this trouble if you can use the RETURN statement?
View 4 Replies
View Related
Jul 20, 2005
I'm using an Access2K front end on a SQL Server2K backend.I use Scope_Identity() in a lot of stored procedures to pass thenewwly inserted record's unique ID to the next select statement in thesame stored procedure.What I'm wondering is how I can pass the Scope_Identity back to thecalling application.I'm hoping someone can show me the SP code and the aceess code neededto accomplish the following:I insert a new record in a table with a stored procedure. The SPpasses the uniqueID (Scope_Identity) back to MS Access, then MS Accessuses the uniqueID when calling another function...thanks
View 1 Replies
View Related
Feb 16, 2007
Hi all,
I have a customer with an RS installation in a DMZ, using ADAM for its authentication.
The problem I have is as follows :
When setting up the execution log reporting (supplied as part of the standard install) all information being captured for report execution e.g Which user ran a specific report and when, is coming up with 'UNKNOWN' for the user name.
Does anyone have any idea where to look to fix the recording of user information? I am not sure whether it is a RS or A.D.A.M issue.
Thanks
Clint Pugh
View 2 Replies
View Related
Jul 25, 2014
We have reports in SharePoint integrated mode which are really slow when compared to native mode. I have been asked to research and give info on what exactly causes the delays.
Any articles which give me information as to what happens when a report is run from SharePoint server and where does it log.
View 1 Replies
View Related
Mar 26, 2005
Recently I read such statments 'When SQL Server is run in "lightweight pooling" mode (fiber mode) and the DTC service is started, unexpected behavior may occur.'
Can someone say anything about fibe mode?I am appreciated for it.:)
View 3 Replies
View Related
Jan 20, 2004
We are network admins at a college, with no database experience at all. We use an Altiris product which uses SQL to maintain a database. Our database is OK, but the transaction log has grown to 24 Gb and has caused a slowdown. When we try to back up the database in preparation for shrinking it to the recommended 100 Mb, the server seems to start the backup but crashes (restarts) after a few minutes. Has the situation got out of hand i.e. with files so big, is our server never going to be able to work with it? Or are we missing something obvious?
Any information on resolving the situation gratefully received, thanks in advance.
Denis
PS
View 2 Replies
View Related
Dec 15, 1999
I am using the DTS wizard to import tables from an AS/400. Some of the tables in the job are quite large and Sql Server either hangs up or completely crashes. My current configuration is WIN NT, SP4.0 SQL Server 7.0 no Service pack. Any suggestions?
View 1 Replies
View Related
Apr 30, 2007
Every time I do a full backup of my databases, it will go through most of them, then get to the largest database I have (13 Gig) which is the Sharepoint database, and as it starts to back it up, the machine will then freeze up and need to be hard rebooted. I confirmed it was the backup by moving the backup to a different time, which is when the server crashed. Also, if I manually attempt to do a full backup on it, the machine will then crash.
I'm running Windows Server 2003, SP2, fully patched, SQL server 2005 SP2 (32-bit) fully patched. 4 Gigs memory. Have tried setting it to use 3 Gig itself, with and without AWE, but it didn't make a difference. This machine is a dedicated SQL Server machine. Microsoft has had us run perfmon and send them perfmon reports and dumps. They don't see anything that would cause our issues. Nothing shows up in the event viewer. This server has been running just fine since last June when we installed SQL 2005. The problems started occurring on March 8 of this year. I don't see any patches that correspond to that date.
Hardware is all reporting fine according to the Gateway Hardware tool.
I'm the Sharepoint Admin, we have no SQL Admin, so now this is another job of mine. So any advice, anything I should look for, would be extremely helpful.
Thanks!
Linda
View 8 Replies
View Related
May 29, 2007
Hi,
I am invoking RS web services to render reports, using Apache Axis to generate stub classes from Reporting Service WSDL.
Please let me know if I can integrate Report Viewer control in the jsp where I am writing the report output. Else do I have to create my own custom tags simulating ReportViewer functionality.
View 4 Replies
View Related