Tips and Troubleshooting

I am unable to login to my prior-year database. How can I resolve this issue?

If you are receiving the following message, please perform the steps below.

Message

Checking database configuration options:

Successfully connected to SQL Server; but, the database option 'IsSingleUser' is not 'off' as is expected. You must perform a 'reset single user mode' operation before logging into WinFSIM.

Exception Details - Click here to expand Exception Details associated with 'IsSingleUser' error.

Exception Details

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

Type: MarshalledException

Message: Exception has been thrown by the target of an invocation.

Source: Interop.MCSApplicationServerClient

TargetSite: MCS.Lib.FormProgress.ThrowMarshalledException

Stack Trace:

at MCS.Lib.FormProgress.ThrowMarshalledException(Exception e)

at MCS.Lib.FormProgress.LaunchBackground(IWin32Window parent, String description, String captionText, Boolean allowCancel, CallbackBase callbackBase)

at MCS.Lib.FormProgress.LaunchBackground[T](IWin32Window parent, String description, String captionText, Boolean allowCancel, Callback`1 callbackFunction, T callbackUserData, CancelRequestedCallback`1 cancelFunction)

at MCS.Lib.FormConnectApplicationServer.cmdOk_Click(Object sender, EventArgs evtArgs)

Inner Exception:

-----------------
Type: TargetInvocationException
Message: Exception has been thrown by the target of an invocation.
Source: mscorlib
TargetSite: System.RuntimeMethodHandle._InvokeMethodFast
Stack Trace:
  at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
  at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
  at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
  at System.Delegate.DynamicInvokeImpl(Object[] args)
  at Interop.MCSApplicationServerClient.VB6CallbackMarshaller.Launch()

Inner Exception:
-----------------
Type: COMException
Message: Checking database configuration options:
Successfully connected to SQL Server; but, the database option 'IsSingleUser' is not 'off' as is expected. You must perform a 'reset single user mode' operation before logging into WinFSIM.
Source: WinFSIM
TargetSite: System.RuntimeType.ForwardCallToInvokeMember
Stack Trace:
  at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
  at Interop.MCSApplicationServerClient.VB6IConnector.Connect(String serverName, String userName, String password, Boolean useWindowsAuth, String networkLibrary)
  at Interop.MCSApplicationServerClient.Connector.<ConnectUsingCurrentConnectionParams>b__5()

Step 1: From the WinFSIM login screen, enter your username and password. Then, click on the Advanced button.

Step 2: Right-click on Server Utilities and select Connect Using Windows Auth.

Step 3: Click on Reset database single-user mode to FALSE.

Step 4: You will be notified once single-user mode has been reset. Click Ok.

Step 5: Click the red X icon to close the Server Utilities window.

Step 6: Click Ok on the login screen.