Showing posts with label msde2000. Show all posts
Showing posts with label msde2000. Show all posts

Friday, March 30, 2012

Installing multiple instances of MSDE2000

Hello
I installed 2 instances of msde , installation passed ok but noone can
connect to my machine , i portscanned host machine and port 1443 is not
opened ,can it be becaus i installed it on a VmWare console, any help is
apriciated.
PS I didn't forget to set DISABLENETWORKPROTOCOLS=0.
Thx in advance
__________
TomislavFist you need to find out what the instance names are and whether one is a
default instance (both are probably named instances as no-one is listening
to port 1433).
Use either server network utility, svrnetcn.exe, or check the services in
the machine. After you know the instance names, you connect using:
machinename\instancename
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Tomislav Zemljak" <tomislav.zemljak@.*maknime*bj.tel.hr> wrote in message
news:c3rn9s$ksm$1@.sunce.iskon.hr...
> Hello
> I installed 2 instances of msde , installation passed ok but noone can
> connect to my machine , i portscanned host machine and port 1443 is not
> opened ,can it be becaus i installed it on a VmWare console, any help is
> apriciated.
> PS I didn't forget to set DISABLENETWORKPROTOCOLS=0.
> Thx in advance
> __________
> Tomislav
>|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote:
> Fist you need to find out what the instance names are and whether one is a
> default instance (both are probably named instances as no-one is listening
> to port 1433).
One is default instance , other is named "second"
> Use either server network utility, svrnetcn.exe, or check the services in
> the machine. After you know the instance names, you connect using:
> machinename\instancename
That didn't solve it ... both instances are started and appear to be
working on host machine , remote users still cant connect and portscann
shows that port 1443 isn't open .Thx for trying thou.|||You don't say whether these instances are both named or one is a default def
ault instance. You cannot have two
default instances. My guess is that you have two names instance. A named ins
tance does NOT listen on 1433.
Please follow my direction closely to find out whether these are default or
named instances and the name of
the instance.
This is what I write in my earlier post:

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Tomislav Zemljak" <tomislav.zemljak@.*maknime*bj.tel.hr> wrote in message news:c3s99i$4ge$1
@.sunce.iskon.hr...
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote:
> One is default instance , other is named "second"
> That didn't solve it ... both instances are started and appear to be
> working on host machine , remote users still cant connect and portscann
> shows that port 1443 isn't open .Thx for trying thou.
>|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote:
> You don't say whether these instances are both named or one is a default
default instance.
As i already wrote (look below) one is default instance , other is named
"second".
I "fixed" the problem by reinstalling both instances , now they work , thx
for tryng to help !
You cannot have two
> default instances. My guess is that you have two names instance. A named
instance does NOT listen on 1433.
> Please follow my direction closely to find out whether these are default
or named instances and the name of
> the instance.
> This is what I write in my earlier post:
>
in
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Tomislav Zemljak" <tomislav.zemljak@.*maknime*bj.tel.hr> wrote in message
news:c3s99i$4ge$1@.sunce.iskon.hr...
wrote:
is a
listening
in
>

Installing MSDE2000 sp3 - help

Hiya folks,
I'm a newbie at this, so forgive the ignorance that I may display!
I have installed a software package on my system that installs MSDE through
merge modules contained in its MSI. I have several workstations that
connect. Unfortunately, with SP2 coming down the pipe for windows xp, i
have to do lots of fancy stuff to make sure they still connect (it uses
named pipes tcp/ip). The solution according to microsoft is to install SP3
for sql...i've downloaded the MSDE version of the upgrade, and attempted to
install for several hours with no luck.
First, it said i required a strong password, which i supplised in the
setup.ini:
[options]
sapassword="mypassword"
Things started to load, and then the installer quit. Confused, I started it
again. Now the installer is giving me '
the instance name specified is invalid'
Ok, so i go back to the setup.ini and add a line
[options]
sapassword="mypassword"
instancename="liveddm"
and STILL, i get the invalid instance name error message. No matter what I
seem to try, it is telling me i have an invalid instance name; if i use
enterprise manager, i can clearly see my instance and browse the attached
database. I've also tried instancename="computername\liveddm" with no luck.
Any help would be greatly appreciated.
Thanks!
Sheldon
sheldon@.REMOVETHISthedoctorcompany.com
Sheldon Purkiss wrote:
> Hiya folks,
> I'm a newbie at this, so forgive the ignorance that I may display!
> I have installed a software package on my system that installs MSDE through
> merge modules contained in its MSI. I have several workstations that
> connect. Unfortunately, with SP2 coming down the pipe for windows xp, i
> have to do lots of fancy stuff to make sure they still connect (it uses
> named pipes tcp/ip). The solution according to microsoft is to install SP3
> for sql...i've downloaded the MSDE version of the upgrade, and attempted to
> install for several hours with no luck.
> First, it said i required a strong password, which i supplised in the
> setup.ini:
> [options]
> sapassword="mypassword"
> Things started to load, and then the installer quit. Confused, I started it
> again. Now the installer is giving me '
> the instance name specified is invalid'
> Ok, so i go back to the setup.ini and add a line
> [options]
> sapassword="mypassword"
> instancename="liveddm"
> and STILL, i get the invalid instance name error message. No matter what I
> seem to try, it is telling me i have an invalid instance name; if i use
> enterprise manager, i can clearly see my instance and browse the attached
> database. I've also tried instancename="computername\liveddm" with no luck.
> Any help would be greatly appreciated.
> Thanks!
> Sheldon
> sheldon@.REMOVETHISthedoctorcompany.com
>
>
>
Hi Sheldon
Unfortunately, I believe that if your software vendor has installed MSDE
using merge modules from within their own MSI they will need to supply
you with the patch package themselves.
See http://www.microsoft.com/sql/downloads/2000/sp3.asp
Tony

Installing MSDE2000

Hi,
I've been trying to follow Microsoft's instructions on installing MSDE2000 for Visual Studio. I do instancename=VSDOTNET SECURITY=SQL SAPWD=XXXX and all that. When I reboot, I notice that I have no services in the SQL Service Manager, nor can it find my computername.

Anybody know why this is?This is on Windows XP professional SP1.

Monday, March 12, 2012

installation problem

Hi,
I am facing a problem installing MSDE2000 on some computers. When i run my application setup program MSDE gets installed on some computers while it does not install on some others consistently.
I am using a merge module to install MSDE2000 with InstallShiel 9.
The target OS is NT4.0 SP6.
Any inputs will be most welcome.
regards,
Henry
Make sure you download the DevStudio 9.01 service pack from Install Shield
(just to do Tools | Check for Updates from within DevStudio). The merge
module for SQL gets updated with that. Otherwise, Install Shield tech
support might suggest to use the Install Shield redistributable for MSDE
instead.
************************************************** *****************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
************************************************** *****************
"Henry" <anonymous@.discussions.microsoft.com> wrote in message
news:EAFBF9A8-B3A3-4D55-82B7-78F4224CB685@.microsoft.com...
> Hi,
> I am facing a problem installing MSDE2000 on some computers. When i run my
application setup program MSDE gets installed on some computers while it
does not install on some others consistently.
> I am using a merge module to install MSDE2000 with InstallShiel 9.
> The target OS is NT4.0 SP6.
> Any inputs will be most welcome.
> regards,
> Henry