error installing standard edition on a windows 2003 server

I have a windows 2003 server with the latest service pack and patches. This server also acts a domain controller.
Is installing standard edition on a server that is a domain controller supported because it looks like install is trying to create and add to local groups which are not present on a server if it is a domain controller.

I tried installing the standard edition of sql server and I get the following error:
ITLE: Microsoft SQL Server 2005 CTP Setup

SQL Server Setup was unable add user NT AUTHORITY\SYSTEM to local group SQLServer2005SQLBrowserUser.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1187.07&EvtSrc=setup.rll&EvtID=1603&EvtType=sqlca%5csqlsecurityca.cpp%40Do_sqlGroupMember%40Do_sqlGroupMember%40x735d

BUTTONS:

OK

TITLE: Microsoft SQL Server 2005 CTP Setup

The setup has encountered an unexpected error while Installing Local Groups. The error is :The system cannot find the file specified.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1187.07&EvtSrc=setup.rll&EvtID=2&EvtType=Unknown%40Rollback_sqlGroupMember%40Unknown%40x0

BUTTONS:

OK

Currently SQL Server 2005 will not install on a Domain Controller or on Windows Small Business Server. There is no known work around at this time other than installing on a machine that is not configured as a domain controller. This is a known issue and we're working on resolving it.

Dan|||is this fix now?|||

3.10 Installing SQL Server Express on a Windows Domain Controller

Security Note:

We recommend against running SQL Server Express on a domain controller.

It is possible to install SQL Server Express on a Windows domain controller; however, it cannot run on a Windows Server 2003 domain controller as Local Service or Network Service. SQL Server service accounts should run as Windows domain user accounts. It is also possible to install SQL Server service accounts to run as Local System, but this option is not recommended.

Do not change the role of the server after you install SQL Server Express. For example, if you install SQL Server Express on a member server, do not use the Dcpromo tool to promote the server to a domain controller. Or, if you install SQL Server Express on a domain controller, do not use Dcpromo to demote the server to a member server. Changing the role of a server after you install SQL Server Express can result in loss of functionality and is not supported.

error installing standard edition on a windows 2003 server

I have a windows 2003 server with the latest service pack and patches. This server also acts a domain controller.
Is installing standard edition on a server that is a domain controller supported because it looks like install is trying to create and add to local groups which are not present on a server if it is a domain controller.

I tried installing the standard edition of sql server and I get the following error:
ITLE: Microsoft SQL Server 2005 CTP Setup

SQL Server Setup was unable add user NT AUTHORITY\SYSTEM to local group SQLServer2005SQLBrowserUser.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1187.07&EvtSrc=setup.rll&EvtID=1603&EvtType=sqlca%5csqlsecurityca.cpp%40Do_sqlGroupMember%40Do_sqlGroupMember%40x735d

BUTTONS:

OK

TITLE: Microsoft SQL Server 2005 CTP Setup

The setup has encountered an unexpected error while Installing Local Groups. The error is :The system cannot find the file specified.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1187.07&EvtSrc=setup.rll&EvtID=2&EvtType=Unknown%40Rollback_sqlGroupMember%40Unknown%40x0

BUTTONS:

OK

Currently SQL Server 2005 will not install on a Domain Controller or on Windows Small Business Server. There is no known work around at this time other than installing on a machine that is not configured as a domain controller. This is a known issue and we're working on resolving it.

Dan|||is this fix now?|||

3.10 Installing SQL Server Express on a Windows Domain Controller

Security Note:

We recommend against running SQL Server Express on a domain controller.

It is possible to install SQL Server Express on a Windows domain controller; however, it cannot run on a Windows Server 2003 domain controller as Local Service or Network Service. SQL Server service accounts should run as Windows domain user accounts. It is also possible to install SQL Server service accounts to run as Local System, but this option is not recommended.

Do not change the role of the server after you install SQL Server Express. For example, if you install SQL Server Express on a member server, do not use the Dcpromo tool to promote the server to a domain controller. Or, if you install SQL Server Express on a domain controller, do not use Dcpromo to demote the server to a member server. Changing the role of a server after you install SQL Server Express can result in loss of functionality and is not supported.

Error Installing Service Pack 1

Hi all,
I tried to upgrade a clients site to Sp1 and got the following error:
"SQL Setup failed to connect to the database service for server
configuration. Refer to the Server error logs and setup logs for more
detailed error information."
I was just wondering if anyone else has come across this error and know any
ways to fix it?
Also does the account I am logged onto (or Term Served into) the box with
require access to the Configuration Database or the Database Server?
And I can't find any documentation on what security level is required for
applying the Service Pack ie. SQL System Administrator or just DBO of the
config database?
Thanks in advance.
Angus LoganJust like the original setup, the service pack uses integrated security to
update the ReportServer database. You need to have dbo privileges to the
database on the machine where setup is being run.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Angus Logan" <angus_logan@.data3.com.au> wrote in message
news:ebzCsMeWEHA.384@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> I tried to upgrade a clients site to Sp1 and got the following error:
> "SQL Setup failed to connect to the database service for server
> configuration. Refer to the Server error logs and setup logs for more
> detailed error information."
> I was just wondering if anyone else has come across this error and know
> any
> ways to fix it?
> Also does the account I am logged onto (or Term Served into) the box with
> require access to the Configuration Database or the Database Server?
> And I can't find any documentation on what security level is required for
> applying the Service Pack ie. SQL System Administrator or just DBO of the
> config database?
> Thanks in advance.
> Angus Logan
>

error in sql server 2005 setup on win2k sp4

error msg in summary.txt

Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows 2000 Server Service Pack 4 (Build 2195)
Time : Wed Feb 14 03:31:27 2007
LDINTSQL1 : There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information.

SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.

Time : Wed Feb 14 03:39:30 2007

List of log files:
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_LDINTSQL1_Core.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_LDINTSQL1_Datastore.xml
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_LDINTSQL1_.NET Framework 2.0.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_LDINTSQL1_.NET Framework 2.0 LangPack.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_LDINTSQL1_.NET Framework Upgrade Advisor.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_LDINTSQL1_.NET Framework Upgrade Advisor LangPack.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_LDINTSQL1_.NET Framework Windows Installer.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_LDINTSQL1_.NET Framework Windows Installer LangPack.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_LDINTSQL1_SNAC.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_LDINTSQL1_Support.log

error msg in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_LDINTSQL1_Core.log

Microsoft SQL Server 2005 Setup beginning at Wed Feb 14 03:31:27 2007
Process ID : 2176
\\ldnas1\msdn versions\Server Applications\SQL Server 2005 std\Servers\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/1/14 3:31:27
Complete: LoadResourcesAction at: 2007/1/14 3:31:27, returned true
Running: ParseBootstrapOptionsAction at: 2007/1/14 3:31:27
Loaded DLL:\\ldnas1\msdn versions\Server Applications\SQL Server 2005 std\Servers\xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/1/14 3:31:27, returned true
Running: ValidateWinNTAction at: 2007/1/14 3:31:27
Complete: ValidateWinNTAction at: 2007/1/14 3:31:27, returned true
Running: ValidateMinOSAction at: 2007/1/14 3:31:27
Complete: ValidateMinOSAction at: 2007/1/14 3:31:27, returned true
Running: PerformSCCAction at: 2007/1/14 3:31:27
Complete: PerformSCCAction at: 2007/1/14 3:31:27, returned true
Running: ActivateLoggingAction at: 2007/1/14 3:31:27
Complete: ActivateLoggingAction at: 2007/1/14 3:31:27, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__2176" returned false.
Running: PerformSCCAction2 at: 2007/1/14 3:31:27
Loaded DLL:C:\WINNT\system32\msi.dll Version:3.1.4000.2435
Loaded DLL:C:\WINNT\system32\msi.dll Version:3.1.4000.2435
Complete: PerformSCCAction2 at: 2007/1/14 3:31:27, returned true
Running: PerformDotNetCheck at: 2007/1/14 3:31:27
Complete: PerformDotNetCheck at: 2007/1/14 3:31:27, returned true
Running: ComponentUpdateAction at: 2007/1/14 3:31:27
Complete: ComponentUpdateAction at: 2007/1/14 3:31:54, returned true
Delay load of action "DetectLocalBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchLocalBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchLocalBootstrap__2176" returned false.
Running: PerformDotNetCheck2 at: 2007/1/14 3:31:54
Complete: PerformDotNetCheck2 at: 2007/1/14 3:31:54, returned true
Running: InvokeSqlSetupDllAction at: 2007/1/14 3:31:54
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution.
Failed to determine path to bootstrap files : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: setup\sqlsetupactions.cpp
Compiler Timestamp: Thu Sep 1 22:23:04 2005
Function Name: sqls::InvokeSqlSetupDllAction::perform
Source Line Number: 1663

any ideas?

thanks

Does your server have MDAC 2.8 SP1 installed (It is a pre-req for SQL Server 2005 setup)? To see the version of MDAC installed, you can do the following.

1. Start ->Run and type "regedit".

2. In the registry tree in the left panel, drill down to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\Version. The version key should have "2.81.1117.0".

If MDAC version on the machine is less than 2.8 SP1, then you should go to download center and installing Mdac 2.8 sp1 redist from there.

If you have Mdac 2.8 sp1 installed, then can you provide the following info?

1. Are you an admin on the box?

2. What is the OS language although it shouldn't matter.

3. What is the language of SQL Server 2005 you are installing?

4. How are you installing it: Double-clicking setup.exe or through command line parameters passed to setup.exe?

5. Have you done previous installs of SQL Server 2005 on the machine?

6. Is the SQL Server 2005 you are installing an RTM release, if so which SKU?

---

This posting is provided "AS IS" with no warranties, and confers no rights.

Error in restore

Dear Newsgroup,
I am using sql server 2000 over win 2000 server with service pack 4.
I have been given a back up of a database (I have tried both from T-SQL and
Enterprise Manager)
T-SQL
RESTORE FILELISTONLY
FROM DISK = 'c:\A.bck'
RESTORE DATABASE B
FROM DISK = 'c:\A.bck'
WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
MOVE 'A_Log' TO 'c:\test\B.ldf'
and as I try to restore I get the following error :
Server: Msg 3154, Level 16, State 2, Line 1
The backup set holds a backup of a database other than the existing 'B'
database.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Would you kindly help me ''?
Thank you in advance,
YassYou need to specify the REPLACE option. This is needed when the target
database exists and the backup was created from a database with a different
name.
RESTORE DATABASE B
FROM DISK = 'c:\A.bck'
WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
MOVE 'A_Log' TO 'c:\test\B.ldf',
REPLACE
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Yass" <gol_e_yass@.yahoo.com> wrote in message
news:bv0tq4$1r58@.news.emirates.net.ae...
> Dear Newsgroup,
>
> I am using sql server 2000 over win 2000 server with service pack 4.
> I have been given a back up of a database (I have tried both from T-SQL
and
> Enterprise Manager)
> T-SQL
> RESTORE FILELISTONLY
> FROM DISK = 'c:\A.bck'
> RESTORE DATABASE B
> FROM DISK = 'c:\A.bck'
> WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
> MOVE 'A_Log' TO 'c:\test\B.ldf'
> and as I try to restore I get the following error :
> Server: Msg 3154, Level 16, State 2, Line 1
> The backup set holds a backup of a database other than the existing 'B'
> database.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Would you kindly help me ''?
> Thank you in advance,
> Yass
>
>
>

Error in restore

Dear Newsgroup,
I am using sql server 2000 over win 2000 server with service pack 4.
I have been given a back up of a database (I have tried both from T-SQL and
Enterprise Manager)
T-SQL
RESTORE FILELISTONLY
FROM DISK = 'c:\A.bck'
RESTORE DATABASE B
FROM DISK = 'c:\A.bck'
WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
MOVE 'A_Log' TO 'c:\test\B.ldf'
and as I try to restore I get the following error :
Server: Msg 3154, Level 16, State 2, Line 1
The backup set holds a backup of a database other than the existing 'B'
database.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Would you kindly help me ''?
Thank you in advance,
YassYou need to specify the REPLACE option. This is needed when the target
database exists and the backup was created from a database with a different
name.
RESTORE DATABASE B
FROM DISK = 'c:\A.bck'
WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
MOVE 'A_Log' TO 'c:\test\B.ldf',
REPLACE
Hope this helps.
Dan Guzman
SQL Server MVP
"Yass" <gol_e_yass@.yahoo.com> wrote in message
news:bv0tq4$1r58@.news.emirates.net.ae...

quote:

---

> Dear Newsgroup,
>
> I am using sql server 2000 over win 2000 server with service pack 4.
> I have been given a back up of a database (I have tried both from T-SQL

---

and

quote:

---

> Enterprise Manager)
> T-SQL
> RESTORE FILELISTONLY
> FROM DISK = 'c:\A.bck'
> RESTORE DATABASE B
> FROM DISK = 'c:\A.bck'
> WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
> MOVE 'A_Log' TO 'c:\test\B.ldf'
> and as I try to restore I get the following error :
> Server: Msg 3154, Level 16, State 2, Line 1
> The backup set holds a backup of a database other than the existing 'B'
> database.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Would you kindly help me ''?
> Thank you in advance,
> Yass
>
>
>

---

error in installing hot fix

i installed an service pack 2

Quick Details

Version:

9.00.3042

Knowledge Base (KB) Articles:

KB921896

Date Published:

3/6/2007

Language:

English

Download Size:

282.4 MB - 392.4 MB*

*Download size depends on selected download components.

the above installation , i was success. but the version is 9.00.3042. so what i did was i stalled the hot fix , http://support.microsoft.com/kb/933097

but this hox fis installation is success for all, but it failed for database services with below error message :

product Installation Status
Product : SQL Server Database Services 2005 (MSSQLSERVER)
Product Version (Previous): 3152
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB933097_sqlrun_sql.msp.log
Error Number : 29537
Error Description : MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.

now i don't know what to do...

i don't want to uninstall sqlserver 2005 and redo the whole thing...

because thisd is my first assinment in the new job and if i redo the whole thing then it won't be good since it'll take 1 week..

is there any way i can solve this issue?

A Knowledge Based article has been published explaining the problem and workaround:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;918695

Please let us know if this article does not address your problem.

Thanks,
Sam Lester (MSFT)

|||but i installed sp2.
the above kb is the issue with sp1

error in installing hot fix

i installed an service pack 2

Quick Details

Version:

9.00.3042

Knowledge Base (KB) Articles:

KB921896

Date Published:

3/6/2007

Language:

English

Download Size:

282.4 MB - 392.4 MB*

*Download size depends on selected download components.

the above installation , i was success. but the version is 9.00.3042. so what i did was i stalled the hot fix , http://support.microsoft.com/kb/933097

but this hox fis installation is success for all, but it failed for database services with below error message :

product Installation Status
Product : SQL Server Database Services 2005 (MSSQLSERVER)
Product Version (Previous): 3152
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB933097_sqlrun_sql.msp.log
Error Number : 29537
Error Description : MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.

now i don't know what to do...

i don't want to uninstall sqlserver 2005 and redo the whole thing...

because thisd is my first assinment in the new job and if i redo the whole thing then it won't be good since it'll take 1 week..

is there any way i can solve this issue?

A Knowledge Based article has been published explaining the problem and workaround:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;918695

Please let us know if this article does not address your problem.

Thanks,
Sam Lester (MSFT)

|||but i installed sp2.
the above kb is the issue with sp1