How can i use SQL Server 2000 DB in SQL Server 2005 Express. I have just installed new windows and installed only .NET Framework 2.0 products (VWD, SQL Server 2005 Express) and i need to convert the DB with its Data to 2005 express.Well i tried to copy the old DB in the App_Data folder and connect to it and here's the connection string
"Data Source=localhost\sqlexpress;DataBase=forum;Integrated Security=True"
and i think it may work [
] but it gave me this error
Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\forum.mdf". Operating system error 2: "2(error not found)". Cannot open database "forum" requested by the login. The login failed. Login failed for user 'CIPHER-CASTLE\Cipher'. File activation failure. The physical file name "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\forum_log.LDF" may be incorrect.
i think the problem is to register the asp user in the db, how can i do that in Express Edition, if that is the problem?!
"Data Source=localhost\sqlexpress;DataBase=forum;Integrated Security=True"
and i think it may work [
] but it gave me this errorUnable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\forum.mdf". Operating system error 2: "2(error not found)". Cannot open database "forum" requested by the login. The login failed. Login failed for user 'CIPHER-CASTLE\Cipher'. File activation failure. The physical file name "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\forum_log.LDF" may be incorrect.
i think the problem is to register the asp user in the db, how can i do that in Express Edition, if that is the problem?!