MSDE Tookit thinks MSDE is not installed when it is.

I have multiple applications that will use the same named instance of MSDE. When I try to setup my second application using the MSDE Deployment addin it thinks that MSDE needs to be installed again. According to the flowchart it should bypass this and
just install my appliation. Any suggestions as to why my setup insists in needs to install another instance? My instance name is the same for all applications.
Thanks,
Bill
Bill in one of the previous messages someone from Microsoft mentioned that it is a known bug in the beta version of the toolkit. Hopefully it will be fixed.
goodluck
dev
|||Thanks for the info. Does anyone know when the full release will be out?
sql

MSDE multiple instances

Hello there,
I want to install multiple instances of MSDE on XP prof edition. How many
instances can i create on a single machine?
Also, any URL for this would be helpful?
Thanks,
David
hi David,
David wrote:
> Hello there,
> I want to install multiple instances of MSDE on XP prof edition. How
> many instances can i create on a single machine?
> Also, any URL for this would be helpful?
> Thanks,
> David
you can install up to 16 instances per server, but this is a theorical limit
as you will not have enought resources to serve all of them..
each additional running instance will add about 20mb of RAM requirement but
this only is the initial load, as the real load will depend on instance
activity that will end up at the Win32 process limit of addressing up to 2gb
of RAM, and many running instances will of course bring your server down to
knees...
for additional information about SQL Server memory management, please have a
look at excellent Ken Henderson's article at
http://msdn.microsoft.com/library/de...v_03252004.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE Multiple Instance

I am trying to set up multiple instances of MSDE 2000 for use by Trend Micro virus scan products. I have the instance set up but I am trying to access svrnetcn.exe to set up named pipes and TCP/IP and I keep getting a 126 error "The Specified Module could not be found". Any ideas how to set this up.

thanks,

eric

Moving thread to Express/MSDE forum.|||

This seems to be a general Windows error that indicates that you are either missing certain DLLs that are required to launch this program. The only information I found on this specific to SQL is at http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21455359.html. Check that out and see if it sheds light on your situation.

Mike

|||

I had this same issue and ended up searching for that 126 error message. I found a somewhat related reference to an older service pack being installed than what it wanted, so maybe SVRNETCN.exe or some of its required files were corrupted. Who knows. Maybe at some point I installed an older version of MSDE over a newer version and broke it. I went to add/remove programs and removed that new Instance of Trend from the system. Then I download the MSDE 2000 SP4 install package and installed that on the system for Trend (setup.exe INSTANCENAME=Trend SAPWD="strongpwd" SECURITYMODE=sql). Once that was on I used OSQL and checked the version of MSDE to verify SP4 was there. Then I ran SVRNETCN.exe with no problems and enabled "Named Pipes" and "TCP/IP". Then I ran the Trend Control Manager install with no errors.

If you need any more specific information than that let me know and I'll dig up links for you. Good luck.