Hi

    I have problems with installing SP4 on MSDE Revision A (I'm using
the SP4 for MSDE) which is a named instance with mixed mode authentication
enabled. It's on Windows XP Professional OEM Polish version with SP2 installed.
The instance is using MSSQL_INAME Windows account. I have MS Visual Studio
2005 Beta 2 installed on this machine along with SQL Server 2005 CTP
Tools (no SQL Server 2005 instance installed).
    The SP4 instalation is run using 'sa' database login (from Windows
'Administrator' account).
    The log fragment is:

Starting custom action SetFileAndRegACLs()
Beginning modification of directory Security Descriptor (SD).
  SQL Path:               C:\Program Files\Microsoft SQL Server\MSSQL$INAME\\
  SQL Data Path:          C:\Program Files\Microsoft SQL Server\MSSQL$INAME\\
  SQL Service Account:    .\MSSQL_INAME
  Agent Service Account:  .\MSSQL_INAME
Error:
  Nie zosta³o wykonane mapowanie miêdzy nazwami kont a identyfikatorami zabezpieczeñ.

  Error Code =  1332
Ending modification of directory Security Descriptor (SD).
Ending custom action SetFileAndRegACLs().
Action ended 23:40:35: InstallFinalize. Return value 3.


Additional info:

SELECT SERVERPROPERTY('ProductLevel')
  SP3

SELECT @@VERSION
  Microsoft SQL Server  2000 - 8.00.818 (Intel X86)
  May 31 2003 16:08:15
  Copyright (c) 1988-2003 Microsoft Corporation
  Desktop Engine on Windows NT 5.1 (Build 2600: Dodatek Service Pack 2)

SELECT SERVERPROPERTY('ProductVersion')
  8.00.818

SELECT SERVERPROPERTY('Edition')
  Desktop Engine


    Do you have any ideas what can be causing the problem? I allready installed
SP4 on other MSDE RevA (not OEM Windows, VS2003 instead of VS2005, no SQL2005 tools).

    Thank you for any help.


Hilarion

Hello,

These newsgroups are geared to answer on the English version of the
product. For support for localized versions we request that use the support
resources appropriate to that language.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi

    I'm trying to install English version of MDSE SP4 on English MSDE Rev. A.
AFAIK there's no Polish version of MSDE Rev. A (nor SP4 or any other from
SQL Server 2000 family). I'm not asking for help with the Polish Windows
I use, so please help me with the MSDE if you can.
    If the problem is with some messages displayed in polish (like
"Nie zosta³o wykonane mapowanie miêdzy nazwami kont a identyfikatorami
zabezpieczeñ." or "Dodatek Service Pack 2") then I can try and translate them
to English (they are in Polish because of Polish MDAC or Windows I suppose).

    Hilarion

Show quoteHide quote

Hello,

Unfortunately, I know little about this language. You have submitted an
international request to the English Support. In order to analyze and work
on the issue with you in more efficient manner, please contact the
localized support resource.

Or you can contact Customer Service and Support (CSS) for more immediate
assistance.  For more information on available CSS services, please click
here:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;OfferProPhone#faq607
. 

If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.

Thanks for understanding.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi

    I do not understand. I'm asking for help with ENGLISH version of
MSDE and you are telling me that you know little about this language?
I'm NOT asking for help with MDACs or Windows (which indeed I have
Polish).
    Is there anyone here that knows something about English language
and about English version of MSDE and could help me with applying
English SP4 on English MSDE Revision A (SP3a)?

Hilarion


Show quoteHide quote

Hello Hilarion,

I know little about the Polish.  To troubleshoot the issue, I need to check
the error mesage.   A exact error message is very important during the
troubleshooting process. We can resolve the issue in an efficient way if
the error message is exact.

I'd like to provide general informaiton for your reference.  I notice that
the SQL Service Account is  .\MSSQL_INAME.   Based on my research, the
issue may occur if the SQL Service Account is configured to use an account
other than the LocalSystem.

So the workaround is to change the startup account back to LocalSystem for
the duration of the upgrade.  I suggest that you use SQL Enterprise
Manager(EM) to change the startup account .  After installing SQL server
client tools on the computer, SEM is installed.

The following article is for your reference:

283811 How to change the SQL Server or SQL Server Agent Service account
without using SQL Enterprise Manager in SQL Server 2000 (283811)

http://support.microsoft.com/?id=283811

You can also use the sc.exe tool to automate the process of changing the
startup account of MSSQLSERVER service, rather than messing with the
services registry key directly:
http://msdn.microsoft.com/library/en-us/dnpic/html/msdn_scmslite.asp?frame=t
rue

I hope the information is helpful.  Thanks for your cooperation and
understanding.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi

    As I wrote in my other post the English error message is:
"No mapping between account names and security IDs was done.".
This is Windows error message for error number 1332 (use
"net nethelp 1332" command from command line to check it).
    I'll try changing service account as you suggest and will
post the results tomorrow.

    Hilarion

Hi,

    I had no chance yet to try changing the services accounts
on problematic machine, but I recalled one thing: the other
PC I recently updated to MSDE SP4 (from Rev. A) had same service
account configuration (one custom Windows account for both
SQL Server and SQL Agent services) and I had no problems with
that machine.
    I'll make the tests on problematic machine anyway.

    Hilarion

Hello,

Please take your time and let me know the results at your earliest
convenience.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi,

Some additional info:

    The error message, which is reported in install log in Polish
("Nie zosta³o wykonane mapowanie miêdzy nazwami kont a identyfikatorami
zabezpieczeñ.") is a Windows error message, and in English it is:
"No mapping between account names and security IDs was done."
(use "net nethelp 1332" command from Windows command line to check the
message in your Windows' language).
    Results of my searches suggest that the error may occure when some
Windows account name can't be translated to it's SID because the
account name is misspelled or was removed or the domain controller
is unavailable. The problem is that I have never typed any account
name by hand (so it's not a spelling problem) nor removed any
Windows account (it's possible that some installer did, but the accounts
related to SQL instance are in place), and the Windows is not (and was
not) under domain control. I found a post which describes how to check
which account name could not be resolved and I'll try it in the evening
(I do not have access to that computer now). I'll post the results.


Hilarion

Missing Program group
Nocount
index scan and seek help...
Error when creating new database user
Blocking issue in sql2000
trigger or stored procedure
Enterprise Manager connection to Local server very sloooow.
SQL Server 2000 performance issues
Does SQL 7 server run well in Win Server 2k3 or do I have to upgra
SQLExpress 2005/Yukon documentation