Error reporting from SP to .NET code, how?

Hey

ASP.NET 2.0 + MS Sql Server 2005 Express (that version which comes with VS2005)

This code below fails. The Delete method executes a stored procedure, but somehow this SP fails. The SP shown here is a short version of the actual SP. As you see from the code below, there are no way the Delete method can know if SP executed successfully. I assume I just could have returned @.@.error, but that just gives an error number, and not the description of the error??.. And how should I capture exceptions like these?? How should code this SP so it report the error??

Any suggestions??

public override void Delete(System.Guid id, int user)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("SendMessage", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@.id", SqlDbType.UniqueIdentifier).Value = id;
cmd.Parameters.Add("@.user", SqlDbType.Int).Value = user;
}
}

ALTER PROCEDURE dbo.DeleteMessage @.id uniqueidentifier, @.user int
AS
BEGIN
UPDATE table_A set column_A = 1 WHERE Id = @.id;
DELETE FROM table_B WHERE Id = @.id;
IF (@.@.error = 0)
COMMIT TRAN;
ELSE
ROLLBACK TRAN;
END

there is a couple of way to report that what happened, you can use execute nonquery to get number of rows affected by last SQL command, you can return from your procedure single cell using SELECT with value 0 for success and 1 for error and finally you can use output parameters and read its values after procedure executes. See T-SQL help in SQL management studio express which is very good and you can find everything you wont.

Error remotely connecting to SQL Server Express

I've been trying to configure remote connections to my sql server express to no avail.

First here are some constants to clear some things up:
- OS: Windows XP Pro
- SQL Express version: April CTP release
- Windows Firewall: disabled (to avoid any problems there)
- Network type: two computers connected a router.
- Router firewall: Enabled (I may be wrong but the router firewall only blocks external traffic, so I left it on.)

First, I configured my SQL server to allow remote connections in the SQL Surface Area Configuration. (Set it to both TCP/IP and named pipes)

Second, I enabled and configured sql server browser.

Third, I enabled TCP/IP and named pipes in the 'Protocols for SQL Express' option of the SQL Server Configuration Manager.

According to http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
I have done everything I need to (including edit the registry to enable the SQL Server Browser service) and the error I continue to get is:

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)"

So I tinkered and had no success in messing with anything that would fix it. Although, ***when I browsed for network servers on different machine, the server instance DID show up in the list***. So I find it odd that it can find the instance when browsing, but fails to 'find' it when making a connection.

So I didn't stop there, I decided to try the non-sql server browser method of remotely connecting: specifying the IP.

I went back to the blog of instructions referenced above and re-did the steps, this time specifying a TCP Port for the server instance and then after specifying the port on the remote computer connection string, and attempting to connect, I get this error:

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (Microsoft SQL Server, Error: 10060)"

I've done all I know how, read all the possible blogs I can, and nothing's come up. If anyone can shed some light on me, I'd pay you 1 billion pretend dollars. Any help would be appreciated. Thank you!

First of all, why are you using a CTP version of SQL Server Express ?

What is your connection string / with which application are you trying to connect ?

Is SQL Server Browser started on the server ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

Error opening Management Studio (Express)

Hello all,

I'm having an error opening the SSMS Express on a machine. This is a new install on this machine, so i've never had this running. However, i've install SSMSE many times and this is the first error that I've come across. I have the minimum requirements on the machine (Framework, XML, Windows Installer)

The error is:

Header: "Microsoft .Net Framework"
"Unhandled exception has occured in a component in your application. If you click Continue, the application will igonore this error and attempt to continue.

Attempted to read or write protected memory. This is often an indication that the other memory is corrupt"

(Details at end of post)

Now what this machine is running is:

OS: SBS 2003 SP1

Memory: 1.5 GB (over 1 GB is free)

Hard Disk: 7 GB of free space

Windows Updates are done up to just before SP2

SQL Server Express (SP2) is installed on this machine.

SSMSE Version: 3042

What I've done trying to resolve this issue:
1) reboot the machine
2) apply remaining windows updates (save for W2K3 SP2)
3) Re-install of SSMSE
4) Re-download of SSMSE install package and an uninstall & reinstall
5) Repair of .Net Framework 2.0
6) Repair of SQL Native Client

I'm not sure what to attempt next, if anyone can give me any insite at all, that would be great. All I did was install the requirements, install SQL Server Express SP2, then install SSMSE. This has worked in the past for me.

Any and all help greatly appreciated!!

Thanks,

Ryan

Note: here is the stack track that the application generates:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
at System.Drawing.SafeNativeMethods.Gdip.GdipGetLogFontW(HandleRef font, HandleRef graphics, Object lf)
at System.Drawing.Font.ToLogFont(Object logFont, Graphics graphics)
at System.Drawing.Font.ToLogFont(Object logFont)
at System.Drawing.Font.ToHfont()
at System.Windows.Forms.Control.FontHandleWrapper..ctor(Font font)
at System.Windows.Forms.Control.get_FontHandle()
at System.Windows.Forms.Control.SetWindowFont()
at System.Windows.Forms.Control.OnHandleCreated(EventArgs e)
at System.Windows.Forms.TreeView.OnHandleCreated(EventArgs e)
at System.Windows.Forms.Control.WmCreate(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.TreeView.WndProc(Message& m)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.LazyTreeView.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.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
-
Microsoft.SqlServer.Express.AppIDPackage
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.AppIDPackage.DLL
-
Microsoft.SqlServer.Express.VSIntegration
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.VSIntegration.DLL
-
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-
Microsoft.VisualStudio.Shell.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.0.4054
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
-
Microsoft.VisualStudio.OLE.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.0.4054
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
-
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
-
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
-
Microsoft.SqlServer.Express.SqlWorkbench.Interfaces
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SqlWorkbench.Interfaces.DLL
-
Microsoft.SqlServer.Express.SqlTDiagM
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SqlTDiagM.DLL
-
Microsoft.DataWarehouse.SQM
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL
-
Microsoft.SqlServer.Instapi
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
-
Microsoft.SqlServer.Express.ObjectExplorer
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.ObjectExplorer.DLL
-
Microsoft.SqlServer.Express.SqlMgmt
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SqlMgmt.DLL
-
Microsoft.SqlServer.Express.ConnectionDlg
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.ConnectionDlg.DLL
-
Microsoft.VisualStudio
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 built by: RTM
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.dll
-
Microsoft.VisualStudio.Shell
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Shell/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.dll
-
Microsoft.VisualStudio.Shell.Interop.8.0
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop.8.0/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.8.0.dll
-
System.Drawing.Design
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing.Design/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.Design.dll
-
Microsoft.VisualStudio.Designer.Interfaces
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Designer.Interfaces/1.0.5000.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Designer.Interfaces.dll
-
Microsoft.SqlServer.Express.RegSvrEnum
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.RegSvrEnum.DLL
-
Microsoft.SqlServer.Express.CustomControls
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.CustomControls.DLL
-
Microsoft.SqlServer.Express.Smo
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.Smo.DLL
-
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.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.

--

**********************************************************************************************

--

To me that looks like a problem with the .NET framework. Try doing a full reinstall of the framework.

You might want to ask in one of the .NET forums and see if they can shead any light.

|||

That's what I thought too, so I ended up uninstalling the framework, rebooting, and reinstalling. No issues on the reinstall.

Still the error exists. However, I have found that I get errors in the SQL Surface Area Configuration Wizard as well. I'm assuming this runs off the ".NET Framework" as well. I've read some issues with this happening with some .NET controls, but I'm assuming that these are working fine as this seems to be the only machine with these issues. What concerns me is that if SQL Server uses any of hte .NET framework (besides the CLR) then I'm not sure if I want to continue on this machine.

Any ideas on what do look for?

|||

Ok, i'm convinced that this is an issue with .NET framework on this machine. It seems to be related to the System.Drawing DLL. I can get into the program but, it'll throw another error if I right click, however, this error comes from System.Drawing.Font

I'm going to move this thread to under a .NET Thread.

Thanks,

|||

Moved to:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1679733&SiteID=1&mode=1

|||

Ryan Slimmon wrote:

Moved to:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1679733&SiteID=1&mode=1

Any update on this issue - I am getting same message when trying to import SQL 2000 Server registration details

Error opening Management Studio (Express)

Hello all,

I'm having an error opening the SSMS Express on a machine. This is a new install on this machine, so i've never had this running. However, i've install SSMSE many times and this is the first error that I've come across. I have the minimum requirements on the machine (Framework, XML, Windows Installer)

The error is:

Header: "Microsoft .Net Framework"
"Unhandled exception has occured in a component in your application. If you click Continue, the application will igonore this error and attempt to continue.

Attempted to read or write protected memory. This is often an indication that the other memory is corrupt"

(Details at end of post)

Now what this machine is running is:

OS: SBS 2003 SP1

Memory: 1.5 GB (over 1 GB is free)

Hard Disk: 7 GB of free space

Windows Updates are done up to just before SP2

SQL Server Express (SP2) is installed on this machine.

SSMSE Version: 3042

What I've done trying to resolve this issue:
1) reboot the machine
2) apply remaining windows updates (save for W2K3 SP2)
3) Re-install of SSMSE
4) Re-download of SSMSE install package and an uninstall & reinstall
5) Repair of .Net Framework 2.0
6) Repair of SQL Native Client

I'm not sure what to attempt next, if anyone can give me any insite at all, that would be great. All I did was install the requirements, install SQL Server Express SP2, then install SSMSE. This has worked in the past for me.

Any and all help greatly appreciated!!

Thanks,

Ryan

Note: here is the stack track that the application generates:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
at System.Drawing.SafeNativeMethods.Gdip.GdipGetLogFontW(HandleRef font, HandleRef graphics, Object lf)
at System.Drawing.Font.ToLogFont(Object logFont, Graphics graphics)
at System.Drawing.Font.ToLogFont(Object logFont)
at System.Drawing.Font.ToHfont()
at System.Windows.Forms.Control.FontHandleWrapper..ctor(Font font)
at System.Windows.Forms.Control.get_FontHandle()
at System.Windows.Forms.Control.SetWindowFont()
at System.Windows.Forms.Control.OnHandleCreated(EventArgs e)
at System.Windows.Forms.TreeView.OnHandleCreated(EventArgs e)
at System.Windows.Forms.Control.WmCreate(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.TreeView.WndProc(Message& m)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.LazyTreeView.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.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
-
Microsoft.SqlServer.Express.AppIDPackage
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.AppIDPackage.DLL
-
Microsoft.SqlServer.Express.VSIntegration
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.VSIntegration.DLL
-
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-
Microsoft.VisualStudio.Shell.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.0.4054
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
-
Microsoft.VisualStudio.OLE.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.0.4054
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
-
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
-
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
-
Microsoft.SqlServer.Express.SqlWorkbench.Interfaces
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SqlWorkbench.Interfaces.DLL
-
Microsoft.SqlServer.Express.SqlTDiagM
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SqlTDiagM.DLL
-
Microsoft.DataWarehouse.SQM
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL
-
Microsoft.SqlServer.Instapi
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
-
Microsoft.SqlServer.Express.ObjectExplorer
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.ObjectExplorer.DLL
-
Microsoft.SqlServer.Express.SqlMgmt
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SqlMgmt.DLL
-
Microsoft.SqlServer.Express.ConnectionDlg
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.ConnectionDlg.DLL
-
Microsoft.VisualStudio
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 built by: RTM
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.dll
-
Microsoft.VisualStudio.Shell
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Shell/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.dll
-
Microsoft.VisualStudio.Shell.Interop.8.0
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop.8.0/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.8.0.dll
-
System.Drawing.Design
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing.Design/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.Design.dll
-
Microsoft.VisualStudio.Designer.Interfaces
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Designer.Interfaces/1.0.5000.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Designer.Interfaces.dll
-
Microsoft.SqlServer.Express.RegSvrEnum
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.RegSvrEnum.DLL
-
Microsoft.SqlServer.Express.CustomControls
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.CustomControls.DLL
-
Microsoft.SqlServer.Express.Smo
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.Smo.DLL
-
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.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.

--

**********************************************************************************************

--

To me that looks like a problem with the .NET framework. Try doing a full reinstall of the framework.

You might want to ask in one of the .NET forums and see if they can shead any light.

|||

That's what I thought too, so I ended up uninstalling the framework, rebooting, and reinstalling. No issues on the reinstall.

Still the error exists. However, I have found that I get errors in the SQL Surface Area Configuration Wizard as well. I'm assuming this runs off the ".NET Framework" as well. I've read some issues with this happening with some .NET controls, but I'm assuming that these are working fine as this seems to be the only machine with these issues. What concerns me is that if SQL Server uses any of hte .NET framework (besides the CLR) then I'm not sure if I want to continue on this machine.

Any ideas on what do look for?

|||

Ok, i'm convinced that this is an issue with .NET framework on this machine. It seems to be related to the System.Drawing DLL. I can get into the program but, it'll throw another error if I right click, however, this error comes from System.Drawing.Font

I'm going to move this thread to under a .NET Thread.

Thanks,

|||

Moved to:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1679733&SiteID=1&mode=1

|||

Ryan Slimmon wrote:

Moved to:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1679733&SiteID=1&mode=1

Any update on this issue - I am getting same message when trying to import SQL 2000 Server registration details

sql

error on installing sql express 2005

I'm having trouble loging into sql...then I remebered when I first installed it on my XP pro machine the system config check showed everything passed except the following:

System Configuration Check

-

- COM Plus Catalog Requirement (Warning)

Messages

COM Plus Catalog Requirement

If SQL Server Setup fails, Setup will roll back the installation but may not remove all .manifest files. The workaround is to rename the files and then rerun Setup. For more information, see How to: Work Around COM+ Check Failure in SQL Server Setup.

- Can this be the reason I cannot log into sql ?

Did you resolve this issue?

error on installing sql express 2005

I'm having trouble loging into sql...then I remebered when I first installed it on my XP pro machine the system config check showed everything passed except the following:

System Configuration Check

-

- COM Plus Catalog Requirement (Warning)

Messages

COM Plus Catalog Requirement

If SQL Server Setup fails, Setup will roll back the installation but may not remove all .manifest files. The workaround is to rename the files and then rerun Setup. For more information, see How to: Work Around COM+ Check Failure in SQL Server Setup.

- Can this be the reason I cannot log into sql ?

Did you resolve this issue?sql

Error on Install

I'm getting an error when trying to install the SQL Server 2005 Express. After it installs the Native Client & Support file, it goes through a configuration check.

I'm getting this error (complete) ::

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine <machine name> Error: 2147746132 (0x80040154)

and then stops.

Suggestions would be great!!!

Check here:

http://support.microsoft.com/default.aspx/kb/201234

Buck Woody

|||

Re-registering WMI

I've been having some issues with WMI on my laptop over the past couple of weeks (the symptoms of which have been strange WMI repository messages, inability to run WMIC or scripts, machine running slower than usual etc.). I didn't really want to have to re-install or repair Windows to fix this. Fortunately I found this very helpful article on resetting and re-registering the WMI services.

This included the following commands to re-register all of the WMI components:

cd /d %windir%\system32\wbem

for %i in (*.dll) do RegSvr32 -s %i

for %i in (*.exe) do %i /RegServer

Published Friday, March 18, 2005 5:19 PM by smguest

I did this, worked for me.

Error on Install

I'm getting an error when trying to install the SQL Server 2005 Express. After it installs the Native Client & Support file, it goes through a configuration check.

I'm getting this error (complete) ::

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine <machine name> Error: 2147746132 (0x80040154)

and then stops.

Suggestions would be great!!!

Check here:

http://support.microsoft.com/default.aspx/kb/201234

Buck Woody

|||

Re-registering WMI

I've been having some issues with WMI on my laptop over the past couple of weeks (the symptoms of which have been strange WMI repository messages, inability to run WMIC or scripts, machine running slower than usual etc.). I didn't really want to have to re-install or repair Windows to fix this. Fortunately I found this very helpful article on resetting and re-registering the WMI services.

This included the following commands to re-register all of the WMI components:

cd /d %windir%\system32\wbem

for %i in (*.dll) do RegSvr32 -s %i

for %i in (*.exe) do %i /RegServer

Published Friday, March 18, 2005 5:19 PM by smguest

I did this, worked for me.

sql

Error on DROP TABLE

Hi,

I was trying to drop a table (or alter it in any way) and the Managment Studio Express gave me an error of timeout. So I say something like DROP TABLE myTable, and it takes a while and gives me the error. Does anybody know how to unlock a table?

Thanks

Hi Alessandro,

As this is Express, I'm guessing that a stopping and restarting the SQL Server service sin't going to impact usage? If not, do this and re-issue your drop command, you'll probably that an application is placing a lock on the table in question and blocking the ddl command.

There are other ways to identify the offending session (spid), but this is probably easiest in your case.

Cheers,

Rob

|||

post back the actual error u gets...

Madhu

|||

Hi

Possible to post the error message to further explore your problem?

At the mean time:

1. Check whether the table really exists in the correct database. Do the folowing:

Select Name from Sys.Objects where name='tablename' -- (if exist)

Drop table databasename.schema.tablename

2. Check that the Login that you are using to execute this query has the approriate permission. You can do so by verify the user properties in the security node.

3. Check whether the table has any reference to other tables

4. Verify whether the table is locked using the current activity. If necessary, you can end the lock by killing the session.

Error msg:SQLServer2005_SSMSEE.msi is not a valid installer package

I have downloaded the msi file for the SQL Server Management Studio Express. However, clicking the msi file, showed a Windows Installer error msg that the installer package can not be opened because it is not a valid installer pckage.

Previously, I did download and install the SQL Server 2005 Express successfully. We need Management Studio Express in order to run the 'Enterprise manager'. Am I right?

TIA,

Jeffrey

hi Jeffrey,

your downloaded file could be corrupted.. try downloading it again..

regards

Error Msg 8120

Hello all,

I am using SQL Server 2005 Express on my local machine and am having a hard time figuring out why this problem is occuring. I am creating a stored procedure just fyi. 8120 = Column 's.Spread' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. And also...Column 's.Pay End Dt' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Both of these fields are being used in an expression not actually pulled into the query. I have bolded the line that the error refers to...Here is the sql:

USE ForecastSQLDBA
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE GetHistoricalData
@.AccountName varchar(50),
@.MaxDate smalldatetime
AS
BEGIN

SELECTDivision,
SUM(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN Spread ELSE 0 END) AS [05Spread],
SUM(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN Spread ELSE 0 END) AS [06Spread],
SUM(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN [Bill] ELSE 0 END)/SUM(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN [Cost] ELSE 0 END) AS [05MarkUp],
SUM(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN [Bill] ELSE 0 END)/SUM(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN [Cost] ELSE 0 END) AS [06MarkUp],
SUM(CASE WHEN [Pay End Dt] BETWEEN '2007-01-01' AND @.maxdate THEN [Bill] ELSE 0 END)/SUM(CASE WHEN [Pay End Dt] BETWEEN '2007-01-01' AND @.maxdate THEN [Cost] ELSE 0 END) AS [07MarkUp],
SUM(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN Spread ELSE 0 END)/SUM(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN [Emp] ELSE 0 END) AS [05SPC],
SUM(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN Spread ELSE 0 END)/SUM(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN [Emp] ELSE 0 END) AS [06SPC],
SUM(CASE WHEN [Pay End Dt] BETWEEN '2007-01-01' AND @.maxdate THEN Spread ELSE 0 END)/SUM(CASE WHEN [Pay End Dt] BETWEEN '2007-01-01' AND @.maxdate THEN [Emp] ELSE 0 END) AS [07SPC],
SUM(CASE WHEN [Pay End Dt] = @.maxdate THEN [Bill] ELSE 0 END)/SUM(CASE [Pay End Dt] WHEN @.maxdate THEN [Cost] ELSE 0 END) AS [07CurMarkUp],
AVG(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN [Emp] ELSE 0 END) AS [05AvgEmp],
AVG(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN [Emp] ELSE 0 END) AS [06AvgEmp],
AVG(CASE WHEN [Pay End Dt] BETWEEN '2007-01-01' AND @.maxdate THEN [Emp] ELSE 0 END) AS [07AvgEmp],
MAX(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN [Spread] ELSE 0 END) AS [05High],
MAX(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN Spread ELSE 0 END) AS [06High],
MAX(CASE WHEN [Pay End Dt] BETWEEN '2007-01-01' AND @.maxdate THEN Spread ELSE 0 END) AS [07High],
CASE Spread WHEN MAX(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN Spread ELSE 0 END) THEN [Pay End Dt] ELSE '' END AS [05MaxWeek],
CASE Spread WHEN MAX(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN Spread ELSE 0 END) THEN [Pay End Dt] ELSE '' END AS [06MaxWeek],
CASE Spread WHEN MAX(CASE WHEN [Pay End Dt] BETWEEN '2007-01-01' AND @.maxdate THEN Spread ELSE 0 END) THEN [Pay End Dt] ELSE '' END AS [05MaxWeek]

FROM (SELECT Division, [Pay End Dt], Sum(isnull([SumOfNum of Emp],0)) AS Emp, SUM(isnull([SumOfNet Spread],0)) AS Spread, SUM(isnull([SumOfTotal Bill],0)) AS Bill, SUM(isnull([SumOfCost],0)) AS Cost FROM dbo.tbl_NAHistory WHERE [Generic Customer] = @.AccountName GROUP BY Division, [Pay End Dt]) AS s

GROUP BY [Division];
END

Thanks in advance,
-BOK, I was wrong...the last three CASE expressions need to go in the GROUP BY but they can't because they have aggregates. Any ideas?

Error moving SQL Express 2005 Database to other folder / computer

When we try to move a SQL Express 2005 database to another folder in the same
computer or to other computer it only attach as read only.
Here is the procedure:
- Install SQL Express (I used a instance called SQL2005)
- Create or attach a database from other computer
- Detach the database (sp_detach_db)
- Copy files (mdf and ldf) to other folder
- Attach the database (sp_attach_db or create database for attach).
It will attach the database as readonly. If you try to use Alter Database to
change to read-write you receive an error.
This is only on the Express Edition. The same procedure works ok on the
developer copy download from MSDN.
The point is, I need to distribute this database to customers (they have
some data inside, so I cannot create then). I don't know what folder my
customers will use to install. And I cannot remove the readonly state of the
database.
How to solve this ?
Thanks for any help.
Hi
Just solved it.
The SQL Express installed with user "NetWork Service" not "LocalSystem" I
use in the other machine. I changed my command line to force LocalSystem and
it is now working.
"Gustavo Trunci" wrote:

> When we try to move a SQL Express 2005 database to another folder in the same
> computer or to other computer it only attach as read only.
> Here is the procedure:
> - Install SQL Express (I used a instance called SQL2005)
> - Create or attach a database from other computer
> - Detach the database (sp_detach_db)
> - Copy files (mdf and ldf) to other folder
> - Attach the database (sp_attach_db or create database for attach).
> It will attach the database as readonly. If you try to use Alter Database to
> change to read-write you receive an error.
> This is only on the Express Edition. The same procedure works ok on the
> developer copy download from MSDN.
> The point is, I need to distribute this database to customers (they have
> some data inside, so I cannot create then). I don't know what folder my
> customers will use to install. And I cannot remove the readonly state of the
> database.
> How to solve this ?
>
> Thanks for any help.
>
>

Error moving SQL Express 2005 Database to other folder / computer

When we try to move a SQL Express 2005 database to another folder in the sam
e
computer or to other computer it only attach as read only.
Here is the procedure:
- Install SQL Express (I used a instance called SQL2005)
- Create or attach a database from other computer
- Detach the database (sp_detach_db)
- Copy files (mdf and ldf) to other folder
- Attach the database (sp_attach_db or create database for attach).
It will attach the database as readonly. If you try to use Alter Database to
change to read-write you receive an error.
This is only on the Express Edition. The same procedure works ok on the
developer copy download from MSDN.
The point is, I need to distribute this database to customers (they have
some data inside, so I cannot create then). I don't know what folder my
customers will use to install. And I cannot remove the readonly state of the
database.
How to solve this '
Thanks for any help.Hi
Just solved it.
The SQL Express installed with user "NetWork Service" not "LocalSystem" I
use in the other machine. I changed my command line to force LocalSystem and
it is now working.
"Gustavo Trunci" wrote:

> When we try to move a SQL Express 2005 database to another folder in the s
ame
> computer or to other computer it only attach as read only.
> Here is the procedure:
> - Install SQL Express (I used a instance called SQL2005)
> - Create or attach a database from other computer
> - Detach the database (sp_detach_db)
> - Copy files (mdf and ldf) to other folder
> - Attach the database (sp_attach_db or create database for attach).
> It will attach the database as readonly. If you try to use Alter Database
to
> change to read-write you receive an error.
> This is only on the Express Edition. The same procedure works ok on the
> developer copy download from MSDN.
> The point is, I need to distribute this database to customers (they have
> some data inside, so I cannot create then). I don't know what folder my
> customers will use to install. And I cannot remove the readonly state of t
he
> database.
> How to solve this '
>
> Thanks for any help.
>
>

Error moving SQL Express 2005 Database to other folder / computer

When we try to move a SQL Express 2005 database to another folder in the same
computer or to other computer it only attach as read only.
Here is the procedure:
- Install SQL Express (I used a instance called SQL2005)
- Create or attach a database from other computer
- Detach the database (sp_detach_db)
- Copy files (mdf and ldf) to other folder
- Attach the database (sp_attach_db or create database for attach).
It will attach the database as readonly. If you try to use Alter Database to
change to read-write you receive an error.
This is only on the Express Edition. The same procedure works ok on the
developer copy download from MSDN.
The point is, I need to distribute this database to customers (they have
some data inside, so I cannot create then). I don't know what folder my
customers will use to install. And I cannot remove the readonly state of the
database.
How to solve this '
Thanks for any help.Hi
Just solved it.
The SQL Express installed with user "NetWork Service" not "LocalSystem" I
use in the other machine. I changed my command line to force LocalSystem and
it is now working.
"Gustavo Trunci" wrote:
> When we try to move a SQL Express 2005 database to another folder in the same
> computer or to other computer it only attach as read only.
> Here is the procedure:
> - Install SQL Express (I used a instance called SQL2005)
> - Create or attach a database from other computer
> - Detach the database (sp_detach_db)
> - Copy files (mdf and ldf) to other folder
> - Attach the database (sp_attach_db or create database for attach).
> It will attach the database as readonly. If you try to use Alter Database to
> change to read-write you receive an error.
> This is only on the Express Edition. The same procedure works ok on the
> developer copy download from MSDN.
> The point is, I need to distribute this database to customers (they have
> some data inside, so I cannot create then). I don't know what folder my
> customers will use to install. And I cannot remove the readonly state of the
> database.
> How to solve this '
>
> Thanks for any help.
>
>

Error messages of return codes of SQL installer

Hi all,

I have one application through which i m installing SQL Server 2005 Express Edition.

If some failure occures, all I get is one exitCode which is a return code of SQL Express installer. Is there any way by which I can find out the exact reason of failure.

One example is error code 28062.

This error code is for "sql is unable to install on compressed folder / drive".

Please help

Thanks and regards,

-Anup

Are you using either encrypted or compressed drives where you want to install the edition on ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Error Message when restoring Database

I am receiving the following error message when I am trying to restore a database in SQL Express 2005. Has anyone ever seen it before?

microsoft.sqlserver.express.connectionInfo

Could you be more specific to provide the error you are getting?|||

The snippet you pasted is just the class (including the namespace) where the error has occured. You will have to paste the whole exception information (eventually including the stack trace) in order to help you.

Jens K. Suessmeyer.

http://www.sqlserver2005.de