I got sql 2000 installed on my machine. I got a sql 2000 database instance on my computer and I installed sql 2005 server enterprise but I have got no server instance from sql 2005 like what i have in sql 2000 when i first install, i can have an own server instance on my computer.
is it becos when i have a previous sql 2000 server instance on my computer?
Your SQL server 2000 is probably installed as the 'default' instance. You can keep the default instance at version 2000, and install a 'named' instance for 2005. Or upgrade your default instance to 2005.
Look for the screen during setup that asks (radio buttons)
1) default instance, or
2) named instance. (to create a new named instance you need to type in a name for the instance)
|||how do i install a named instance? i need to uninstall sql 2005?|||i tried upgrading but the sql 2000 instance has errors when upgrading...|||i dun have the adventure works database....only northwind in sql 2000|||You can create several named instances on the same computer, so you don't need to uninstall. (you can have 50 named instances with enterprise version)
To create a named instance from the command line you can type this: (this is a single command)
start /wait setup.exe /qb INSTANCENAME=brohans ADDLOCAL=SQL_Engine,Client_Components,SQLXML SAPWD=b2r0o0h6ans
Or use the setup interface and select the radio button for a named instance then type in brohans for the instance name.
|||i install the adventureworks database....in my sql 2005
this article is helpful.
http://msdn2.microsoft.com/en-us/library/ms143804.aspx
No comments:
Post a Comment