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.
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another.
Base the dependent combo on a query for its row source:
Add a reference to the first combo on the form as criteria i…