In an instalation of sql server appears an error message saying sql server
can't work with directories with more than 39 characters. The operative
system is W2000 Server.
Thank you."Alberto" <alberto@.nospam.com> wrote in message
news:eAJRbaYxDHA.2136@.TK2MSFTNGP10.phx.gbl...
> In an instalation of sql server appears an error message saying sql server
> can't work with directories with more than 39 characters. The operative
> system is W2000 Server.
Does it install with a shorter folder name? You may have found a limitation,
I've never created a folder that long...
Steve|||If I try to change the directory of instalation, the system is locked.
Thanks.
"Steve Thompson" <SteveThompson@.nomail.please> escribió en el mensaje
news:O5ppb9YxDHA.2456@.TK2MSFTNGP12.phx.gbl...
> "Alberto" <alberto@.nospam.com> wrote in message
> news:eAJRbaYxDHA.2136@.TK2MSFTNGP10.phx.gbl...
> > In an instalation of sql server appears an error message saying sql
server
> > can't work with directories with more than 39 characters. The operative
> > system is W2000 Server.
> Does it install with a shorter folder name? You may have found a
limitation,
> I've never created a folder that long...
> Steve
>|||Are you installing with an account that has proper permissions (local
administrator)?
And, that you cannot change the installed folder if you choose the 'Custom'
install path?
Steve
"Alberto" <alberto@.nospam.com> wrote in message
news:u3BFb2gxDHA.1740@.TK2MSFTNGP12.phx.gbl...
> If I try to change the directory of instalation, the system is locked.
> Thanks.
> "Steve Thompson" <SteveThompson@.nomail.please> escribió en el mensaje
> news:O5ppb9YxDHA.2456@.TK2MSFTNGP12.phx.gbl...
> > "Alberto" <alberto@.nospam.com> wrote in message
> > news:eAJRbaYxDHA.2136@.TK2MSFTNGP10.phx.gbl...
> > > In an instalation of sql server appears an error message saying sql
> server
> > > can't work with directories with more than 39 characters. The
operative
> > > system is W2000 Server.
> >
> > Does it install with a shorter folder name? You may have found a
> limitation,
> > I've never created a folder that long...
> >
> > Steve
> >
> >
>
Showing posts with label instalation. Show all posts
Showing posts with label instalation. Show all posts
Monday, March 12, 2012
Instalation of SQL SERVER 2005
I 'm trying to install SQL server tools and I have this message :
A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the template.ini and set the UPGRADE property to the name of the component.
I can't understand what a have to do to resolve this
Thanks
I suspect you have SQL Express already installed on your machine. You will need to uninstall the tools that are installed with Express before you can install the tools that ships with the full edition of SQL Server.
jeff.
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.
Instalation MSDE failled !
Hello,
I'm trying to install MSDE but it fails.
I notice thatthe install log has several return values 3 wich means
problems.
...
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (AHFTSH,LocalSystem,87).
Action ended 11:25:35: InstallFinalize. Return value 3.
...
Start custom action DeferProperties
Defer Properties returns: 0
MSI (s) (48:B4) [11:25:40:093]: Executing op:
End(Checksum=0,ProgressTotalHDWord=0,ProgressTotal LDWord=0)
MSI (s) (48:B4) [11:25:40:093]: Error in rollback skipped. Return: 5
MSI (s) (48:B4) [11:25:40:109]: Calling SRSetRestorePoint API.
dwRestorePtType: 13, dwEventType: 103, llSequenceNumber: 246, szDescription:
"".
MSI (s) (48:B4) [11:25:40:171]: The call to SRSetRestorePoint API succeeded.
Returned status: 0.
MSI (s) (48:B4) [11:25:40:171]: Unlocking Server
MSI (s) (48:B4) [11:25:40:171]: PROPERTY CHANGE: Deleting UpdateStarted
property. Its current value is '1'.
Action ended 11:25:40: INSTALL. Return value 3.
...
MSI (s) (48:B4) [11:25:40:328]: MainEngineThread is returning 1603
MSI (s) (48:94) [11:25:40:328]: Destroying RemoteAPI object.
MSI (s) (48:30) [11:25:40:328]: Custom Action Manager thread ending.
MSI (c) (28:3C) [11:25:40:328]: Back from server. Return value: 1603
MSI (c) (28:3C) [11:25:40:328]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
Action ended 11:25:40: INSTALL. Return value 3.
...
=== Logging stopped: 21-11-2007 11:25:40 ===
MSI (c) (28:3C) [11:25:40:359]: Note: 1: 1708
MSI (c) (28:3C) [11:25:40:359]: Product: Microsoft SQL Server Desktop
Engine -- Installation operation failed.
MSI (c) (28:3C) [11:25:40:375]: Grabbed execution mutex.
MSI (c) (28:3C) [11:25:40:375]: Cleaning up uninstalled install packages, if
any exist
MSI (c) (28:3C) [11:25:40:375]: MainEngineThread is returning 1603
=== Verbose logging stopped: 21-11-2007 11:25:40 ===
Solutions ?
Regards
Antonio Ferreiar
Andrea,
Thanks. Problem solved.
Antonio
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> escreveu na mensagem
news:5qj194F10cgomU1@.mid.individual.net...
> hi Antonio,
> Antonio Ferreira wrote:
> have you already seen http://support.microsoft.com/kb/829386/en-us ?
> regards
> --
> 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
>
I'm trying to install MSDE but it fails.
I notice thatthe install log has several return values 3 wich means
problems.
...
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (AHFTSH,LocalSystem,87).
Action ended 11:25:35: InstallFinalize. Return value 3.
...
Start custom action DeferProperties
Defer Properties returns: 0
MSI (s) (48:B4) [11:25:40:093]: Executing op:
End(Checksum=0,ProgressTotalHDWord=0,ProgressTotal LDWord=0)
MSI (s) (48:B4) [11:25:40:093]: Error in rollback skipped. Return: 5
MSI (s) (48:B4) [11:25:40:109]: Calling SRSetRestorePoint API.
dwRestorePtType: 13, dwEventType: 103, llSequenceNumber: 246, szDescription:
"".
MSI (s) (48:B4) [11:25:40:171]: The call to SRSetRestorePoint API succeeded.
Returned status: 0.
MSI (s) (48:B4) [11:25:40:171]: Unlocking Server
MSI (s) (48:B4) [11:25:40:171]: PROPERTY CHANGE: Deleting UpdateStarted
property. Its current value is '1'.
Action ended 11:25:40: INSTALL. Return value 3.
...
MSI (s) (48:B4) [11:25:40:328]: MainEngineThread is returning 1603
MSI (s) (48:94) [11:25:40:328]: Destroying RemoteAPI object.
MSI (s) (48:30) [11:25:40:328]: Custom Action Manager thread ending.
MSI (c) (28:3C) [11:25:40:328]: Back from server. Return value: 1603
MSI (c) (28:3C) [11:25:40:328]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
Action ended 11:25:40: INSTALL. Return value 3.
...
=== Logging stopped: 21-11-2007 11:25:40 ===
MSI (c) (28:3C) [11:25:40:359]: Note: 1: 1708
MSI (c) (28:3C) [11:25:40:359]: Product: Microsoft SQL Server Desktop
Engine -- Installation operation failed.
MSI (c) (28:3C) [11:25:40:375]: Grabbed execution mutex.
MSI (c) (28:3C) [11:25:40:375]: Cleaning up uninstalled install packages, if
any exist
MSI (c) (28:3C) [11:25:40:375]: MainEngineThread is returning 1603
=== Verbose logging stopped: 21-11-2007 11:25:40 ===
Solutions ?
Regards
Antonio Ferreiar
Andrea,
Thanks. Problem solved.
Antonio
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> escreveu na mensagem
news:5qj194F10cgomU1@.mid.individual.net...
> hi Antonio,
> Antonio Ferreira wrote:
> have you already seen http://support.microsoft.com/kb/829386/en-us ?
> regards
> --
> 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
>
Instalation MSDE
When I execute the following instruction
OSQL /USA /P
presents the following error message:
[Microsoft]{ODBC SQL Server Driver][SHARED MEMORY]
SQL Server does not exist or access denied.
[Microsoft]{ODBC SQL Server Driver] Connectionopen
(connect())
Operating system WINDOWS 98 2 Edition
When I verify in the configurations / Panel of Control appeared a new icon
(MSDTC don't remind the acronym). When I execute and requested that selects
the service in what doesn't appear noneEither sa has a non-null password or MSDE is not installed as the default
instance. Use osql /l to list the available servers.
--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.
"Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:#YYYXxFTDHA.1324@.TK2MSFTNGP11.phx.gbl...
> When I execute the following instruction
> OSQL /USA /P
> presents the following error message:
> [Microsoft]{ODBC SQL Server Driver][SHARED MEMORY]
> SQL Server does not exist or access denied.
> [Microsoft]{ODBC SQL Server Driver] Connectionopen
> (connect())
> Operating system WINDOWS 98 2 Edition
> When I verify in the configurations / Panel of Control appeared a new icon
> (MSDTC don't remind the acronym). When I execute and requested that
selects
> the service in what doesn't appear none
>
OSQL /USA /P
presents the following error message:
[Microsoft]{ODBC SQL Server Driver][SHARED MEMORY]
SQL Server does not exist or access denied.
[Microsoft]{ODBC SQL Server Driver] Connectionopen
(connect())
Operating system WINDOWS 98 2 Edition
When I verify in the configurations / Panel of Control appeared a new icon
(MSDTC don't remind the acronym). When I execute and requested that selects
the service in what doesn't appear noneEither sa has a non-null password or MSDE is not installed as the default
instance. Use osql /l to list the available servers.
--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.
"Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:#YYYXxFTDHA.1324@.TK2MSFTNGP11.phx.gbl...
> When I execute the following instruction
> OSQL /USA /P
> presents the following error message:
> [Microsoft]{ODBC SQL Server Driver][SHARED MEMORY]
> SQL Server does not exist or access denied.
> [Microsoft]{ODBC SQL Server Driver] Connectionopen
> (connect())
> Operating system WINDOWS 98 2 Edition
> When I verify in the configurations / Panel of Control appeared a new icon
> (MSDTC don't remind the acronym). When I execute and requested that
selects
> the service in what doesn't appear none
>
instalation mistake
I have made a mistake when I have installed SQL server.
I have installed Personal edition instead of standard edition.
How to change sql server edition from personal to standard if I have some
databases active?
Ales
If I were you, I would backup the DBs, uninstall personal and install
standard and then restore the DBs. Barring that, is it possible to run an
instance of standard side by side and transfer the DBs through a dump and
load? Unless you can upgrade editions(don't beleive you can), you are going
to ave to backup and restore anyway.
"Ales Baranek" wrote:
> I have made a mistake when I have installed SQL server.
> I have installed Personal edition instead of standard edition.
> How to change sql server edition from personal to standard if I have some
> databases active?
> Ales
>
>
|||Hi,
It requires downtime.
(info from books online)
To upgrade a SQL Server 2000 installation to a different edition of SQL
Server 2000
1.. Insert the Microsoft SQL Server 2000T compact disc for the edition
you want to install into your CD-ROM drive. If the compact disc does not
autorun, double-click Autorun.exe in the root directory of the compact disc.
2.. Select SQL Server 2000 Components, select Install Database Server, and
then setup prepares the SQL Server Installation Wizard. At the Welcome
screen, click Next.
3.. In Computer Name dialog box, select Local Computer or Remote computer.
4.. In the Installation Selection dialog box, click Upgrade, Remove, or
Add Components to an existing instance of SQL Server, and then click Next.
5.. In the Instance Name dialog box, click Next.
6.. In the Existing Installation dialog box, click Upgrade your existing
installation, and then click Next.
7.. If Setup detects that you are doing an edition upgrade, the Upgrade
dialog box appears. Click Yes, Upgrade my <text specific to the upgrade> to
upgrade the feature set of your current installation, and click Next.
8.. After the upgrade is completed, you are prompted as to whether you
want to install additional components. If you click Yes, the Select
Components dialog box appears. Accept the defaults or select the additional
components you want to install, and then click Next.
You can select an item in the Components list, and then select items from
the related Sub-Components list. Click to select items you want to install;
clear the check box of the items you do not want to install.
9.. When you are finished specifying options, in the Start Copying Files
dialog box, click Next.
10.. In the Setup Complete dialog box, click Yes, I want to restart my
computer now, and then click Finish to complete the edition upgrade.
Thanks
Hari
SQL Server MVP
"Ales Baranek" <barda@.staryhrozenkov.cz> wrote in message
news:OXkcO42oFHA.3608@.TK2MSFTNGP15.phx.gbl...
>I have made a mistake when I have installed SQL server.
> I have installed Personal edition instead of standard edition.
> How to change sql server edition from personal to standard if I have some
> databases active?
> Ales
>
|||And what about the databases?
SQL personal is with SP3 now and upgrade will be without any SP. I will have
to install this SP3 on the new standard edition. Does it affect databases?
Ales
"Hari Prasad" <hari_prasad_k@.hotmail.com> pe v diskusnm pspvku
news:%23yFWGy3oFHA.1372@.TK2MSFTNGP10.phx.gbl...
> Hi,
> It requires downtime.
> (info from books online)
> To upgrade a SQL Server 2000 installation to a different edition of SQL
> Server 2000
> 1.. Insert the Microsoft SQL Server 2000T compact disc for the edition
> you want to install into your CD-ROM drive. If the compact disc does not
> autorun, double-click Autorun.exe in the root directory of the compact
> disc.
>
> 2.. Select SQL Server 2000 Components, select Install Database Server,
> and then setup prepares the SQL Server Installation Wizard. At the Welcome
> screen, click Next.
>
> 3.. In Computer Name dialog box, select Local Computer or Remote
> computer.
>
> 4.. In the Installation Selection dialog box, click Upgrade, Remove, or
> Add Components to an existing instance of SQL Server, and then click Next.
>
> 5.. In the Instance Name dialog box, click Next.
>
> 6.. In the Existing Installation dialog box, click Upgrade your existing
> installation, and then click Next.
>
> 7.. If Setup detects that you are doing an edition upgrade, the Upgrade
> dialog box appears. Click Yes, Upgrade my <text specific to the upgrade>
> to upgrade the feature set of your current installation, and click Next.
>
> 8.. After the upgrade is completed, you are prompted as to whether you
> want to install additional components. If you click Yes, the Select
> Components dialog box appears. Accept the defaults or select the
> additional components you want to install, and then click Next.
> You can select an item in the Components list, and then select items from
> the related Sub-Components list. Click to select items you want to
> install; clear the check box of the items you do not want to install.
> 9.. When you are finished specifying options, in the Start Copying Files
> dialog box, click Next.
>
> 10.. In the Setup Complete dialog box, click Yes, I want to restart my
> computer now, and then click Finish to complete the edition upgrade.
> Thanks
> Hari
> SQL Server MVP
>
> "Ales Baranek" <barda@.staryhrozenkov.cz> wrote in message
> news:OXkcO42oFHA.3608@.TK2MSFTNGP15.phx.gbl...
>
I have installed Personal edition instead of standard edition.
How to change sql server edition from personal to standard if I have some
databases active?
Ales
If I were you, I would backup the DBs, uninstall personal and install
standard and then restore the DBs. Barring that, is it possible to run an
instance of standard side by side and transfer the DBs through a dump and
load? Unless you can upgrade editions(don't beleive you can), you are going
to ave to backup and restore anyway.
"Ales Baranek" wrote:
> I have made a mistake when I have installed SQL server.
> I have installed Personal edition instead of standard edition.
> How to change sql server edition from personal to standard if I have some
> databases active?
> Ales
>
>
|||Hi,
It requires downtime.
(info from books online)
To upgrade a SQL Server 2000 installation to a different edition of SQL
Server 2000
1.. Insert the Microsoft SQL Server 2000T compact disc for the edition
you want to install into your CD-ROM drive. If the compact disc does not
autorun, double-click Autorun.exe in the root directory of the compact disc.
2.. Select SQL Server 2000 Components, select Install Database Server, and
then setup prepares the SQL Server Installation Wizard. At the Welcome
screen, click Next.
3.. In Computer Name dialog box, select Local Computer or Remote computer.
4.. In the Installation Selection dialog box, click Upgrade, Remove, or
Add Components to an existing instance of SQL Server, and then click Next.
5.. In the Instance Name dialog box, click Next.
6.. In the Existing Installation dialog box, click Upgrade your existing
installation, and then click Next.
7.. If Setup detects that you are doing an edition upgrade, the Upgrade
dialog box appears. Click Yes, Upgrade my <text specific to the upgrade> to
upgrade the feature set of your current installation, and click Next.
8.. After the upgrade is completed, you are prompted as to whether you
want to install additional components. If you click Yes, the Select
Components dialog box appears. Accept the defaults or select the additional
components you want to install, and then click Next.
You can select an item in the Components list, and then select items from
the related Sub-Components list. Click to select items you want to install;
clear the check box of the items you do not want to install.
9.. When you are finished specifying options, in the Start Copying Files
dialog box, click Next.
10.. In the Setup Complete dialog box, click Yes, I want to restart my
computer now, and then click Finish to complete the edition upgrade.
Thanks
Hari
SQL Server MVP
"Ales Baranek" <barda@.staryhrozenkov.cz> wrote in message
news:OXkcO42oFHA.3608@.TK2MSFTNGP15.phx.gbl...
>I have made a mistake when I have installed SQL server.
> I have installed Personal edition instead of standard edition.
> How to change sql server edition from personal to standard if I have some
> databases active?
> Ales
>
|||And what about the databases?
SQL personal is with SP3 now and upgrade will be without any SP. I will have
to install this SP3 on the new standard edition. Does it affect databases?
Ales
"Hari Prasad" <hari_prasad_k@.hotmail.com> pe v diskusnm pspvku
news:%23yFWGy3oFHA.1372@.TK2MSFTNGP10.phx.gbl...
> Hi,
> It requires downtime.
> (info from books online)
> To upgrade a SQL Server 2000 installation to a different edition of SQL
> Server 2000
> 1.. Insert the Microsoft SQL Server 2000T compact disc for the edition
> you want to install into your CD-ROM drive. If the compact disc does not
> autorun, double-click Autorun.exe in the root directory of the compact
> disc.
>
> 2.. Select SQL Server 2000 Components, select Install Database Server,
> and then setup prepares the SQL Server Installation Wizard. At the Welcome
> screen, click Next.
>
> 3.. In Computer Name dialog box, select Local Computer or Remote
> computer.
>
> 4.. In the Installation Selection dialog box, click Upgrade, Remove, or
> Add Components to an existing instance of SQL Server, and then click Next.
>
> 5.. In the Instance Name dialog box, click Next.
>
> 6.. In the Existing Installation dialog box, click Upgrade your existing
> installation, and then click Next.
>
> 7.. If Setup detects that you are doing an edition upgrade, the Upgrade
> dialog box appears. Click Yes, Upgrade my <text specific to the upgrade>
> to upgrade the feature set of your current installation, and click Next.
>
> 8.. After the upgrade is completed, you are prompted as to whether you
> want to install additional components. If you click Yes, the Select
> Components dialog box appears. Accept the defaults or select the
> additional components you want to install, and then click Next.
> You can select an item in the Components list, and then select items from
> the related Sub-Components list. Click to select items you want to
> install; clear the check box of the items you do not want to install.
> 9.. When you are finished specifying options, in the Start Copying Files
> dialog box, click Next.
>
> 10.. In the Setup Complete dialog box, click Yes, I want to restart my
> computer now, and then click Finish to complete the edition upgrade.
> Thanks
> Hari
> SQL Server MVP
>
> "Ales Baranek" <barda@.staryhrozenkov.cz> wrote in message
> news:OXkcO42oFHA.3608@.TK2MSFTNGP15.phx.gbl...
>
instalation mistake
I have made a mistake when I have installed SQL server.
I have installed Personal edition instead of standard edition.
How to change sql server edition from personal to standard if I have some
databases active?
AlesIf I were you, I would backup the DBs, uninstall personal and install
standard and then restore the DBs. Barring that, is it possible to run an
instance of standard side by side and transfer the DBs through a dump and
load? Unless you can upgrade editions(don't beleive you can), you are going
to ave to backup and restore anyway.
"Ales Baranek" wrote:
> I have made a mistake when I have installed SQL server.
> I have installed Personal edition instead of standard edition.
> How to change sql server edition from personal to standard if I have some
> databases active?
> Ales
>
>|||Hi,
It requires downtime.
(info from books online)
To upgrade a SQL Server 2000 installation to a different edition of SQL
Server 2000
1.. Insert the Microsoft SQL Server 2000T compact disc for the edition
you want to install into your CD-ROM drive. If the compact disc does not
autorun, double-click Autorun.exe in the root directory of the compact disc.
2.. Select SQL Server 2000 Components, select Install Database Server, and
then setup prepares the SQL Server Installation Wizard. At the Welcome
screen, click Next.
3.. In Computer Name dialog box, select Local Computer or Remote computer.
4.. In the Installation Selection dialog box, click Upgrade, Remove, or
Add Components to an existing instance of SQL Server, and then click Next.
5.. In the Instance Name dialog box, click Next.
6.. In the Existing Installation dialog box, click Upgrade your existing
installation, and then click Next.
7.. If Setup detects that you are doing an edition upgrade, the Upgrade
dialog box appears. Click Yes, Upgrade my <text specific to the upgrade> to
upgrade the feature set of your current installation, and click Next.
8.. After the upgrade is completed, you are prompted as to whether you
want to install additional components. If you click Yes, the Select
Components dialog box appears. Accept the defaults or select the additional
components you want to install, and then click Next.
You can select an item in the Components list, and then select items from
the related Sub-Components list. Click to select items you want to install;
clear the check box of the items you do not want to install.
9.. When you are finished specifying options, in the Start Copying Files
dialog box, click Next.
10.. In the Setup Complete dialog box, click Yes, I want to restart my
computer now, and then click Finish to complete the edition upgrade.
Thanks
Hari
SQL Server MVP
"Ales Baranek" <barda@.staryhrozenkov.cz> wrote in message
news:OXkcO42oFHA.3608@.TK2MSFTNGP15.phx.gbl...
>I have made a mistake when I have installed SQL server.
> I have installed Personal edition instead of standard edition.
> How to change sql server edition from personal to standard if I have some
> databases active?
> Ales
>|||And what about the databases?
SQL personal is with SP3 now and upgrade will be without any SP. I will have
to install this SP3 on the new standard edition. Does it affect databases?
Ales
"Hari Prasad" <hari_prasad_k@.hotmail.com> pe v diskusnm pspvku
news:%23yFWGy3oFHA.1372@.TK2MSFTNGP10.phx.gbl...
> Hi,
> It requires downtime.
> (info from books online)
> To upgrade a SQL Server 2000 installation to a different edition of SQL
> Server 2000
> 1.. Insert the Microsoft SQL Server 2000T compact disc for the edition
> you want to install into your CD-ROM drive. If the compact disc does not
> autorun, double-click Autorun.exe in the root directory of the compact
> disc.
>
> 2.. Select SQL Server 2000 Components, select Install Database Server,
> and then setup prepares the SQL Server Installation Wizard. At the Welcome
> screen, click Next.
>
> 3.. In Computer Name dialog box, select Local Computer or Remote
> computer.
>
> 4.. In the Installation Selection dialog box, click Upgrade, Remove, or
> Add Components to an existing instance of SQL Server, and then click Next.
>
> 5.. In the Instance Name dialog box, click Next.
>
> 6.. In the Existing Installation dialog box, click Upgrade your existing
> installation, and then click Next.
>
> 7.. If Setup detects that you are doing an edition upgrade, the Upgrade
> dialog box appears. Click Yes, Upgrade my <text specific to the upgrade>
> to upgrade the feature set of your current installation, and click Next.
>
> 8.. After the upgrade is completed, you are prompted as to whether you
> want to install additional components. If you click Yes, the Select
> Components dialog box appears. Accept the defaults or select the
> additional components you want to install, and then click Next.
> You can select an item in the Components list, and then select items from
> the related Sub-Components list. Click to select items you want to
> install; clear the check box of the items you do not want to install.
> 9.. When you are finished specifying options, in the Start Copying Files
> dialog box, click Next.
>
> 10.. In the Setup Complete dialog box, click Yes, I want to restart my
> computer now, and then click Finish to complete the edition upgrade.
> Thanks
> Hari
> SQL Server MVP
>
> "Ales Baranek" <barda@.staryhrozenkov.cz> wrote in message
> news:OXkcO42oFHA.3608@.TK2MSFTNGP15.phx.gbl...
>
I have installed Personal edition instead of standard edition.
How to change sql server edition from personal to standard if I have some
databases active?
AlesIf I were you, I would backup the DBs, uninstall personal and install
standard and then restore the DBs. Barring that, is it possible to run an
instance of standard side by side and transfer the DBs through a dump and
load? Unless you can upgrade editions(don't beleive you can), you are going
to ave to backup and restore anyway.
"Ales Baranek" wrote:
> I have made a mistake when I have installed SQL server.
> I have installed Personal edition instead of standard edition.
> How to change sql server edition from personal to standard if I have some
> databases active?
> Ales
>
>|||Hi,
It requires downtime.
(info from books online)
To upgrade a SQL Server 2000 installation to a different edition of SQL
Server 2000
1.. Insert the Microsoft SQL Server 2000T compact disc for the edition
you want to install into your CD-ROM drive. If the compact disc does not
autorun, double-click Autorun.exe in the root directory of the compact disc.
2.. Select SQL Server 2000 Components, select Install Database Server, and
then setup prepares the SQL Server Installation Wizard. At the Welcome
screen, click Next.
3.. In Computer Name dialog box, select Local Computer or Remote computer.
4.. In the Installation Selection dialog box, click Upgrade, Remove, or
Add Components to an existing instance of SQL Server, and then click Next.
5.. In the Instance Name dialog box, click Next.
6.. In the Existing Installation dialog box, click Upgrade your existing
installation, and then click Next.
7.. If Setup detects that you are doing an edition upgrade, the Upgrade
dialog box appears. Click Yes, Upgrade my <text specific to the upgrade> to
upgrade the feature set of your current installation, and click Next.
8.. After the upgrade is completed, you are prompted as to whether you
want to install additional components. If you click Yes, the Select
Components dialog box appears. Accept the defaults or select the additional
components you want to install, and then click Next.
You can select an item in the Components list, and then select items from
the related Sub-Components list. Click to select items you want to install;
clear the check box of the items you do not want to install.
9.. When you are finished specifying options, in the Start Copying Files
dialog box, click Next.
10.. In the Setup Complete dialog box, click Yes, I want to restart my
computer now, and then click Finish to complete the edition upgrade.
Thanks
Hari
SQL Server MVP
"Ales Baranek" <barda@.staryhrozenkov.cz> wrote in message
news:OXkcO42oFHA.3608@.TK2MSFTNGP15.phx.gbl...
>I have made a mistake when I have installed SQL server.
> I have installed Personal edition instead of standard edition.
> How to change sql server edition from personal to standard if I have some
> databases active?
> Ales
>|||And what about the databases?
SQL personal is with SP3 now and upgrade will be without any SP. I will have
to install this SP3 on the new standard edition. Does it affect databases?
Ales
"Hari Prasad" <hari_prasad_k@.hotmail.com> pe v diskusnm pspvku
news:%23yFWGy3oFHA.1372@.TK2MSFTNGP10.phx.gbl...
> Hi,
> It requires downtime.
> (info from books online)
> To upgrade a SQL Server 2000 installation to a different edition of SQL
> Server 2000
> 1.. Insert the Microsoft SQL Server 2000T compact disc for the edition
> you want to install into your CD-ROM drive. If the compact disc does not
> autorun, double-click Autorun.exe in the root directory of the compact
> disc.
>
> 2.. Select SQL Server 2000 Components, select Install Database Server,
> and then setup prepares the SQL Server Installation Wizard. At the Welcome
> screen, click Next.
>
> 3.. In Computer Name dialog box, select Local Computer or Remote
> computer.
>
> 4.. In the Installation Selection dialog box, click Upgrade, Remove, or
> Add Components to an existing instance of SQL Server, and then click Next.
>
> 5.. In the Instance Name dialog box, click Next.
>
> 6.. In the Existing Installation dialog box, click Upgrade your existing
> installation, and then click Next.
>
> 7.. If Setup detects that you are doing an edition upgrade, the Upgrade
> dialog box appears. Click Yes, Upgrade my <text specific to the upgrade>
> to upgrade the feature set of your current installation, and click Next.
>
> 8.. After the upgrade is completed, you are prompted as to whether you
> want to install additional components. If you click Yes, the Select
> Components dialog box appears. Accept the defaults or select the
> additional components you want to install, and then click Next.
> You can select an item in the Components list, and then select items from
> the related Sub-Components list. Click to select items you want to
> install; clear the check box of the items you do not want to install.
> 9.. When you are finished specifying options, in the Start Copying Files
> dialog box, click Next.
>
> 10.. In the Setup Complete dialog box, click Yes, I want to restart my
> computer now, and then click Finish to complete the edition upgrade.
> Thanks
> Hari
> SQL Server MVP
>
> "Ales Baranek" <barda@.staryhrozenkov.cz> wrote in message
> news:OXkcO42oFHA.3608@.TK2MSFTNGP15.phx.gbl...
>
instalation mistake
I have made a mistake when I have installed SQL server.
I have installed Personal edition instead of standard edition.
How to change sql server edition from personal to standard if I have some
databases active?
AlesIf I were you, I would backup the DBs, uninstall personal and install
standard and then restore the DBs. Barring that, is it possible to run an
instance of standard side by side and transfer the DBs through a dump and
load? Unless you can upgrade editions(don't beleive you can), you are going
to ave to backup and restore anyway.
"Ales Baranek" wrote:
> I have made a mistake when I have installed SQL server.
> I have installed Personal edition instead of standard edition.
> How to change sql server edition from personal to standard if I have some
> databases active?
> Ales
>
>|||Hi,
It requires downtime.
(info from books online)
To upgrade a SQL Server 2000 installation to a different edition of SQL
Server 2000
1.. Insert the Microsoft® SQL Server 2000T compact disc for the edition
you want to install into your CD-ROM drive. If the compact disc does not
autorun, double-click Autorun.exe in the root directory of the compact disc.
2.. Select SQL Server 2000 Components, select Install Database Server, and
then setup prepares the SQL Server Installation Wizard. At the Welcome
screen, click Next.
3.. In Computer Name dialog box, select Local Computer or Remote computer.
4.. In the Installation Selection dialog box, click Upgrade, Remove, or
Add Components to an existing instance of SQL Server, and then click Next.
5.. In the Instance Name dialog box, click Next.
6.. In the Existing Installation dialog box, click Upgrade your existing
installation, and then click Next.
7.. If Setup detects that you are doing an edition upgrade, the Upgrade
dialog box appears. Click Yes, Upgrade my <text specific to the upgrade> to
upgrade the feature set of your current installation, and click Next.
8.. After the upgrade is completed, you are prompted as to whether you
want to install additional components. If you click Yes, the Select
Components dialog box appears. Accept the defaults or select the additional
components you want to install, and then click Next.
You can select an item in the Components list, and then select items from
the related Sub-Components list. Click to select items you want to install;
clear the check box of the items you do not want to install.
9.. When you are finished specifying options, in the Start Copying Files
dialog box, click Next.
10.. In the Setup Complete dialog box, click Yes, I want to restart my
computer now, and then click Finish to complete the edition upgrade.
Thanks
Hari
SQL Server MVP
"Ales Baranek" <barda@.staryhrozenkov.cz> wrote in message
news:OXkcO42oFHA.3608@.TK2MSFTNGP15.phx.gbl...
>I have made a mistake when I have installed SQL server.
> I have installed Personal edition instead of standard edition.
> How to change sql server edition from personal to standard if I have some
> databases active?
> Ales
>|||And what about the databases?
SQL personal is with SP3 now and upgrade will be without any SP. I will have
to install this SP3 on the new standard edition. Does it affect databases?
Ales
"Hari Prasad" <hari_prasad_k@.hotmail.com> pí¹e v diskusním pøíspìvku
news:%23yFWGy3oFHA.1372@.TK2MSFTNGP10.phx.gbl...
> Hi,
> It requires downtime.
> (info from books online)
> To upgrade a SQL Server 2000 installation to a different edition of SQL
> Server 2000
> 1.. Insert the Microsoft® SQL Server 2000T compact disc for the edition
> you want to install into your CD-ROM drive. If the compact disc does not
> autorun, double-click Autorun.exe in the root directory of the compact
> disc.
>
> 2.. Select SQL Server 2000 Components, select Install Database Server,
> and then setup prepares the SQL Server Installation Wizard. At the Welcome
> screen, click Next.
>
> 3.. In Computer Name dialog box, select Local Computer or Remote
> computer.
>
> 4.. In the Installation Selection dialog box, click Upgrade, Remove, or
> Add Components to an existing instance of SQL Server, and then click Next.
>
> 5.. In the Instance Name dialog box, click Next.
>
> 6.. In the Existing Installation dialog box, click Upgrade your existing
> installation, and then click Next.
>
> 7.. If Setup detects that you are doing an edition upgrade, the Upgrade
> dialog box appears. Click Yes, Upgrade my <text specific to the upgrade>
> to upgrade the feature set of your current installation, and click Next.
>
> 8.. After the upgrade is completed, you are prompted as to whether you
> want to install additional components. If you click Yes, the Select
> Components dialog box appears. Accept the defaults or select the
> additional components you want to install, and then click Next.
> You can select an item in the Components list, and then select items from
> the related Sub-Components list. Click to select items you want to
> install; clear the check box of the items you do not want to install.
> 9.. When you are finished specifying options, in the Start Copying Files
> dialog box, click Next.
>
> 10.. In the Setup Complete dialog box, click Yes, I want to restart my
> computer now, and then click Finish to complete the edition upgrade.
> Thanks
> Hari
> SQL Server MVP
>
> "Ales Baranek" <barda@.staryhrozenkov.cz> wrote in message
> news:OXkcO42oFHA.3608@.TK2MSFTNGP15.phx.gbl...
>>I have made a mistake when I have installed SQL server.
>> I have installed Personal edition instead of standard edition.
>> How to change sql server edition from personal to standard if I have some
>> databases active?
>> Ales
>>
>
I have installed Personal edition instead of standard edition.
How to change sql server edition from personal to standard if I have some
databases active?
AlesIf I were you, I would backup the DBs, uninstall personal and install
standard and then restore the DBs. Barring that, is it possible to run an
instance of standard side by side and transfer the DBs through a dump and
load? Unless you can upgrade editions(don't beleive you can), you are going
to ave to backup and restore anyway.
"Ales Baranek" wrote:
> I have made a mistake when I have installed SQL server.
> I have installed Personal edition instead of standard edition.
> How to change sql server edition from personal to standard if I have some
> databases active?
> Ales
>
>|||Hi,
It requires downtime.
(info from books online)
To upgrade a SQL Server 2000 installation to a different edition of SQL
Server 2000
1.. Insert the Microsoft® SQL Server 2000T compact disc for the edition
you want to install into your CD-ROM drive. If the compact disc does not
autorun, double-click Autorun.exe in the root directory of the compact disc.
2.. Select SQL Server 2000 Components, select Install Database Server, and
then setup prepares the SQL Server Installation Wizard. At the Welcome
screen, click Next.
3.. In Computer Name dialog box, select Local Computer or Remote computer.
4.. In the Installation Selection dialog box, click Upgrade, Remove, or
Add Components to an existing instance of SQL Server, and then click Next.
5.. In the Instance Name dialog box, click Next.
6.. In the Existing Installation dialog box, click Upgrade your existing
installation, and then click Next.
7.. If Setup detects that you are doing an edition upgrade, the Upgrade
dialog box appears. Click Yes, Upgrade my <text specific to the upgrade> to
upgrade the feature set of your current installation, and click Next.
8.. After the upgrade is completed, you are prompted as to whether you
want to install additional components. If you click Yes, the Select
Components dialog box appears. Accept the defaults or select the additional
components you want to install, and then click Next.
You can select an item in the Components list, and then select items from
the related Sub-Components list. Click to select items you want to install;
clear the check box of the items you do not want to install.
9.. When you are finished specifying options, in the Start Copying Files
dialog box, click Next.
10.. In the Setup Complete dialog box, click Yes, I want to restart my
computer now, and then click Finish to complete the edition upgrade.
Thanks
Hari
SQL Server MVP
"Ales Baranek" <barda@.staryhrozenkov.cz> wrote in message
news:OXkcO42oFHA.3608@.TK2MSFTNGP15.phx.gbl...
>I have made a mistake when I have installed SQL server.
> I have installed Personal edition instead of standard edition.
> How to change sql server edition from personal to standard if I have some
> databases active?
> Ales
>|||And what about the databases?
SQL personal is with SP3 now and upgrade will be without any SP. I will have
to install this SP3 on the new standard edition. Does it affect databases?
Ales
"Hari Prasad" <hari_prasad_k@.hotmail.com> pí¹e v diskusním pøíspìvku
news:%23yFWGy3oFHA.1372@.TK2MSFTNGP10.phx.gbl...
> Hi,
> It requires downtime.
> (info from books online)
> To upgrade a SQL Server 2000 installation to a different edition of SQL
> Server 2000
> 1.. Insert the Microsoft® SQL Server 2000T compact disc for the edition
> you want to install into your CD-ROM drive. If the compact disc does not
> autorun, double-click Autorun.exe in the root directory of the compact
> disc.
>
> 2.. Select SQL Server 2000 Components, select Install Database Server,
> and then setup prepares the SQL Server Installation Wizard. At the Welcome
> screen, click Next.
>
> 3.. In Computer Name dialog box, select Local Computer or Remote
> computer.
>
> 4.. In the Installation Selection dialog box, click Upgrade, Remove, or
> Add Components to an existing instance of SQL Server, and then click Next.
>
> 5.. In the Instance Name dialog box, click Next.
>
> 6.. In the Existing Installation dialog box, click Upgrade your existing
> installation, and then click Next.
>
> 7.. If Setup detects that you are doing an edition upgrade, the Upgrade
> dialog box appears. Click Yes, Upgrade my <text specific to the upgrade>
> to upgrade the feature set of your current installation, and click Next.
>
> 8.. After the upgrade is completed, you are prompted as to whether you
> want to install additional components. If you click Yes, the Select
> Components dialog box appears. Accept the defaults or select the
> additional components you want to install, and then click Next.
> You can select an item in the Components list, and then select items from
> the related Sub-Components list. Click to select items you want to
> install; clear the check box of the items you do not want to install.
> 9.. When you are finished specifying options, in the Start Copying Files
> dialog box, click Next.
>
> 10.. In the Setup Complete dialog box, click Yes, I want to restart my
> computer now, and then click Finish to complete the edition upgrade.
> Thanks
> Hari
> SQL Server MVP
>
> "Ales Baranek" <barda@.staryhrozenkov.cz> wrote in message
> news:OXkcO42oFHA.3608@.TK2MSFTNGP15.phx.gbl...
>>I have made a mistake when I have installed SQL server.
>> I have installed Personal edition instead of standard edition.
>> How to change sql server edition from personal to standard if I have some
>> databases active?
>> Ales
>>
>
Instalation in a Quad-Core Server
I want to install SQL Server 2000 Standart or Enterprice Edition in a Server
with two Intel Quad Core processor. SQL server Standart support Quad Core
processors?Yes, you have to make sure during installation to select the licensing
option for 4 processors.
--
Anith|||Even if it's a Quad Core processor, it's only one physical processor, so you
just will have to buy only one Processor License for your SQL Server
environment. It does not matter how many cores the chip has on it. The
important thing is phsycally processor itself and it's physically count. If
it's only one chip, then it's only one processor and it requires only one
Processor License.
However, I highly recommend you to contact a local authorized software
vendor.
How to Buy Microsoft SQL Server:
http://www.microsoft.com/sql/howtobuy/default.mspx
Multicore and Hyperthreaded Processor Licensing:
http://download.microsoft.com/download/f/1/e/f1ecd771-cf97-4d98-9a1b-b86e3f24e08f/multicore_hyperthread_brief.doc
--
Ekrem Ã?nsoy
"Hector" <Hector@.discussions.microsoft.com> wrote in message
news:A05E2642-21B9-4BEA-AA0A-31CE58F7D15B@.microsoft.com...
>I want to install SQL Server 2000 Standart or Enterprice Edition in a
>Server
> with two Intel Quad Core processor. SQL server Standart support Quad Core
> processors?
>|||Should that be two processors?
Linchi
"Anith Sen" wrote:
> Yes, you have to make sure during installation to select the licensing
> option for 4 processors.
> --
> Anith
>
>|||Ah.. yes. Multiple cores integrated into single chip are treated as one unit
for processor licensing.
http://download.microsoft.com/download/f/1/e/f1ecd771-cf97-4d98-9a1b-b86e3f24e08f/multicore_hyperthread_brief.doc
--
Anith
with two Intel Quad Core processor. SQL server Standart support Quad Core
processors?Yes, you have to make sure during installation to select the licensing
option for 4 processors.
--
Anith|||Even if it's a Quad Core processor, it's only one physical processor, so you
just will have to buy only one Processor License for your SQL Server
environment. It does not matter how many cores the chip has on it. The
important thing is phsycally processor itself and it's physically count. If
it's only one chip, then it's only one processor and it requires only one
Processor License.
However, I highly recommend you to contact a local authorized software
vendor.
How to Buy Microsoft SQL Server:
http://www.microsoft.com/sql/howtobuy/default.mspx
Multicore and Hyperthreaded Processor Licensing:
http://download.microsoft.com/download/f/1/e/f1ecd771-cf97-4d98-9a1b-b86e3f24e08f/multicore_hyperthread_brief.doc
--
Ekrem Ã?nsoy
"Hector" <Hector@.discussions.microsoft.com> wrote in message
news:A05E2642-21B9-4BEA-AA0A-31CE58F7D15B@.microsoft.com...
>I want to install SQL Server 2000 Standart or Enterprice Edition in a
>Server
> with two Intel Quad Core processor. SQL server Standart support Quad Core
> processors?
>|||Should that be two processors?
Linchi
"Anith Sen" wrote:
> Yes, you have to make sure during installation to select the licensing
> option for 4 processors.
> --
> Anith
>
>|||Ah.. yes. Multiple cores integrated into single chip are treated as one unit
for processor licensing.
http://download.microsoft.com/download/f/1/e/f1ecd771-cf97-4d98-9a1b-b86e3f24e08f/multicore_hyperthread_brief.doc
--
Anith
Instalation
I'm facing a problem while installing SQL Server 2005 Express. When SQLServer Installer going to start service during instalation, installer don't start service and rollback the instalation. i found following message in SQL
LOG File
.2007-08-31 12:01:17.28 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-08-31 12:01:17.28 Server Detected 1 CPUs. This is an informational message; no user action is required.
2007-08-31 12:04:36.56 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2007-08-31 12:04:38.06 Server Database Mirroring Transport is disabled in the endpoint configuration.
2007-08-30 00:07:34.21 Server Service control: stop before startup
if u have any solution regarding above please help me.
Thankx in advance.Hi Zaib,
Please check this KB article and follow up the workaround inside.
http://support.microsoft.com/kb/920114
Error message when you try to install SQL Server Express or SQL Server Express Edition or SQL Server Express Edition with Advanced Services: "The SQL Server service failed to start"
CAUSE
This problem occurs because the Network Service account does not have permissions on the following folder: C:\Documents and Settings\NetworkService\Application Data\Microsoft\Protect
WORKAROUND
To work around this problem, grant the Network Service account the Full Control permission on the Protect folder. To do this, follow these steps:
1.
Open My Computer.
2.
Type C:\Documents and Settings\NetworkService\Application Data\Microsoft in the address bar, and then press ENTER.
3.
Right-click the Protect folder, and then click Properties.
4.
In the folder Properties dialog box, click the Security tab.
5.
Under Group or user names, determine whether NETWORK SERVICE is listed. If NETWORK SERVICE is not listed, follow these steps to add this account:
6.
Click NETWORK SERVICE under Group or user names, and then click to select the Allow check box for Full Control under Permissions for NETWORK SERVICE.
7.
Click OK to close the folder Properties dialog box.
8.
Click Retry in the error message dialog box to continue to install SQL Server Express Edition or SQL Server Express Edition with Advanced Services.
Note that the NetworkService folder may be hidden, and If the Protect folder is not found, you need to create it manually.
Please take a try. I hope that can help you.
These threads are similar to your issue.
SQL Express installation error
SQL Express Cannot Start
SQL server 2005 express failed to install under win2k SP4
Best regards,
Martin Xie
|||I move it from VB Express forum to SQL Server Express forum for better responses.
Thanks,
Martin
Instalation
I'm facing a problem while installing SQL Server 2005 Express. When SQLServer Installer going to start service during instalation, installer don't start service and rollback the instalation. i found following message in SQL
LOG File
.2007-08-31 12:01:17.28 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-08-31 12:01:17.28 Server Detected 1 CPUs. This is an informational message; no user action is required.
2007-08-31 12:04:36.56 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2007-08-31 12:04:38.06 Server Database Mirroring Transport is disabled in the endpoint configuration.
2007-08-30 00:07:34.21 Server Service control: stop before startup
if u have any solution regarding above please help me.
Thankx in advance.Hi Zaib,
Please check this KB article and follow up the workaround inside.
http://support.microsoft.com/kb/920114
Error message when you try to install SQL Server Express or SQL Server Express Edition or SQL Server Express Edition with Advanced Services: "The SQL Server service failed to start"
CAUSE
This problem occurs because the Network Service account does not have permissions on the following folder: C:\Documents and Settings\NetworkService\Application Data\Microsoft\Protect
WORKAROUND
To work around this problem, grant the Network Service account the Full Control permission on the Protect folder. To do this, follow these steps:
1.
Open My Computer.
2.
Type C:\Documents and Settings\NetworkService\Application Data\Microsoft in the address bar, and then press ENTER.
3.
Right-click the Protect folder, and then click Properties.
4.
In the folder Properties dialog box, click the Security tab.
5.
Under Group or user names, determine whether NETWORK SERVICE is listed. If NETWORK SERVICE is not listed, follow these steps to add this account:
6.
Click NETWORK SERVICE under Group or user names, and then click to select the Allow check box for Full Control under Permissions for NETWORK SERVICE.
7.
Click OK to close the folder Properties dialog box.
8.
Click Retry in the error message dialog box to continue to install SQL Server Express Edition or SQL Server Express Edition with Advanced Services.
Note that the NetworkService folder may be hidden, and If the Protect folder is not found, you need to create it manually.
Please take a try. I hope that can help you.
These threads are similar to your issue.
SQL Express installation error
SQL Express Cannot Start
SQL server 2005 express failed to install under win2k SP4
Best regards,
Martin Xie
|||I move it from VB Express forum to SQL Server Express forum for better responses.
Thanks,
Martin
Subscribe to:
Comments (Atom)