I'll have to do some more research on this issue. If I read your suggestion correctly, I can change the compatibility level merely by changing the number and then doing another backup and restore? This seems too good to be true. My ISP tech support staff have just confirmed my suspicion that my database's compatibility level is 80 it was originally built on SQL Server 2000. Is this a known problem with SQL Server Express 2005 and 64 bit Windows 7? What should I be doing that I'm not?
When the install says it's complete, I have no Surface Area configuration tool in my start menu, and Management Studio Express can't find a local database server to connect to. I searched the log directory for the string "database services" and found nothing usable. It refers me to the setup log for detail but when I click on the link nothing comes up. (I can't find such a file on my disk.)Īctually with SP3 I got a new error: SQL Server Database Services install failed. It complains that it can't find the installation package for Microsoft SQL Server Native Client and says to try again with the installation package sqlncli_圆4.msi.
A compatibility check said, not compatible.) (I tried downloading and installing a 32-bit ASP.Net package and the installer wouldn't even run. It complains that only 64-bit ASP.Net is registered and it needs 32-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit). The Windows 7 answer site suggested I needed SP3, so I downloaded the SP3 installer (the EXE) but I get the same errors I got with the unpatched version: I'm trying to rebuild my web development interface, which means I'm trying to install SQL Server Express 2005 and SQL Server Management Studio Express 2005, which I've been using on Vista. I recently rebuilt my Windows Vista Home Premium laptop with Windows 7 Ultimate I also went from 32-bit to 64-bit.