I have installed SQL Server 2005 Express on a Windows Server 2003 DC R2 SP2.
I have migrated an Access 2003 db to this Express Edition of SQL using ODBC and things work great when I am local to server and using SSMSE. When my remote users load Access DB and run queries that require ODBC connection then it fails. I have looked at most things from client side...to no avail.
Googling my way through this issue, I have found some helpful tips but no solution.
I am unable to open SS Surface Area Configuration and Configuration Manager. I get some WMI errors and/or access issues.
I have tried upgrading to full version Standard SQL and it failed during install.
I am frustrated and would like to blow it away and re-install everything, but I need to retain my 3 different dbs. Please either help with a fix or tell me the safest way to back up db and reinstall Server and bring my db's back to life.
Thanks in advance.