Greetings.
I just installed MSDE 2000A
How can I install northwind database on it ?
I looked up on the net and it asks you to install vs2003 version of MSDE
So do I have to del this and install the other MSDE ?
Coz I did run the ConfigSamples.exe from my VS 2003 sdk directory, but it
did not install northwind database for me.
Thanks
Hemang
http://www.microsoft.com/downloads/d...displaylang=en
should help.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Hemang Shah" <hemang@.hemang.net> wrote in message
news:CfGdnTTggswyXX_cRVn-qg@.rogers.com...
> Greetings.
> I just installed MSDE 2000A
> How can I install northwind database on it ?
> I looked up on the net and it asks you to install vs2003 version of MSDE
> So do I have to del this and install the other MSDE ?
> Coz I did run the ConfigSamples.exe from my VS 2003 sdk directory, but it
> did not install northwind database for me.
> Thanks
> Hemang
>
Showing posts with label installed. Show all posts
Showing posts with label installed. 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
>
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 MSDTC Resource after installing SQL Server 2000 cluster
Is it possible to install and configure the MSDTC resource in a SQL Server 2000 cluster after SQL is installed and running?
When I recently went through a rebuild of my cluster, I forgot to install the resource before installing SQL Server. Now, if I install and bring online the MSDTC resource the SQL disk groups will not fail over correctly. The SQL Server resource will not come online.
Thanks in advance for any help. I would really like to avoid rebuilding again.
Andy
I am not an expert on clusters but you might want to check out the following article
http://support.microsoft.com/kb/294209/en-us
Michelle
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
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 MSDE??
Ok I installed the MSDE and after following the steps the last message box says to go to the control panel and install and configure the components.
I'm not sure what to do once I'm in the control panel.
Thank you.Somewhere along the way did you try to install MSDE but were unsuccessful? What is the exact wording of the message you are receiving?
Terri|||I am also having a problem with the installation of MSDE. About 2/3's the way through the installation the process froze. I cannot uninstall or re-install. The message I am receiving is that the installation was tampered with and needs to be uninstalled and re-installed. When I go to My Computer, Install/Uninstall Software, SQL Server is not listed.
Any suggestions?|||Well, searching the SQL Server and MSDE Forum here for posts from others who have experienced the same thing is a good start. And then starting a new thread with your own particular situation with the exact error messages would be the next step.
Terri|||i have the same probleme.
in my case it was an error of directory\subdirectory
c:\sql2ksp3\MSDE>
don't forget the MSDE subdirectory !! ;)
then type the command : setup SAPWD=xxxx SecurityMode=SQL
i hope it can help you.sql
Installing MSDE SQL 2000 SP4
I was working on a install for MSDE SQL SERVER 2000 when I noticed that there
was a more recent version available. I have not yet installed and wanted to
kow if the Service Pack 4 for Microsoft SQL Server 2000 - Desktop Engine
(MSDE 2000) included the Microsoft SQL Server 2000 - Database Engine
Components and the Service Pack 4 for Microsoft SQL Server 2000 - Analysis
Services Components in it's install or do I have to install them after I set
up the engine for the first time. Let me re-iterate that I am not upgrading
an instance rather I am trying to install an instance with the SP4 updates,
hoping that I get all of the tools that I can in one shot.
ANDREA,
Thank you for your answer. I have another question. I am sending these
files across a network and trying to automate the installation. I know how
to automate the MSDE install after I have extracted the files from the
SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE, but is there a way to use command
lines to extract silently or maybe even feed it a path to extract to? That
way I only have to worry about one file?
ANdrew
"Andrea Montanari" wrote:
> hi,
> Thunda wrote:
> you can directly go with the sp4 version... it can both install fresh sp
> level MSDE instances as long as upgrade existing pre-sp4 instances..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>
>
was a more recent version available. I have not yet installed and wanted to
kow if the Service Pack 4 for Microsoft SQL Server 2000 - Desktop Engine
(MSDE 2000) included the Microsoft SQL Server 2000 - Database Engine
Components and the Service Pack 4 for Microsoft SQL Server 2000 - Analysis
Services Components in it's install or do I have to install them after I set
up the engine for the first time. Let me re-iterate that I am not upgrading
an instance rather I am trying to install an instance with the SP4 updates,
hoping that I get all of the tools that I can in one shot.
ANDREA,
Thank you for your answer. I have another question. I am sending these
files across a network and trying to automate the installation. I know how
to automate the MSDE install after I have extracted the files from the
SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE, but is there a way to use command
lines to extract silently or maybe even feed it a path to extract to? That
way I only have to worry about one file?
ANdrew
"Andrea Montanari" wrote:
> hi,
> Thunda wrote:
> you can directly go with the sp4 version... it can both install fresh sp
> level MSDE instances as long as upgrade existing pre-sp4 instances..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>
>
Installing MSDE 2000a
I have downloaded MSDE 2000a and installed it from the run command on Windows
XP SP2 but can only connect with the login "Trusted NT connection" and not
with the sa login. Can someone please give me the correct command to type to
install with sql or mixed authentication.
http://support.microsoft.com/default...b;en-us;319930
look at the heading "Enable Mixed Mode Authentication After Installation"
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"cwsjnr" wrote:
> I have downloaded MSDE 2000a and installed it from the run command on Windows
> XP SP2 but can only connect with the login "Trusted NT connection" and not
> with the sa login. Can someone please give me the correct command to type to
> install with sql or mixed authentication.
XP SP2 but can only connect with the login "Trusted NT connection" and not
with the sa login. Can someone please give me the correct command to type to
install with sql or mixed authentication.
http://support.microsoft.com/default...b;en-us;319930
look at the heading "Enable Mixed Mode Authentication After Installation"
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"cwsjnr" wrote:
> I have downloaded MSDE 2000a and installed it from the run command on Windows
> XP SP2 but can only connect with the login "Trusted NT connection" and not
> with the sa login. Can someone please give me the correct command to type to
> install with sql or mixed authentication.
Installing MSDE 2000 on Server with SQL 2005 Express
Can anybody help?
I have a Windows XP and 2003 server; we have installed SQL 2005 Express on it but have an application that installs MSDE 2000 to connect to an application. After the MSDE 2000 is installed we can no longer see the instance across the network. If we uninstall the SQL 2005 express version we can see the Instance in MSDE 2000.
Is there any compatibility issue with install MSDE 2000 after SQL 2005 has been installed.
Many Thanks in advance
David
In general, this should work. There are specific limitations, which I think are well spelled out in BOL. Here's a copy and paste; hopefully this will describe your issue:
In SQL Server 2000, the identification of the server connection endpoints was performed by the SQL Server service. SQL Server 2005 replaces that function with the SQL Server Browser service. If you install SQL Server on a computer that is also running SQL Server 2000 or MSDE, you must ensure that SQL Server 2000 or MSDE is upgraded to Service Pack 3 (SP3) or later. Versions prior to SP3 do not properly share port 1434 and may not make your SQL Server instances available to requesting client applications. Although you can change the services startup order so that the SQL Server Browser service starts before SQL Server 2000 or MSDE, the recommended resolution is to update all older versions of SQL Server to the latest service pack.
When an instance of SQL Server 2000 is installed on the computer, if the SQL Server Browser is not running, the SQL Server 2000 listener service starts. If SQL Server Browser starts after the listener service, it waits 5 seconds for SQL Server 2000 to give up port 1434. If that does not occur, SQL Server Browser fails to start. To resolve this problem with versions of SQL Server 2000 prior to service pack 3, stop SQL Server 2000, start SQL Server Browser, then restart SQL Server 2000. The SQL Server 2000 listener service continues to attempt to start on port 1434, so the SQL Server 2000 instance should be upgraded to service pack 3 as soon as possible.
SQL Server 7.0 had no similar capabilities and has no conflicts with SQL Server Browser.
Installing MSDE 2000 on a system with SQL Express 2005
I noticed that when I install an app that uses MSDE 2000 on my system (which
has SQL Express 2005 installed) the MSDE setup will load and hang at "11
minutes" remaining. I can't cancel it, clicking Cancel switches the dialog
to say "Cancelling" but nothing ever happens.
Is it possible for MSDE 2000 to co-exist with SQL Express 2005 on a system?
If yes, how?
Thanks for your help!
hi Pyil,
Phil Palios wrote:
> I noticed that when I install an app that uses MSDE 2000 on my system
> (which has SQL Express 2005 installed) the MSDE setup will load and
> hang at "11 minutes" remaining. I can't cancel it, clicking Cancel
> switches the dialog to say "Cancelling" but nothing ever happens.
> Is it possible for MSDE 2000 to co-exist with SQL Express 2005 on a
> system? If yes, how?
yes it should be ... do not know if MSDE 2000 should be previously installed
than SQLExpress, but should be..
please provide the
/L*v "c:\MsdeLot.txt"
parameter to the setup.exe boostrap installer in order to allow verbose
logging of the installation process.. this will result in an about
2mb(succesfull installation) text file you can inspect for
RETURN VALUE 3
entries... about 10/15 lines before each entry, some (sometime cryptic)
description of the problem will be reported..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
I opened up the MSDE log and there are no lines that contain "value 3" my
guess for this is that since setup hung it never was able to log a value 3
and exit gracefully.
The last two lines in the log are:
Starting custom action InstallSqlRedis
Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlredis.exe
/q:a"
So it appears that sqlredis.exe may be what is hanging, and the MSDE install
is not hearing back so it hangs. Any ideas on what is going on and how it
may be fixed?
Thanks so much!
-Phil
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3t11onFprggaU1@.individual.net...
> hi Pyil,
> Phil Palios wrote:
> yes it should be ... do not know if MSDE 2000 should be previously
> installed than SQLExpress, but should be..
> please provide the
> /L*v "c:\MsdeLot.txt"
> parameter to the setup.exe boostrap installer in order to allow verbose
> logging of the installation process.. this will result in an about
> 2mb(succesfull installation) text file you can inspect for
> RETURN VALUE 3
> entries... about 10/15 lines before each entry, some (sometime cryptic)
> description of the problem will be reported..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Phil,
Phil Palios wrote:
> Hi Andrea,
> I opened up the MSDE log and there are no lines that contain "value
> 3" my guess for this is that since setup hung it never was able to
> log a value 3 and exit gracefully.
> The last two lines in the log are:
> Starting custom action InstallSqlRedis
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\sqlredis.exe /q:a"
> So it appears that sqlredis.exe may be what is hanging, and the MSDE
> install is not hearing back so it hangs. Any ideas on what is going
> on and how it may be fixed?
>
you can not fix this, as this problem is raised by MDAC setup itself... but
you can hack it... it's not supported but you can do it...
first install the latest MDAC stack manually, then run MSDE setup.exe
boostrap installer...
when MSDE setup hangs, kill setupre.exe process via Task Manager, then the
setup will proceed and complete successfully...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
has SQL Express 2005 installed) the MSDE setup will load and hang at "11
minutes" remaining. I can't cancel it, clicking Cancel switches the dialog
to say "Cancelling" but nothing ever happens.
Is it possible for MSDE 2000 to co-exist with SQL Express 2005 on a system?
If yes, how?
Thanks for your help!
hi Pyil,
Phil Palios wrote:
> I noticed that when I install an app that uses MSDE 2000 on my system
> (which has SQL Express 2005 installed) the MSDE setup will load and
> hang at "11 minutes" remaining. I can't cancel it, clicking Cancel
> switches the dialog to say "Cancelling" but nothing ever happens.
> Is it possible for MSDE 2000 to co-exist with SQL Express 2005 on a
> system? If yes, how?
yes it should be ... do not know if MSDE 2000 should be previously installed
than SQLExpress, but should be..
please provide the
/L*v "c:\MsdeLot.txt"
parameter to the setup.exe boostrap installer in order to allow verbose
logging of the installation process.. this will result in an about
2mb(succesfull installation) text file you can inspect for
RETURN VALUE 3
entries... about 10/15 lines before each entry, some (sometime cryptic)
description of the problem will be reported..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
I opened up the MSDE log and there are no lines that contain "value 3" my
guess for this is that since setup hung it never was able to log a value 3
and exit gracefully.
The last two lines in the log are:
Starting custom action InstallSqlRedis
Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlredis.exe
/q:a"
So it appears that sqlredis.exe may be what is hanging, and the MSDE install
is not hearing back so it hangs. Any ideas on what is going on and how it
may be fixed?
Thanks so much!
-Phil
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3t11onFprggaU1@.individual.net...
> hi Pyil,
> Phil Palios wrote:
> yes it should be ... do not know if MSDE 2000 should be previously
> installed than SQLExpress, but should be..
> please provide the
> /L*v "c:\MsdeLot.txt"
> parameter to the setup.exe boostrap installer in order to allow verbose
> logging of the installation process.. this will result in an about
> 2mb(succesfull installation) text file you can inspect for
> RETURN VALUE 3
> entries... about 10/15 lines before each entry, some (sometime cryptic)
> description of the problem will be reported..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Phil,
Phil Palios wrote:
> Hi Andrea,
> I opened up the MSDE log and there are no lines that contain "value
> 3" my guess for this is that since setup hung it never was able to
> log a value 3 and exit gracefully.
> The last two lines in the log are:
> Starting custom action InstallSqlRedis
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\sqlredis.exe /q:a"
> So it appears that sqlredis.exe may be what is hanging, and the MSDE
> install is not hearing back so it hangs. Any ideas on what is going
> on and how it may be fixed?
>
you can not fix this, as this problem is raised by MDAC setup itself... but
you can hack it... it's not supported but you can do it...
first install the latest MDAC stack manually, then run MSDE setup.exe
boostrap installer...
when MSDE setup hangs, kill setupre.exe process via Task Manager, then the
setup will proceed and complete successfully...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Installing MSDE
Hello All:
I am having a problem with installing MSDE. I do not have SQL Server 2000 installed on my computer, but I am getting the error, "A strong SA password is required for security reasons. Please use SAPWD switch to supply the same..." If I am not running SQL Server, how can I get an SA password so I can complete the install. Thanks for the help in advance.
- Jesse Williamsthere's a command-line swicth in the MSDE installer program for setting the SAPWD
check the readme file that came with the installer, or run this:
setup.exe /?
I can't recall the usage off the top of my head I'm afraid.|||Take a look at this as well:http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1. More info on MSDE can be found on support.microsoft.com.|||I figured it out after I posted and did some research on this forum and read the read me. Correct, it is a command line switch. There are two ways to configure the installation: thru the setup.ini or at the command line. If you go with setup.ini add these parameters under [Options]:
instancename="nameofyourserver"
targetdir="C:\path"
datadir="C:\path"
securitymode=sql
targetdir is the folder that setup will install the executables for MSDE
datadir is the folder that will house the data
instancename is the name of your server instance
After saving the setup.ini return to the command prompt and type
setup /settings "setup.ini" sapwd="strongpwd"
This will allow you to set the sa password more securely.
You can also achieve the same at the command prompt instead of using the setup.ini:
setup instancename="nameofyourserver" targetdir="C:\path" datadir="C:\path" securitymode=sql sapwd="strongpwd"
Hope this helps for the future. Thanks for everyones help.
- Jesse
Wednesday, March 28, 2012
Installing MS SQL Server 2000
:p Hi,
I've MS SQL Server 6.5 installed in my Windows 2000 machine. Is it possible to install MS SQL Server 2000 personal or standard edition in the same machine without upgrading or removing the old SQL Server 6,5 ?
Thanks in advance.yes
books online {Working with Named and Multiple Instances of SQL Server 2000}|||Thanks Scott, I did it.
I've MS SQL Server 6.5 installed in my Windows 2000 machine. Is it possible to install MS SQL Server 2000 personal or standard edition in the same machine without upgrading or removing the old SQL Server 6,5 ?
Thanks in advance.yes
books online {Working with Named and Multiple Instances of SQL Server 2000}|||Thanks Scott, I did it.
Installing MS Reporting Services Probs
Hi NG
We have a problem to install the MS Reporting Services 2000 on a Windows
2003 Server Web Edition.
IIS is propertly installed, runing, and its serves many wepages.
During the installation (System prequestites check) of RS comes the
following message:
"IIS either not installed or not configured for a server component
installation"
We have no idea, how we can configure the IIS for server component
installations.
Thx for help.
Greets TomSeems you can only install Reporting Services Developer Edition on Windows
2003 server Web edition:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8jom.asp
Or maybe you can try setting it up as a web farm, as your database will have
to be running on a different server anyway:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8jom.asp
Kaisa M. Lindahl Lervik
"news.microsoft.com" <thomas.scholtke@.rbc-is.ch> wrote in message
news:ukqWIurPGHA.532@.TK2MSFTNGP15.phx.gbl...
> Hi NG
> We have a problem to install the MS Reporting Services 2000 on a Windows
> 2003 Server Web Edition.
> IIS is propertly installed, runing, and its serves many wepages.
> During the installation (System prequestites check) of RS comes the
> following message:
> "IIS either not installed or not configured for a server component
> installation"
> We have no idea, how we can configure the IIS for server component
> installations.
> Thx for help.
> Greets Tom
>
We have a problem to install the MS Reporting Services 2000 on a Windows
2003 Server Web Edition.
IIS is propertly installed, runing, and its serves many wepages.
During the installation (System prequestites check) of RS comes the
following message:
"IIS either not installed or not configured for a server component
installation"
We have no idea, how we can configure the IIS for server component
installations.
Thx for help.
Greets TomSeems you can only install Reporting Services Developer Edition on Windows
2003 server Web edition:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8jom.asp
Or maybe you can try setting it up as a web farm, as your database will have
to be running on a different server anyway:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8jom.asp
Kaisa M. Lindahl Lervik
"news.microsoft.com" <thomas.scholtke@.rbc-is.ch> wrote in message
news:ukqWIurPGHA.532@.TK2MSFTNGP15.phx.gbl...
> Hi NG
> We have a problem to install the MS Reporting Services 2000 on a Windows
> 2003 Server Web Edition.
> IIS is propertly installed, runing, and its serves many wepages.
> During the installation (System prequestites check) of RS comes the
> following message:
> "IIS either not installed or not configured for a server component
> installation"
> We have no idea, how we can configure the IIS for server component
> installations.
> Thx for help.
> Greets Tom
>
Installing Microsoft SQL server management studio express broke my asp.net databases
Morning, Cannot open user default database. Login failed.
I installed the managerment stuid on my machine and now none of my database connections seem to work any more. I keep getting the attached error. Before I installed the studio the system worked fine, I could connect to the database and everything was fine. Does the studio change any permission stuff? I cannot seem to get it to work again at all now, I added in aspnet as a login inside the studio and it still won't let me connect to the database. I cannot find *any* logs anywhere that might be helpful in what it is doing or see any way to debug the connection to find out what the problem is. When I look at the permissions inside of the studio it shows me that the connections should all be fine.
I checked and remote and local connections are setup, although it is only doing local connections anyway since this is a asp.net web server page.
Any idea what the problem is here? This is very frustrating and annoying :( Since I didn't change anything and now nothing I will do gets it to work. I even tried to uninstall the management tool and it still doesn't work.
Cannot open user default database. Login failed.
Login failed for user 'GREENANDFLUFFY\ASPNET'.
Description: An
unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the
error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'GREENANDFLUFFY\ASPNET'.
I have posted a solution (that works for me) here.
And there are other solutions in that older post.
|||Simply set the user dafault database for the user to a database which is existing and accessible to him, either with the procedure sp_defaultdb or via the management Studio.HTH, jens Suessmeyer.
http://www.sqlserver2005.de|||It was working just fine till I installed the management studio though. What could that possibly be doing to muck with the permissions?
I checked and the user has the default database as master and it definately has access to it. None of the other solutions on this page worked either.
I am really really really unimpressed with this current situation, it is a terrible user experience.|||Make also sure that the database mentioned in the connection string (depending on your provider you are using, for .NET it should be "Initial Catalog" is existing and accessible to the user. if you didn′t configure the user extensivly just drop anbd recreate him. i don′t know which administrative tasks you did prior to this problem, but this should "reset" the settings. make also sure that the user is not in a group which has access denied in the database you are redirecting to. These right will be inherited to the user as restrictive right will always overwrite granted rights.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
Installing MDAC 2.5 on W2k sp3
I have tried installing MDAC 2.5 on a w2k sp3 machine and it fails with the following error:
Microsoft Data Access components 2.5 is already installed on the version of windows you are running. Setup cannot update the system. For more information .....
BUT, Mdac 2.5 is not installed on the machine and VB applications using it do not work.
Any ideas?
ThankQ1 Any ideas?
A1 Yes.
1 Check your MDAC component status with the compatibility checking tool. See:
http://www.microsoft.com/data/download.htm#CCinfo
http://download.microsoft.com/download/dasdk/CC/2.7/WIN98MeXP/EN-US/cc.exe
2 See MDAC Installation Notes at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmdac/html/data_mdacinstall.asp|||Thanks DBA,
This has let me discover that the latest PCs with W2k have sp3 installed by default which includes MDAC 2.6. It is therefore not possible to install MDAC 2.5 - it physically stops you.
It just means I have to change the references to the ADO 2.5 objects to 2.6...|||You are most welcome.
Hopefully 2.6 is otherwise fully compatible with your applications. Newer (and sometimes corrupt or third party) dll issues are not an uncommon source of spurious "already installed" and similar MDAC errors.sql
Microsoft Data Access components 2.5 is already installed on the version of windows you are running. Setup cannot update the system. For more information .....
BUT, Mdac 2.5 is not installed on the machine and VB applications using it do not work.
Any ideas?
ThankQ1 Any ideas?
A1 Yes.
1 Check your MDAC component status with the compatibility checking tool. See:
http://www.microsoft.com/data/download.htm#CCinfo
http://download.microsoft.com/download/dasdk/CC/2.7/WIN98MeXP/EN-US/cc.exe
2 See MDAC Installation Notes at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmdac/html/data_mdacinstall.asp|||Thanks DBA,
This has let me discover that the latest PCs with W2k have sp3 installed by default which includes MDAC 2.6. It is therefore not possible to install MDAC 2.5 - it physically stops you.
It just means I have to change the references to the ADO 2.5 objects to 2.6...|||You are most welcome.
Hopefully 2.6 is otherwise fully compatible with your applications. Newer (and sometimes corrupt or third party) dll issues are not an uncommon source of spurious "already installed" and similar MDAC errors.sql
installing hotfix SQL2000-KB810185-8.00.0780-ENU
I am attempting to install this hotfix on a second instance of SQL Server
2000 running sp3 on a window 2003 server. I successfully installed the
hotfix on the first instance with no problems following the same sequence of
events against the first instance.
I am unable to install as it tells me one of the files is write locked. I
have shutdown both instances (SQL server and SQL agent) as well as the MSDTC.
I have shutdown the Window 2003 server and attempted to run the install. I
was successfully able to install the hotfixes on 2 instances on another
server running the same products.
The file in question is dbmslpcn.dll.
Any suggestions ?
1. Try renaming the DLL - does this work?
2. Run TLIST (included in windows resource kit) to see what app is holding
a lock to this DLL
syntax: TLIST -m <DLL>/<.exe Name>
3. shutdown all unecessary services and set to manual mode, then reboot.
See KB for a list of services to NOT shut down:
INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
ID: 219264
Do not shut off any services necessary for disk or network access.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||I ran the tasklist command, found my application that was using the file and
stopped that service. thanks very much for the info
"Fany Vargas [MSFT]" wrote:
> 1. Try renaming the DLL - does this work?
> 2. Run TLIST (included in windows resource kit) to see what app is holding
> a lock to this DLL
> syntax: TLIST -m <DLL>/<.exe Name>
> 3. shutdown all unecessary services and set to manual mode, then reboot.
> See KB for a list of services to NOT shut down:
> INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
> ID: 219264
> Do not shut off any services necessary for disk or network access.
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
2000 running sp3 on a window 2003 server. I successfully installed the
hotfix on the first instance with no problems following the same sequence of
events against the first instance.
I am unable to install as it tells me one of the files is write locked. I
have shutdown both instances (SQL server and SQL agent) as well as the MSDTC.
I have shutdown the Window 2003 server and attempted to run the install. I
was successfully able to install the hotfixes on 2 instances on another
server running the same products.
The file in question is dbmslpcn.dll.
Any suggestions ?
1. Try renaming the DLL - does this work?
2. Run TLIST (included in windows resource kit) to see what app is holding
a lock to this DLL
syntax: TLIST -m <DLL>/<.exe Name>
3. shutdown all unecessary services and set to manual mode, then reboot.
See KB for a list of services to NOT shut down:
INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
ID: 219264
Do not shut off any services necessary for disk or network access.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||I ran the tasklist command, found my application that was using the file and
stopped that service. thanks very much for the info
"Fany Vargas [MSFT]" wrote:
> 1. Try renaming the DLL - does this work?
> 2. Run TLIST (included in windows resource kit) to see what app is holding
> a lock to this DLL
> syntax: TLIST -m <DLL>/<.exe Name>
> 3. shutdown all unecessary services and set to manual mode, then reboot.
> See KB for a list of services to NOT shut down:
> INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
> ID: 219264
> Do not shut off any services necessary for disk or network access.
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
installing hotfix SQL2000-KB810185-8.00.0780-ENU
I am attempting to install this hotfix on a second instance of SQL Server
2000 running sp3 on a window 2003 server. I successfully installed the
hotfix on the first instance with no problems following the same sequence of
events against the first instance.
I am unable to install as it tells me one of the files is write locked. I
have shutdown both instances (SQL server and SQL agent) as well as the MSDTC
.
I have shutdown the Window 2003 server and attempted to run the install. I
was successfully able to install the hotfixes on 2 instances on another
server running the same products.
The file in question is dbmslpcn.dll.
Any suggestions ?1. Try renaming the DLL - does this work?
2. Run TLIST (included in windows resource kit) to see what app is holding
a lock to this DLL
syntax: TLIST -m <DLL>/<.exe Name>
3. shutdown all unecessary services and set to manual mode, then reboot.
See KB for a list of services to NOT shut down:
INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
ID: 219264
Do not shut off any services necessary for disk or network access.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx|||I ran the tasklist command, found my application that was using the file and
stopped that service. thanks very much for the info
"Fany Vargas [MSFT]" wrote:
> 1. Try renaming the DLL - does this work?
> 2. Run TLIST (included in windows resource kit) to see what app is holding
> a lock to this DLL
> syntax: TLIST -m <DLL>/<.exe Name>
> 3. shutdown all unecessary services and set to manual mode, then reboot.
> See KB for a list of services to NOT shut down:
> INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
> ID: 219264
> Do not shut off any services necessary for disk or network access.
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>sql
2000 running sp3 on a window 2003 server. I successfully installed the
hotfix on the first instance with no problems following the same sequence of
events against the first instance.
I am unable to install as it tells me one of the files is write locked. I
have shutdown both instances (SQL server and SQL agent) as well as the MSDTC
.
I have shutdown the Window 2003 server and attempted to run the install. I
was successfully able to install the hotfixes on 2 instances on another
server running the same products.
The file in question is dbmslpcn.dll.
Any suggestions ?1. Try renaming the DLL - does this work?
2. Run TLIST (included in windows resource kit) to see what app is holding
a lock to this DLL
syntax: TLIST -m <DLL>/<.exe Name>
3. shutdown all unecessary services and set to manual mode, then reboot.
See KB for a list of services to NOT shut down:
INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
ID: 219264
Do not shut off any services necessary for disk or network access.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx|||I ran the tasklist command, found my application that was using the file and
stopped that service. thanks very much for the info
"Fany Vargas [MSFT]" wrote:
> 1. Try renaming the DLL - does this work?
> 2. Run TLIST (included in windows resource kit) to see what app is holding
> a lock to this DLL
> syntax: TLIST -m <DLL>/<.exe Name>
> 3. shutdown all unecessary services and set to manual mode, then reboot.
> See KB for a list of services to NOT shut down:
> INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
> ID: 219264
> Do not shut off any services necessary for disk or network access.
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>sql
installing hotfix SQL2000-KB810185-8.00.0780-ENU
I am attempting to install this hotfix on a second instance of SQL Server
2000 running sp3 on a window 2003 server. I successfully installed the
hotfix on the first instance with no problems following the same sequence of
events against the first instance.
I am unable to install as it tells me one of the files is write locked. I
have shutdown both instances (SQL server and SQL agent) as well as the MSDTC.
I have shutdown the Window 2003 server and attempted to run the install. I
was successfully able to install the hotfixes on 2 instances on another
server running the same products.
The file in question is dbmslpcn.dll.
Any suggestions ?1. Try renaming the DLL - does this work?
2. Run TLIST (included in windows resource kit) to see what app is holding
a lock to this DLL
syntax: TLIST -m <DLL>/<.exe Name>
3. shutdown all unecessary services and set to manual mode, then reboot.
See KB for a list of services to NOT shut down:
INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
ID: 219264
Do not shut off any services necessary for disk or network access.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx|||I ran the tasklist command, found my application that was using the file and
stopped that service. thanks very much for the info
"Fany Vargas [MSFT]" wrote:
> 1. Try renaming the DLL - does this work?
> 2. Run TLIST (included in windows resource kit) to see what app is holding
> a lock to this DLL
> syntax: TLIST -m <DLL>/<.exe Name>
> 3. shutdown all unecessary services and set to manual mode, then reboot.
> See KB for a list of services to NOT shut down:
> INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
> ID: 219264
> Do not shut off any services necessary for disk or network access.
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
2000 running sp3 on a window 2003 server. I successfully installed the
hotfix on the first instance with no problems following the same sequence of
events against the first instance.
I am unable to install as it tells me one of the files is write locked. I
have shutdown both instances (SQL server and SQL agent) as well as the MSDTC.
I have shutdown the Window 2003 server and attempted to run the install. I
was successfully able to install the hotfixes on 2 instances on another
server running the same products.
The file in question is dbmslpcn.dll.
Any suggestions ?1. Try renaming the DLL - does this work?
2. Run TLIST (included in windows resource kit) to see what app is holding
a lock to this DLL
syntax: TLIST -m <DLL>/<.exe Name>
3. shutdown all unecessary services and set to manual mode, then reboot.
See KB for a list of services to NOT shut down:
INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
ID: 219264
Do not shut off any services necessary for disk or network access.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx|||I ran the tasklist command, found my application that was using the file and
stopped that service. thanks very much for the info
"Fany Vargas [MSFT]" wrote:
> 1. Try renaming the DLL - does this work?
> 2. Run TLIST (included in windows resource kit) to see what app is holding
> a lock to this DLL
> syntax: TLIST -m <DLL>/<.exe Name>
> 3. shutdown all unecessary services and set to manual mode, then reboot.
> See KB for a list of services to NOT shut down:
> INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
> ID: 219264
> Do not shut off any services necessary for disk or network access.
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
Installing full text index on SQL Server
A couple of years ago our ISP installed SQL Server 2000 single
processor licence on our server in their data centre.
They omitted to turn on indexing, or install full text indexing.
This was fine, but now we need to use it.
Is there any way that we can install full text indexing on the server
remotely using scripts to create the relevent stored procedures etc?
Or will we have to send the disk back to the data center so they can
put it in the server for us?
If this is the case and we re-insert the disk, what would be the effect
on the server of putting the disk back in (remembering that this is a
live server with several web sites hosted on it)? Would a new instance
be created? master databases over written etc? or would it be just fine
and the new services be added without any problems?
Any help, links, kb refs etc greatly appreciated
Paul R.
sp_fulltext_database 'enable'
Paul Zanbaka
Sharepoint Adminstrator and DBA
www.mycodekb.com
"thoades@.hotmail.com" wrote:
> A couple of years ago our ISP installed SQL Server 2000 single
> processor licence on our server in their data centre.
> They omitted to turn on indexing, or install full text indexing.
> This was fine, but now we need to use it.
> Is there any way that we can install full text indexing on the server
> remotely using scripts to create the relevent stored procedures etc?
> Or will we have to send the disk back to the data center so they can
> put it in the server for us?
> If this is the case and we re-insert the disk, what would be the effect
> on the server of putting the disk back in (remembering that this is a
> live server with several web sites hosted on it)? Would a new instance
> be created? master databases over written etc? or would it be just fine
> and the new services be added without any problems?
> Any help, links, kb refs etc greatly appreciated
> Paul R.
>
|||Many thanks Paul, that was exactly what I needed.
usefull examples also found here
http://sqljunkies.com/How%20To/E823E...80EB34CB1.scuk
Pr.
Paul Zanbaka wrote:[vbcol=seagreen]
> sp_fulltext_database 'enable'
> --
> Paul Zanbaka
> Sharepoint Adminstrator and DBA
> www.mycodekb.com
>
> "thoades@.hotmail.com" wrote:
|||Anytime Paul
Check out my site
http://www.mycodekb.com/
Paul Zanbaka
Sharepoint Adminstrator and DBA
"thoades@.hotmail.com" wrote:
> Many thanks Paul, that was exactly what I needed.
> usefull examples also found here
> http://sqljunkies.com/How%20To/E823E...80EB34CB1.scuk
> Pr.
> Paul Zanbaka wrote:
>
processor licence on our server in their data centre.
They omitted to turn on indexing, or install full text indexing.
This was fine, but now we need to use it.
Is there any way that we can install full text indexing on the server
remotely using scripts to create the relevent stored procedures etc?
Or will we have to send the disk back to the data center so they can
put it in the server for us?
If this is the case and we re-insert the disk, what would be the effect
on the server of putting the disk back in (remembering that this is a
live server with several web sites hosted on it)? Would a new instance
be created? master databases over written etc? or would it be just fine
and the new services be added without any problems?
Any help, links, kb refs etc greatly appreciated
Paul R.
sp_fulltext_database 'enable'
Paul Zanbaka
Sharepoint Adminstrator and DBA
www.mycodekb.com
"thoades@.hotmail.com" wrote:
> A couple of years ago our ISP installed SQL Server 2000 single
> processor licence on our server in their data centre.
> They omitted to turn on indexing, or install full text indexing.
> This was fine, but now we need to use it.
> Is there any way that we can install full text indexing on the server
> remotely using scripts to create the relevent stored procedures etc?
> Or will we have to send the disk back to the data center so they can
> put it in the server for us?
> If this is the case and we re-insert the disk, what would be the effect
> on the server of putting the disk back in (remembering that this is a
> live server with several web sites hosted on it)? Would a new instance
> be created? master databases over written etc? or would it be just fine
> and the new services be added without any problems?
> Any help, links, kb refs etc greatly appreciated
> Paul R.
>
|||Many thanks Paul, that was exactly what I needed.
usefull examples also found here
http://sqljunkies.com/How%20To/E823E...80EB34CB1.scuk
Pr.
Paul Zanbaka wrote:[vbcol=seagreen]
> sp_fulltext_database 'enable'
> --
> Paul Zanbaka
> Sharepoint Adminstrator and DBA
> www.mycodekb.com
>
> "thoades@.hotmail.com" wrote:
|||Anytime Paul
Check out my site
http://www.mycodekb.com/
Paul Zanbaka
Sharepoint Adminstrator and DBA
"thoades@.hotmail.com" wrote:
> Many thanks Paul, that was exactly what I needed.
> usefull examples also found here
> http://sqljunkies.com/How%20To/E823E...80EB34CB1.scuk
> Pr.
> Paul Zanbaka wrote:
>
Installing full text index on SQL Server
A couple of years ago our ISP installed SQL Server 2000 single
processor licence on our server in their data centre.
They omitted to turn on indexing, or install full text indexing.
This was fine, but now we need to use it.
Is there any way that we can install full text indexing on the server
remotely using scripts to create the relevent stored procedures etc?
Or will we have to send the disk back to the data center so they can
put it in the server for us?
If this is the case and we re-insert the disk, what would be the effect
on the server of putting the disk back in (remembering that this is a
live server with several web sites hosted on it)? Would a new instance
be created? master databases over written etc? or would it be just fine
and the new services be added without any problems?
Any help, links, kb refs etc greatly appreciated
Paul R.sp_fulltext_database 'enable'
--
Paul Zanbaka
Sharepoint Adminstrator and DBA
www.mycodekb.com
"thoades@.hotmail.com" wrote:
> A couple of years ago our ISP installed SQL Server 2000 single
> processor licence on our server in their data centre.
> They omitted to turn on indexing, or install full text indexing.
> This was fine, but now we need to use it.
> Is there any way that we can install full text indexing on the server
> remotely using scripts to create the relevent stored procedures etc?
> Or will we have to send the disk back to the data center so they can
> put it in the server for us?
> If this is the case and we re-insert the disk, what would be the effect
> on the server of putting the disk back in (remembering that this is a
> live server with several web sites hosted on it)? Would a new instance
> be created? master databases over written etc? or would it be just fine
> and the new services be added without any problems?
> Any help, links, kb refs etc greatly appreciated
> Paul R.
>|||Many thanks Paul, that was exactly what I needed.
usefull examples also found here
http://sqljunkies.com/How%20To/E823E84B-C443-4483-B4A3-CEF80EB34CB1.scuk
Pr.
Paul Zanbaka wrote:
> sp_fulltext_database 'enable'
> --
> Paul Zanbaka
> Sharepoint Adminstrator and DBA
> www.mycodekb.com
>
> "thoades@.hotmail.com" wrote:
> > A couple of years ago our ISP installed SQL Server 2000 single
> > processor licence on our server in their data centre.
> >
> > They omitted to turn on indexing, or install full text indexing.
> >
> > This was fine, but now we need to use it.
> >
> > Is there any way that we can install full text indexing on the server
> > remotely using scripts to create the relevent stored procedures etc?
> >
> > Or will we have to send the disk back to the data center so they can
> > put it in the server for us?
> >
> > If this is the case and we re-insert the disk, what would be the effect
> > on the server of putting the disk back in (remembering that this is a
> > live server with several web sites hosted on it)? Would a new instance
> > be created? master databases over written etc? or would it be just fine
> > and the new services be added without any problems?
> >
> > Any help, links, kb refs etc greatly appreciated
> >
> > Paul R.
> >
> >|||Anytime Paul
Check out my site
http://www.mycodekb.com/
--
Paul Zanbaka
Sharepoint Adminstrator and DBA
"thoades@.hotmail.com" wrote:
> Many thanks Paul, that was exactly what I needed.
> usefull examples also found here
> http://sqljunkies.com/How%20To/E823E84B-C443-4483-B4A3-CEF80EB34CB1.scuk
> Pr.
> Paul Zanbaka wrote:
> > sp_fulltext_database 'enable'
> > --
> > Paul Zanbaka
> > Sharepoint Adminstrator and DBA
> > www.mycodekb.com
> >
> >
> > "thoades@.hotmail.com" wrote:
> >
> > > A couple of years ago our ISP installed SQL Server 2000 single
> > > processor licence on our server in their data centre.
> > >
> > > They omitted to turn on indexing, or install full text indexing.
> > >
> > > This was fine, but now we need to use it.
> > >
> > > Is there any way that we can install full text indexing on the server
> > > remotely using scripts to create the relevent stored procedures etc?
> > >
> > > Or will we have to send the disk back to the data center so they can
> > > put it in the server for us?
> > >
> > > If this is the case and we re-insert the disk, what would be the effect
> > > on the server of putting the disk back in (remembering that this is a
> > > live server with several web sites hosted on it)? Would a new instance
> > > be created? master databases over written etc? or would it be just fine
> > > and the new services be added without any problems?
> > >
> > > Any help, links, kb refs etc greatly appreciated
> > >
> > > Paul R.
> > >
> > >
>
processor licence on our server in their data centre.
They omitted to turn on indexing, or install full text indexing.
This was fine, but now we need to use it.
Is there any way that we can install full text indexing on the server
remotely using scripts to create the relevent stored procedures etc?
Or will we have to send the disk back to the data center so they can
put it in the server for us?
If this is the case and we re-insert the disk, what would be the effect
on the server of putting the disk back in (remembering that this is a
live server with several web sites hosted on it)? Would a new instance
be created? master databases over written etc? or would it be just fine
and the new services be added without any problems?
Any help, links, kb refs etc greatly appreciated
Paul R.sp_fulltext_database 'enable'
--
Paul Zanbaka
Sharepoint Adminstrator and DBA
www.mycodekb.com
"thoades@.hotmail.com" wrote:
> A couple of years ago our ISP installed SQL Server 2000 single
> processor licence on our server in their data centre.
> They omitted to turn on indexing, or install full text indexing.
> This was fine, but now we need to use it.
> Is there any way that we can install full text indexing on the server
> remotely using scripts to create the relevent stored procedures etc?
> Or will we have to send the disk back to the data center so they can
> put it in the server for us?
> If this is the case and we re-insert the disk, what would be the effect
> on the server of putting the disk back in (remembering that this is a
> live server with several web sites hosted on it)? Would a new instance
> be created? master databases over written etc? or would it be just fine
> and the new services be added without any problems?
> Any help, links, kb refs etc greatly appreciated
> Paul R.
>|||Many thanks Paul, that was exactly what I needed.
usefull examples also found here
http://sqljunkies.com/How%20To/E823E84B-C443-4483-B4A3-CEF80EB34CB1.scuk
Pr.
Paul Zanbaka wrote:
> sp_fulltext_database 'enable'
> --
> Paul Zanbaka
> Sharepoint Adminstrator and DBA
> www.mycodekb.com
>
> "thoades@.hotmail.com" wrote:
> > A couple of years ago our ISP installed SQL Server 2000 single
> > processor licence on our server in their data centre.
> >
> > They omitted to turn on indexing, or install full text indexing.
> >
> > This was fine, but now we need to use it.
> >
> > Is there any way that we can install full text indexing on the server
> > remotely using scripts to create the relevent stored procedures etc?
> >
> > Or will we have to send the disk back to the data center so they can
> > put it in the server for us?
> >
> > If this is the case and we re-insert the disk, what would be the effect
> > on the server of putting the disk back in (remembering that this is a
> > live server with several web sites hosted on it)? Would a new instance
> > be created? master databases over written etc? or would it be just fine
> > and the new services be added without any problems?
> >
> > Any help, links, kb refs etc greatly appreciated
> >
> > Paul R.
> >
> >|||Anytime Paul
Check out my site
http://www.mycodekb.com/
--
Paul Zanbaka
Sharepoint Adminstrator and DBA
"thoades@.hotmail.com" wrote:
> Many thanks Paul, that was exactly what I needed.
> usefull examples also found here
> http://sqljunkies.com/How%20To/E823E84B-C443-4483-B4A3-CEF80EB34CB1.scuk
> Pr.
> Paul Zanbaka wrote:
> > sp_fulltext_database 'enable'
> > --
> > Paul Zanbaka
> > Sharepoint Adminstrator and DBA
> > www.mycodekb.com
> >
> >
> > "thoades@.hotmail.com" wrote:
> >
> > > A couple of years ago our ISP installed SQL Server 2000 single
> > > processor licence on our server in their data centre.
> > >
> > > They omitted to turn on indexing, or install full text indexing.
> > >
> > > This was fine, but now we need to use it.
> > >
> > > Is there any way that we can install full text indexing on the server
> > > remotely using scripts to create the relevent stored procedures etc?
> > >
> > > Or will we have to send the disk back to the data center so they can
> > > put it in the server for us?
> > >
> > > If this is the case and we re-insert the disk, what would be the effect
> > > on the server of putting the disk back in (remembering that this is a
> > > live server with several web sites hosted on it)? Would a new instance
> > > be created? master databases over written etc? or would it be just fine
> > > and the new services be added without any problems?
> > >
> > > Any help, links, kb refs etc greatly appreciated
> > >
> > > Paul R.
> > >
> > >
>
Installing full text index on SQL Server
A couple of years ago our ISP installed SQL Server 2000 single
processor licence on our server in their data centre.
They omitted to turn on indexing, or install full text indexing.
This was fine, but now we need to use it.
Is there any way that we can install full text indexing on the server
remotely using scripts to create the relevent stored procedures etc?
Or will we have to send the disk back to the data center so they can
put it in the server for us?
If this is the case and we re-insert the disk, what would be the effect
on the server of putting the disk back in (remembering that this is a
live server with several web sites hosted on it)? Would a new instance
be created? master databases over written etc? or would it be just fine
and the new services be added without any problems?
Any help, links, kb refs etc greatly appreciated
Paul R.sp_fulltext_database 'enable'
--
Paul Zanbaka
Sharepoint Adminstrator and DBA
www.mycodekb.com
"thoades@.hotmail.com" wrote:
> A couple of years ago our ISP installed SQL Server 2000 single
> processor licence on our server in their data centre.
> They omitted to turn on indexing, or install full text indexing.
> This was fine, but now we need to use it.
> Is there any way that we can install full text indexing on the server
> remotely using scripts to create the relevent stored procedures etc?
> Or will we have to send the disk back to the data center so they can
> put it in the server for us?
> If this is the case and we re-insert the disk, what would be the effect
> on the server of putting the disk back in (remembering that this is a
> live server with several web sites hosted on it)? Would a new instance
> be created? master databases over written etc? or would it be just fine
> and the new services be added without any problems?
> Any help, links, kb refs etc greatly appreciated
> Paul R.
>|||Many thanks Paul, that was exactly what I needed.
usefull examples also found here
http://sqljunkies.com/How%20To/E823...F80EB34CB1.scuk
Pr.
Paul Zanbaka wrote:[vbcol=seagreen]
> sp_fulltext_database 'enable'
> --
> Paul Zanbaka
> Sharepoint Adminstrator and DBA
> www.mycodekb.com
>
> "thoades@.hotmail.com" wrote:
>|||Anytime Paul
Check out my site
http://www.mycodekb.com/
Paul Zanbaka
Sharepoint Adminstrator and DBA
"thoades@.hotmail.com" wrote:
> Many thanks Paul, that was exactly what I needed.
> usefull examples also found here
> http://sqljunkies.com/How%20To/E823...F80EB34CB1.scuk
> Pr.
> Paul Zanbaka wrote:
>sql
processor licence on our server in their data centre.
They omitted to turn on indexing, or install full text indexing.
This was fine, but now we need to use it.
Is there any way that we can install full text indexing on the server
remotely using scripts to create the relevent stored procedures etc?
Or will we have to send the disk back to the data center so they can
put it in the server for us?
If this is the case and we re-insert the disk, what would be the effect
on the server of putting the disk back in (remembering that this is a
live server with several web sites hosted on it)? Would a new instance
be created? master databases over written etc? or would it be just fine
and the new services be added without any problems?
Any help, links, kb refs etc greatly appreciated
Paul R.sp_fulltext_database 'enable'
--
Paul Zanbaka
Sharepoint Adminstrator and DBA
www.mycodekb.com
"thoades@.hotmail.com" wrote:
> A couple of years ago our ISP installed SQL Server 2000 single
> processor licence on our server in their data centre.
> They omitted to turn on indexing, or install full text indexing.
> This was fine, but now we need to use it.
> Is there any way that we can install full text indexing on the server
> remotely using scripts to create the relevent stored procedures etc?
> Or will we have to send the disk back to the data center so they can
> put it in the server for us?
> If this is the case and we re-insert the disk, what would be the effect
> on the server of putting the disk back in (remembering that this is a
> live server with several web sites hosted on it)? Would a new instance
> be created? master databases over written etc? or would it be just fine
> and the new services be added without any problems?
> Any help, links, kb refs etc greatly appreciated
> Paul R.
>|||Many thanks Paul, that was exactly what I needed.
usefull examples also found here
http://sqljunkies.com/How%20To/E823...F80EB34CB1.scuk
Pr.
Paul Zanbaka wrote:[vbcol=seagreen]
> sp_fulltext_database 'enable'
> --
> Paul Zanbaka
> Sharepoint Adminstrator and DBA
> www.mycodekb.com
>
> "thoades@.hotmail.com" wrote:
>|||Anytime Paul
Check out my site
http://www.mycodekb.com/
Paul Zanbaka
Sharepoint Adminstrator and DBA
"thoades@.hotmail.com" wrote:
> Many thanks Paul, that was exactly what I needed.
> usefull examples also found here
> http://sqljunkies.com/How%20To/E823...F80EB34CB1.scuk
> Pr.
> Paul Zanbaka wrote:
>sql
Subscribe to:
Posts (Atom)