HostWeb Forums » Microsoft Databases » microsoft.public.sqlserver.msde » 2 msde without update interference
Topic: 2 msde without update interference
I am trying to install a second sql on the main computer, everything works
fine till I upload an update to it. Is there a way to make it work properly?
Replies below ↓
Replies
2 msde without update interference
I am trying to install a second sql on the main computer, everything works
fine till I upload an update to it. Is there a way to make it work properly?
2 msde without update interference
I am trying to install a second sql on the main computer, everything works
fine till I upload an update to it. Is there a way to make it work properly?
2 msde without update interference
I am trying to install a second sql on the main computer, everything works
fine till I upload an update to it. Is there a way to make it work properly?
Re: 2 msde without update interference
hi,
Sebastien wrote:
> I am trying to install a second sql on the main computer, everything
> works fine till I upload an update to it. Is there a way to make it
> work properly?
teoretically, up to 16 MSDE instances (at different service pack level as
well) can be installed on the same machine.. and I can confirm (not about 16
instances, but 5) it works as expected..
what do you mean by "it works fine till I upload an update to it"?
if you mean "update data", the obvious question is if you correctly provided
the instance name at connection time.. as you already know only 1 instance
of them can be the default instance, that can be referred as "(Local)" or
"ComputerName", depending on the client "position"... your second instace
will be a named instance, and it's full name is "(Local)\InstanceName" or
"ComputerName\InstanceName" (again, depending on the client "position")..
the InstanceName is te name you provided at install time and can be
verified, for instance, in the Services applet..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://www.hotelsole.com
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply