CODEWITHSUNDEEP
sql-serverms-access
user310291
user310291

Reputation: 38190

Is SQL Server Installation 2008 Express reliable enough to replace MS Access?

I have tried to install SQL Server Express 2008 on several pcs of different brands. I have no luck or what: nearly each time I get something which prevents it from installing.

Just now I got "Performance counter registry hive consistency check" failed and solution is overwelmingly complex http://support.microsoft.com/kb/300956.

How can one choose SQL Server Express 2008 as a local pc database vs MS Access as a good choice for selling an application knowing that clients risk to encounter such unsolvable problem for most of them as they are not even expert users ?

Why do so many people push for SQL Server ? Is it really objective ?

As a User myself, I have downloaded many softwares which uses SQL Server Express 2008, since I can't install, I just gave up, I won't even complain because I fear most often they wouldn't even bother (and registering for support is always a hassle). That is companies are losing potential clients without even knowing it !

Upvotes: 3

Views: 371

Answers (2)

Tassisto
Tassisto

Reputation: 10345

Run the SQL Server 2008 installer again and complete these steps.

  1. I exported the 009 tree with regedit to Perflib.reg
  2. Opened the Perflib.reg in Notepad
  3. Replaced "[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\009]" to "[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\013]"
  4. Save the file
  5. Finally double click the Perflib.reg file.

This should work, you can find more here.

Upvotes: 0

Christian Specht
Christian Specht

Reputation: 36431

If you just want a local database that you can distribute with your application, do you really need the full-blown SQL Server Express, which needs to be installed?

I think an embedded database (SQL Server CE, SQLite...) is what you need.
They don't require any installation at all, you just have to distribute a few assemblies with your application.

Upvotes: 3

Related Questions