Setup MSDE with ComputerName\InstanceName

Setup MSDE with ComputerName\InstanceName

Post by Q2hyaXN0aW » Thu, 14 Apr 2005 01:08:05

How can I install MSDE with de ComputerName\InstanceName, I dont need
(Local)\InstanceName because I need to access this database from another

I try with

setup INSTANCENAME="(ComputerName)\InstanceName" SECURITYMODE=SQL SAPWD="sa"

the error messager is "The instance name is not valid"

thanks for help


Setup MSDE with ComputerName\InstanceName

Post by Andrea Mon » Thu, 14 Apr 2005 21:28:40

hi Christian,

you only need to specify the instance name, at setup time as setup
the full instance name will later be, at runtime, (Local)\InstanceName and
".\InstanceName" and "ComputerName\InstanceName", and, as long as you
enabled the desired network protocols, it will be remotely available as
Andrea Montanari (Microsoft MVP - SQL Server) ://
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
--------- remove DMO to reply