Hi NG,
I have two problems with MSDE 2000 installed without any parameter
(default).
1 - The default installation is a SP2 and I cannot upgrade to SP4 because it
tells me 'Invalid instance'. I tried to use this entry in the setup.ini
INSTANCENAME=MSSQLServer because I thought to be the default instance name
but nothing happened. How can I see the instance name? If I open the
monitor in the systray I see SERVER - MSSQLServer. Then, how can I upgrade
to SP4?

2 - Same server. When I try to connect from a client when creating ODBC I
get this error: SqlState 28000 SqlServer Error 18456. I enabled builtin
users to connect, I enabled TCP/IP with svrnetcn.exe. I connect locally.

All this happens on two PC, one with XP Pro sp2 and the other with W 2000
pro. I enabled the user PC1 on both machines.
Any hint?
Thank you.


--

----------------------------------
Luigi Fantelli
----------------------------------

hi,
[quoted text, click to view]

as the instance to be ugraded is the default instance, just do not provide
the "INSTANCENAME=" parameter..

[quoted text, click to view]

verify the "general" connectivity is operating checking the
firewalls..http://support.microsoft.com/kb/841251/en-us
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
--------- remove DMO to reply

"Andrea Montanari" <andrea.sqlDMO@virgilio.it> ha scritto nel messaggio
news:5331kmF1qptupU1@mid.individual.net...
[quoted text, click to view]

Hi to you,
this is exactly the problem. The instance is the default instance and if I
try to upgrade, without any parameter, I get the INVALID INSTANCE error.


[quoted text, click to view]

Yes. Next time I will try to create firewall exceptions in the XP machine,
but the 2000 PC doesn't have any.

Many thanks.

hi,
[quoted text, click to view]

has this instance been installed via the "standard" Microsoft provided
package or has it been installed via a third party tampered package?
if this is the case (someone else packaged the installation binaries, a
usual condition in "old days"), the standard package is not able to upgrade
the instance becouse of different guid, and only the former provider can
re-package an upgrade...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
--------- remove DMO to reply

[quoted text, click to view]

Yes, from the original CD. SP4 has benn downloaded from Microsoft site.

hi,
[quoted text, click to view]

just a curiosity... did you provide the
/upgradesp SQLRUN
parameter to the call to setupe.exe boostrap installer?
http://msdn2.microsoft.com/en-us/library/aa214935(SQL.80).aspx
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
--------- remove DMO to reply