Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sql2000 upgrade to sql2005

Status
Not open for further replies.
JodyLyn

JodyLyn

MIS
Sep 27, 2005
9
US
Trying to do an inplace upgrade, ran sql2005 setup which appeared to install database engine. It ran through "upgrading the database" (status bar), but all databases are still sql 2000. When i look to change compatibility level, there is no option for '90'. I did read it must be changed at the command line with something like:

start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=SQL5WTS UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

but that only gives a windows message to use Add/Remove programs from Control Panel.

please help, dont know what else to try.
 
Status
Not open for further replies.

Similar threads

bethabernathy
  • Locked
  • Question
Front End Access 365 Database dsn Connection Fails when attempting to link to 2016 SQL server
Replies
1
Views
213
dhookom
dhookom
dgillz
  • Locked
  • Question
SQL View not available to Excel Power Query
Replies
1
Views
207
dgillz
dgillz
torquinian
  • Locked
  • Question
Error 0x80131904 when trying to connect to database
Replies
0
Views
189
torquinian
torquinian
dgillz
  • Locked
  • Question
SQL Server timeouts after updating workstations to Windows 10
Replies
0
Views
194
dgillz
dgillz
tekpr00
  • Locked
  • Question
Hello I am new to a new organizatio
Replies
1
Views
100
johnherman
johnherman

Part and Inventory Search

Sponsor

Back
Top