Showing posts with label edition. Show all posts
Showing posts with label edition. Show all posts

Thursday, March 29, 2012

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 SQL Server Management Studio Express on Windows Vista RC1

Hello NG,

After installing SQL Server 2005 Express Edition on Windows Vista RC1, I wanted to install also the Managent Studio but I always receive the following error message:

"Bei der Installation dieses Pakets ist ein unerwarteter Fehler aufgetreten. Es liegt eventuell ein das Paket betreffendes Problem vor. Der Fehlercode ist 29506."

Where can I find more infos about this error-code?

Anybody knows this problem?

Thank in advance for every help.

You might want to try installing under rasied permissions for the user... Also from memory the install of the express products on vista had not been approved (Supported) and MS were working on it with the Newer SP for the express products. You might want to check it out with one of the guys from MS. Also if you could translate the error message to english it might help some of use read what is going on....

|||I′ve got the same error. I started a cmd-shell as an Administrator and started the MSI package from there. This works.

HTH
Alexej Kucher

|||

Hi...

How can I start a cmd_shell as an Administrator.

thanks

|||Just right-click the command shell icon and choose "run as..." .Enter the admin credentials.

Error installing SQL Server Management Studio Express on Windows Vista RC1

Hello NG,

After installing SQL Server 2005 Express Edition on Windows Vista RC1, I wanted to install also the Managent Studio but I always receive the following error message:

"Bei der Installation dieses Pakets ist ein unerwarteter Fehler aufgetreten. Es liegt eventuell ein das Paket betreffendes Problem vor. Der Fehlercode ist 29506."

Where can I find more infos about this error-code?

Anybody knows this problem?

Thank in advance for every help.

You might want to try installing under rasied permissions for the user... Also from memory the install of the express products on vista had not been approved (Supported) and MS were working on it with the Newer SP for the express products. You might want to check it out with one of the guys from MS. Also if you could translate the error message to english it might help some of use read what is going on....

|||I′ve got the same error. I started a cmd-shell as an Administrator and started the MSI package from there. This works.

HTH
Alexej Kucher

|||

Hi...

How can I start a cmd_shell as an Administrator.

thanks

|||Just right-click the command shell icon and choose "run as..." .Enter the admin credentials.

Error installing SQL Server Management Studio Express on Windows Vista RC1

Hello NG,

After installing SQL Server 2005 Express Edition on Windows Vista RC1, I wanted to install also the Managent Studio but I always receive the following error message:

"Bei der Installation dieses Pakets ist ein unerwarteter Fehler aufgetreten. Es liegt eventuell ein das Paket betreffendes Problem vor. Der Fehlercode ist 29506."

Where can I find more infos about this error-code?

Anybody knows this problem?

Thank in advance for every help.

You might want to try installing under rasied permissions for the user... Also from memory the install of the express products on vista had not been approved (Supported) and MS were working on it with the Newer SP for the express products. You might want to check it out with one of the guys from MS. Also if you could translate the error message to english it might help some of use read what is going on....

|||I′ve got the same error. I started a cmd-shell as an Administrator and started the MSI package from there. This works.

HTH
Alexej Kucher|||

Hi...

How can I start a cmd_shell as an Administrator.

thanks

|||Just right-click the command shell icon and choose "run as..." .Enter the admin credentials.

Error installing SQL Server Management Studio Express

Yesterday I successfully installed Microsoft Visual Basic 2005 Express Edition which included SQL Server 2005 Express. Today I noticed I needed to download the Management Studio seperate download. I downloaded SQLServer2005_SSMSEE.msi and executed it and get the following error:

Error reading from file C:\...\SQLServer2005_SSMSEE.msi. Verify that the file exists and that you can access it..

Solved my own problem. Once I moved the msi to C:\ the installation worked. Apparently the path it was in was too long causing it to be unreadable. c:\xxxx\xxxx\SQLServer2005_SSMSEE.msiSQLServer2005_SSMSEE.msi.

Make sure you download the management tools for Express as well - it will make your life easier.

Buck Woody

Tuesday, March 27, 2012

Error installing SQL Server Management Studio Express

Yesterday I successfully installed Microsoft Visual Basic 2005 Express Edition which included SQL Server 2005 Express. Today I noticed I needed to download the Management Studio seperate download. I downloaded SQLServer2005_SSMSEE.msi and executed it and get the following error:

Error reading from file C:\...\SQLServer2005_SSMSEE.msi. Verify that the file exists and that you can access it..

Solved my own problem. Once I moved the msi to C:\ the installation worked. Apparently the path it was in was too long causing it to be unreadable. c:\xxxx\xxxx\SQLServer2005_SSMSEE.msiSQLServer2005_SSMSEE.msi.

Make sure you download the management tools for Express as well - it will make your life easier.

Buck Woody

sql

Error installing SQL Server Developer 2005

I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
time I attempt to I get the error message:
"Failed to install and configure assemblies C:\Program Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll
in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: MSDTC was unable to read its configuration information.
(Exception from HRESULT: 0x8004D027)"
Not only that, but in my Component Services->Distributed Transaction
Coordinator section, I get the following error message when trying to open
either the Transaction List or Transaction Statistics:
"Cannot open this folder because connection to the MSDTC service on 'My
Computer' failed."
Please help!
Thanks in advance,
Mervin Williams
Mervin Williams schrieb:
> I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
> time I attempt to I get the error message:
> "Failed to install and configure assemblies C:\Program Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: MSDTC was unable to read its configuration information.
> (Exception from HRESULT: 0x8004D027)"
> Not only that, but in my Component Services->Distributed Transaction
> Coordinator section, I get the following error message when trying to open
> either the Transaction List or Transaction Statistics:
> "Cannot open this folder because connection to the MSDTC service on 'My
> Computer' failed."
>
Maybe MSDTC is not running. You can check this by going into cmd
and type "net start" <enter>. You should see a "distributed transaction
coordinator" service. If not maybe its starttype is "disabled" and you
should change it to "automatic".
hth
Gregor Stefka
|||Actually, I have no "Distributed Transaction Coordinator" service in my
Services applet. Why is this and how do I install it?
Thanks in advance,
Mervin Williams
"Gregor Stefka" <stefka@.zuehlke-bieker.de> wrote in message
news:egCWZ7zkHHA.4876@.TK2MSFTNGP03.phx.gbl...
> Mervin Williams schrieb:
> Maybe MSDTC is not running. You can check this by going into cmd
> and type "net start" <enter>. You should see a "distributed transaction
> coordinator" service. If not maybe its starttype is "disabled" and you
> should change it to "automatic".
> hth
> Gregor Stefka
|||Mervin Williams (mwilliams@.innovasolutions.net) writes:
> I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
> time I attempt to I get the error message:
> "Failed to install and configure assemblies C:\Program Files\Microsoft SQL
>
Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notifications
ervices.dll
> in the COM+ catalog. Error: -2146233087
Do you plan to work with Notification Services? Not that I want to
belittle it, but is not the most commonly used component of SQL Server.
So if you have no direct need of it, why not just skip installing it?
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Error installing SQL Server Developer 2005

I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
time I attempt to I get the error message:
"Failed to install and configure assemblies C:\Program Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll
in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: MSDTC was unable to read its configuration information.
(Exception from HRESULT: 0x8004D027)"
Not only that, but in my Component Services->Distributed Transaction
Coordinator section, I get the following error message when trying to open
either the Transaction List or Transaction Statistics:
"Cannot open this folder because connection to the MSDTC service on 'My
Computer' failed."
Please help!
Thanks in advance,
Mervin WilliamsMervin Williams schrieb:
> I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
> time I attempt to I get the error message:
> "Failed to install and configure assemblies C:\Program Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: MSDTC was unable to read its configuration information.
> (Exception from HRESULT: 0x8004D027)"
> Not only that, but in my Component Services->Distributed Transaction
> Coordinator section, I get the following error message when trying to open
> either the Transaction List or Transaction Statistics:
> "Cannot open this folder because connection to the MSDTC service on 'My
> Computer' failed."
>
Maybe MSDTC is not running. You can check this by going into cmd
and type "net start" <enter>. You should see a "distributed transaction
coordinator" service. If not maybe its starttype is "disabled" and you
should change it to "automatic".
hth
Gregor Stefka|||Actually, I have no "Distributed Transaction Coordinator" service in my
Services applet. Why is this and how do I install it?
Thanks in advance,
Mervin Williams
"Gregor Stefka" <stefka@.zuehlke-bieker.de> wrote in message
news:egCWZ7zkHHA.4876@.TK2MSFTNGP03.phx.gbl...
> Mervin Williams schrieb:
>> I'm trying to install Microsoft SQL Server 2005 Developer Edition and
>> each
>> time I attempt to I get the error message:
>> "Failed to install and configure assemblies C:\Program Files\Microsoft
>> SQL
>> Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll
>> in the COM+ catalog. Error: -2146233087
>> Error message: Unknown error 0x80131501
>> Error description: MSDTC was unable to read its configuration
>> information.
>> (Exception from HRESULT: 0x8004D027)"
>> Not only that, but in my Component Services->Distributed Transaction
>> Coordinator section, I get the following error message when trying to
>> open
>> either the Transaction List or Transaction Statistics:
>> "Cannot open this folder because connection to the MSDTC service on 'My
>> Computer' failed."
> Maybe MSDTC is not running. You can check this by going into cmd
> and type "net start" <enter>. You should see a "distributed transaction
> coordinator" service. If not maybe its starttype is "disabled" and you
> should change it to "automatic".
> hth
> Gregor Stefka|||Mervin Williams (mwilliams@.innovasolutions.net) writes:
> I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
> time I attempt to I get the error message:
> "Failed to install and configure assemblies C:\Program Files\Microsoft SQL
>
Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notifications
ervices.dll
> in the COM+ catalog. Error: -2146233087
Do you plan to work with Notification Services? Not that I want to
belittle it, but is not the most commonly used component of SQL Server.
So if you have no direct need of it, why not just skip installing it?
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Error installing SQL Server Developer 2005

I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
time I attempt to I get the error message:
"Failed to install and configure assemblies C:\Program Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll
in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: MSDTC was unable to read its configuration information.
(Exception from HRESULT: 0x8004D027)"
Not only that, but in my Component Services->Distributed Transaction
Coordinator section, I get the following error message when trying to open
either the Transaction List or Transaction Statistics:
"Cannot open this folder because connection to the MSDTC service on 'My
Computer' failed."
Please help!
Thanks in advance,
Mervin Williams
Mervin Williams schrieb:
> I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
> time I attempt to I get the error message:
> "Failed to install and configure assemblies C:\Program Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: MSDTC was unable to read its configuration information.
> (Exception from HRESULT: 0x8004D027)"
> Not only that, but in my Component Services->Distributed Transaction
> Coordinator section, I get the following error message when trying to open
> either the Transaction List or Transaction Statistics:
> "Cannot open this folder because connection to the MSDTC service on 'My
> Computer' failed."
>
Maybe MSDTC is not running. You can check this by going into cmd
and type "net start" <enter>. You should see a "distributed transaction
coordinator" service. If not maybe its starttype is "disabled" and you
should change it to "automatic".
hth
Gregor Stefka
|||Actually, I have no "Distributed Transaction Coordinator" service in my
Services applet. Why is this and how do I install it?
Thanks in advance,
Mervin Williams
"Gregor Stefka" <stefka@.zuehlke-bieker.de> wrote in message
news:egCWZ7zkHHA.4876@.TK2MSFTNGP03.phx.gbl...
> Mervin Williams schrieb:
> Maybe MSDTC is not running. You can check this by going into cmd
> and type "net start" <enter>. You should see a "distributed transaction
> coordinator" service. If not maybe its starttype is "disabled" and you
> should change it to "automatic".
> hth
> Gregor Stefka
|||Mervin Williams (mwilliams@.innovasolutions.net) writes:
> I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
> time I attempt to I get the error message:
> "Failed to install and configure assemblies C:\Program Files\Microsoft SQL
>
Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notifications
ervices.dll
> in the COM+ catalog. Error: -2146233087
Do you plan to work with Notification Services? Not that I want to
belittle it, but is not the most commonly used component of SQL Server.
So if you have no direct need of it, why not just skip installing it?
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Error installing SQL Server Developer 2005

I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
time I attempt to I get the error message:
"Failed to install and configure assemblies C:\Program Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll
in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: MSDTC was unable to read its configuration information.
(Exception from HRESULT: 0x8004D027)"
Not only that, but in my Component Services->Distributed Transaction
Coordinator section, I get the following error message when trying to open
either the Transaction List or Transaction Statistics:
"Cannot open this folder because connection to the MSDTC service on 'My
Computer' failed."
Please help!
Thanks in advance,
Mervin Williams
Mervin Williams schrieb:
> I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
> time I attempt to I get the error message:
> "Failed to install and configure assemblies C:\Program Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: MSDTC was unable to read its configuration information.
> (Exception from HRESULT: 0x8004D027)"
> Not only that, but in my Component Services->Distributed Transaction
> Coordinator section, I get the following error message when trying to open
> either the Transaction List or Transaction Statistics:
> "Cannot open this folder because connection to the MSDTC service on 'My
> Computer' failed."
>
Maybe MSDTC is not running. You can check this by going into cmd
and type "net start" <enter>. You should see a "distributed transaction
coordinator" service. If not maybe its starttype is "disabled" and you
should change it to "automatic".
hth
Gregor Stefka
|||Actually, I have no "Distributed Transaction Coordinator" service in my
Services applet. Why is this and how do I install it?
Thanks in advance,
Mervin Williams
"Gregor Stefka" <stefka@.zuehlke-bieker.de> wrote in message
news:egCWZ7zkHHA.4876@.TK2MSFTNGP03.phx.gbl...
> Mervin Williams schrieb:
> Maybe MSDTC is not running. You can check this by going into cmd
> and type "net start" <enter>. You should see a "distributed transaction
> coordinator" service. If not maybe its starttype is "disabled" and you
> should change it to "automatic".
> hth
> Gregor Stefka
|||Mervin Williams (mwilliams@.innovasolutions.net) writes:
> I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
> time I attempt to I get the error message:
> "Failed to install and configure assemblies C:\Program Files\Microsoft SQL
>
Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notifications
ervices.dll
> in the COM+ catalog. Error: -2146233087
Do you plan to work with Notification Services? Not that I want to
belittle it, but is not the most commonly used component of SQL Server.
So if you have no direct need of it, why not just skip installing it?
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Error installing SQL Server Developer 2005

I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
time I attempt to I get the error message:
"Failed to install and configure assemblies C:\Program Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll
in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: MSDTC was unable to read its configuration information.
(Exception from HRESULT: 0x8004D027)"
Not only that, but in my Component Services->Distributed Transaction
Coordinator section, I get the following error message when trying to open
either the Transaction List or Transaction Statistics:
"Cannot open this folder because connection to the MSDTC service on 'My
Computer' failed."
Please help!
Thanks in advance,
Mervin Williams
Mervin Williams schrieb:
> I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
> time I attempt to I get the error message:
> "Failed to install and configure assemblies C:\Program Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: MSDTC was unable to read its configuration information.
> (Exception from HRESULT: 0x8004D027)"
> Not only that, but in my Component Services->Distributed Transaction
> Coordinator section, I get the following error message when trying to open
> either the Transaction List or Transaction Statistics:
> "Cannot open this folder because connection to the MSDTC service on 'My
> Computer' failed."
>
Maybe MSDTC is not running. You can check this by going into cmd
and type "net start" <enter>. You should see a "distributed transaction
coordinator" service. If not maybe its starttype is "disabled" and you
should change it to "automatic".
hth
Gregor Stefka
|||Actually, I have no "Distributed Transaction Coordinator" service in my
Services applet. Why is this and how do I install it?
Thanks in advance,
Mervin Williams
"Gregor Stefka" <stefka@.zuehlke-bieker.de> wrote in message
news:egCWZ7zkHHA.4876@.TK2MSFTNGP03.phx.gbl...
> Mervin Williams schrieb:
> Maybe MSDTC is not running. You can check this by going into cmd
> and type "net start" <enter>. You should see a "distributed transaction
> coordinator" service. If not maybe its starttype is "disabled" and you
> should change it to "automatic".
> hth
> Gregor Stefka
|||Mervin Williams (mwilliams@.innovasolutions.net) writes:
> I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
> time I attempt to I get the error message:
> "Failed to install and configure assemblies C:\Program Files\Microsoft SQL
>
Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notifications
ervices.dll
> in the COM+ catalog. Error: -2146233087
Do you plan to work with Notification Services? Not that I want to
belittle it, but is not the most commonly used component of SQL Server.
So if you have no direct need of it, why not just skip installing it?
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
sql

Error installing SQL Server Developer 2005

I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
time I attempt to I get the error message:
"Failed to install and configure assemblies C:\Program Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notifications
ervices.dll
in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: MSDTC was unable to read its configuration information.
(Exception from HRESULT: 0x8004D027)"
Not only that, but in my Component Services->Distributed Transaction
Coordinator section, I get the following error message when trying to open
either the Transaction List or Transaction Statistics:
"Cannot open this folder because connection to the MSDTC service on 'My
Computer' failed."
Please help!
Thanks in advance,
Mervin WilliamsMervin Williams schrieb:
> I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
> time I attempt to I get the error message:
> "Failed to install and configure assemblies C:\Program Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificatio
nservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: MSDTC was unable to read its configuration information.
> (Exception from HRESULT: 0x8004D027)"
> Not only that, but in my Component Services->Distributed Transaction
> Coordinator section, I get the following error message when trying to open
> either the Transaction List or Transaction Statistics:
> "Cannot open this folder because connection to the MSDTC service on 'My
> Computer' failed."
>
Maybe MSDTC is not running. You can check this by going into cmd
and type "net start" <enter>. You should see a "distributed transaction
coordinator" service. If not maybe its starttype is "disabled" and you
should change it to "automatic".
hth
Gregor Stefka|||Actually, I have no "Distributed Transaction Coordinator" service in my
Services applet. Why is this and how do I install it?
Thanks in advance,
Mervin Williams
"Gregor Stefka" <stefka@.zuehlke-bieker.de> wrote in message
news:egCWZ7zkHHA.4876@.TK2MSFTNGP03.phx.gbl...
> Mervin Williams schrieb:
> Maybe MSDTC is not running. You can check this by going into cmd
> and type "net start" <enter>. You should see a "distributed transaction
> coordinator" service. If not maybe its starttype is "disabled" and you
> should change it to "automatic".
> hth
> Gregor Stefka|||Mervin Williams (mwilliams@.innovasolutions.net) writes:
> I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
> time I attempt to I get the error message:
> "Failed to install and configure assemblies C:\Program Files\Microsoft SQL
>
Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notifications
ervices.dll
> in the COM+ catalog. Error: -2146233087
Do you plan to work with Notification Services? Not that I want to
belittle it, but is not the most commonly used component of SQL Server.
So if you have no direct need of it, why not just skip installing it?
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Error installing SQL Server 7 on XP Pro

I need to install SQL Server 7 Desktop Edition on an XP Pro machine.
When I try, using my MSDN SQL Server 7 CD, I get an error dialog with
the following message. This error occurs before I get the splash
screen asking if I want to install the Desktop or Standard Edition.
"The Enterprise Edition server component cannot be installed on
Windows NT workstation using this CD. Only client components will be
available for installation."
What do I have to do to install 7.0 on XP Pro?
Thanks.
Bill
Bill,
Probably you are using the incorrect CD. I've already installed many times -
the Desktop Edition, without any problem.
Regards,
Vitor Mauricio
Is not possible to install
"Bill Todd" <no@.no.com> wrote in message
news:kk74c0lpd8jfgod5qt3qbrhu0btbs6f2ag@.4ax.com...
> I need to install SQL Server 7 Desktop Edition on an XP Pro machine.
> When I try, using my MSDN SQL Server 7 CD, I get an error dialog with
> the following message. This error occurs before I get the splash
> screen asking if I want to install the Desktop or Standard Edition.
> "The Enterprise Edition server component cannot be installed on
> Windows NT workstation using this CD. Only client components will be
> available for installation."
> What do I have to do to install 7.0 on XP Pro?
> Thanks.
> --
> Bill

Error installing SQL Server 7 on XP Pro

I need to install SQL Server 7 Desktop Edition on an XP Pro machine.
When I try, using my MSDN SQL Server 7 CD, I get an error dialog with
the following message. This error occurs before I get the splash
screen asking if I want to install the Desktop or Standard Edition.
"The Enterprise Edition server component cannot be installed on
Windows NT workstation using this CD. Only client components will be
available for installation."
What do I have to do to install 7.0 on XP Pro?
Thanks.
--
BillBill,
Probably you are using the incorrect CD. I've already installed many times -
the Desktop Edition, without any problem.
Regards,
Vitor Mauricio
Is not possible to install
"Bill Todd" <no@.no.com> wrote in message
news:kk74c0lpd8jfgod5qt3qbrhu0btbs6f2ag@.
4ax.com...
> I need to install SQL Server 7 Desktop Edition on an XP Pro machine.
> When I try, using my MSDN SQL Server 7 CD, I get an error dialog with
> the following message. This error occurs before I get the splash
> screen asking if I want to install the Desktop or Standard Edition.
> "The Enterprise Edition server component cannot be installed on
> Windows NT workstation using this CD. Only client components will be
> available for installation."
> What do I have to do to install 7.0 on XP Pro?
> Thanks.
> --
> Bill

Error installing SQL Server 7 on XP Pro

I need to install SQL Server 7 Desktop Edition on an XP Pro machine.
When I try, using my MSDN SQL Server 7 CD, I get an error dialog with
the following message. This error occurs before I get the splash
screen asking if I want to install the Desktop or Standard Edition.
"The Enterprise Edition server component cannot be installed on
Windows NT workstation using this CD. Only client components will be
available for installation."
What do I have to do to install 7.0 on XP Pro?
Thanks.
--
BillBill,
Probably you are using the incorrect CD. I've already installed many times -
the Desktop Edition, without any problem.
Regards,
Vitor Mauricio
Is not possible to install
"Bill Todd" <no@.no.com> wrote in message
news:kk74c0lpd8jfgod5qt3qbrhu0btbs6f2ag@.4ax.com...
> I need to install SQL Server 7 Desktop Edition on an XP Pro machine.
> When I try, using my MSDN SQL Server 7 CD, I get an error dialog with
> the following message. This error occurs before I get the splash
> screen asking if I want to install the Desktop or Standard Edition.
> "The Enterprise Edition server component cannot be installed on
> Windows NT workstation using this CD. Only client components will be
> available for installation."
> What do I have to do to install 7.0 on XP Pro?
> Thanks.
> --
> Bill

Error installing sql server 2005 express edition

I am trying to install sql server 2005 express edition.But i get an error stating that

sql server setup unexpectedly failed. For more information review the detup summary log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\summary.txt

Summary.txt looks like this.It has only these 3 lines of information nothing else other this, which i have seen in many posts.


Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows XP Home Edition Service Pack 2 (Build 2600)
Time : Tue Apr 03 22:36:33 2007

I am using windows xp. Probably many of you might have had this problem.Could anyone please provide me with some help.Thanks in advance.

Are there any files in the folder at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files? These are the detailed log files. If there are any files with similar date/time stamps as the summary.txt file, take a look at those to see if anything stands out.

Mike

|||

Thanks for your reply. There are 2 more folders (Files and Hotfix). under Files there was a file named

SQLSetup0025_ARUN_Core.txt. I am not sure what these files mean and there are few more files under Hotfix. Any suggestions?

Microsoft SQL Server 2005 Setup beginning at Tue Apr 03 22:36:33 2007
Process ID : 1932
d:\7733ee80231e45be08e36dd892bf84ea\setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/3/3 22:36:33
Complete: LoadResourcesAction at: 2007/3/3 22:36:33, returned true
Running: ParseBootstrapOptionsAction at: 2007/3/3 22:36:33
Loaded DLLBig Smile:\7733ee80231e45be08e36dd892bf84ea\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/3/3 22:36:33, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 124
-
writeEncryptedString() failed
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 123
-
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Wed Jun 14 16:28:04 2006
Function Name: sqls::CryptSameUserSameMachine:Stick out tonguerotectData
Source Line Number: 50

2
Could not skip Component update due to datastore exception.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "1932"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/3/3 22:36:33
Complete: ValidateWinNTAction at: 2007/3/3 22:36:33, returned true
Running: ValidateMinOSAction at: 2007/3/3 22:36:33
Complete: ValidateMinOSAction at: 2007/3/3 22:36:33, returned true
Running: PerformSCCAction at: 2007/3/3 22:36:33
Complete: PerformSCCAction at: 2007/3/3 22:36:33, returned true
Running: ActivateLoggingAction at: 2007/3/3 22:36:33
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
00E5CFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "1932"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

Thanks,
Arun

|||

Hi Arun,

It looks like the CryptoAPI is failing, check out this post and look at the answer from Jeffery.

Mike

sql

Error installing SQL Server 2005 Developer Edition

I get the following error installing SQL Server 2005 Developer Edition

Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: You must have administrative credentials to perform this task. Contact your system administrator for assistance.

I am installing on Windows XP with Admin privs.

There is nothing listed in COM+ Services for SQL.

The Distributed Transaction Coordinator service is running.

There is a previous installation of SQL 2000 Developer Edition installed.

I have seen some pretty old posts with the same error.

I was wondering if there was a final resolution, service pack, etc. that solves this problem?

I think your best bet is to follow Milos' suggestion in this thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1143461&SiteID=1

Thanks,
Sam Lester (MSFT)

|||

As I mentioned, there is nothing in COM+ services for SQL.

I just clicked ignore to let the installation continue.

I have not tried to use integration services yet.

Error installing SQL Server 2000 Developer Edition

Hello, I hope someone knows the answer to this issue. I am trying to install SQL Server 2000 Developer Edition and once I get to the screen that is asking for the SQL Server instance and Login Information I receive the following error when trying to proceed.

(Report Server database is a different version and cannot be used for this installation)

I have installed reporting services 2000 developer edition many times and I have never seen this error.

Are you adding a new Report Server to an existing deployment? If so then you are probably impacted by the Service Pack of the SQL Server instance.

I have seen something like this before but can't recall exactly the resolution. However I do recall I was able to find some documentation on this on the Microsoft site.

Sorry can't be of any more help

|||

I ran into the same problem installing Reporting Services on a new web server and I deleted the Report and ReportTemp databases form the server and then the install went fine.

Error Installing SQL Server 2000

I have a problem installing SQL Server 2000 standard edition in a Windows 2003 Server , when I try to setup there is a message saying :
" You cannot install SQL server 2000 sp 2 and below in this operating system " and the installation stops .

I have tried to run sp3 before the installation but obviously It doesnt work . I think the solution is something like updating the setup program to make it work in Windows 2003 Server , when I see the system requirements on the box it says that I can install SQL server 2000 in w2003 .

what can I do ?

thanks a lot for your help .That was not an error message. We have several DB servers with SQL 2000 running on Win2003. It's a warning message telling you that you have to patch up to sp2 or later to run SQL on Win2003. It should let you install SQL 2000 after that message. If you have problems, it's probably something else. How could you have sp3 installed on the server if you haven't installed SQL on there? I'm just taking what you said in your post.|||yes , It has to be something else . Of course I could not install sp3 because SQL server is not running .|||I got the same thing - ignore it. Just make sure you install SP3 and you'll be fine. After installing, you can check the event viewer, and see that it won't start the service until you apply the proper service pack.|||As I am saying the installation stops , and the setup dialog disappears , Nothing gets installed , I am started to think there is some problem with the windows 2003 server setup CD , I do not know ... any ideas ? I have tried to install SQL server from two different CDs and It doesnt work . Thats why I think the problem is with the Windows 2003 CD.|||you may need to update your msi installer. some times this can become corrupt. make sure you look up information on how to update the msi. i have never done this before but found that it could be a solution to your problem. one more thing BACK UP!!!! before you do this. (no brainer)sql