Hi,

I have SQL Server 2000(32 bit) on the Win2008 Server, if I would like to 
promote it to the SQL Server 2008 on the same machine, is it possible?
One more question, will the connection string in our client's .Net 
application need to change as well?
Thanks for help.


Jason 

1.	Backup your databases.
2.	Uninstall SQL SVR 2000 completely
3.	Install SQL SVR 2008
4.	Restore your databases

Nothing else will change except for the provider name in the connection 
string. It is now SQLOLEDB.1 - it is as easy as that unless you did some 
low level selects into system databases/SPs that have been deprecated.

Cheers,

Geoff Schaller
Software Objectives


"Jason Huang" <JasonHuang8888@hotmail.com> wrote in message 
news:uIfaLBlnKHA.4628@TK2MSFTNGP06.phx.gbl:

> Hi,
>
> I have SQL Server 2000(32 bit) on the Win2008 Server, if I would like to
> promote it to the SQL Server 2008 on the same machine, is it possible?
> One more question, will the connection string in our client's .Net
> application need to change as well?
> Thanks for help.
>
>
> Jason

In addion on Geoff's cooment I would also run Upgrade Advisor (download form 
MS site) to see depricated syntax /queries that do not work on SS2008






"Geoff Schaller" <geoffx@softxwareobjectives.com.au> wrote in message 
news:qBw7n.3491$pv.2302@news-server.bigpond.net.au...
> 1. Backup your databases.
> 2. Uninstall SQL SVR 2000 completely
> 3. Install SQL SVR 2008
> 4. Restore your databases
>
> Nothing else will change except for the provider name in the connection 
> string. It is now SQLOLEDB.1 - it is as easy as that unless you did some 
> low level selects into system databases/SPs that have been deprecated.
>
> Cheers,
>
> Geoff Schaller
> Software Objectives
>
>
> "Jason Huang" <JasonHuang8888@hotmail.com> wrote in message 
> news:uIfaLBlnKHA.4628@TK2MSFTNGP06.phx.gbl:
>
>> Hi,
>>
>> I have SQL Server 2000(32 bit) on the Win2008 Server, if I would like to
>> promote it to the SQL Server 2008 on the same machine, is it possible?
>> One more question, will the connection string in our client's .Net
>> application need to change as well?
>> Thanks for help.
>>
>>
>> Jason
>