Debugging Database Errors With SQL Server Express
Apr 24, 2006
I am trying to debug a classic ASP application using Visual Web Developer Express and SQL Server Express editions. When my application tries to execute a stored procedure, I get the following error:
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available.
Is there a way for me to trace queries that are getting executed in SQL Server Express so I can see which stored procedure is failing? I seem to remember being able to do this with SQL Server 2000. Any other ideas on how to debug SQL Server errors like these using SQL Server Express?
TIA for the help.
Michael
View 1 Replies
ADVERTISEMENT
Jul 20, 2006
Hi All,
I am having a couple of problems with an SSIS package. The first is whenever I add a Data Viewer to one of my data flow tasks it crashes Visual Studio. This happens every single time. I have tried rebooting, but that didn't help. The second error I am getting is whenever I call ComponentMetaData.GetErrorDescription(Row.ErrorCode) from within a data flow script task it generates a "Catastrophic Failure" and indicates that it occurred when calling the GetErrorDescription method. I am not sure if something is corrupted or what the issue is. Does anyone have any insight?
Thanks,
Justin
View 3 Replies
View Related
Apr 23, 2006
I have a medical records system, SoapWare v4.90, that uses MSDE (SQL2000) databases. Due to the 2gb limitation, I am trying to migrate over to SQL 2005 (Standard or Express) which I have heard works fine. The SoapWare has a datamanager that allows me to log in to the MSDE instance, detach the SoapWare databases from msde (as well as do backups, etc) which I can confirm are detached.
Then I log back into a SQL2005 database instance using the datamanager and try to attach the database. This is what their pictured instructions demonstrate. However, I get the following error:
Database 'sw_charts' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.
Of course, some of the entries will be read only, since doctors have to sign off the charts and are not allowed to subsequently change them. But I should still be able to switch over to sql 2005?!?!?!?
Or... is there a way to attach the databases to SQLExpress manually?
Help pls?
View 1 Replies
View Related
Feb 13, 2008
Hi all,
I try to learn "How to Access Stored Procedures with ADO.NET 2.0 - VB 2005 Express: (1) Handling the Input and Output Parameters and (2) Reporting their Values in VB Forms". I found a good article "Calling Stored Procedures from ADO.NET" by John Paul Cook in http://www.dbzine.com/sql/sql-artices/cook6. I downloaded the source code into my VB 2005 Express:
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlTypes
Public Class Form_Cook
Inherits System.Windows.Form.Form
#Region " Windows Form Designer generated code "
Public Sub New()
MyBase.New()
'This call is required by the Windows Form Designer.
InitializeComponent()
'Add any initialization after the InitializeComponent() call
End Sub
'Form overrides dispose to clean up the component list.
Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
If disposing Then
If Not (components Is Nothing) Then
components.Dispose()
End If
End If
MyBase.Dispose(disposing)
End Sub
'Required by the Windows Form Designer
Private components As System.ComponentModel.IContainer
'NOTE: The following procedure is required by the Windows Form Designer
'It can be modified using the Windows Form Designer.
'Do not modify it using the code editor.
Friend WithEvents GroupBox1 As System.Windows.Forms.GroupBox
Friend WithEvents labelPAF As System.Windows.Forms.Label
Friend WithEvents labelNbrPrices As System.Windows.Forms.Label
Friend WithEvents UpdatePrices As System.Windows.Forms.Button
Friend WithEvents textBoxPAF As System.Windows.Forms.TextBox
Friend WithEvents TenMostExpensive As System.Windows.Forms.Button
Friend WithEvents grdNorthwind As System.Windows.Forms.DataGrid
Friend WithEvents groupBox2 As System.Windows.Forms.GroupBox
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
Me.GroupBox1 = New System.Windows.Forms.GroupBox()
Me.labelPAF = New System.Windows.Forms.Label()
Me.labelNbrPrices = New System.Windows.Forms.Label()
Me.textBoxPAF = New System.Windows.Forms.TextBox()
Me.UpdatePrices = New System.Windows.Forms.Button()
Me.groupBox2 = New System.Windows.Forms.GroupBox()
Me.TenMostExpensive = New System.Windows.Forms.Button()
Me.grdNorthwind = New System.Windows.Forms.DataGrid()
Me.GroupBox1.SuspendLayout()
Me.groupBox2.SuspendLayout()
CType(Me.grdNorthwind, System.ComponentModel.ISupportInitialize).BeginInit()
Me.SuspendLayout()
'
'GroupBox1
'
Me.GroupBox1.Controls.AddRange(New System.Windows.Forms.Control() {Me.labelPAF, Me.labelNbrPrices, Me.textBoxPAF, Me.UpdatePrices})
Me.GroupBox1.Location = New System.Drawing.Point(8, 8)
Me.GroupBox1.Name = "GroupBox1"
Me.GroupBox1.Size = New System.Drawing.Size(240, 112)
Me.GroupBox1.TabIndex = 9
Me.GroupBox1.TabStop = False
'
'labelPAF
'
Me.labelPAF.Location = New System.Drawing.Point(8, 16)
Me.labelPAF.Name = "labelPAF"
Me.labelPAF.Size = New System.Drawing.Size(112, 32)
Me.labelPAF.TabIndex = 2
Me.labelPAF.Text = "Enter Price Adjustment Factor"
'
'labelNbrPrices
'
Me.labelNbrPrices.Location = New System.Drawing.Point(8, 80)
Me.labelNbrPrices.Name = "labelNbrPrices"
Me.labelNbrPrices.Size = New System.Drawing.Size(216, 16)
Me.labelNbrPrices.TabIndex = 5
'
'textBoxPAF
'
Me.textBoxPAF.Location = New System.Drawing.Point(120, 16)
Me.textBoxPAF.Name = "textBoxPAF"
Me.textBoxPAF.TabIndex = 0
Me.textBoxPAF.Text = ""
'
'UpdatePrices
'
Me.UpdatePrices.Location = New System.Drawing.Point(8, 48)
Me.UpdatePrices.Name = "UpdatePrices"
Me.UpdatePrices.Size = New System.Drawing.Size(88, 23)
Me.UpdatePrices.TabIndex = 6
Me.UpdatePrices.Text = "Update Prices"
'
'groupBox2
'
Me.groupBox2.Controls.AddRange(New System.Windows.Forms.Control() {Me.TenMostExpensive, Me.grdNorthwind})
<Part 1----To be continued due to the length of this post>
View 1 Replies
View Related
Feb 12, 2008
I 'm getting this error on expanding the + nodes in SQL Server Management Studio Express Object Explorer:i.e. Database -> System Databases -> Any DB selected and expanding the Tables node When I click on the nodes for Tables for any of my databases, I see it saying expanding..., but then a message box errors pops up. It was working fine until after my lunch hour when I attempted to create some new tables.Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)Additional Information:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)Could not continue scan with NOLOCK due to data movement. (Microsoft SQL Server, Error: 601)
View 2 Replies
View Related
Jul 24, 2015
I have an SSIS and SSAS project in the same solution. I need to debug the SSIS package regardless if there is an error or two in the SSAS project. Is there a way to ignore the SSAS project while I debug the SSIS package?
View 2 Replies
View Related
Nov 7, 2007
Hi,
I'm trying to migrate a MSDE based application into a SQL2005 Express SP2 DB Engine on Windows Vista Business but I'm facing several errors that are blocking me.
Since the installation of SQL2005 Expr. must be done in a silent mode (the end user shouldn't set anything), I'm installing it using this syntax:
SQLEXPRSP2_ITA.EXE -q /norebootchk /qb reboot=ReallySuppress addlocal=all instancename=CSERV DISABLENETWORKPROTOCOLS=0 SQLBROWSERAUTOSTART=1 SQLACCOUNT="NT AUTHORITYSYSTEM" SQLBROWSERACCOUNT="NT AUTHORITYSYSTEM" AGTACCOUNT="NT AUTHORITYSYSTEM" ASACCOUNT="NT AUTHORITYSYSTEM" RSACCOUNT="NT AUTHORITYSYSTEM"
The installation proceeds without problems but when my program tries to create the database, a message error appears:
CREATE DATABASE denied on database 'master' (I translated directly from italian).
What I would like is to install SQL 2005 with "Windows Authentication" access instead of "SQL Authentication".
If I install SQL2005 manually by setting a named instance (CSERV), Windows Authentication mode, activating the option "set the local account as SQL administrative account" (translated from italian and suggested with Vista) I get the following error (read from the LOG):
CREATE FILE encountered operating system error 5 (access denied) while attempting to open or create the physical file 'C:Program FilesMicrosoft SQL ServerCSERVDataCGIDBDat.mdf'
CSERVData is the folder that the application creates and where the "mdf" and "ldf" files are stored.
So in the first case it seems that SQL2005 don't recognize the local account as administrator even if the user has administrative privileges (at least for Vista), in the second case is Vista that is blocking the action.
What is the solution??
Thank you and regards.
Roberto G.
View 4 Replies
View Related
Nov 28, 2005
I am trying to install SQL Server 2005 Express, but it fails.
View 6 Replies
View Related
Feb 6, 2006
I've been having horrific problems installing and working with SQL Server Express 2005. I installed SSE with the Visual Web Developer tool so I assumed that the instance would synch up; but it didn't (see log contents at end) so I opened up permissions wide open to all users, and even that didn't help. I don't know for sure but I suspect that the problem probably relates to my deleting SQL Server entries from the registry and all directories and files related to it on disk. After going through the process of uninstalling and reinstalling Express 2005 numerous times, I became frustrated and decided to pull out all stops.
After reading and following all MSDN instructions and every blog and forum I could possibly locate on the subject, I could never resolve the problem of not reaching my database. I enabled all pipes and TCP/IP, etc. in the Configuration Manager, in both instances I had created; had run all command-line procedures recommended; and used cleanup programs that I could find, before reinstalling. I couldn't even get success in doing a test connection. I did get to a point where my ASP returned the message that it had connected but that the user didn't have permissions.
I think I'm destined to working with Access, which is a shame since I have encouraged students in a Web development class I teach to work with the more powerful SQL Server products. They've had success with SQL Server, so I'm setting a bad example.
Thanks in advance for help any of you can suggest.
Microsoft SQL Server 2005 Setup beginning at Sun Feb 05 23:48:08 2006Process ID : 2036c:6645bd818fccc8ef0bad80e6a12f5bsetup.exe Version: 2005.90.1399.0Running: LoadResourcesAction at: 2006/1/5 23:48:6Complete: LoadResourcesAction at: 2006/1/5 23:48:6, returned trueRunning: ParseBootstrapOptionsAction at: 2006/1/5 23:48:6Loaded DLL:c:6645bd818fccc8ef0bad80e6a12f5bxmlrw.dll Version:2.0.3604.0Complete: ParseBootstrapOptionsAction at: 2006/1/5 23:48:8, returned trueRunning: ValidateWinNTAction at: 2006/1/5 23:48:8Complete: ValidateWinNTAction at: 2006/1/5 23:48:8, returned trueRunning: ValidateMinOSAction at: 2006/1/5 23:48:8Complete: ValidateMinOSAction at: 2006/1/5 23:48:8, returned trueRunning: PerformSCCAction at: 2006/1/5 23:48:8Complete: PerformSCCAction at: 2006/1/5 23:48:8, returned trueRunning: ActivateLoggingAction at: 2006/1/5 23:48:8Complete: ActivateLoggingAction at: 2006/1/5 23:48:8, returned trueRunning: DetectPatchedBootstrapAction at: 2006/1/5 23:48:8Complete: DetectPatchedBootstrapAction at: 2006/1/5 23:48:8, returned trueAction "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__2036" returned false.Running: PerformSCCAction2 at: 2006/1/5 23:48:8Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435Complete: PerformSCCAction2 at: 2006/1/5 23:48:9, returned trueRunning: PerformDotNetCheck at: 2006/1/5 23:48:9Complete: PerformDotNetCheck at: 2006/1/5 23:48:9, returned trueRunning: ComponentUpdateAction at: 2006/1/5 23:48:9Complete: ComponentUpdateAction at: 2006/1/5 23:48:30, returned trueRunning: DetectLocalBootstrapAction at: 2006/1/5 23:48:30Complete: DetectLocalBootstrapAction at: 2006/1/5 23:48:30, returned trueRunning: LaunchLocalBootstrapAction at: 2006/1/5 23:48:30
View 1 Replies
View Related
Jun 29, 2007
I can't get the download to work...i've tried regular sql server express 2005, the express for sp2 and the express with advanced services. I keep getting this message after the native client and support files are installed.."This application has failed to start because XOLEHLP.dll was not found. Re-installing the application may fix this problem."Then right after that message is says... "Failed to load SQLSpars.dll"
View 1 Replies
View Related
Jul 9, 2006
Hi,
I have found that when I'm debugging a custom component in BIDS that I've created in another instance of Visual Studio, every time I rebuild the component I have to shutdown and restart BIDS and then reattach to the BIDS process. Which is pretty time consuming... And if I find a small error in my custom component when debugging then I don't seem to be allowed to make any changes to the code unless I stop debugging and go through the process above.
Am I missing something here? Or do I really have to manually go through these steps every time I want to change code in the component I'm debugging?
Can I automate the process with MSBuild or NAnt? If so, is there an example of this anywhere?
Thanks in advance,
Lawrie.
View 1 Replies
View Related
Dec 12, 2005
I am using installshield to distribute SQL Server 2005 Express. I have the SQLEXPR.EXE file and I want to run it in /qb mode so the user can see the pretty dialogs pop up but not have to click anything.
View 6 Replies
View Related
Feb 21, 2008
Hello everyone.
I have a problem in accessing my SQL SERVER Express 2005 database.
The error is:
Cannot open database "MyDB" requested by the login. The login failed.
Login failed for user 'NT AUTHORITYSERVIZIO DI RETE'.
My ConnectionString is:
Data Source=(local); User ID=ExtApp; Initial Catalog=MyDB; Trusted_Connection=yes; Connection Timeout=15
In SQL SERVER I have set the Database log in ExtApp with SQL Authentication mode, instead of Windows Auth mode, and even inserted in my database the user associated with this login
The debugger keeps on telling me the same error that occours when I Try to open a connection (please note that the code has no errors because it works in another application, a client app not an asp.net 2.0 web app, so I assume that there are no errors or mistakes in the code).
Please can anyone tell me something about this????
Thanks
View 1 Replies
View Related
Mar 5, 2007
Hello
I am developing a windows forms app in Visual C# Express edition, it has a database, and when I am debugging, nothing is being done in the database, and I am sure it is nothing to do with the code. Because all I am doing is creating a database with one table, and just dragging the table (with the datagridview) onto a form, then it runs perfectly, but when I add or delete records, and exit the program, it is not reflected on my DB (which is a SQL Server express DB by the way),
I was looking everywhere, and all I could find was to change the "copy to output directory" propierty of the DB to "copy if newer" but still it doesn't work,
Any ideas why this may be happening??
thanks a lot
Andrés
View 3 Replies
View Related
Jul 1, 2015
I recently updated the datatype of a sproc parameter from bit to tinyint. When I executed the sproc with the updated parameters the sproc appeared to succeed and returned "1 row(s) affected" in the console. However, the update triggered by the sproc did not actually work.
The table column was a bit which only allows 0 or 1 and the sproc was passing a value of 2 so the table was rejecting this value. However, the sproc did not return an error and appeared to return success. So is there a way to configure the database or sproc to return an error message when this type of error occurs?
View 1 Replies
View Related
Feb 25, 2007
I have an Access DB with about 50 tables. When I run the upsize wizard all bur four tables import beautifully, data and all. Four of the tables fail with the message 'Table was skipped, or export failed'
When I try to IMPORT the data I get 100 or so messages like this one:
Warning 0x80047076: Data Flow Task: The output column "AssessPlanPHPID" (23) on output "OLE DB Source Output" (11) and component "Source - tblAssessPlan" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
And the import fails. Note that the upsize creates the tables just fine, it just won't import the data.
Any ideas?
I apologize for the fonts jumping around.
View 2 Replies
View Related
Apr 16, 2007
When I downloaded/started using Visual Web Developer I was under the impression that I needed to install SQL Server Management Studio Express in order to create/manage databases, and to provide the engine to access the data.
Since then I have found tutorials and have successfully created/used databases solely from within Visual Web Developer. I'm assuming that Visual Web Developer includes a database engine, much like the webserver that is included. (This is an awesome thing).
When I tried to upload my web application with database to my production server, the database would not work, it started working after I installed SQL Server Management Studio Express on the server.
Is it my understanding that you need SQL Server Management Studio Express if you do not have Visual Web Developer Express installed in order to provide the data access engine?
Also, I am unable to "attach" my Visual Web Developer Express created database to SQL Server Management Studio Express. Are there any posts that provide more information about this topic?
The only reason I'm asking is that I have extra whitespace on the end of my text fields, and I thought ANSI_PADDING was turned on. I do not see the option in Visual Web Developer Express, but have found it in SQL Server Management Studio Express.
View 14 Replies
View Related
Feb 18, 2008
Hi,
I am a newbie so i apologies beforehand for any mistakes i make on this forum.
Anyway, i created an asp.net website using the MS Visual Web developer tool. This has a couple of SQL SERVER databases within it.
I then latervinstalled the SQL SERVER management studio express in order to manage the SQL SERVER DBs that i had as part of my website but they do not appear within the management studio db list.
As this is the express version, is there anyway of importing the existing SQL SERVER dbs that i have to the management studio so i can manage them from there?
Regards,
Shuja.
View 5 Replies
View Related
Jul 10, 2007
Okay, I've read massive topics on ClickOnce, and embedded database applications, etc, etc.
I need a handful of good suggestions how I can create a deployment package, to get my sql express database onto a SQL Express server.
The database will need to be multi-user, because I am also developing a WinForms application to connect to the SQL Express database.
I'm thinking I need to use some automated scripting features, to generate scripts for the database once I am done (unless you have a better suggestion).
After that, I need to know what to do with those scripts, and how can I create a setup / deployment packages to run those scripts against a SQL Express server.
The other alterntative obviously is to copy my sql express database, and run an attach command. This will work the first time, only because this will have been the first deployment of this database.
Please keep in mind when answering this question, that I will not be embedding the database, and as far as I understand ClickOnce is a feature for use with embedded databases or user instance databases (not sure).
Daniel Crane
View 6 Replies
View Related
Apr 30, 2006
Hi, I'm completely new to SQL Server and ASP.NET, so please bear with me on my learning curve! I've installed Visual Web Developer Express and SQL Server Express (on the same PC). I then used Web Developer Express to successfully create a new database with a couple of tables in it. So far so good. I then installed SQL Server Management Studio Express on the same PC and tried to connect to my new database. The connection to the SQL Server instance appears to work OK (using Windows Authentication) but I can't see the database I previously created. All I can see are the System Databases. Does anyone know what the solution might be?
View 4 Replies
View Related
Nov 2, 2007
Hi all,
I have the "Northwind" database in my Sql Server Management Studio Express.
In my C:ProSSEAppsSamplesForChapter02Chapter02 folder, I have the following 2 files:
(1) ListColumnValues (MS-DOS Batch File)
sqlcmd -S .sqlexpress -v DBName = "Northwind" CName = "CompanyName" TName =
"Shippers" -i c:prosseappschapter02ListListColumnVales.sql -o
c:prosseappschapter02ColumnValuesOut.rpt
(2) ListColumnValues (Microsoft SQL Server Query File)
USE $(Northwind)
GO
SELECT $(CompanyName) FROM $(Shippers)
GO
When I ran the following SQLcmd:
C:ProSSEAppsSamplesForChapter02Chapter02>ListColumnValues.bat
I got the following "ColumnValuesOut.rpt" with error messages:
'Northwind' scripting variable not defined.
Msg 102, Level 15, State 1, Server L1P2P3SQLEXPRESS, Line 1
Incorrect syntax near '$'.
'CompanyName' scripting variable not defined.
'Shippers' scripting variable not defined.
Msg 102, Level 15, State 1, Server L1P2P3SQLEXPRESS, Line 1
Incorrect syntax near 'CompanyName'.
I copied these T-SQL statements from a book and I do not know how to correct them.
Please help and tell me how to correct these errors.
Thanks in advance,
Scott Chang
View 3 Replies
View Related
Dec 3, 2007
Hi all,
In the last one and half years, I used the Northwind Database in SQL Server Management Studio Express (SSMSE) to learn the programming of SqlConnections, Data sources, Database Exploere, ADO.NET 2.0, etc. via VB 2005 Express.
The Northwind Database in my SSMSE got lost very often, but I was not aware of it. How can I know where the Northwind Database is used or processed by my VB 2005 Express projects that were the examples of some tutorial books or my trial projects? How can I release the Northwind Database back to my SSMSE from the VB 2005 Express projects? Please help and advise.
Thanks in advance,
Scott Chang
View 2 Replies
View Related
Jun 24, 2007
I am new to this type of programming and and have read all articles on adding an image to the database and it seems they all use sql queries to add an image but I want to add an image at design time. I am using Visual Basic 2005. I am also using Visual Basic 2005 Express Edition to try the same thing. I am trying to build a Translator program for english to Brazilian Portuguese and the reason I want to add the images is so that when I translate the word cat from english to Portuguese, I can also show an image of a cat. Can anyone please help me
View 3 Replies
View Related
Jan 6, 2007
Hi all,
I have read/studied (i) Working with Databases in Visual Web Developer 2005 Express in http://quickstarts.asp.net/QuickStartv20/aspnet/doc/data/vwd.aspx, (ii) Xcopy Deployment (SQL Server Express) in http://msdn2.microsoft.com/en-us/library/ms165716.aspx, (iii) User Instances for Non-Administrators in http://msdn2.microsoft.com/en-us/library/ms143684.aspx, and (iv) Embedding SQL Server Server Express in Applications in http://msdn2.microsoft.com/en-us/library/ms165660.aspx. I do not understand the concepts and procedures to do Xcopy and User Instances for non-administrators completely-I do not know how to connect to databases and create database diagrams or schemas using the Database Explorer. I have a stand-alone Windows XP Pro PC. I have created a ChemDatabase with 3 dbo tables in the SQL Server Management Studio of my SQL Server Express and a website of my VWD Express application with an App_Data folder. I am not able to proceed to use Xcopy and user instance to bring the 3 dbo tables of ChemDatabase to my App_Data folder. Please help and give me some detailed procedures/instructions to bring the 3 dbo tables of ChemDatabase (or ChemDatabase itself) from the SQL Server Management Studio Express to the App_Data folder of the website of my VWD Express project?
Thanks in advance,
Scott Chang
View 3 Replies
View Related
Jun 29, 2007
I can't get the download to work...i've tried regular sql server express 2005, the express for sp2 and the express with advanced services. I keep getting this message after the native client and support files are installed.."This application has failed to start because XOLEHLP.dll was not found. Re-installing the application may fix this problem."Then right after that message is says... "Failed to load SQLSpars.dll"
View 1 Replies
View Related
Sep 2, 2007
Hi all, ive got a problem creating a sql connection.
Lets start from the beginning. I open Visual Studio, create a new empty website and then go to add a new SQL Database (new item > SQL Database). It asks me if i want to put this into the App_Data folder (which i choose 'yes' to), and then this error comes up...
I then decided to try a website template i found that i know works (because i got it running on Visual Studio at work), and this error comes up when i try to build the site...#
Heres a snippet of my machine.config...
Sorry about all the screenshots but im new to sql connections etc. Its all works fine at work and i can add a new database connection etc, but on my Home machine (Vista Ultimate, Visual Studio 2005 Pro, SQL Express).
Im sure its something to do with the machine.config, but i dont know how to rebuild it.
Any help will be appreciated.
Thanks
View 5 Replies
View Related
Dec 7, 2006
I installed Visual Studio 2005 on my machine, which includes SQL Server Express. I then installed the Developer edition of SQL Server over the top, as that's the edition I wanted. I now get four errors in my Application event log whenever I boot Windows:
MSSQLSERVER - Performance counter shared memory setup failed with error -1. Reinstall sqlctr.ini for this instance, and ensure that the instance login account has correct registry permissions.
MSSQLSERVER - Error in mapping SQL Server performance object/counter indexes to object/counter names. SQL Server performance counters are disabled.
MSSQL$SQLEXPRESS - Performance counter shared memory setup failed with error -1. Reinstall sqlctr.ini for this instance, and ensure that the instance login account has correct registry permissions.
MSSQL$SQLEXPRESS - Error in mapping SQL Server performance object/counter indexes to object/counter names. SQL Server performance counters are disabled.
Any idea what's causing this problem and how I can fix it?
Thanks
View 5 Replies
View Related
Sep 10, 2006
Hi guys, I've tried to back a database from a server on the net ie: discountasp.net by using Microsoft SQL 2005 Express management tool.
After all the set up:
(1) the part "Destination", in the "Disk" radio button was cheked, the path for the backup file shows like: D:MSSQL.1MSSQLBackupmyDatabase.back; As I understand D: is the CD drive(?), so I put a CDisc in the drive, and kept going with the process. The Process went very well and inform that the Database has been fully backed up. But I never have found the "saved" or "backed up" that I backed up. Can anyone show me where this backup Database in that D: drive, and where is that D: drive anyway?
(2) In that "destination" part, if I clicked "add", and then typed in the path address part like: C:....mybackupDatabase.bak for example, the the tool gave me the error: ... not set to an instance ...; I counldn't even select the Browse to browse to the directory that I wanted to back up the Database.
Please help me for this.
Regards.
Joey
View 1 Replies
View Related
May 22, 2006
My machine environment is as follows:
- Windows Server 2003 Standard with SP1
- IIS 6.0 with some "classic ASP" applications running under it (not ASP.NET)
- SQL Server 2000 Client (Enterprise Manager, Query Analyzer etc)
- .NET Framework Runtime 1.1 & 2.0
- Visual Studio.NET 2003 & 2005
I've never installed (or even trusted) any beta/CTP version of either Visual Studio or SQL 2005 (or any other MS trial products for that matter) on my machine.
Initially I installed SQL 2005 Express, and then the RTM version of SQL Management Studio Express.
Later i found this "SQL 2005 Express with Advanced Features" download, and figured that this must be a roll-up of all those features (and then some), so i removed all the old SQL 2005 components and installed this SQLEXPR_ADV.EXE.
I did this twice: the first time with Reporting Services; then removed the whole thing due to errors to be described below; the second time without RS.
The installation process itself is relatively painless, but after it's completed, whenever I open an ASP page from the local IIS server, dozens of warning messages like this would show up in the eventlog:
1.
=============================
Event Type: Warning
Event Source: MsiInstaller
Event Category: None
Event ID: 1015
Date: 2006-05-22
Time: 2:01:24 PM
User: NT AUTHORITYNETWORK SERVICE
Description:
Failed to connect to server. Error: 0x80070005
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
2.
=============================
Event Type: Warning
Event Source: MsiInstaller
Event Category: None
Event ID: 1001
Date: 2006-05-22
Time: 2:01:24 PM
User: MYPCIUSR_MYPC
Description:
Detection of product '{A4512736-8D63-4298-9271-5329931FA46B}', feature 'SQL_SSMSEE' failed during request for component '{6EC5DFBD-F6B5-4F02-8432-BFB8B03562B8}'
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
3.
=========================
Event Type: Warning
Event Source: MsiInstaller
Event Category: None
Event ID: 1004
Date: 2006-05-22
Time: 2:01:24 PM
User: MYPCIUSR_MYPC
Description:
Detection of product '{A4512736-8D63-4298-9271-5329931FA46B}', feature 'SQL_SSMSEE', component '{180F515D-F56C-40DD-9D71-CC532EA8E286}' failed. The resource '' does not exist.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
I can use the Management Studio Express to create a database and tables, but having tons of errors flooding my eventlog is still a serious problem.
Any ideas on how to resolve this?
By the way, I think the total experience with SQL 2005 installation is far worse than SQL 2000, which is a very mature product. It seems that SQL 2005 was rushed out of the door to meet some deadlines so quality was seriously comprised as a result. Sending out a service pack less than 6 months after the RTM release is a testament to this conclusion, right?
View 1 Replies
View Related
Dec 28, 2005
Problem 1: Upon starting SQL Server Express I get the following error:
"An unhandled exception has occurred in a component in your application....Cannot create a stable subkey under a volatile parent." Clicking OK lets the Server continue and I can use it quasi-normally.
Problem 2: Also, when I try to generate a diagram, I get a message that states
"Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects."
But, the database HAS an owner, and resetting the owner (using the Files...) to other users has no effect.
Problem 3: I tried to change the name of a database, and it refused to do so. Except that now all objects under the database name (it is the same old name) have disappeared. Is there a magic folder somewhere that contains all of the tables, etc. that were 'banished' from the server?
Is there a way to detach the databases from Express and reattach them to the SQL Server 2000 I am also running? Last time I tried the 'detach' worked but all the objects were wiped out by the 'attach'. Handy feature.
Thanks
Glen
View 1 Replies
View Related
Jan 11, 2006
I recently added a new user to my database. Now I want to delete that user, but I keep getting the error above. What do I need to do to delete my recently added user?
View 4 Replies
View Related
Jan 23, 2008
Hi,
What are the steps required to migrate or upgrade data or database from a sql server 2005 express database to main sql server 2005 database?
Regards,Sandy
View 1 Replies
View Related
