| Author |
Topic |
|
nj_developer
Starting Member
5 Posts |
 Posted - 2010-01-25 : 06:55:18
|
| Hi,I Installed sql server 2008(Express Edition) successfully.when I attach the database display below error: |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-25 : 06:56:03
|
| whats the error message? |
 |
|
|
nj_developer
Starting Member
5 Posts |
Posted - 2010-01-25 : 07:01:16
|
| the database 'D:\portal\app_data\aspnetdb.mdf' cannot be opened because it is version 655.this server support version 612 and earlier. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-25 : 07:03:16
|
quote:
Originally posted by nj_developer
the database 'D:\portal\app_data\aspnetdb.mdf' cannot be opened because it is version 655.this server support version 612 and earlier.
the error message is self explanatory. you're trying to attach created using later version onto earlier version server. if you need to do this make sure you upgrade server to be of version 655 or higher |
|
|
|
nj_developer
Starting Member
5 Posts |
Posted - 2010-01-25 : 07:10:09
|
| How upgrade to version 655? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-01-25 : 07:21:50
|
Version 655 is SQL Server 2008.select name, version from sys.sysdatabases
N 56°04'39.26"E 12°55'05.63" |
|
|
|
nj_developer
Starting Member
5 Posts |
Posted - 2010-01-25 : 07:23:50
|
| I have and installed sql server 2008!!! |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-25 : 07:25:55
|
quote:
Originally posted by nj_developer
I have and installed sql server 2008!!!
have you installed sql 2008 or is it just that you've sql 2008 client tools?SELECT SERVERPROPERTY('productversion') |
|
|
|
nj_developer
Starting Member
5 Posts |
Posted - 2010-01-25 : 07:29:01
|
| product:Microsoft SQL Server Express Editionversion:9.00.3042.00 |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-25 : 07:38:38
|
| "I Installed sql server 2008(Express Edition) successfully."and"product:Microsoft SQL Server Express Editionversion:9.00.3042.00"Version 9.xx is SQL 2005 ... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-25 : 10:01:37
|
quote:
Originally posted by Kristen
"I Installed sql server 2008(Express Edition) successfully."and"product:Microsoft SQL Server Express Editionversion:9.00.3042.00"Version 9.xx is SQL 2005 ...
so my guess was right. its only the client tool that's sql 2008 not actual server he's connecting to  |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-25 : 10:12:12
|
| Or two instances, perhaps? (Connecting to SQL 2005 by default?) |
|
|
|
|
Attach database error