Error while trying to connect open project tracker database files

Error while trying to connect open project tracker database files

Old forum URL: forums.lhotka.net/forums/t/10946.aspx


aravinda_sn posted on Monday, December 05, 2011

I am getting an error while trying to open aspnetdb.mdf and PTracker.mdf .I am using SQ: Server 2008 R2 express. Here is a part of the error message:

cannot be opened because it is version 655. This server supports version 611 and earlier. A downgrade path is not supported

JonnyBee replied on Tuesday, December 06, 2011

According to this info version 611 is SqlServer 2005 Express and NOT using SqlServer 2008 R2. http://weblogs.sqlteam.com/dang/archive/2011/07/17/internal-sql-server-database-version-numbers.aspx

Plaease make sure that your selected SqlServer Express, in Visual Studio 2010 - goto Tools - Options - Database Tools - Data Connections is set to an instance of SqlServer 2008 Express R2 and you may have to edit the connection string in web.config too.

RockfordLhotka replied on Tuesday, December 06, 2011

Jonny is corrrect. And I just went through this too, because I reinstalled Win7 on my laptop. What a pain!

My frustration (and solution) is here:

http://www.lhotka.net/weblog/CommentView,guid,1b5df3cb-faa4-4798-9a8e-2339a1b61aa9.aspx#commentstart

 

aravinda_sn replied on Tuesday, December 06, 2011

Thanks for the info. But since the solution involved reinstallation(s), I thought I would try that as a last resource. So I looked for more info from the web. I found this article which enable me to open protracker.mdf file from sql server 2008 express.

http://learningsqlserver.wordpress.com/2011/02/13/how-can-i-open-mdf-and-ldf-files-in-sql-server-attach-tutorial-troublshooting/

After that I tried similar approach to connect from Visual studio 2010 and it worked. Then I modified the connection string to use correct server name. Then I was able to run project tracker successfully.

Copyright (c) Marimer LLC