Attaching FMS Database

[mloveless]

Hi,

 

I'm experiencing an error when trying to attach the FMS database for FMSSQL.

 

I've tried both attaching it to an already existing 2005 Express instance and also using the install wizard for FMS to create a new instance and then attach it.

 

The error I receive is:

 

A severe error occured on the current command. The results, if any, should be discarded. Please check your configuration. (usefull isn't it?)

 

I Also recieve the following on occations:

 

Ad hoc update to system catalogs is not supported.

See the end of this message for details on invoking

just-in-time (JIT) debugging instead of this dialog box.

 

************** Exception Text **************

System.Data.SqlClient.SqlException: Ad hoc update to system catalogs is not supported.

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)

at System.Data.SqlClient.SqlCommand.ExecuteScalar()

at DbAttach.dbHelper.setDatabaseCompatabilityToSQL2005()

at DbAttach.dbHelper.attachSQLDatabaseRequest(String databaseName, String sourceFile)

at DbAttach.InterfaceModeForm.buttonAttach_Click(Object sender, EventArgs e)

at System.Windows.Forms.Control.OnClick(EventArgs e)

at System.Windows.Forms.Button.OnClick(EventArgs e)

at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)

at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.ButtonBase.WndProc(Message& m)

at System.Windows.Forms.Button.WndProc(Message& m)

at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

 

 

************** Loaded Assemblies **************

mscorlib

Assembly Version: 1.0.5000.0

Win32 Version: 1.1.4322.2407

CodeBase: file:///c:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll

----------------------------------------

DbAttach

Assembly Version: 1.8.2.0

Win32 Version: 1.8.2.0

CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/MSSQL.1/MSSQL/Binn/DbAttach.exe

----------------------------------------

System.Windows.Forms

Assembly Version: 1.0.5000.0

Win32 Version: 1.1.4322.2365

CodeBase: file:///c:/windows/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll

----------------------------------------

System

Assembly Version: 1.0.5000.0

Win32 Version: 1.1.4322.2407

CodeBase: file:///c:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll

----------------------------------------

System.Drawing

Assembly Version: 1.0.5000.0

Win32 Version: 1.1.4322.2327

CodeBase: file:///c:/windows/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll

----------------------------------------

System.Data

Assembly Version: 1.0.5000.0

Win32 Version: 1.1.4322.2365

CodeBase: file:///c:/windows/assembly/gac/system.data/1.0.5000.0__b77a5c561934e089/system.data.dll

----------------------------------------

System.EnterpriseServices

Assembly Version: 1.0.5000.0

Win32 Version: 1.1.4322.2326

CodeBase: file:///c:/windows/assembly/gac/system.enterpriseservices/1.0.5000.0__b03f5f7f11d50a3a/system.enterpriseservices.dll

----------------------------------------

System.Xml

Assembly Version: 1.0.5000.0

Win32 Version: 1.1.4322.2371

CodeBase: file:///c:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll

----------------------------------------

 

************** JIT Debugging **************

To enable just in time (JIT) debugging, the config file for this

application or machine (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:

 

 

When JIT debugging is enabled, any unhandled exception

will be sent to the JIT debugger registered on the machine

rather than being handled by this dialog.

 

 

 

 

 

 

This is driving me mad. I've tried everything I can think of and nothing is working.

 

Thanks in advance,

 

Mike

Edited June 3, 2008 by mloveless
additional error message