for sure, i don't even have a reg key under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MicrosoftSQLServer called MSSQLServer

the answer is defininately

Change the following key to have a value of 2:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\LoginMode

This code should work better as you don't need the reference to the object loaded for it to work

dim oapp as object

Set oapp = createobject("SQLDMO.Application")

Debug.Print oapp.VersionMajor & "." & oapp.VersionMinor

🙂

...