While Opening Management Studio I Am Getting Error--Attempted To Read Or Protected Memory.
Hi,
I am getting error while opening the Data Base Engine in Sql server Management Studio.
We applied SP2. and restarted the server but no luck.
Error Message:Attempted to read or protected memory. This is often an indication that other memory is corrupt(mscorlib).
View Complete Forum Thread with Replies
Related Forum Messages:
Attempted To Read Or Write Protected Memory. This Is Often An Indication That Other Memory Is Corrupt. (Microsoft Visual Studio)
Hello. I have received the follwoing error upon an attempt to Browse the Cube. All other tabs are functional, including the Calculations tab. We are running Windows Server 2003 SP2 and SQL Server 2005 SP2. Any suggestions would be greatly appreciated! **EDIT** - Have confirmed SP1 for VS2005 is installed both locally and on server, also. Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (Microsoft Visual Studio) ------------------------------ Program Location: at Microsoft.Office.Interop.Owc11.PivotView.get_FieldSets() at Microsoft.AnalysisServices.Controls.PivotTableFontAdjustor.TransformFonts(Font font) at Microsoft.AnalysisServices.Browse.CubeBrowser.UpdatePivotTable(Boolean translate) at Microsoft.AnalysisServices.Browse.CubeBrowser.UpdateAll(Boolean translate) at Microsoft.AnalysisServices.Browse.CubeBrowser.InitialUpdate() at Microsoft.AnalysisServices.Browse.CubeBrowser.SupportFunctionWhichCanFail(FunctionWhichCanFail function)
View Replies !
Error - Attempted To Read Or Write Protected Memory
Hi, I am back with one more problem.. I have created few reports using SSRS 2005. I am using Oracle database in Data Source to fetch my data. It is working fine and showing me report correctly. But after running the report 8 to 10 times, it starts giving me Memory error. To get rid of that, I need to recycle (stop-start) ReportingService from IIS. I am exactly getting following error... Attempted to read or write protected memory. This is often an indication that other memory is corrupt. I am not getting the actual problem, why is it giving memory error only after running few times? Please let me know if anyone facing same problem or knowing the solution for the problem. Thanks, HMaheta
View Replies !
' Attempted To Read Or Write Protected Memory' While Generating A Snapshot
Hi all, The shotshot agent is generating a snapshot, I got the error ' Attempted to read or write protected memory. This is often an indication that other memory is corrupt'. Then, the agent failed. I tried to restart the agent and generate a snapshot again. This time, it run normally. So far, I got this error twice since the replication launched. Kindly advise. Thanks a lot.
View Replies !
&&"Attempted To Read Or Write Protected Memory Error&&" In SSIS
I'm trying to import data from a Sybase ASE 12.0 database called "OurTestDatabase" into MS SQL Server 2005. I started SSIS Wizard and indicated "Sybase ASE OLEDB Provider" as a source and SQL Native Client as the target. I'm gettign the following error message: ----------------------------------------------------------------------------------------------------------------- Cannot get supported data types from the database connection "Provider=Sybase.ASEOLDEDBProvider;Password=;Persist Security Info=True;User ID=sa;Data Source=sybase;Initial Catalog=OurTestDatabase" Additional information |_ Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (System.Data) ----------------------------------------------------------------------------------------------------------------- The same data source worked with DTS when we thought we'd convert to MS SQL Server 2000. Is this a bug in SSIS? What can be done? Using ".Net Framework Provider for ODBC" is not a good option because this doesn't allow me to choose any tables from the Sybase source. Any help is greatly appreciated.
View Replies !
Opening Table In Management Studio Is Very Slow
Dear Gurus When I open a large table (say more than 1,000,000 Rows) in the SSMS by right clicking on the table name, it takes a very big time to fully open the table.More than 20 minutes for 1,000,000 records on a local instance. SQL Server 2000 EM was extremely faster. Does any one knows a work around? I need to be able to view and edit the data in SSMS. Thanks in advance. Parviz
View Replies !
Problem Opening Sql Server Management Studio
Hi all, can anyone advise on a problem i am having. I have installed SQL Server Express but i am getting an error when i try to open up the management studio app. The DB seems to be fine as i can connect to this from another machine. The error i get says: The proper type library could not be found in the system registry. An attempt to repair this condition failed because you do not have the permissions to write to the system registry or because the type library cound not be loaded. This can be fixed by a system administrator running this program once, which will cause the proper file to be registered. If problems still persist, then try repairing this application from the setup program. I am running windows Vista x86. I have tried opening it as administrator and still no could, i have uninstalled it and re-installed it about 10 times and am getting pretty sick. Has anyone seen this one before ???? Thanks in advance Ian.
View Replies !
Problem Opening Reporting Services In SQL 2005 Management Studio
Please can you help me... I am unable to open reporting services on my SQL 2005 server. How can I open it?? It falls over with the following: TITLE: Connect to Server ------------------------------ Cannot connect to L00000001DEV1. ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title>Compilation Error</title> <style> body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px} H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red } H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon } pre {font-family:"Lucida Console";font-size: .9em} .marker {font-weight: bold; color: black;text-decoration: none;} .version {color: gray;} .error {margin-bottom: 10px;} .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; } </style> </head> <body bgcolor="white"> <span><H1>Server Error in '/ReportServer$ILDEV1' Application.<hr width=100% size=1 color=silver></H1> <h2> <i>Compilation Error</i> </h2></span> <font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif "> <b> Description: </b>An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. <br><br> <b> Compiler Error Message: </b>CS0016: Could not write to output file 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eportserver$ildev1575b41e7ef9faab0App_global.asax.eki-3joz.dll' -- 'Access is denied. '<br><br> <b>Source Error:</b><br><br> <table width=100% bgcolor="#ffffcc"> <tr><td> </td></tr> <tr> <td> <code><pre> [No relevant source lines]</pre></code> </td> </tr> </table> <br> <b>Source File:</b> <b>Line:</b> 0 <br><br> <br><div class="expandable" onclick="OnToggleTOCLevel1('compilerOutputDiv')">Show Detailed Compiler Output:</div> <div id="compilerOutputDiv" style="display: none;"> <br><table width=100% bgcolor="#ffffcc"> <tr> <td> <code><pre> c:windowssystem32inetsrv> "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727csc.exe" /t:library /utf8output /R:"C:WINDOWSassemblyGAC_32System.Web2.0.0.0__b03f5f7f11d50a3aSystem.Web.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem2.0.0.0__b77a5c561934e089System.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eportserver$ildev1575b41e7ef9faab0assemblydl3e595e3cb 025f0d5_c24cc701ReportingServicesWebServer.DLL" /out:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eportserver$ildev1575b41e7ef9faab0App_global.asax.eki-3joz.dll" /debug- /optimize+ /w:4 /nowarn:1659;1699 "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eportserver$ildev1575b41e7ef9faab0App_global.asax.eki-3joz.0.cs" "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eportserver$ildev1575b41e7ef9faab0App_global.asax.eki-3joz.1.cs" Microsoft (R) Visual C# 2005 Compiler version 8.00.50727.42 for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727 Copyright (C) Microsoft Corporation 2001-2005. All rights reserved. error CS0016: Could not write to output file 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eportserver$ildev1575b41e7ef9faab0App_global.asax.eki-3joz.dll' -- 'Access is denied. ' </pre></code> </td> </tr> </table> </div> <script type="text/javascript"> function OnToggleTOCLevel1(level2ID) { var elemLevel2 = document.getElementById(level2ID); if (elemLevel2.style.display == 'none') { elemLevel2.style.display = ''; } else { elemLevel2.style.display = 'none'; } } </script> <br><br> <hr width=100% size=1 color=silver> <b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832 </font> </body> </html> <!-- [HttpCompileException]: (0): error CS0016: Could not write to output file 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eportserver$ildev1575b41e7ef9faab0App_global.asax.eki-3joz.dll' -- 'Access is denied. ' at System.Web.Compilation.AssemblyBuilder.Compile() at System.Web.Compilation.BuildProvidersCompiler.PerformBuild() at System.Web.Compilation.ApplicationBuildProvider.GetGlobalAsaxBuildResult(Boolean isPrecompiledApp) at System.Web.Compilation.BuildManager.CompileGlobalAsax() at System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() at System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) [HttpException]: (0): error CS0016: Could not write to output file 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eportserver$ildev1575b41e7ef9faab0App_global.asax.eki-3joz.dll' -- 'Access is denied. ' at System.Web.HttpRuntime.FirstRequestInit(HttpContext context) at System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) --> --. (Microsoft.SqlServer.Management.UI.RSClient) ------------------------------ BUTTONS: OK ------------------------------
View Replies !
Visual Studio/BIDS Out Of Memory Errors Opening Large DTSX Files
I'm currently experiencing major problems with SSIS when opening and editing large .DTSX package files that contain Exec DTS 2000 Tasks which have the package data loaded internally. I have no issues if I point the task to a .DTS file, or to an actual DTS package on a SQL 2000 server - but if I load the package internally then once the underlying .DTSX file gets over around 17MB or so in size (which doesnt take long making a few edits to even fairly simple packages now and then), I start to experience major issues with VS/BIDS 2005 crashing randomly when I try to perform any action with the package (open, save etc). Things like OutOfMemory exception errors, followed by the properties of Exec DTS 2000 task being deleted, and also sometimes accompanied by messages about the application not being installed properly. Again its ONLY when the underlying .DTSX file reaches a certain size limit, and only when I've got an Exec DTS 2000 task with the package loaded internally. I've replicated the issue using several different package files on several different machines (even on servers with lots of memory, fwiw). Can anyone out there help me with this? SSIS - namely SSIS Exec DTS 2000 package tasks - are our lifeblood at my company and this trend of random and serious crashing on large package files is very disturbing to say the least. thanks, Wil
View Replies !
Microsoft SQL Server 2005 Management Studio - Opening SQL-File From Explorer Does Not Connect Automaticly To Server/database
hello, I have a question about opening files in the Microsoft SQL Server 2005 Management Studio. In the old Query Analyzer from SQL 2000 I can open SQL Files via drag & drop (from explorer to QA) or open it with a double click in the explorer. Then the Files opened, if I had actual a connection to a server / database (QA is stared with one file and has a connection to Server/Datebase), with this connection. Now in Microsoft SQL Server 2005 Management Studio I'll be asked everytime for Server and have to get the database from the database list - it does not connect automaticly to server/database, that is actual connected (I have opened a file with the connection and a connected database in the object explorer). Someone do not have this problem - but we found no option to set it up. Any ideas? thanks & best regards, Christian Kiedels
View Replies !
Management Studio Error
When executing export data task and through the wizard to include column names within a flat file desitination and get the following error listed below. If you uncheck the box and don't include the column names it works correctly. Error - Pre-execute (Error) Messages Information 0x402090dc: Data Flow Task: The processing of file "C:Documents and Settings*Desktop est_2.txt" has started. (SQL Server Import and Export Wizard) Error 0xc0202095: Data Flow Task: Failed to write out column name for column "ClientSubGroupID". (SQL Server Import and Export Wizard) Error 0xc004701a: Data Flow Task: component "Destination - test_2_txt" (22) failed the pre-execute phase and returned error code 0xC0202095. (SQL Server Import and Export Wizard)
View Replies !
Error Connecting In Management Studio
Hello, I am having problems connecting to my SQL Server instance with Management Studio; basically the setup is as follows; *Single server running windows 2003 enterprise - in a workgroup not domain *SQL Server is installed on this machine *When I try and connect from the same machine using its own IP address and Windows authentication I get the 18452 error "login failed for {NULL} user" I am testing it like this because Sharepoint is failing in configuration wizard because it is connecting the same way - at least the login failure audit logs say the same. Many thanks for answers
View Replies !
Error When Trying To Start Management Studio
Hello Guys, I am getting the following error when I try to start SQL 2005 Management Studio to manage my SQL Server : Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). Any ideas ? Thanks,
View Replies !
Installation Error On Management Studio Express
Hi, I'm still getting error 2908 while installing the SQL Server Management Studio Express. The file downloads, I run it and it goes through the setup wizard. It gets almost all the way through the installation and then gets this error. The complete message is 'The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2908. The install then rolls back. Any suggestions? Product: Microsoft SQL Server Management Studio Express -- The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2908. The arguments are: {2AC4F9E9-0BFA-4CAC-BA2E-D089C63637F5}, , Product: Microsoft SQL Server Management Studio Express -- Error 1935. An error occurred during the installation of assembly 'Microsoft.ReportViewer.WebForms,Version="8.0.0.0",Culture="neutral",PublicKeyToken="b03f5f7f11d50a3a",FileVersion="8.0.50727.42",ProcessorArchitecture="MSIL"'. Please refer to Help and Support for more information. HRESULT: 0x8002802F. assembly interface: , function: CreateAssemblyNameObject, component: {B68B643F-A989-4510-9D98-0B2385E85ADF}
View Replies !
Installation Error On Management Studio Express
Hi, I'm getting error 2908 while installing the SQL Server Management Studio Express. The file downloads, I run it and it goes through the setup wizard. It gets almost all the way through the installation and then gets this error. The complete message is 'The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2908. The install then rolls back. Any suggestions? Here's the errors that are getting generated in the application log Product: Microsoft SQL Server Management Studio Express -- Error 1935. An error occurred during the installation of assembly 'Microsoft.ReportViewer.WebForms,Version="8.0.0.0",Culture="neutral",PublicKeyToken="b03f5f7f11d50a3a",FileVersion="8.0.50727.42",ProcessorArchitecture="MSIL"'. Please refer to Help and Support for more information. HRESULT: 0x8002802F. assembly interface: , function: CreateAssemblyNameObject, component: {B68B643F-A989-4510-9D98-0B2385E85ADF} Product: Microsoft SQL Server Management Studio Express -- The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2908. The arguments are: {2AC4F9E9-0BFA-4CAC-BA2E-D089C63637F5}, ,
View Replies !
Error Connecting To Express Using Sql Management Studio
Hi, The issue, I have had SQL express installed and working ok, however, I can no longer connect OS: XP sp2.0 .net installed ver1.1 .. 2.0 sp1, 3.0sp1 and 3.5 The install of SQL was using the SQLEXR_adv download I have removed SQL and all associated applications folders and windows SQL services I have re-installed many times but always receive the same issue. I re-built the .net 2.0 The issue I have is when I try and connect form my applications or with Express sql management studio I receive the following error: It looks like a .net2.0 issue TITLE: Connect to Server ------------------------------ Cannot connect to RNASHLTOPSQLEXPRESS. ------------------------------ ADDITIONAL INFORMATION: The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception. (System.Data) ------------------------------ The type initializer for 'System.Data.SqlClient.SqlConnectionFactory' threw an exception. (System.Data) ------------------------------ The type initializer for 'System.Data.SqlClient.SqlPerformanceCounters' threw an exception. (System.Data) ------------------------------ Configuration system failed to initialize (System.Configuration) ------------------------------ Unrecognized configuration section system.serviceModel. (C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Configmachine.config line 136) (System.Configuration) ------------------------------ BUTTONS: OK ------------------------------
View Replies !
SQL Server Management Studio Express Error
I'm trying to run the disk usage reports from the SQL Server Management Studio and I'm getting an error. I right-click on a database, go to Reports, then Standard Reports and select Disk Usage by Table. I get the error below. Can anyone help? =================================== Object reference not set to an instance of an object. (System.Xml) ------------------------------ Program Location: at System.Xml.XmlReader.CalcBufferSize(Stream input) at System.Xml.XmlTextReaderImpl.InitStreamInput(Uri baseUri, String baseUriStr, Stream stream, Byte[] bytes, Int32 byteCount, Encoding encoding) at System.Xml.XmlTextReaderImpl..ctor(String url, Stream input, XmlNameTable nt) at System.Xml.XmlDocument.Load(Stream inStream) at Microsoft.SqlServer.Management.Reports.StandardReport.LoadRdlDocument() at Microsoft.SqlServer.Management.Reports.Report.LoadReportQueriesFromRdl() at Microsoft.SqlServer.Management.Reports.StandardReportFactory.GetReport(ReportInfo reportInfo, ReportContext context) at Microsoft.SqlServer.Management.Reports.ReportsManager.GetReport(ReportInfo reportInfo, ReportContext context) at Microsoft.SqlServer.Management.Reports.ReportsManager.ShowReport(ReportInfo reportInfo)
View Replies !
Get Timeout Error With TableAdapter But Not With SQL Server Management Studio
I have found a similar problem in Google but that thread doesn't have any conclusion. So that I wish a new thread can help solve this problem ultimately.http://forums.asp.net/rss.aspx?ForumID=54&PostID=1600414Problem description:TableAdapter will raise timeout exception when I try to execute a SQL containing subquery and grouping. However, if the same SQL is executed in SQL Server Management Studio. The response time is always less than 1 second.Solution provided in previous link:Increase the timeout setting of the command - I think this is not the solution. As the default timeout should be 15 seconds, how could it get a timeout error if it execute a SQL supposed to be finished within a second?I have encountered similar problem before. However, I can't remember the exact detail. My solution for that moment seems to be using join instead of subquery in the SQL. Unluckily, this trick does not work this time.Please provide any other suggestion. Thanks in advance.
View Replies !
Management Studio Error On Program/object Load...
I've just installed .NET 2.0, VS 2005, and SQL 2005 Developer (Win XP SP2). When launching Management Studio I'm receving the following error. Any insight would be greatly appreciated.It may also be important to note that I also have VS 2003 and SQL 2000 Developer on this machine as well, not sure if it matters or not.=================================== Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.OLE.Interop.IServiceProvider'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{6D5140C1-7436-11CE-8034-00AA006009FA}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). (Microsoft.VisualStudio.OLE.Interop) ------------------------------Program Location: at Microsoft.VisualStudio.OLE.Interop.IServiceProvider.QueryService(Guid& guidService, Guid& riid, IntPtr& ppvObject) at Microsoft.SqlServer.Management.UI.VSIntegration.ServiceProvider.GetService(Guid guid, Type serviceType) at Microsoft.SqlServer.Management.UI.VSIntegration.ServiceProvider.GetService(Type serviceType) at Microsoft.SqlServer.Management.UI.VSIntegration.ShellWindowPaneUserControl.GetService(Type svcClass) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.System.IServiceProvider.GetService(Type serviceType) at System.ComponentModel.Design.ServiceContainer.GetService(Type serviceType) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetService(Type serviceType) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext.GetService(Type serviceType) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery, Boolean registerBuilder, Boolean registerBuiltItems) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(INodeInformation source, INavigableItem sourceItem, IFilterProvider filter) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren() at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren()
View Replies !
Error Running SSIS Package From Management Studio
Hi I created SSIS Package to transfer tables from one sql2005 DB to another sql2005 DB. When I execute the package from the BIDS it execute succesfully. However, when I import the package (file system) to the management studio - msdb - stored packages and run the package from there (right click: Run Package) I get this error: the validate method on the task failed, and returned error code. the validate method must succeed and indicate the result using an out parameter. what is the reason for this error? I aprriciate your help. SeoAndSo.com
View Replies !
Error Importing SSIS Packages On SQL Management Studio
I encounter this error when importing SSIS packages using SQL Server Management Studio: =================================== Unable to cast object of type 'Microsoft.SqlServer.Dts.ObjectExplorerUI.ImportPackageAsAction' to type 'Microsoft.SqlServer.Dts.ObjectExplorerUI.ISimpleAction'. (Microsoft.SqlServer.DtsObjectExplorerUI) ------------------------------ Program Location: at Microsoft.SqlServer.Dts.ObjectExplorerUI.DtsServerMenuItem.Invoke(INodeInformation parent, String mode, String assembly, String type) The Integration Services that I'm using has just been rebuilt due to problems after installing SP2. I'm using Integration Services 9.0.3042. I can't find anything having this same problem. Any help will be appreciated. Thanks!
View Replies !
Security Error When Execute Sp From An Application, But Not From SQL Management Studio.
Hello, I am facing a very odd behavior with SQL server 2005. I have a database role with specific permissions to execute only some of the stored procedures in the database. I also have a SQL login/user attached to the role. If I execute one of the stored procedures from the application (web application, with Microsoft enterprise library database block) I am getting a security error stating that I need select permission for the schema. However, If I execute the same sp with the same parameters from SQL management studio, connecting with the same SQL login as in the application I can execute the sp without any security errors. The SQL management studio is in on a different server than the targeted database. Are there any differences between executing stored procedures from SQL MS and from application when using the same SQL login? Thanks, IT
View Replies !
Error Trying To Connect To Reporting Services Using SQL Management Studio
Hi. I have some strange error trying to connect to Reporting Services. At the beginning I was suspecting some accounts issues. But after checking all the accounts under wich ASP.NET, SQL SERVER, Reporting Services are running I don't even know what to think. After searching internet for answers the only similar problems' solutions were remove RS and install it again. Have anybody here had this problem? Can you just fix something without reinstalling RS? The error is: Object reference not set to an instance of an object ------------------------------ Program Location: at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods() at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname) at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection() at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString) at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject() at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci) at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci) at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectorThread()
View Replies !
Error Installation SQL Server Management Studio 2005
Could anyone please help me out. I have tried to install the file SQLServer2005_SSMSEE.msi. Everything goes fine untill right at the end I get this error message: An error occured during the installation of assembly 'Microsoft.VisualStudio.VSHelp80,Version="8.0.0.0",Culture="neutral",PublicKeyToken="b03f5f7f11d50a3a", FileVersion="8.0.50727.42". Please refer to Help and Support for more information. HRESULT: 0x80070020. Then the installation is rolled back. Thanks for your help in advance. Paik
View Replies !
Error Installing SQL Server Management Studio Express
Yesterday I successfully installed Microsoft Visual Basic 2005 Express Edition which included SQL Server 2005 Express. Today I noticed I needed to download the Management Studio seperate download. I downloaded SQLServer2005_SSMSEE.msi and executed it and get the following error: Error reading from file C:...SQLServer2005_SSMSEE.msi. Verify that the file exists and that you can access it.. Solved my own problem. Once I moved the msi to C: the installation worked. Apparently the path it was in was too long causing it to be unreadable. c:xxxxxxxxSQLServer2005_SSMSEE.msiSQLServer2005_SSMSEE.msi.
View Replies !
Attach Error In Sql Server Express Management Studio
tried to attach a database in sse-ms, and for some reason the database name is changing to G:someFoldersomeFolderdb.mdf, even tho i dont have a drive g:, during "attach as" screens inside sse-ms, , ie attach>add> then select the database the mdf loction is what it is suppose to be ie C:inetpubwwwrootapp_datachp11wroxunited.mdf but the database name in the same screen shot is G:someOtherFolderAndPathwroxunited.mdf and the attach as is also the G:someOtherFolderAndPathwroxunited.mdf. pretty confused, could use a clue, thanks
View Replies !
SqlWb.exe : Application Error- Memory Could Not Be &&"read&&" Error
Hi, I am trying to execute a SSIS package from a client through BIDS, but when I start BIDS, I am getting the error - SqlWb.exe : Application error - The instruction at "0X77D...." referenced memory at "0X00000002". The memory could bot be "read". Click on OK to terminate the program. Click on CANCEL to terminate the program. Please help. Other information: I have tried running the package on the server and it executes properly. I really dont know why this is a problem with the SQL Server clients alone. I have also tried googling around and could not find any resolution. Can anyone point me to the right direction please!!! Thanks in advance!!!
View Replies !
'Too Many Characters' Error In Sql String - Working In SQL Management Studio But Not In Code Behind???
Hello i constructed the following query in SQL management studio and it runs fine, exactly how i want it to. However when i run it in my code behind i get the error: 'Too many characters in character literal' I desperatly need to use this query exactly how it displays in the mangement tool - why wont it work the same in my code behind? (I am using c# in my code behind and binding the results of the query to a gridview) Regards "SELECT DISTINCT (dbo.AuthorList(publicationID))+ ';' + ISNULL(' Editor: '+Publication.editor, '')+ '' + ISNULL(' "'+Publication.title+'"', '')+ '' + ISNULL(' Book: "'+Publication.booktitle+'"', '')+ '' + ISNULL(' '+Publication.type, '')+ '' + ISNULL(' '+Publication.journal, '')+ '' + ISNULL(' Series: '+Publication.series+'.', '')+ '' + ISNULL(' '+Publication.school, '')+ '' + ISNULL(' '+Publication.institution, '')+ '' + ISNULL(' '+Publication.organisation, '')+ '' + ISNULL(' '+Publication.month, '')+ '' + ISNULL(' ('+convert(nvarchar, Publication.year)+')', '')+ '' + ISNULL(' '+Publication.publisher, '')+ '' + ISNULL(' '+Publication.address+'.', '')+ '' + ISNULL(' '+Publication.howpublished, '')+ '' + ISNULL(' Ed: '+convert(nvarchar, Publication.edition)+'.', '')+ '' + ISNULL(' '+Publication.note, '')+ '' + ISNULL(' Vol:'+Publication.volume+'.', '')+ '' + ISNULL(' No:'+Publication.number+'.', '')+ '' + ISNULL(' Pages:'+Publication.pages+'.', '')+ '' + ISNULL(' Chapter:'+Publication.chapter+'.', '') AS SingleColumn, Publication.publicationID FROM Publication;"
View Replies !
SSIS Error Message When Trying To Open MSDB In Management Studio
Hi all, I get this error when trying to open folder MSDB in management studio. I'm running Win 2003, SQL server 2005 64 bit on AMD with two instances of SQL. Any one that have a solution ? I havent found any thing that works. If I enable VIA in SQL Server I can't start SQL Service TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: Login timeout expired 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. VIA Provider: The specified module could not be found. (Microsoft SQL Native Client) ------------------------------ Login timeout expired 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. VIA Provider: The specified module could not be found. (Microsoft SQL Native Client)
View Replies !
Cannot Install Workstation Components (Management Studio,etc) (ADD_LOCAL Error)
I have Vista Ultimate (IIS Enabled), SQL Server 2005 Developer Edition (downloaded and ran the SP2 Update), Visual Studio 2008. VS2008 installs no problem. When I install SQL Server 2005, I get an error when it trys to install the last part( Workstation Components, Management Studio, etc). I have tried FULLY, MANUALLY removing all SQL products and registry entries. I have used Windows Installer Cleanup Utility. I have tried Microsoft's recommended way of manually removing SQL Server 2005. If I manually run SqlRun_Tools.msi the error comes up right away. The error is: "A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the template.ini and set the UPGRADE property to the name of the component." Here's the Setup Error log: http://toby.pastebin.com/f63405e24 Any help?! Thanks! -Toby
View Replies !
.Net Framework Error Message When Starting SQL 2005 Management Studio
Has anyone ever recieved an error when starting the Management Studio? "Unhandled excpetion has occurred in a component in your application. "Input String was not in a correct format" I click continue and I can still use the manager;however, it gets annoying. The details of the error are very long and too much to add to this thread. Any ideas?
View Replies !
Database Connection Error In SQL Server Management Studio Express
Hello, We are trying to connect the data base in SQL Server Management Studio Express using Operating System Xp. The following error show during the connection time. " Cannot open database "Test" requested by the login. The login failed. Login failed for user 'NT AUTHORITYSYSTEM'. We have the login Id for sa and password. Connect to server it work properly. Could you please give me the steps to resolve the problem. Thanks, Mahesh
View Replies !
Management Studio Disconnects With Error Msg 0, Level 11, State 0, Line 0
I am trying to run the following: select * from sysindexes The operation begins and results are produced but after about 200 results, I get the error - Msg 0, Level 11, State 0, Line 0 - and it disconnects. This is a DB moved (restored) from SQL 2000 to SQL 2005. Any ideas would be appreciated. I am the "make do" DBA and not very good at it yet, I am afraid. Regards, Mike
View Replies !
Error In Microsoft Sql Server Management Studio Trying To Modify Tables Or Columns
I get the error below when trying to modify a table or colum with MSSMS. I can expad out the tree and look at the columns, but I can't change them, view the data in them, or create new ones. __________________________________________________________________________________________________________________________________ TITLE: Microsoft SQL Server Management Studio ------------------------------ Class does not support aggregation (or class object is remote) (Exception from HRESULT: 0x80040110 (CLASS_E_NOAGGREGATION)) (Microsoft.SqlServer.SqlTools.VSIntegration) I resintallelled .NET Framework, recommended from another post. I am using .NET 3.5 BETA Frame work, ans SQL Server 2005 V 9.00.139.00
View Replies !
Reporting Services 2005 And SQL Server Management Studio Connection Error
I have installed multiple instances of SSRS on same server with different database. I can go to the report server URL for both SSRS and run reports. But I cannot connect to the 2nd instance through "SQL Server Management Studio". Also I am getting following error when I try to connect to the "Reporting services configuration" tool from a remote machine Code Block See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.Management.ManagementException: Not found at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode) at System.Management.PropertyData.RefreshPropertyInfo() at System.Management.PropertyDataCollection.get_Item(String propertyName) at System.Management.ManagementBaseObject.GetPropertyValue(String propertyName) at System.Management.ManagementBaseObject.get_Item(String propertyName) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.get_IsSharePointIntegrated() at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus() at ReportServicesConfigUI.ConfigurationManager.ChangeMachine() at ReportServicesConfigUI.ConfigurationManager.LaunchDialog() at ReportServicesConfigUI.ConfigurationManager.OnActivated(EventArgs e) at System.Windows.Forms.Form.set_Active(Boolean value) at System.Windows.Forms.Form.WmActivate(Message& m) at System.Windows.Forms.Form.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) ************** Loaded Assemblies ************** mscorlib Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.832 (QFE.050727-8300) CodeBase: file:///C:/WINNT/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll ---------------------------------------- RSConfigTool Assembly Version: 9.0.242.0 Win32 Version: 9.00.3042.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/RSConfigTool.exe ---------------------------------------- System.Windows.Forms Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.832 (QFE.050727-8300) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- System Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.832 (QFE.050727-8300) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- System.Drawing Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.832 (QFE.050727-8300) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll ---------------------------------------- System.Xml Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.832 (QFE.050727-8300) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll ---------------------------------------- System.Management Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.832 (QFE.050727-8300) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll ---------------------------------------- System.ServiceProcess Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll ---------------------------------------- ************** JIT Debugging ************** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box.
View Replies !
Error Installing SQL Server Management Studio Express On Windows Vista RC1
Hello NG, After installing SQL Server 2005 Express Edition on Windows Vista RC1, I wanted to install also the Managent Studio but I always receive the following error message: "Bei der Installation dieses Pakets ist ein unerwarteter Fehler aufgetreten. Es liegt eventuell ein das Paket betreffendes Problem vor. Der Fehlercode ist 29506." Where can I find more infos about this error-code? Anybody knows this problem? Thank in advance for every help.
View Replies !
SQL Server Error Message - Operating System Error 10038: An Operation Was Attempted On Something That Is Not A Socket...
My apologies...I wasn't for sure where to post an error like this... Over the last 2 months I have gotten this SQL Server error (twice). All existing processes will continue to work, however no new processes can be created and users cannot connect to the server. This is the exact text of the message in the SQL Server error log. Operating system error 10038: An operation was attempted on something that is not a socket... Error: 17059, Severity: 18, State: 0 Error accepting connection request via Net-Library 'SSNETLIB'. Execution continuing. Error: 17882, Severity: 18, State: While we can typically just stop SQL Server Service and restart the services...I have found it is best to restart the machine during non-production times to take care of any 'residual' effects of this error. The SQL Server 2000 SP4 box with Windows 2003 Standard SP1 is well maintained by our I.T. team and it typically will run 4 or 5 months without a reboot. Thank you... ...cordell...
View Replies !
Cannot Connect To SQL Report Server Through Web As Well As Management Studio (Http:503 Error Service Unavailable.)
hi all, i have SQL 2205 with SP1 installed on my machine. and i m not bale to connect to Report Server using SQL management studio as well as from web. i have installed reporting server and database on same machine. i tried using "http://localhost/reportserver" "http://localhost/reports" "http://localhost/reportmanager" but i am not bale to connect i am getting "Service Unavailable" page. and when i try to connect using SQL Management Studio with "servername/instance" as well as "http://localhost/reportserver" i am getting a error saying. =================================== Cannot connect to http://localhost/reportserver.The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient) =================================== but if i try and connect to other reporting server on other machine using web http://servername/reportserver i m able to connect it. but dont know whats the problem on my machine. do i need to start any services for this... so anybody knows how to troubleshoot this issue. Thanks in advance...
View Replies !
DTSRun Causes The Memory Could Not Be &"read&" Application Error
Hi,I've got this dts package in sql server 2000 sp4 that has severaltransformation tasks with an oracle database (10g) as the destination.The package executes successfully when run through the dts designer butwhen run using dtsrun, I get the following error at the completion ofall tasks in the dts package. The data inserts into the oracle databasebut i always get this Application errorThe Instruction at "0x7c8327f9" referenced memory at "Oxffffffff". Thememory could not be "read"Does anyone know how I can fix this?ThanksLyn
View Replies !
SQL Server Management Studio Express On Vista Home Premium (Error On Attaching And Detaching .mdf)
I have SQL Express 2005 SP2 installed in my Vista Home Premium. I am using SQL Server Management Studio Express to manage .mdf. When I click "Add..." to attach .mdf database, I have this prompt error message : The server principal "My-PCMyName" is not able to access the database "model" under the current security context. (Microsoft SQL Server, Error: 916) I have elevated the rights, "Run as administrator", of my SQL Server Management Studio Express, but still having problem. I also encounter security error when detaching the existing .mdf : The EXECUTE permission was denied on the object 'sp_detach_db', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229) Please advice. Thanks.
View Replies !
SQL Server Management Express Studio Management Tools
I have recently installed the SQL Server Management Studio Express but I do not find Management Tools in order to create scheduled backups and shrinking of the databases. I was under the impression that this should be included in the Management Studio. I use the SQL 2005 Express for smaller customers who run the SQL on a desktop unit. I need a way to backup the data to a server machine for backup purposes. I have uninstalled and reinstalled to no avail.
View Replies !
Visual Studio Database File And SQL Server Management Studio Express Question
I have a database in my "App_Data" folder of my visual studio project. I can view it fine in Visual Studio's built-in tools for managing a database attached to a solution. However i recently started playing around with the SQL Server Management Studio Express program. When i attach my database to Management Studio, and try to run my program it crashes. I think it might be a permissions error?!? When i detatch it and reattach it in visual studio it runs fine again. Any suggestions? ThanksJason
View Replies !
Error Message On Attempted Duplicate Insert
Hi All, I have a web form that inserts information into two tables in sql 2005 database on a submit button click. I have a unique key on the tables preventing duplicate information which works fine. The problem I have is that at the minute if a users tries to insert a duplicate row they just get the built in sql error message. Is there a way I can validate the information before if goes into the database and display perhaps a label telling the user of their error or is there a way I can customize the build in sql error message? I've had a search on various forums and sites and can't find any info that would help me. Thanks in advance Dave
View Replies !
Error: Process ID Attempted To Unlock A Resource It Does Not Own
we are using sql server 2005 standard edition with sp1 From last couple of days, I am getting lot of these errors- Process 304 unlocking unowned resource: OBJECT: 2:792809934:0 Process ID 304 attempted to unlock a resource it does not own: OBJECT: 2:792809934:0 . Retry the transaction, because this error may be caused by a timing condition. If the problem persists, contact the database administrator. A user request from the session with SPID 304 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory. SqlDumpExceptionHandler: Process 304 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. 2007-05-23 05:31:58.74 spid76 * ******************************************************************************* 2007-05-23 05:31:58.74 spid76 * 2007-05-23 05:31:58.74 spid76 * BEGIN STACK DUMP: 2007-05-23 05:31:58.74 spid76 * 05/23/07 05:31:58 spid 76 2007-05-23 05:31:58.74 spid76 * 2007-05-23 05:31:58.74 spid76 * 2007-05-23 05:31:58.74 spid76 * Exception Address = 00000000015F4502 Module(sqlservr+00000000005F4502) 2007-05-23 05:31:58.74 spid76 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION 2007-05-23 05:31:58.74 spid76 * Access Violation occurred reading address 0000000000000018 2007-05-23 05:31:58.74 spid76 * Input Buffer 68 bytes - 2007-05-23 05:31:58.74 spid76 * 16 00 00 00 12 00 00 00 02 00 00 00 00 00 00 00 00 00 2007-05-23 05:31:58.74 spid76 * S G L M e s 01 00 00 00 15 00 53 00 47 00 4c 00 4d 00 65 00 73 00 2007-05-23 05:31:58.74 spid76 * s a g e Q u e u e 73 00 61 00 67 00 65 00 51 00 75 00 65 00 75 00 65 00 2007-05-23 05:31:58.74 spid76 * S e l e c t 53 00 65 00 6c 00 65 00 63 00 74 00 00 00 2007-05-23 05:31:58.74 spid76 * 2007-05-23 05:31:58.74 spid76 * 2007-05-23 05:31:58.74 spid76 * MODULE BASE END SIZE 2007-05-23 05:31:58.74 spid76 * sqlservr 0000000001000000 00000000035FBFFF 025fc000 2007-05-23 05:31:58.74 spid76 * ntdll 0000000078EC0000 0000000078FF8FFF 00139000 2007-05-23 05:31:58.74 spid76 * kernel32 0000000078D40000 0000000078EB1FFF 00172000 2007-05-23 05:31:58.74 spid76 * MSVCR80 0000000078130000 00000000781FEFFF 000cf000 2007-05-23 05:31:58.74 spid76 * msvcrt 000007FF7FC00000 000007FF7FC85FFF 00086000 2007-05-23 05:31:58.74 spid76 * MSVCP80 000000007C420000 000000007C530FFF 00111000 2007-05-23 05:31:58.74 spid76 * ADVAPI32 000007FF7FEE0000 000007FF7FFE4FFF 00105000 2007-05-23 05:31:58.74 spid76 * RPCRT4 000007FF7FD30000 000007FF7FED8FFF 001a9000 2007-05-23 05:31:58.74 spid76 * USER32 0000000078C30000 0000000078D3BFFF 0010c000 2007-05-23 05:31:58.74 spid76 * GDI32 000007FF7FC90000 000007FF7FD28FFF 00099000 2007-05-23 05:31:58.74 spid76 * CRYPT32 000007FF7D180000 000007FF7D2DEFFF 0015f000 2007-05-23 05:31:58.74 spid76 * MSASN1 000007FF7D150000 000007FF7D179FFF 0002a000 2007-05-23 05:31:58.74 spid76 * Secur32 000007FF7E7F0000 000007FF7E811FFF 00022000 2007-05-23 05:31:58.74 spid76 * MSWSOCK 000007FF76FE0000 000007FF7705BFFF 0007c000 2007-05-23 05:31:58.74 spid76 * WS2_32 000007FF77150000 000007FF7717FFFF 00030000 2007-05-23 05:31:58.74 spid76 * WS2HELP 000007FF77140000 000007FF7714BFFF 0000c000 2007-05-23 05:31:58.74 spid76 * USERENV 000007FF7C4A0000 000007FF7C5A8FFF 00109000 2007-05-23 05:31:58.74 spid76 * opends60 00000000333E0000 00000000333E7FFF 00008000 2007-05-23 05:31:58.74 spid76 * NETAPI32 000007FF771B0000 000007FF77247FFF 00098000 2007-05-23 05:31:58.74 spid76 * SHELL32 000007FF7F190000 000007FF7FB97FFF 00a08000 2007-05-23 05:31:58.74 spid76 * SHLWAPI 000007FF7EF60000 000007FF7EFFAFFF 0009b000 2007-05-23 05:31:58.74 spid76 * comctl32 0000000000AF0000 0000000000C76FFF 00187000 2007-05-23 05:31:58.74 spid76 * psapi 000007FF7E1B0000 000007FF7E1BFFFF 00010000 2007-05-23 05:31:58.74 spid76 * instapi 0000000048060000 000000004806CFFF 0000d000 2007-05-23 05:31:58.74 spid76 * CLUSAPI 000007FF7B1C0000 000007FF7B1E3FFF 00024000 2007-05-23 05:31:58.74 spid76 * ole32 000007FF7ECE0000 000007FF7EF51FFF 00272000 2007-05-23 05:31:58.74 spid76 * OLEAUT32 000007FF7E9F0000 000007FF7EB03FFF 00114000 2007-05-23 05:31:58.74 spid76 * RESUTILS 000007FF7B310000 000007FF7B32BFFF 0001c000 2007-05-23 05:31:58.74 spid76 * sqlevn70 000000004F610000 000000004F7A3FFF 00194000 2007-05-23 05:31:58.74 spid76 * SQLOS 00000000344D0000 00000000344D5FFF 00006000 2007-05-23 05:31:58.74 spid76 * NTMARTA 000007FF7E2F0000 000007FF7E32BFFF 0003c000 2007-05-23 05:31:58.74 spid76 * SAMLIB 000007FF76F80000 000007FF76F95FFF 00016000 2007-05-23 05:31:58.74 spid76 * WLDAP32 000007FF7E780000 000007FF7E7E5FFF 00066000 2007-05-23 05:31:58.74 spid76 * rsaenh 000000000FFB0000 000000000FFEDFFF 0003e000 2007-05-23 05:31:58.74 spid76 * AUTHZ 000007FF7E2C0000 000007FF7E2ECFFF 0002d000 2007-05-23 05:31:58.74 spid76 * MSCOREE 000006427EE60000 000006427EED3FFF 00074000 2007-05-23 05:31:58.75 spid76 * msv1_0 000007FF7E330000 000007FF7E373FFF 00044000 2007-05-23 05:31:58.75 spid76 * iphlpapi 000007FF57250000 000007FF57280FFF 00031000 2007-05-23 05:31:58.75 spid76 * kerberos 000007FF77410000 000007FF774C2FFF 000b3000 2007-05-23 05:31:58.75 spid76 * cryptdll 000007FF7DAB0000 000007FF7DABEFFF 0000f000 2007-05-23 05:31:58.75 spid76 * schannel 000007FF7DB70000 000007FF7DBB0FFF 00041000 2007-05-23 05:31:58.75 spid76 * COMRES 000007FF7E920000 000007FF7E9E5FFF 000c6000 2007-05-23 05:31:58.75 spid76 * XOLEHLP 000007FF5C560000 000007FF5C566FFF 00007000 2007-05-23 05:31:58.75 spid76 * MSDTCPRX 000007FF67140000 000007FF67210FFF 000d1000 2007-05-23 05:31:58.75 spid76 * msvcp60 000000000AD30000 000000000AE19FFF 000ea000 2007-05-23 05:31:58.75 spid76 * MTXCLU 000007FF7B540000 000007FF7B569FFF 0002a000 2007-05-23 05:31:58.75 spid76 * VERSION 000007FF7FBF0000 000007FF7FBFAFFF 0000b000 2007-05-23 05:31:58.75 spid76 * WSOCK32 000007FF770F0000 000007FF770F9FFF 0000a000 2007-05-23 05:31:58.75 spid76 * DNSAPI 000007FF7E720000 000007FF7E76DFFF 0004e000 2007-05-23 05:31:58.75 spid76 * winrnr 000007FF7E820000 000007FF7E82AFFF 0000b000 2007-05-23 05:31:58.75 spid76 * rasadhlp 000007FF7E830000 000007FF7E836FFF 00007000 2007-05-23 05:31:58.75 spid76 * hnetcfg 000007FF6D1F0000 000007FF6D280FFF 00091000 2007-05-23 05:31:58.75 spid76 * wshtcpip 000007FF76FA0000 000007FF76FAAFFF 0000b000 2007-05-23 05:31:58.75 spid76 * security 000007FF77530000 000007FF77534FFF 00005000 2007-05-23 05:31:58.75 spid76 * msfte 0000000049980000 0000000049D2DFFF 003ae000 2007-05-23 05:31:58.75 spid76 * dbghelp 000000000D7F0000 000000000D949FFF 0015a000 2007-05-23 05:31:58.75 spid76 * WINTRUST 000007FF7E210000 000007FF7E25DFFF 0004e000 2007-05-23 05:31:58.75 spid76 * imagehlp 000007FF7E2A0000 000007FF7E2B2FFF 00013000 2007-05-23 05:31:58.75 spid76 * dssenh 000000000FF70000 000000000FFABFFF 0003c000 2007-05-23 05:31:58.75 spid76 * ntdsapi 000007FF7DAD0000 000007FF7DAF3FFF 00024000 2007-05-23 05:31:58.75 spid76 * xpsp2res 000007FF5C210000 000007FF5C4D6FFF 002c7000 2007-05-23 05:31:58.75 spid76 * CLBCatQ 0000000003600000 00000000036DDFFF 000de000 2007-05-23 05:31:58.75 spid76 * sqlncli 00000000337A0000 0000000033A5DFFF 002be000 2007-05-23 05:31:58.75 spid76 * COMCTL32 0000000003700000 00000000037EDFFF 000ee000 2007-05-23 05:31:58.75 spid76 * comdlg32 000007FF7D360000 000007FF7D3D6FFF 00077000 2007-05-23 05:31:58.75 spid76 * SQLNCLIR 0000000035000000 0000000035032FFF 00033000 2007-05-23 05:31:58.75 spid76 * msftepxy 000000000F130000 000000000F150FFF 00021000 2007-05-23 05:31:58.75 spid76 * xpstar90 0000000053C30000 0000000053CB4FFF 00085000 2007-05-23 05:31:58.75 spid76 * SQLSCM90 0000000053AD0000 0000000053ADBFFF 0000c000 2007-05-23 05:31:58.75 spid76 * ODBC32 000007FF63EB0000 000007FF63F16FFF 00067000 2007-05-23 05:31:58.75 spid76 * BatchParser90 00000000520C0000 00000000520ECFFF 0002d000 2007-05-23 05:31:58.75 spid76 * ATL80 000000007C630000 000000007C64DFFF 0001e000 2007-05-23 05:31:58.75 spid76 * odbcint 000007FF63DC0000 000007FF63DD7FFF 00018000 2007-05-23 05:31:58.75 spid76 * xpstar90 0000000010CC0000 0000000010CE5FFF 00026000 2007-05-23 05:31:58.75 spid76 * msxmlsql 0000000078800000 0000000078963FFF 00164000 2007-05-23 05:31:58.75 spid76 * msxml3 000007FF78A20000 000007FF78C2DFFF 0020e000 2007-05-23 05:31:58.75 spid76 * xpsqlbot 000000004A7C0000 000000004A7C7FFF 00008000 2007-05-23 05:31:58.75 spid76 * xplog70 0000000034730000 000000003473FFFF 00010000 2007-05-23 05:31:58.75 spid76 * xplog70 00000000125B0000 00000000125B2FFF 00003000 2007-05-23 05:31:58.75 spid76 * 2007-05-23 05:31:58.75 spid76 * P1Home: FFFFFADEC275F600: 2007-05-23 05:31:58.75 spid76 * P2Home: 0000000017F4DEA0: FFFFFADEC275F600 0000000017F4DEA0 0000000000000000 0000000017F4E660 0000800000000000 FFFFFADEC275F940 2007-05-23 05:31:58.75 spid76 * P3Home: 0000000000000000: 2007-05-23 05:31:58.75 spid76 * P4Home: 0000000017F4E660: FFFFFFFF00000001 0000000000000000 0000000100ECCEA8 0000000100ECCF60 0000000000000000 00000000E226E9C0 2007-05-23 05:31:58.75 spid76 * P5Home: 0000800000000000: 2007-05-23 05:31:58.75 spid76 * P6Home: FFFFFADEC275F940: 2007-05-23 05:31:58.75 spid76 * ContextFlags: 000000000010001F: 2007-05-23 05:31:58.75 spid76 * MxCsr: 0000000000001FA0: 2007-05-23 05:31:58.75 spid76 * SegCs: 0000000000000033: 2007-05-23 05:31:58.75 spid76 * SegDs: 000000000000002B: 2007-05-23 05:31:58.75 spid76 * SegEs: 000000000000002B: 2007-05-23 05:31:58.75 spid76 * SegFs: 0000000000000053: 2007-05-23 05:31:58.75 spid76 * SegGs: 000000000000002B: 2007-05-23 05:31:58.75 spid76 * SegSs: 000000000000002B: 2007-05-23 05:31:58.75 spid76 * EFlags: 0000000000010202: 0065002E0064006D 0046000000650078 004F004E005F0050 0053004F0048005F 00480043005F0054 003D004B00430045 2007-05-23 05:31:58.75 spid76 * Rax: 0000000100ECCF60: 0000000000000000 0000000100ECCEA8 0000000000000000 0065006300630041 0000000000000000 0000000000000000 2007-05-23 05:31:58.75 spid76 * Rcx: 0000000000000000: 2007-05-23 05:31:58.75 spid76 * Rdx: 0000000000000000: 2007-05-23 05:31:58.75 spid76 * Rbx: 0000000000000000: 2007-05-23 05:31:58.75 spid76 * Rsp: 0000000017F4E440: 0000000001B30DC0 FFFFFFFFFF000000 0000000000000000 0000000078D6E31C 00000000D44421C0 00000000015E8750 2007-05-23 05:31:58.75 spid76 * Rbp: 0000000017F4E660: FFFFFFFF00000001 0000000000000000 0000000100ECCEA8 0000000100ECCF60 0000000000000000 00000000E226E9C0 2007-05-23 05:31:58.75 spid76 * Rsi: 0000000273C15900: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 2007-05-23 05:31:58.75 spid76 * Rdi: 0000000000000000: 2007-05-23 05:31:58.75 spid76 * R8: 00000000D44421C0: 0000000000000000 0000000000000000 00000000D039C1D0 00000000E892C1D0 0000000000000001 00000000038203A0 2007-05-23 05:31:58.75 spid76 * R9: 0000000000000000: 2007-05-23 05:31:58.75 spid76 * R10: 0000000001000000: 0000000300905A4D 0000FFFF00000004 00000000000000B8 0000000000000040 0000000000000000 0000000000000000 2007-05-23 05:31:58.75 spid76 * R11: 0000000017F4E5C8: 00000000015E5847 00000000063C8080 00000000063C8130 0000000192CED0F0 0000000001541382 FFFFFFFFFFFF0002 2007-05-23 05:31:58.75 spid76 * R12: 0000000017F4E608: 00000000063C4C58 0000000000000000 0000000000000000 00000000000002AA 0000000017F4E890 0000000100ECCE70 2007-05-23 05:31:58.75 spid76 * R13: 0000000000000001: 2007-05-23 05:31:58.75 spid76 * R14: 0000000000000000: 2007-05-23 05:31:58.75 spid76 * R15: 0000000000000000: 2007-05-23 05:31:58.75 spid76 * Rip: 00000000015F4502: 086F8B4C187A8B48 C1F6434FB60F2074 44004E814E850F02 0F04C1F660244C89 4C894C004E815985 30250C8B48657824 2007-05-23 05:31:58.75 spid76 * ******************************************************************************* 2007-05-23 05:31:58.75 spid76 * ------------------------------------------------------------------------------- 2007-05-23 05:31:58.75 spid76 * Short Stack Dump 2007-05-23 05:31:58.75 spid76 00000000015F4502 Module(sqlservr+00000000005F4502) 2007-05-23 05:31:58.75 spid76 00000000015E5847 Module(sqlservr+00000000005E5847) 2007-05-23 05:31:58.75 spid76 000000000158A7CE Module(sqlservr+000000000058A7CE) 2007-05-23 05:31:58.75 spid76 00000000024796E7 Module(sqlservr+00000000014796E7) 2007-05-23 05:31:58.75 spid76 000000000247A0E5 Module(sqlservr+000000000147A0E5) 2007-05-23 05:31:58.75 spid76 0000000001A2F32F Module(sqlservr+0000000000A2F32F) 2007-05-23 05:31:58.75 spid76 0000000001625988 Module(sqlservr+0000000000625988) 2007-05-23 05:31:58.75 spid76 0000000001736E0B Module(sqlservr+0000000000736E0B) 2007-05-23 05:31:58.75 spid76 000000000161BC5B Module(sqlservr+000000000061BC5B) 2007-05-23 05:31:58.75 spid76 00000000016126D1 Module(sqlservr+00000000006126D1) 2007-05-23 05:31:58.75 spid76 0000000001614BB6 Module(sqlservr+0000000000614BB6) 2007-05-23 05:31:58.75 spid76 000000000268C3CA Module(sqlservr+000000000168C3CA) 2007-05-23 05:31:58.75 spid76 000000000268DCB4 Module(sqlservr+000000000168DCB4) 2007-05-23 05:31:58.75 spid76 000000000161FC5E Module(sqlservr+000000000061FC5E) 2007-05-23 05:31:58.75 spid76 00000000015C80E8 Module(sqlservr+00000000005C80E8) 2007-05-23 05:31:58.75 spid76 00000000015CAD6D Module(sqlservr+00000000005CAD6D) 2007-05-23 05:31:58.75 spid76 00000000015E0232 Module(sqlservr+00000000005E0232) 2007-05-23 05:31:58.75 spid76 00000000015DE73E Module(sqlservr+00000000005DE73E) 2007-05-23 05:31:58.75 spid76 00000000015D66CE Module(sqlservr+00000000005D66CE) 2007-05-23 05:31:58.75 spid76 00000000015D7129 Module(sqlservr+00000000005D7129) 2007-05-23 05:31:58.75 spid76 00000000015CE674 Module(sqlservr+00000000005CE674) 2007-05-23 05:31:58.75 spid76 00000000014CE4C7 Module(sqlservr+00000000004CE4C7) 2007-05-23 05:31:58.75 spid76 00000000017A0B89 Module(sqlservr+00000000007A0B89) 2007-05-23 05:31:58.75 spid76 0000000001785C90 Module(sqlservr+0000000000785C90) 2007-05-23 05:31:58.75 spid76 00000000017D08F8 Module(sqlservr+00000000007D08F8) 2007-05-23 05:31:58.75 spid76 00000000781337A7 Module(MSVCR80+00000000000037A7) 2007-05-23 05:31:58.77 spid76 0000000078133864 Module(MSVCR80+0000000000003864) 2007-05-23 05:31:58.77 spid76 0000000078D6B66A Module(kernel32+000000000002B66A) Can anyone help me these errors? Why I am getting these errors ? And how do i resolve this issue? Thanks
View Replies !
Memory Management (fixed Memory, AWE)
Hi, I am going to install SQL Server 2000 (then SQL 2K5) on a Win Server 2K3 with 8 GB of ram, but it will be 16 GB in the near future. I would like to reserve a fixed memory (for momemt less than 3-4 GB) for SQL Server and the rest for application (virtualization). Without AWE enabled, max memory for SQL Server 2K5 is 4GB as for SQL Server 2000? How can I manage and optimize memory keeping in mind AWE. (any doc, website available?) Thank
View Replies !
|
TRACKER
