SIMS FMS - 6.85 to 6.91 upgrade, DBAttach gives unhandled exception

[nry]

I have successfully installed the 6.83 to 6.85 upgrade and have moved on to the 6.91 installation.

 

I have installed SQL Server 2005 Express from the FMS CD and have installed the 6.91 software. I am at the stage where I need to run dbattach and can successfully enter the server name, username and password.

 

I then enter a database name and choose the CCSFMS.MDF file and click attach. After a few seconds I am given a pop-up error box which states:

 

SIMS Database Management Utility

A unhandled exception has occured in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will be shut down immediately.

 

The details of this error are:

 

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: General network error. Check your network documentation.

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

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

at DbAttach.dbHelper.isNewSecurity(String dbname)

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.2379

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

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

DbAttach

Assembly Version: 1.4.10.24588

Win32 Version: 1.4.10.24588

CodeBase: file:///D:/binn/DbAttach.exe

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

System.Windows.Forms

Assembly Version: 1.0.5000.0

Win32 Version: 1.1.4322.2365

CodeBase: file:///c:/winnt/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.2380

CodeBase: file:///c:/winnt/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:/winnt/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:/winnt/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:/winnt/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:/winnt/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.

 

I cannot find anything relating to this specific error in the knowledge base from Capita and yet again they've pointed me to Professional Services as they no longer support the upgrade.

 

I'm currently told I should have a file called FMSSQLApplicationSetup.exe to run to confirm the DBUpgrade files are installed correctly, but I'm not even at that stage yet nor do I have that file, only the new FMSApplicationSetup.exe which kicks off the 6.91 install again.

[nry]

Checking Event Viewer I can see this error:

 

Error: 50000 Severity: 22 State: 127 Error ASSEMBLY SIMSSqlUtilities Does not exist, Please Run SIMSSQLApplicationSetup.exe and install to C:\Program Files\Microsoft SQL Server Express\MSSQL.2\MSSQL\binn

 

Still unsure what this SIMSSqlApplicationSetup.exe file is though?

[nry]

More digging around...I restored a SIMSSqlApplicationSetup.exe from our old admin server (which had SIMS on too). Running this and installing to the directory from the Event Viewer error does not fix things, it still complains in the same manner. Is there perhaps a different version of this setup exe that I need?