Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
logikos
Starting Member
1 Post |
 Posted - 2006-10-30 : 10:34:07
|
| I just installed 2005 and accepted all the defaults to upgrade the default instance of 2000 as prompted. I also upgraded the Sharepoint instance. However, when I open the SQL Server Mgnt Studio, my server shows 8.0.2039 as the version, which is 2000The whole installation process went fine including sp1. I looked in Services to see if there was more than one instance of SQL Server, and there isn't. Also, all my database files are still in the old 2000 (mssql\data) directory. Any ideas, solutions? Thank you.This issue is also preventing the proper initialization of Reporting Services, which did not exist in 2000, but am installing a new instance in 2005. Using the configuration utility, all steps are fine until I reach the point where it tries to connect, then it reports an error when verifying database version. |
|
|
schuhtl
Posting Yak Master
102 Posts |
Posted - 2006-10-31 : 14:53:58
|
| Have you tried changing the compatibility level for each database (right click database>options>choose compatibility level)? When you upgrade the compatibility level does not change. You have to manually change it. |
 |
|
|
|
|
|
Upgraded 2000 to 2005; database still 2000