SQL Server Express 2005 Database Access Through 2008 64-bit SSMS
I have a Vista 64-bit laptop. I first tried to install the 64-bit version of SQL Server Express 2005 on my machine, but no matter what I tried, only the 32-bit version seemed to work ... so this is what was installed.
SQL Server Express 2005 32-bit worked fine, but I recently installed SQL Server Express 2008 64-bit - with all the tools and features. During installation, it correctly recognized my 2005 database, but I had to uninstall my 2005 SSMS before I could install the 2008 version.
This is fine, but the problem is that when I try to access an existing 2005 database through SSMS 2008 it gives me the following message:
"Database planning board not available (Object Explorer)"
- where "plan board" is the name of my 2005 database.
Does anyone have any idea how to get around this error / problem?
- Thanks Mike S.
source to share
I found the answer after doing a little google research. My password for my 2005 copy was different from my 2008 copy. Also, while I could log into the 2005 instance using Windows Authentication, I was unable to access the plan holder database. After logging in with my old 2005 password, I was able to see the database. Then I discovered that the 2005 instance did not have a Windows username as a login with rights to the planboard database.
I'm not really sure why it worked before then and then didn't work after installing 2008 ... but after entering my Windows username as a SQL Server login to the 2005 instance and granting it rights to the planned database ... Now I can login using Windows Authentication to access the 2005 database.
I thought it was a 32x 64bit issue, but it was a security issue.
source to share