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 |
|
rsmerker
Starting Member
11 Posts |
 Posted - 2008-12-09 : 10:32:49
|
| I have a couple versions of SQL 2008 that i need to integrate with a few programs that i run. However the programs do not support/work well with SQL2008. I was reading somewhere that you can "downgrade" SQL2008 to SQL2005. This will in essence install/run SQL2005 using the SQL2008 installation. Is this possible?*Normally you would think that it would be backwards compatible and work just fine, but i am finding that is not the case.**The SQL installation disks have already been purchased so i am stuck with them so I have to try and get them to work without purchasing 2005. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-09 : 10:41:54
|
do you mean changing compatibility level? then just try changing it to 90 to make it behave like sql 2005.This can be done as followsEXEC sp_dbcmptlevel youdb,90 |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-12-09 : 10:42:04
|
| put your database into the 90 compatibility mode.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
|
|
|
rsmerker
Starting Member
11 Posts |
Posted - 2008-12-09 : 11:05:33
|
| Thanks. I am looking into this. I found that one of my programs creates the database during its installation so you can not create it in SQL first or it will not work. I tried to change the compat mode on the "model" database to see if that would work because i think that is what the program uses to create the database and it still did not work.lol, if only things would go as planned (and the ordering department would have gotten me 2005 like i asked) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-09 : 11:07:39
|
quote:
Originally posted by rsmerker
Thanks. I am looking into this. I found that one of my programs creates the database during its installation so you can not create it in SQL first or it will not work. I tried to change the compat mode on the "model" database to see if that would work because i think that is what the program uses to create the database and it still did not work.lol, if only things would go as planned (and the ordering department would have gotten me 2005 like i asked)
did you get any error? |
|
|
|
rsmerker
Starting Member
11 Posts |
Posted - 2008-12-09 : 11:22:59
|
| It is saying "unable to connect to SQL server" make sure that the service is running, and that the administrator account password supplied is correct. If i check the logs inside the Mgmt studio it isn't even showing that the program is even trying to access it. Both programs are located on the same server so it isn't being blocked network wise. |
|
|
|
rsmerker
Starting Member
11 Posts |
Posted - 2008-12-09 : 11:24:27
|
| bty, it did let me change the compat lvl on the model, it just wouldn't let me create the database when installing the other program (foundstone security scanner) |
|
|
|
|
|
|
SQL2008 --> SQL2005