SQL Server 08 evaluation upgrade to developers edition

Question

SQL Server 08 evaluation upgrade to developers edition

isuckatsql

SSChampion

Points: 10381
More actions
December 22, 2008 at 8:15 am

#204449

i am doing an upgrade from SQL Server 2008 Evaluation Edition to Developers Edition.
Should i uninstall the Evaluation Edition or is it OK to install the developers edition as a new instance ?
Thanks

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 1

You should be able to do a inplace upgrade from Evaluation to Developer in 2008 without problems.

isuckatsql SSChampion Points: 10381 More actions · Answer 2

isuckatsql

SSChampion

Points: 10381

December 22, 2008 at 1:42 pm

#916376

Thanks:)

isuckatsql SSChampion Points: 10381 More actions · Answer 3

How do you access the second instance ?

I have the original default instance, which was the Evaluation Edition, and a new instance which is named 'Developer Edition'.

In SQL Mgmt Studio it always goes to the Default Instance.

Thanks

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 4

Type .\Developer Edition in server name box under management studio.

MJ

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 5

You shouldn't have had to install the named instance. You should have been able to migrate the default instance from Eval to Dev using the installer. This would be equivalent to a SKUUPGRADE=1 in 2005.

isuckatsql SSChampion Points: 10381 More actions · Answer 6

Thanks for the feedback.

Once i copy my DB's over, can i not just delete the original instance ?

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 7

You can, but SQL 2008 is then running in a named instance. I prefer to keep it in the default instance unless it is intentionally going to be a multi-instance server.

isuckatsql SSChampion Points: 10381 More actions · Answer 8

I restored my DB to the new instance and now get:

Microsoft SQL Server Login

Connection failed:

SQL State: '01000'

SQL Server Error: 53

[Microsoft][ODBC SQL Server Driver][DBNETLIB]

Connection open

(connect ( ) )

Connection failed:

SQL State: '08001'

SQL Server Error: 17

Nothing has really changed other than the new instance ?

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 9

Did you change your connection string to point to the named instance?

isuckatsql SSChampion Points: 10381 More actions · Answer 10

yes and when i do an ODBC test connection it works ?

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 11

Please write a full question in your post and provide information for people that are scanning the forums. The full title doesn't appear and we are not using that to figure out what you are asking.

isuckatsql SSChampion Points: 10381 More actions · Answer 12

I dont understand ?

I asked a full question and was in the middle of an ongoing dialogue.

Where would you lioke me to add information ?

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 13

What are the network protocols enabled for this new instance?

MJ

isuckatsql SSChampion Points: 10381 More actions · Answer 14

isuckatsql

SSChampion

Points: 10381

December 23, 2008 at 11:31 am

#916956

Not sure what you mean ?