Install on Personal Edition 2000 SP3a

I installed SQL 2000 on a Windows XP box with a typical install, but
Full-Text Search does not appear to have been installed. It does not appear
at all. I want to go back and install it, but the install wants to create a
new instance. Can this be done without creating a new instance or
uninstalling and then reinstalling?
Thanks
It should work, can you issue this query?
select ServerProperty(N'IsFulltextInstalled')
This will tell you whether it is installed or not.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Audrey" <Audrey@.discussions.microsoft.com> wrote in message
news:16AC1E43-9D2F-4889-8527-90B05A3B6AC3@.microsoft.com...
> I installed SQL 2000 on a Windows XP box with a typical install, but
> Full-Text Search does not appear to have been installed. It does not
appear
> at all. I want to go back and install it, but the install wants to create
a
> new instance. Can this be done without creating a new instance or
> uninstalling and then reinstalling?
> Thanks
sql

Install on alternate TCP Port

I am trying to create an unattended install of MSDE 2000 sp3a that will set the default tcp port to something other than 1433. I am using a setup.ini file and have tried the following with out any success - any ideas would be great! Thanks
[Options]
SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0
[SdServerNetwork-0]
TCPPort=1433
hi Kelly
"Kelly" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:D1F4F952-218E-46F9-BF44-ED0F083F0AAD@.microsoft.com...
> I am trying to create an unattended install of MSDE 2000 sp3a that will
set the default tcp port to something other than 1433. I am using a
setup.ini file and have tried the following with out any success - any ideas
would be great! Thanks
> [Options]
> SECURITYMODE=SQL
> DISABLENETWORKPROTOCOLS=0
> [SdServerNetwork-0]
> TCPPort=1433
the MSDE 2000 setup boostrapper does not support TCP/IP port redirecting
the
[SdServerNetwork-0]
TCPPort=1433
parameter you provided is only valid for a full blown SQL Server unattended
installations and not for MSDE...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea!
What is the best method to change the tcp port after MSDE has been installed on the client machine?
Is it acceptable to modify the TcpPort via the registry:
HKLM\Software\Microsoft\MSSQLServer\SuperSocketNet Lib\Tcp
|||hi Kelly,
"Kelly" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:36ACB0E9-2A4E-45A1-A0A3-C430B364D324@.microsoft.com...
> Thanks Andrea!
> What is the best method to change the tcp port after MSDE has been
installed on the client machine?
> Is it acceptable to modify the TcpPort via the registry:
> HKLM\Software\Microsoft\MSSQLServer\SuperSocketNet Lib\Tcp
this can be a viable solution as, in order to install MSDE, admin privileges
are required, so you have access to the full registry, but remember you have
to modify that value using the Client Network Utility on all clients...
as regard the server, please have a look at
http://support.microsoft.com/?kbid=823938
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks for all of your help

Install msde with instancename on a W2003 cluster

How can i install the SQL MSDE (sp3a) with a instance name
on a windows 2003 cluster server.
A custumer has a windows 2003 cluster server. When i run
our setup, with parameters like intsance=myprogram, the
software installs normaly on the server. Our client
software louks voor
%Server%\%InstanceName% across the network.
The software don't see the instance name.
Thanks.
Sounds like it is installing correctly. There is nothing special about
installing MSDE on a node of a cluster. Can you use OSQL on the server you
installed MSDE on to connect to the SQL Server? Have you used svrnetcn.exe
to enable the protocols for MSDE? Have you applied SP3 to the MSDE
installation? TCP/IP is not available on Windows 2003 until SP3 is
installed on any version of SQL Server 2000.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Yes, the software installs correctly. (I don't see event
in the logs)
We used msde 2000 with sp3.
Yes i have used the svrnetcn.exe to configure the tcp/ip
protocol, set port to 1433.
I haven't used Osql to test the connection.
I test with the sql enterprice manager, to connect the
msde on the 2003 server. This don't work.
When i install the same msde software on a nomal Windows
2003 server everything works fine.
What else can i do?
What can there be wrong?
Thanks for your reply.
sql

Install database on existing MSDE server with unknown SA password?

Question regarding the MSDE SP3a install process...
What happens if I attempt to install MSDE on a server that already has MSDE
installed and the SA password has been changed to an unknown password? Can
I still install an instance for my database without knowing the SA password?
If not, how can I get around this issue?
I can see my app/database being installed at a customers site that already
has a version of MSDE for a different application they have already
installed and are using.
Thanks,
Jim K.
You should be able to install using Windows authentication, assuming you
know the password for an administrator on the box.
With that, you can also reset the sa password for an existing instance using
sp_password.
http://www.aspfaq.com/
(Reverse address to reply.)
"Jim K" <krusej@.megsinet.net> wrote in message
news:u$W9756gEHA.2952@.TK2MSFTNGP09.phx.gbl...
> Question regarding the MSDE SP3a install process...
> What happens if I attempt to install MSDE on a server that already has
MSDE
> installed and the SA password has been changed to an unknown password?
Can
> I still install an instance for my database without knowing the SA
password?
> If not, how can I get around this issue?
> I can see my app/database being installed at a customers site that already
> has a version of MSDE for a different application they have already
> installed and are using.
> Thanks,
> Jim K.
>

Install Database Components SP3a

Hi,
Do I need to know the sa password when I install Database Components for
SP3a? The extracted service pack files is in the directory of the local
computer.
Thanks.Only if you're installing on the SQL Server/MSDE, not for the clients.
"Samuel Yap" <yaphcs@.yahoo.com> wrote in message
news:%231rcsX0dDHA.3596@.tk2msftngp13.phx.gbl...
> Hi,
> Do I need to know the sa password when I install Database Components for
> SP3a? The extracted service pack files is in the directory of the local
> computer.
> Thanks.
>|||Yes, preferably. But any account that has system administrator privileges to
SQL Server should suffice I suppose. "sa" account is safe and sure to have
all the access to the database files for sure.
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD
http://www.extremeexperts.com
"Samuel Yap" <yaphcs@.yahoo.com> wrote in message
news:%231rcsX0dDHA.3596@.tk2msftngp13.phx.gbl...
> Hi,
> Do I need to know the sa password when I install Database Components for
> SP3a? The extracted service pack files is in the directory of the local
> computer.
> Thanks.
>|||Noted. Thanks.
"Vinodk" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
news:eqSUIi0dDHA.3992@.TK2MSFTNGP11.phx.gbl...
> Yes, preferably. But any account that has system administrator privileges
to
> SQL Server should suffice I suppose. "sa" account is safe and sure to have
> all the access to the database files for sure.
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD
> http://www.extremeexperts.com
>
> "Samuel Yap" <yaphcs@.yahoo.com> wrote in message
> news:%231rcsX0dDHA.3596@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Do I need to know the sa password when I install Database Components for
> > SP3a? The extracted service pack files is in the directory of the local
> > computer.
> >
> > Thanks.
> >
> >
>

Install Analysis Services SP3

Hi,
I'm have downloaded database components SP3- SQL2KSP3.exe SP3a.
When i tried to installed , it gave me this error "An error occurred during
the move data process: -145"
why? please help and guide me on what to do next.
thx,
jessJessica,
Here are few possible issues:
- first of all, don't get mad with this bullet, but check whether you have
AS installed on the computer
- next, you can check the olapsp.log file to see what went wrong
- check the support article at http://www.support.microsoft.com/?id=814462
whether it applies to your case
- I've succeeded to install AS SP3a after this error when I stopped all
unnecessary services.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Jessica" <Jessica@.discussions.microsoft.com> wrote in message
news:6EB3D551-0613-436B-8411-D6853C1370A7@.microsoft.com...
> Hi,
> I'm have downloaded database components SP3- SQL2KSP3.exe SP3a.
> When i tried to installed , it gave me this error "An error occurred
during
> the move data process: -145"
> why? please help and guide me on what to do next.
> thx,
> jess

Install Analysis Services SP3

Hi,
I'm have downloaded database components SP3- SQL2KSP3.exe SP3a.
When i tried to installed , it gave me this error "An error occurred during
the move data process: -145"
why? please help and guide me on what to do next.
thx,
jessJessica,
Here are few possible issues:
- first of all, don't get mad with this bullet, but check whether you have
AS installed on the computer
- next, you can check the olapsp.log file to see what went wrong
- check the support article at http://www.support.microsoft.com/?id=814462
whether it applies to your case
- I've succeeded to install AS SP3a after this error when I stopped all
unnecessary services.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Jessica" <Jessica@.discussions.microsoft.com> wrote in message
news:6EB3D551-0613-436B-8411-D6853C1370A7@.microsoft.com...
> Hi,
> I'm have downloaded database components SP3- SQL2KSP3.exe SP3a.
> When i tried to installed , it gave me this error "An error occurred
during
> the move data process: -145"
> why? please help and guide me on what to do next.
> thx,
> jess

Install Analysis Services SP3

Hi,
I'm have downloaded database components SP3- SQL2KSP3.exe SP3a.
When i tried to installed , it gave me this error "An error occurred during
the move data process: -145"
why? please help and guide me on what to do next.
thx,
jess
Jessica,
Here are few possible issues:
- first of all, don't get mad with this bullet, but check whether you have
AS installed on the computer
- next, you can check the olapsp.log file to see what went wrong
- check the support article at http://www.support.microsoft.com/?id=814462
whether it applies to your case
- I've succeeded to install AS SP3a after this error when I stopped all
unnecessary services.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Jessica" <Jessica@.discussions.microsoft.com> wrote in message
news:6EB3D551-0613-436B-8411-D6853C1370A7@.microsoft.com...
> Hi,
> I'm have downloaded database components SP3- SQL2KSP3.exe SP3a.
> When i tried to installed , it gave me this error "An error occurred
during
> the move data process: -145"
> why? please help and guide me on what to do next.
> thx,
> jess