Transfer VS 2008 Pro to a new PC does gives SQL Server access problems
- Hi,
I try to move my Visual Studio 2008 Pro Application to a new machine and get a confilct when connecting to the build-in ASPNETDB.MDF.
__Old machine:__
XP SP3
Visual Studio 2008 Pro SP1
SQL Server 2005 Developer upgraded to SP2
All side product are upgraded to newest version
__ New machine: __
XP SP3
Visual Studio 2008 Pro SP1
SQL Server 2005 Developer upgraded to SP3
All side product are upgraded to newest version
1st try: After upgrading to SP2 as the old machine has, i could not connect my VS-app to the DB. Error '... db-file has version 655 instead of version 612 ...'
2nd try: After upgrading to SP3 my SQL-server has definitly a newer version then the DB-File.
Visual Studio telling me now 'The logon flag for the user instance is not supported for this version of SQL Server. Connection is closed.' (translated from german)
I already lost many days on this. Please help
Peter Bollinger
Answers
Hi Bollingp,
More clarification with you. For your first try, did you receive the error message like the following?
The database 'C:\USERS\KVDMAST\DOWNLOADS\TEST.MDF' cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported.
If so, this issue occurs when we attach SQL Server 2008 database files to SQL Server 2005 instance.
For your second try, SQL Server 2005(Full Version) does not support the "user instance"(automatic creation of databases from code) directive in the connection string. It's a feature of SQL Server Express Edition. The connection string should be changed a lot.
Here is a useful thread that can help you a lot. See: http://forums.asp.net/p/1385767/2952030.aspx#2952030
Let me know if it works.
Thanks
Please remember to mark the replies as answers if they help and unmark them if they provide no help.- Marked As Answer bybollingp Wednesday, March 18, 2009 9:10 PM
All Replies
Hi Bollingp,
More clarification with you. For your first try, did you receive the error message like the following?
The database 'C:\USERS\KVDMAST\DOWNLOADS\TEST.MDF' cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported.
If so, this issue occurs when we attach SQL Server 2008 database files to SQL Server 2005 instance.
For your second try, SQL Server 2005(Full Version) does not support the "user instance"(automatic creation of databases from code) directive in the connection string. It's a feature of SQL Server Express Edition. The connection string should be changed a lot.
Here is a useful thread that can help you a lot. See: http://forums.asp.net/p/1385767/2952030.aspx#2952030
Let me know if it works.
Thanks
Please remember to mark the replies as answers if they help and unmark them if they provide no help.- Marked As Answer bybollingp Wednesday, March 18, 2009 9:10 PM
- Hi YiChun,
Many thanks for your very valuable answer!
To the first try:
Yes up to SQL Server 2005 SP2, I got the message '... cannot be opened because it is version 655 ...'
With SP3 this changed.
To the second try:
I uninstalled SQL Server 2005 and installed SQL Server 2005 Express Edition SP2 instead. Now I have again the message '... cannot be opened because it is version 655 ...'
Latest news: It works !!! uff... I had somehow lost permissions for the ASPNETDB
Thanks
Peter - My Project was running perfectly fine on SQl server 2005 and VS 2008!
But yesterday i just started the project in my friends laaptop which has SQL server 2008 express and visual webdeveloper with visual C# sp1!
It worked fine there also!
But after that when i tried running the project again in my own PC it showing the error that "The database is version 655 and supported only tilll 612 downgradenot possible" etc.
How do i get back to the original version? :(
