Scenario:
I have 64-bit Windows-7 with SQL Server 2000, 2008, 2008R2, and 2012 installed. In order to check if the undocumented function sys.fn_PhysLocFormatter runs in SQL Server 2005. I decided to install SQL Server 2005 (64-bit) to the same box as well. After installation, I encounter the following issues:
Problem 1:
When log into Database engine, login failed for machinename\theWinLogin, which has the admin right.The application log basically indicates the SQL Server Service account (local system account) does not have the permission to run the service. Weird.
Solution:
Run SQL Server explicitly as an admin.
Problem 2:
The SQL Server FullText Search service, for some reason, cannot be started. Got a timeout error.
Solution:
After installing SP4, it was OK.
Problem 3:
Facing some problems about 64-bit ASP.NET and 64-bit COM+.
Reason:
Basically I have 32-bit installed and used before. But SQL Server 2005 64-Bit needs the 64-bit.
Solution:
Followed the steps in the posts below, the problem is solved.
http://www.expta.com/2007/11/installing-or-switching-aspnet-versions.html
http://codeasp.net/blogs/vivek_iit/microsoft-net/440/sql-server-install-error-one-or-more-of-the-components-being-installed-are-already-registered-as-32-bit-components-in-the-target-application
