sql server 2000 sp4 installation fails on windows server 2003 standard
edition with error "Sql server 2000 is not installed on this machine. Setup
will now exit." Trying to install on a vmware server. Have bounced the server
and retried without success. Any ideas?
s5 wrote:
> sql server 2000 sp4 installation fails on windows server 2003 standard
> edition with error "Sql server 2000 is not installed on this machine. Setup
> will now exit." Trying to install on a vmware server. Have bounced the server
> and retried without success. Any ideas?
Do you have any problems with the SQL Server on that machine? Like
connection problems, etc.
Lasse V?gs?ther Karlsen
http://usinglvkblog.blogspot.com/
mailto:lasse@.vkarlsen.no
PGP KeyID: 0x2A42A1C2
Showing posts with label sp4. Show all posts
Showing posts with label sp4. Show all posts
Friday, March 23, 2012
Install fails
sql server 2000 sp4 installation fails on windows server 2003 standard
edition with error "Sql server 2000 is not installed on this machine. Setup
will now exit." Trying to install on a vmware server. Have bounced the server
and retried without success. Any ideas?s5 wrote:
> sql server 2000 sp4 installation fails on windows server 2003 standard
> edition with error "Sql server 2000 is not installed on this machine. Setup
> will now exit." Trying to install on a vmware server. Have bounced the server
> and retried without success. Any ideas?
Do you have any problems with the SQL Server on that machine? Like
connection problems, etc.
--
Lasse Vågsæther Karlsen
http://usinglvkblog.blogspot.com/
mailto:lasse@.vkarlsen.no
PGP KeyID: 0x2A42A1C2sql
edition with error "Sql server 2000 is not installed on this machine. Setup
will now exit." Trying to install on a vmware server. Have bounced the server
and retried without success. Any ideas?s5 wrote:
> sql server 2000 sp4 installation fails on windows server 2003 standard
> edition with error "Sql server 2000 is not installed on this machine. Setup
> will now exit." Trying to install on a vmware server. Have bounced the server
> and retried without success. Any ideas?
Do you have any problems with the SQL Server on that machine? Like
connection problems, etc.
--
Lasse Vågsæther Karlsen
http://usinglvkblog.blogspot.com/
mailto:lasse@.vkarlsen.no
PGP KeyID: 0x2A42A1C2sql
Install fails
sql server 2000 sp4 installation fails on windows server 2003 standard
edition with error "Sql server 2000 is not installed on this machine. Setup
will now exit." Trying to install on a vmware server. Have bounced the serve
r
and retried without success. Any ideas?s5 wrote:
> sql server 2000 sp4 installation fails on windows server 2003 standard
> edition with error "Sql server 2000 is not installed on this machine. Setu
p
> will now exit." Trying to install on a vmware server. Have bounced the ser
ver
> and retried without success. Any ideas?
Do you have any problems with the SQL Server on that machine? Like
connection problems, etc.
Lasse V?gs?ther Karlsen
http://usinglvkblog.blogspot.com/
mailto:lasse@.vkarlsen.no
PGP KeyID: 0x2A42A1C2
edition with error "Sql server 2000 is not installed on this machine. Setup
will now exit." Trying to install on a vmware server. Have bounced the serve
r
and retried without success. Any ideas?s5 wrote:
> sql server 2000 sp4 installation fails on windows server 2003 standard
> edition with error "Sql server 2000 is not installed on this machine. Setu
p
> will now exit." Trying to install on a vmware server. Have bounced the ser
ver
> and retried without success. Any ideas?
Do you have any problems with the SQL Server on that machine? Like
connection problems, etc.
Lasse V?gs?ther Karlsen
http://usinglvkblog.blogspot.com/
mailto:lasse@.vkarlsen.no
PGP KeyID: 0x2A42A1C2
Monday, March 12, 2012
Instalation of SP4 on MSDE RevA
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 install
ed.
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 zostao wykonane mapowanie midzy nazwami kont a identyfikatorami zabezp
iecze.
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 SQL200
5 tools).
Thank you for any help.
HilarionHello,
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 zostao wykonane mapowanie midzy nazwami kont a identyfikatorami
zabezpiecze." or "Dodatek Service Pack 2") then I can try and translate the
m
to English (they are in Polish because of Polish MDAC or Windows I suppose).
Hilarion
User "Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> in message
news:QRh15RCaFHA.2476@.TK2MSFTNGXA01.phx.gbl wrote:
> Hello,
> These newsgroups are geared to answer on the English version of the
> product. For support for localized versions we request that use the suppor
t
> resources appropriate to that language.
> Sophie Guo
> Microsoft Online Partner Support|||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/defaul...ProPhone#faq607|||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
User "Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> in message
news:hEa4EwnaFHA.2476@.TK2MSFTNGXA01.phx.gbl wrote:
> 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:
> l]
>
> If you are outside the United States, please visit our International
> Support page:
> [url]http://support.microsoft.com/default.aspx?scid=%2finternational.aspx." target="_blank">http://support.microsoft.com/defaul...rnational.aspx.
> Thanks for understanding.
> Sophie Guo
> Microsoft Online Partner Support|||Hi,
Some additional info:
The error message, which is reported in install log in Polish
("Nie zostao wykonane mapowanie midzy 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|||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/e...ite.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.
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 install
ed.
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 zostao wykonane mapowanie midzy nazwami kont a identyfikatorami zabezp
iecze.
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 SQL200
5 tools).
Thank you for any help.
HilarionHello,
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 zostao wykonane mapowanie midzy nazwami kont a identyfikatorami
zabezpiecze." or "Dodatek Service Pack 2") then I can try and translate the
m
to English (they are in Polish because of Polish MDAC or Windows I suppose).
Hilarion
User "Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> in message
news:QRh15RCaFHA.2476@.TK2MSFTNGXA01.phx.gbl wrote:
> Hello,
> These newsgroups are geared to answer on the English version of the
> product. For support for localized versions we request that use the suppor
t
> resources appropriate to that language.
> Sophie Guo
> Microsoft Online Partner Support|||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/defaul...ProPhone#faq607|||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
User "Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> in message
news:hEa4EwnaFHA.2476@.TK2MSFTNGXA01.phx.gbl wrote:
> 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:
> l]
>
> If you are outside the United States, please visit our International
> Support page:
> [url]http://support.microsoft.com/default.aspx?scid=%2finternational.aspx." target="_blank">http://support.microsoft.com/defaul...rnational.aspx.
> Thanks for understanding.
> Sophie Guo
> Microsoft Online Partner Support|||Hi,
Some additional info:
The error message, which is reported in install log in Polish
("Nie zostao wykonane mapowanie midzy 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|||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/e...ite.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.
Instalation of SP4 on MSDE RevA
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.
HilarionHello,
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
User "Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> in message
news:QRh15RCaFHA.2476@.TK2MSFTNGXA01.phx.gbl wrote:
> 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|||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
User "Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> in message
news:hEa4EwnaFHA.2476@.TK2MSFTNGXA01.phx.gbl wrote:
> 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|||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|||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.
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.
HilarionHello,
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
User "Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> in message
news:QRh15RCaFHA.2476@.TK2MSFTNGXA01.phx.gbl wrote:
> 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|||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
User "Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> in message
news:hEa4EwnaFHA.2476@.TK2MSFTNGXA01.phx.gbl wrote:
> 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|||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|||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.
Instalation of SP4 on MSDE RevA
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 zostao wykonane mapowanie midzy 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 zostao wykonane mapowanie midzy 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
User "Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> in message
news:QRh15RCaFHA.2476@.TK2MSFTNGXA01.phx.gbl wrote:
> 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
|||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...roPhone#faq607
|||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
User "Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> in message
news:hEa4EwnaFHA.2476@.TK2MSFTNGXA01.phx.gbl wrote:
> 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...roPhone#faq607
>
> If you are outside the United States, please visit our International
> Support page:
> http://support.microsoft.com/default...national.aspx.
> Thanks for understanding.
> Sophie Guo
> Microsoft Online Partner Support
|||Hi,
Some additional info:
The error message, which is reported in install log in Polish
("Nie zostao wykonane mapowanie midzy 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
|||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...te.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.
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 zostao wykonane mapowanie midzy 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 zostao wykonane mapowanie midzy 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
User "Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> in message
news:QRh15RCaFHA.2476@.TK2MSFTNGXA01.phx.gbl wrote:
> 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
|||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...roPhone#faq607
|||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
User "Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> in message
news:hEa4EwnaFHA.2476@.TK2MSFTNGXA01.phx.gbl wrote:
> 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...roPhone#faq607
>
> If you are outside the United States, please visit our International
> Support page:
> http://support.microsoft.com/default...national.aspx.
> Thanks for understanding.
> Sophie Guo
> Microsoft Online Partner Support
|||Hi,
Some additional info:
The error message, which is reported in install log in Polish
("Nie zostao wykonane mapowanie midzy 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
|||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...te.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.
Friday, March 9, 2012
Inserts to tables as one or two users.
SQL 7.0 SP4
Background: C++ program accesses SQL via ODBC doing
massive inserts to two different tables. The data goes
either to one table or the other, but not both.
Problem: Is it more efficient to have the program access
the database as one or two SQL users?
1. user DOG inserts to table XXX "and" table YYY.
or
2. user DOG inserts to table XXX,
user CAT inserts to table YYY?
Thanks for your help,
DonUnless you need to load them in parallel there isn't any reason to use two
users. Adding connections has a slight overhead that you probably don't
need for this type operation.
--
Andrew J. Kelly
SQL Server MVP
"Don" <ddachner@.yahoo.com> wrote in message
news:0bf401c38126$d4174120$a001280a@.phx.gbl...
> SQL 7.0 SP4
> Background: C++ program accesses SQL via ODBC doing
> massive inserts to two different tables. The data goes
> either to one table or the other, but not both.
> Problem: Is it more efficient to have the program access
> the database as one or two SQL users?
> 1. user DOG inserts to table XXX "and" table YYY.
> or
> 2. user DOG inserts to table XXX,
> user CAT inserts to table YYY?
> Thanks for your help,
> Don|||no, it wouldn't make any difference in performance, it
will only increase work for you to manage permissions to
two users.
Also, consider using stored procedures rather than direct
insert statements. this will give slight performance gain,
and better management of sql code.
>--Original Message--
>SQL 7.0 SP4
>Background: C++ program accesses SQL via ODBC doing
>massive inserts to two different tables. The data goes
>either to one table or the other, but not both.
>Problem: Is it more efficient to have the program access
>the database as one or two SQL users?
>1. user DOG inserts to table XXX "and" table YYY.
>or
>2. user DOG inserts to table XXX,
> user CAT inserts to table YYY?
>Thanks for your help,
>Don
>.
>
Background: C++ program accesses SQL via ODBC doing
massive inserts to two different tables. The data goes
either to one table or the other, but not both.
Problem: Is it more efficient to have the program access
the database as one or two SQL users?
1. user DOG inserts to table XXX "and" table YYY.
or
2. user DOG inserts to table XXX,
user CAT inserts to table YYY?
Thanks for your help,
DonUnless you need to load them in parallel there isn't any reason to use two
users. Adding connections has a slight overhead that you probably don't
need for this type operation.
--
Andrew J. Kelly
SQL Server MVP
"Don" <ddachner@.yahoo.com> wrote in message
news:0bf401c38126$d4174120$a001280a@.phx.gbl...
> SQL 7.0 SP4
> Background: C++ program accesses SQL via ODBC doing
> massive inserts to two different tables. The data goes
> either to one table or the other, but not both.
> Problem: Is it more efficient to have the program access
> the database as one or two SQL users?
> 1. user DOG inserts to table XXX "and" table YYY.
> or
> 2. user DOG inserts to table XXX,
> user CAT inserts to table YYY?
> Thanks for your help,
> Don|||no, it wouldn't make any difference in performance, it
will only increase work for you to manage permissions to
two users.
Also, consider using stored procedures rather than direct
insert statements. this will give slight performance gain,
and better management of sql code.
>--Original Message--
>SQL 7.0 SP4
>Background: C++ program accesses SQL via ODBC doing
>massive inserts to two different tables. The data goes
>either to one table or the other, but not both.
>Problem: Is it more efficient to have the program access
>the database as one or two SQL users?
>1. user DOG inserts to table XXX "and" table YYY.
>or
>2. user DOG inserts to table XXX,
> user CAT inserts to table YYY?
>Thanks for your help,
>Don
>.
>
Subscribe to:
Posts (Atom)