Hi Alex,
Mike is right. We need SQL Server 2008 Express to open the database file
(.mdf). The issue occurs when we attach SQL Server 2008 database files to
SQL Server 2005 instance.
http://forums.asp.net/t/1413516.aspx
http://forums.asp.net/t/1349092.aspx
After we attach a SQL Server 2005 or SQL Server 2000 database to SQL Server
2008, the database is then automatically upgraded to SQL Server 2008.
Please see:
http://msdn.microsoft.com/en-us/library/ms189625.aspx.
When we connect to the database placed in App_Data folder, the database is
attached to a SQL Server Express user instance, which is a new feature
provided from SQL Server 2005 Express and not supported by other editions
of SQL Server, like Developer or Enterprise.
After install the SQL Server 2008 Express, its instance name should be
different from the original SQL Server 2005 Express instance name, so
please go to Microsoft SQL Server 2008 --> Configuration Tools --> SQL
Server Configuration Manager --> SQL Server Services, check the name of the
SQL Server 2008 Express instance and then modify the connection string in
your application’s Web.config file. Meanwhile, please remember to make a
copy of the your database file and database log file to avoid any data lost.
If you have any questions, please feel free to let me know.
Have a nice day, Alex!
Best Regards,
Lingzhi Sun
Microsoft Online Community Support
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.
MSDN Managed Newsgroup support offering is for non-urgent issues where an
initial response from the community or a Microsoft Support Engineer within
2 business day is acceptable. Please note that each follow up response may
take approximately 2 business days as the support professional working with
you may need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
