Problem running SSIS from C# program.

I am able to run it from the file system but when I try running it from SQL Server I get an error message that it cannot load package. I am using the following code.

Package package = app.LoadFromSqlServer("trans_hist", Properties.Resources.dbServerName, Properties.Resources.userId, Properties.Resources.password, null);Nobody is doing this?|||What is the error message exactly? Can you see the package in the MSDB database when looking in Management Studio?

Have you read through this? http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.application.loadfromsqlserver.aspx|||The specified package could not be loaded from the SQL Server Database /r/n

I tried both this
Package package = app.LoadFromSqlServer("trans_hist", Properties.Resources.dbServerName, Properties.Resources.userId, Properties.Resources.password, null);

and this
Package package = app.LoadFromSqlServer("\\MSDB\\Maintenance Plans\\trans_hist", "ppntt240", "id", "password", null);

I also tries adding .dtsx to the SSIS name.|||I think you may want:

"\\Maintenance Plans\\trans_hist"|||That was it, thank you.

Problem running SSIS from C# program.

I am able to run it from the file system but when I try running it from SQL Server I get an error message that it cannot load package. I am using the following code.

Package package = app.LoadFromSqlServer("trans_hist", Properties.Resources.dbServerName, Properties.Resources.userId, Properties.Resources.password, null);

Nobody is doing this?
|||What is the error message exactly? Can you see the package in the MSDB database when looking in Management Studio?

Have you read through this? http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.application.loadfromsqlserver.aspx|||The specified package could not be loaded from the SQL Server Database /r/n

I tried both this
Package package = app.LoadFromSqlServer("trans_hist", Properties.Resources.dbServerName, Properties.Resources.userId, Properties.Resources.password, null);

and this
Package package = app.LoadFromSqlServer("\\MSDB\\Maintenance Plans\\trans_hist", "ppntt240", "id", "password", null);

I also tries adding .dtsx to the SSIS name.
|||I think you may want:

"\\Maintenance Plans\\trans_hist"|||That was it, thank you.

Problem restoring a SQL 2005 database from a backup device

Hi
Other posts indicate this error message occurs if you try and restore from
SQL 2005 to SQL 2000 see http://tinyurl.com/nqfls and [url]http://tinyurl.com/kajam[/ur
l]
John
"wolf.emissar@.gmail.com" wrote:

> I am trying to restore a database from a backup device and when I try
> to add the backup device in the restore database wizard I receive the
> following error message:
> An exception occurred while executing a transact-sql statement or
> batch.
> Too many backup devices specified for backup or restore; only 64 are
> allowed. RESTORE HEADER ONLY is terminating abnormally.
> The backup device was created using SQL Server 2005 and I am trying to
> restore the database to an Express version of 2005.
> I can restore the database successfully if I restore it to the same
> server that I created the backup device on.
> For a little background, I am trying to backup a database on a server
> to a laptop for business continuity purposes. The database is under 1
> gig in total size.
> Any insight is greatly appreciated.
>I am trying to restore a database from a backup device and when I try
to add the backup device in the restore database wizard I receive the
following error message:
An exception occurred while executing a transact-sql statement or
batch.
Too many backup devices specified for backup or restore; only 64 are
allowed. RESTORE HEADER ONLY is terminating abnormally.
The backup device was created using SQL Server 2005 and I am trying to
restore the database to an Express version of 2005.
I can restore the database successfully if I restore it to the same
server that I created the backup device on.
For a little background, I am trying to backup a database on a server
to a laptop for business continuity purposes. The database is under 1
gig in total size.
Any insight is greatly appreciated.|||Hi
Other posts indicate this error message occurs if you try and restore from
SQL 2005 to SQL 2000 see http://tinyurl.com/nqfls and [url]http://tinyurl.com/kajam[/ur
l]
John
"wolf.emissar@.gmail.com" wrote:

> I am trying to restore a database from a backup device and when I try
> to add the backup device in the restore database wizard I receive the
> following error message:
> An exception occurred while executing a transact-sql statement or
> batch.
> Too many backup devices specified for backup or restore; only 64 are
> allowed. RESTORE HEADER ONLY is terminating abnormally.
> The backup device was created using SQL Server 2005 and I am trying to
> restore the database to an Express version of 2005.
> I can restore the database successfully if I restore it to the same
> server that I created the backup device on.
> For a little background, I am trying to backup a database on a server
> to a laptop for business continuity purposes. The database is under 1
> gig in total size.
> Any insight is greatly appreciated.
>|||John, thanks for the response. I am trying to restore to a 2005
instance but it is an Express version, I don't know if this is the
source of the problem or not.
In the second link you attached Tibor mentions logging into a 2000
instance. This sounds very much like the error I am receiving, do you
know what he is referring to? Can express 2005 be configured to run as
a 2000 instance?
John Bell wrote:[vbcol=seagreen]
> Hi
> Other posts indicate this error message occurs if you try and restore from
> SQL 2005 to SQL 2000 see http://tinyurl.com/nqfls and [url]http://tinyurl.com/kajam[/
url]
> John
> "wolf.emissar@.gmail.com" wrote:
>|||John, thanks for the response. I am trying to restore to a 2005
instance but it is an Express version, I don't know if this is the
source of the problem or not.
In the second link you attached Tibor mentions logging into a 2000
instance. This sounds very much like the error I am receiving, do you
know what he is referring to? Can express 2005 be configured to run as
a 2000 instance?
John Bell wrote:[vbcol=seagreen]
> Hi
> Other posts indicate this error message occurs if you try and restore from
> SQL 2005 to SQL 2000 see http://tinyurl.com/nqfls and [url]http://tinyurl.com/kajam[/
url]
> John
> "wolf.emissar@.gmail.com" wrote:
>|||wolf.emissar@.gmail.com wrote:
> I am trying to restore a database from a backup device and when I try
> to add the backup device in the restore database wizard I receive the
> following error message:
> An exception occurred while executing a transact-sql statement or
> batch.
> Too many backup devices specified for backup or restore; only 64 are
> allowed. RESTORE HEADER ONLY is terminating abnormally.
> The backup device was created using SQL Server 2005 and I am trying to
> restore the database to an Express version of 2005.
> I can restore the database successfully if I restore it to the same
> server that I created the backup device on.
> For a little background, I am trying to backup a database on a server
> to a laptop for business continuity purposes. The database is under 1
> gig in total size.
> Any insight is greatly appreciated.
>
Could you try to post the sql statement you are running?
Regards
Steen Schlter Persson
Databaseadministrator / Systemadministrator|||Hi
Both posters were trying to restore a SQL 2005 database onto a SQL 2000
instance and they have the error message you get. Are you sure that there ar
e
no SQL 2000 instances on the machine you have? Database restores are
compatible between all versions of SQL 2005 therefore you should not have an
y
problems. Is this a beta or CTP version?
John
"wolf.emissar@.gmail.com" wrote:

> John, thanks for the response. I am trying to restore to a 2005
> instance but it is an Express version, I don't know if this is the
> source of the problem or not.
> In the second link you attached Tibor mentions logging into a 2000
> instance. This sounds very much like the error I am receiving, do you
> know what he is referring to? Can express 2005 be configured to run as
> a 2000 instance?
> John Bell wrote:
>|||wolf.emissar@.gmail.com wrote:
> I am trying to restore a database from a backup device and when I try
> to add the backup device in the restore database wizard I receive the
> following error message:
> An exception occurred while executing a transact-sql statement or
> batch.
> Too many backup devices specified for backup or restore; only 64 are
> allowed. RESTORE HEADER ONLY is terminating abnormally.
> The backup device was created using SQL Server 2005 and I am trying to
> restore the database to an Express version of 2005.
> I can restore the database successfully if I restore it to the same
> server that I created the backup device on.
> For a little background, I am trying to backup a database on a server
> to a laptop for business continuity purposes. The database is under 1
> gig in total size.
> Any insight is greatly appreciated.
>
Could you try to post the sql statement you are running?
Regards
Steen Schlter Persson
Databaseadministrator / Systemadministrator|||Steen, here is the SQL that I am running for the restore:
restore database wolf_sonar
from disk =3D 'C:\sqlbackups\sonar_wolf_new.bak'
and I recieve the following error message:
Msg 3205, Level 16, State 2, Line 1
Too many backup devices specified for backup or restore; only 64 are
allowed.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
One thing that I did notice that is I don't have a compatibility level
of 90 on the local server on the laptop that the wolf_sonar database
resides on. I only have 70 and 80 as available choices.
John to answer your question, I do not have any 2000 instances on the
machine that I am trying to restore the database to. This is a fairly
new machine and I actually just installed 2005 Express on this box a
couple of days. As a further chack I only see sql server 2005 in add /
remove programs.
Steen Persson (DK) wrote:
> wolf.emissar@.gmail.com wrote:
> Could you try to post the sql statement you are running?
>
> --
> Regards
> Steen Schl=FCter Persson
> Databaseadministrator / Systemadministrator|||John, I have a tried a few different version of 2005 express. The
latest one that I have installed is Version 9.00.2047.00. I do not
believe that this is a beta version.
John Bell wrote:[vbcol=seagreen]
> Hi
> Both posters were trying to restore a SQL 2005 database onto a SQL 2000
> instance and they have the error message you get. Are you sure that there
are
> no SQL 2000 instances on the machine you have? Database restores are
> compatible between all versions of SQL 2005 therefore you should not have
any
> problems. Is this a beta or CTP version?
> John
> "wolf.emissar@.gmail.com" wrote:
>

problem restore database SQL2005

Dear all,
I'm trying to restore a database saved last week in a .bak file through the
GUI of Management Studio but i have the following message error : "the
database is in use".
So i restarted the service engine SQL and changed the option to put Single
User but i have still the same error message when trying to restore.
Do you the procedure to restore a database with SQL2005 through the
Management Studio ?
Thanks in advance.
Check the ActivityLog to find out who is connected to database.
Thanks & Rate the Postings.
-Ravi-
"Ving" wrote:

> Dear all,
> I'm trying to restore a database saved last week in a .bak file through the
> GUI of Management Studio but i have the following message error : "the
> database is in use".
> So i restarted the service engine SQL and changed the option to put Single
> User but i have still the same error message when trying to restore.
> Do you the procedure to restore a database with SQL2005 through the
> Management Studio ?
> Thanks in advance.
>
>

problem restore database SQL2005

Dear all,
I'm trying to restore a database saved last week in a .bak file through the
GUI of Management Studio but i have the following message error : "the
database is in use".
So i restarted the service engine SQL and changed the option to put Single
User but i have still the same error message when trying to restore.
Do you the procedure to restore a database with SQL2005 through the
Management Studio ?
Thanks in advance.Check the ActivityLog to find out who is connected to database.
--
Thanks & Rate the Postings.
-Ravi-
"Ving" wrote:
> Dear all,
> I'm trying to restore a database saved last week in a .bak file through the
> GUI of Management Studio but i have the following message error : "the
> database is in use".
> So i restarted the service engine SQL and changed the option to put Single
> User but i have still the same error message when trying to restore.
> Do you the procedure to restore a database with SQL2005 through the
> Management Studio ?
> Thanks in advance.
>
>

problem restore database SQL2005

Dear all,
I'm trying to restore a database saved last week in a .bak file through the
GUI of Management Studio but i have the following message error : "the
database is in use".
So i restarted the service engine SQL and changed the option to put Single
User but i have still the same error message when trying to restore.
Do you the procedure to restore a database with SQL2005 through the
Management Studio ?
Thanks in advance.Check the ActivityLog to find out who is connected to database.
--
Thanks & Rate the Postings.
-Ravi-
"Ving" wrote:

> Dear all,
> I'm trying to restore a database saved last week in a .bak file through th
e
> GUI of Management Studio but i have the following message error : "the
> database is in use".
> So i restarted the service engine SQL and changed the option to put Single
> User but i have still the same error message when trying to restore.
> Do you the procedure to restore a database with SQL2005 through the
> Management Studio ?
> Thanks in advance.
>
>

Problem processing new cube

All,
When I try to "Design Storage" for a new cube, I get
a "Fact table size can not be 0" message. (I am in the
Cube Editor...) If I focus on the fact table and
select "Browse Data", the data is displayed as it should
be. So, the fact table size clearly is not "0".
From Query Analyzer, I can select rows. The table has over
one million rows in it.
I can't see anything obvious, such as "Refresh connection"
that would seemingly rectify this problem.
Any help appreciated.
TIA,
MikeIn the cube editor, set a value for the Fact Table Size property in the
Advanced tab of the property panel. This value along with the sizes of
dimensions is used during the aggregation design process.
- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:013901c3c58c$86ab1c40$a301280a@.phx.gbl...

quote:

---

> All,
> When I try to "Design Storage" for a new cube, I get
> a "Fact table size can not be 0" message. (I am in the
> Cube Editor...) If I focus on the fact table and
> select "Browse Data", the data is displayed as it should
> be. So, the fact table size clearly is not "0".
> From Query Analyzer, I can select rows. The table has over
> one million rows in it.
> I can't see anything obvious, such as "Refresh connection"
> that would seemingly rectify this problem.
> Any help appreciated.
> TIA,
> Mike

---

problem on sending message

Hi

few weeks ago I found an example of conversation using service broker.
I used the following code:

USE Test GO -- First, we need to create a message type. Note that our message type is -- very simple and allowed any type of content CREATE MESSAGE TYPE HelloMessage VALIDATION = NONE GO -- Once the message type has been created, we need to create a contract -- that specifies who can send what types of messages CREATE CONTRACT HelloContract (HelloMessage SENT BY INITIATOR) select * from sys.service_contracts GO -- The communication is between two endpoints. Thus, we need two queues to -- hold messages CREATE QUEUE [SenderQueue] with status = on select * from sys.service_queues --CREATE QUEUE ReceiverQueue Create QUEUE [ReceiverQueue] with status = on select * from sys.service_queues GO -- Create the required services and bind them to be above created queues CREATE SERVICE [Sender] ON QUEUE [SenderQueue] (HelloContract) CREATE SERVICE [Receiver] ON QUEUE [ReceiverQueue] (HelloContract) GO

Then I try to send a message:

DECLARE @.conversationHandle UNIQUEIDENTIFIER DECLARE @.message NVARCHAR(100) BEGIN BEGIN DIALOG @.conversationHandle FROM SERVICE Sender TO SERVICE 'Receiver' ON CONTRACT HelloContract -- Send a message on the conversation SET @.message = N'Hello, World'; SEND ON CONVERSATION @.conversationHandle MESSAGE TYPE HelloMessage (@.message) END

Then I read the message in the ReceiverQueue

RECEIVE message_body FROM dbo.receiverqueue
I get no messages, can you help me to discover why?

A master key has probably not been setup for that database. See the documentation on CREATE MASTER KEY -- http://msdn2.microsoft.com/en-us/library/ms174382.aspx.

Also, when messages cannot be delivered immediately, they are placed in sys.transmission_queue.

-mike

|||

BEGIN DIALOG @.conversationHandle
FROM SERVICE Sender
TO SERVICE 'Receiver'
ON CONTRACT HelloContract
with encryption = off

|||Thanks for helping!

problem logging onto Great Plains.

I have a user who is trying to log into Great Plains. It uses SQL Server
2000 which is on the same server. HE gets the following error message:
"Error occurred creating the pass-through SQL connection.:0"
When he clicks OK a second message comes up that says: "You're attempting to
log in from a data source using a trusted connection. Update the SQL server
settings for this data source to disable trusted connections and try logging
in again."
Could you please explain what this means and how do I do this.
Thank you
Davidi do not use Great Plains, but it sounds like you are trying to log in
using your NT/Domain account instead of the sql login.|||GreatPlains need a SQL connection. When you try to login you have a window
that indicate a server. This server is in fact an ODBC. The ODBC need to
use a SQL server authentification to be used to log in Great Plains.
"David Goldberg" wrote:

> I have a user who is trying to log into Great Plains. It uses SQL Server
> 2000 which is on the same server. HE gets the following error message:
> "Error occurred creating the pass-through SQL connection.:0"
> When he clicks OK a second message comes up that says: "You're attempting
to
> log in from a data source using a trusted connection. Update the SQL serv
er
> settings for this data source to disable trusted connections and try loggi
ng
> in again."
> Could you please explain what this means and how do I do this.
> Thank you
> David|||what string are you trying to log in with?|||No. He is using his SQL server account. I know this to be true because he
tried logging in from another machine and he could get in. It is only on hi
s
machine that this problem is occurring. I also hadanother user try to log i
n
on that machine and they could not. It appears to be machine related.|||so if he uses his same login on another machine it works, just not on
his machine? are they inside the same firewall?|||YES.|||You need to change the ODBC DSN using the ODBC control panel. Find the DSN
in the ODBC Data Source Administrator, select it and choose Configure. On
the second page you find the option "How should SQL Server verify the
authenticity of the login ID?" Make sure the SQL Server authentication
option is selected.
Mike
"David Goldberg" <DavidGoldberg@.discussions.microsoft.com> wrote in message
news:84305A48-4487-4DD2-BCAF-EA1065035D10@.microsoft.com...
>I have a user who is trying to log into Great Plains. It uses SQL Server
> 2000 which is on the same server. HE gets the following error message:
> "Error occurred creating the pass-through SQL connection.:0"
> When he clicks OK a second message comes up that says: "You're attempting
> to
> log in from a data source using a trusted connection. Update the SQL
> server
> settings for this data source to disable trusted connections and try
> logging
> in again."
> Could you please explain what this means and how do I do this.
> Thank you
> David

problem logging onto Great Plains.

I have a user who is trying to log into Great Plains. It uses SQL Server
2000 which is on the same server. HE gets the following error message:
"Error occurred creating the pass-through SQL connection.:0"
When he clicks OK a second message comes up that says: "You're attempting to
log in from a data source using a trusted connection. Update the SQL server
settings for this data source to disable trusted connections and try logging
in again."
Could you please explain what this means and how do I do this.
Thank you
David
i do not use Great Plains, but it sounds like you are trying to log in
using your NT/Domain account instead of the sql login.
|||GreatPlains need a SQL connection. When you try to login you have a window
that indicate a server. This server is in fact an ODBC. The ODBC need to
use a SQL server authentification to be used to log in Great Plains.
"David Goldberg" wrote:

> I have a user who is trying to log into Great Plains. It uses SQL Server
> 2000 which is on the same server. HE gets the following error message:
> "Error occurred creating the pass-through SQL connection.:0"
> When he clicks OK a second message comes up that says: "You're attempting to
> log in from a data source using a trusted connection. Update the SQL server
> settings for this data source to disable trusted connections and try logging
> in again."
> Could you please explain what this means and how do I do this.
> Thank you
> David
|||what string are you trying to log in with?
|||No. He is using his SQL server account. I know this to be true because he
tried logging in from another machine and he could get in. It is only on his
machine that this problem is occurring. I also hadanother user try to log in
on that machine and they could not. It appears to be machine related.
|||so if he uses his same login on another machine it works, just not on
his machine? are they inside the same firewall?
|||YES.
|||You need to change the ODBC DSN using the ODBC control panel. Find the DSN
in the ODBC Data Source Administrator, select it and choose Configure. On
the second page you find the option "How should SQL Server verify the
authenticity of the login ID?" Make sure the SQL Server authentication
option is selected.
Mike
"David Goldberg" <DavidGoldberg@.discussions.microsoft.com> wrote in message
news:84305A48-4487-4DD2-BCAF-EA1065035D10@.microsoft.com...
>I have a user who is trying to log into Great Plains. It uses SQL Server
> 2000 which is on the same server. HE gets the following error message:
> "Error occurred creating the pass-through SQL connection.:0"
> When he clicks OK a second message comes up that says: "You're attempting
> to
> log in from a data source using a trusted connection. Update the SQL
> server
> settings for this data source to disable trusted connections and try
> logging
> in again."
> Could you please explain what this means and how do I do this.
> Thank you
> David

problem logging onto Great Plains.

I have a user who is trying to log into Great Plains. It uses SQL Server
2000 which is on the same server. HE gets the following error message:
"Error occurred creating the pass-through SQL connection.:0"
When he clicks OK a second message comes up that says: "You're attempting to
log in from a data source using a trusted connection. Update the SQL server
settings for this data source to disable trusted connections and try logging
in again."
Could you please explain what this means and how do I do this.
Thank you
Davidi do not use Great Plains, but it sounds like you are trying to log in
using your NT/Domain account instead of the sql login.|||GreatPlains need a SQL connection. When you try to login you have a window
that indicate a server. This server is in fact an ODBC. The ODBC need to
use a SQL server authentification to be used to log in Great Plains.
"David Goldberg" wrote:
> I have a user who is trying to log into Great Plains. It uses SQL Server
> 2000 which is on the same server. HE gets the following error message:
> "Error occurred creating the pass-through SQL connection.:0"
> When he clicks OK a second message comes up that says: "You're attempting to
> log in from a data source using a trusted connection. Update the SQL server
> settings for this data source to disable trusted connections and try logging
> in again."
> Could you please explain what this means and how do I do this.
> Thank you
> David|||what string are you trying to log in with?|||No. He is using his SQL server account. I know this to be true because he
tried logging in from another machine and he could get in. It is only on his
machine that this problem is occurring. I also hadanother user try to log in
on that machine and they could not. It appears to be machine related.|||so if he uses his same login on another machine it works, just not on
his machine? are they inside the same firewall?|||YES.|||You need to change the ODBC DSN using the ODBC control panel. Find the DSN
in the ODBC Data Source Administrator, select it and choose Configure. On
the second page you find the option "How should SQL Server verify the
authenticity of the login ID?" Make sure the SQL Server authentication
option is selected.
Mike
"David Goldberg" <DavidGoldberg@.discussions.microsoft.com> wrote in message
news:84305A48-4487-4DD2-BCAF-EA1065035D10@.microsoft.com...
>I have a user who is trying to log into Great Plains. It uses SQL Server
> 2000 which is on the same server. HE gets the following error message:
> "Error occurred creating the pass-through SQL connection.:0"
> When he clicks OK a second message comes up that says: "You're attempting
> to
> log in from a data source using a trusted connection. Update the SQL
> server
> settings for this data source to disable trusted connections and try
> logging
> in again."
> Could you please explain what this means and how do I do this.
> Thank you
> David

Problem Launching Report Builder

Hi,

I am having a problem launching Report Builder on one of my users pcs.

When he clicks on the icon the following error message appears:

dfsv.exe has encountered a problem and needs to close

When I log in as myself to his PC Report Builder launches with no problems.

Any advice?

Cheers

Hi,

Re-creating the user's profile worked in this case,

Thx

problem installing Sql Server SP4

Hello,
I am getting the following error message when installing sp4 on a 2nd
instance of sql server 2k on a win2003 server
"Specified file cannot be opened as write. Ensure file is not is use and
restart setup
C:\Program Files\Sql Server\80\Shared\msxmlsql.dll"
I rebooted the server and still get the same error message. When I click OK
on the error message sp4 setup shuts down. Any suggestions appreciated what
I can do to get around this problem.
Thanks,
RichI fixed the problem. Turns out that I had a 2nd instance (a new instance of
sql server running). I had to shut down the first instance. THat was what
was using the file below. I was then able to lnstall sp4.
"Rich" wrote:

> Hello,
> I am getting the following error message when installing sp4 on a 2nd
> instance of sql server 2k on a win2003 server
> "Specified file cannot be opened as write. Ensure file is not is use and
> restart setup
> C:\Program Files\Sql Server\80\Shared\msxmlsql.dll"
> I rebooted the server and still get the same error message. When I click
OK
> on the error message sp4 setup shuts down. Any suggestions appreciated wh
at
> I can do to get around this problem.
> Thanks,
> Rich

Problem installing SQL Server 2005 Developer Edition

Hi,

I have a problem installing SQL Server 2005 Developer Edition.

When I start the setup, I get the message:

"SQL Server Setup could not run. Another instance of SQL Server Setup is already running. The running instance must complete before you can run SQL Server Setup again"

I am using Windows XP and have SQL Server 2000 and SQL Server Express 2005 installed.

I shut down both instances before I attempted to do the install but I still get the message.

I checked active tasks but no tasks with SQL* is running.

Please advise.

Thanks

Have you rebooted the computer?|||

Hi,

Yes I did, but when I reboot the services start automatically and then I stop them manually and then attemp the setup - But the same message displays.

Thanks.

|||Try uninstalling "Microsoft SQL Server Setup Support Files" then re-run the setup.|||Moving to the setup group

Problem Installing SQL Express 2005

When it is checking my PC configuration, I get the error message:

---

TITLE: Microsoft SQL Server 2005 Setup

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine KODY Error:2147942527 (0x8007007f).

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=70342

BUTTONS:

OK

---

I do not know how to fix the problem. Please help!

Sincerely, Kclemens

The OS's affected are: Win 2003, Win2003 SP1(x86, IA64, x64), and XP PRO SP2 and higher

This error can also be seen if WMI is corrupt on your machine. Try these cmd line statements:

Mofcomp.exe %windir%\system32\wbem\cimwin32.mof Regsvr32 wbemupgd.dll regsvr32 wbemsvc.dll wmiprvse /regserver|||

I ran those and on these 2 I got the error message:

Mofcomp.exe %windir%\system32\wbem\cimwin32.mof|||

The error message that you received didn't come through in your post. Can you please repost the error?

-Jeffrey

|||

Can you try with this

Create a Bat file and execute.

=========================

@.echo on
cd /d c:\temp
if not exist %windir%\system32\wbem goto TryInstall
cd /d %windir%\system32\wbem
net stop winmgmt
winmgmt /kill
if exist Rep_bak rd Rep_bak /s /q
rename Repository Rep_bak
for %%i in (*.dll) do RegSvr32 -s %%i
for %%i in (*.exe) do call :FixSrv %%i
for %%i in (*.mof,*.mfl) do Mofcomp %%i
net start winmgmt
goto End
:FixSrv
if /I (%1) == (wbemcntl.exe) goto SkipSrv
if /I (%1) == (wbemtest.exe) goto SkipSrv
if /I (%1) == (mofcomp.exe) goto SkipSrv
%1 /Regserver
:SkipSrv
goto End
:TryInstall
if not exist wmicore.exe goto End
wmicore /s
net start winmgmt
:End

Problem installing SP4

Hi, when attempting to apply SP4 to a SQL cluster, we are getting the
following message.
Buffer Overrun detected!
A buffer overrun has been detected which has corrupted the programs internal
state. The program cannot safely continue execution and must now be
terminated.
This happens just after entering the account required to update both cluster
notes. The account is a domain admin account.
Any help greatly appreciated.
BB
Hello Bruce,
Verify that there are no dependencies other than those created by the SQL Server setup on any SQL Server cluster resources. Resources such as file shares, FTP servers, and Microsoft Internet Information
Services (IIS) servers must always have a unique network name and an IP address resource. You must remove any such non-default dependencies before you install SQL Server 2000 SP4. No dependencies other
than those supplied by the SQL Server setup must be used, except to validate whether SQL Server is online and available for the client application.
For example, if you have MSDTC resource in the SQL group and if MSDTC is dependent on SQL Server Network Name and SQL IP Address then you may have this issue. If this is the case then you will need to
remove the dependencies and then re-run the setup.
Also, make sure that you have followed the SP4 pre-installation checklist (see link below).
If you still have the same problem, then the next step will be to review the logs. I would start with the sqlsp.log (created on the node where you ran the SP4 setup). You can also cut and paste the log for us to review.
Recommended Reading
======================
SQL Server 2000 Service Pack 3, Service Pack 3a, or Service Pack 4 pre-installation checklist for SQL Server 2000 virtual server for failover clustering
http://support.microsoft.com/?kbid=811168
Clustered SQL Server do's, don'ts, and basic warnings
http://support.microsoft.com/default...B;EN-US;254321
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Hi,
I checked the dependencies. It doesn't look like anything is dependent on
SQL Server other than SQLAgent which I believe is correct. The only thing
that I think is weird in this setup is that MSDTC is in the cluster quorum
resource group...
Anyway, here is the content of sqlsp.log.
21:41:52 Begin Setup
21:41:52 Version on Media: 8.00.2039
21:41:52 Mode = Normal
21:41:52 ModeType = NORMAL
21:41:52 Loading library - sqlsut.dll (#L1)
21:41:52 Begin: SetupInitialize()
21:41:52 End: SetupInitialize()
21:41:52 Begin: CheckFixedRequirements()
21:41:52 Platform ID: 0xf00000
21:41:52 Version: 5.2.3790
21:41:52 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.327
21:41:52 End: CheckFixedRequirements()
21:41:53 Processor Architecture: x86 (Pentium)
21:41:53 ComputerName: OMF-DBCLUSTER-A
21:41:53 User Name: datacom
21:41:53 IsAllAccessAllowed returned: 1
21:41:53 OS Language: 0x409
21:41:53 Begin: SetupInstall()
21:41:53 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ...
21:41:53 CommonFilesDir=C:\Program Files\Common Files
21:41:53 Windows Directory=C:\WINDOWS\
21:41:53 Program Files=C:\Program Files\
21:41:53 TEMPDIR=C:\DOCUME~1\datacom\LOCALS~1\Temp\1\
21:41:53 End: SetupInstall()
21:41:53 Begin: ShowDialogs()
21:41:53 Initial Dialog Mask: 0x8300037, Disable Back=0x1
21:41:53 Begin Action ShowDialogsHlpr: 0x1
21:41:53 Begin Action: DialogShowSdWelcome
21:41:56 End Action DialogShowSdWelcome
21:41:56 Dialog 0x1 returned: 1
21:41:56 End Action ShowDialogsHlpr
21:41:56 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
21:41:56 Begin Action ShowDialogsHlpr: 0x2
21:41:56 Begin Action: DialogShowSdMachineName
21:42:02 ShowDlgMachine returned: 1
21:42:02 Name = OMF-DBCLUSTER, Type = 0x20000008
21:42:02 End Action DialogShowSdMachineName
21:42:02 begin ShowDialogsUpdateMask
21:42:02 nFullMask = 0x8300037, nCurrent = 0x2, nDirection = 1
21:42:02 Updated Dialog Mask: 0xb73c037, Disable Back = 0x1
21:42:02 Dialog 0x2 returned: 1
21:42:02 End Action ShowDialogsHlpr
21:42:02 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
21:42:02 Begin Action ShowDialogsHlpr: 0x4
21:42:02 Begin Action: DialogShowSdInstallMode
21:42:02 ShowDlgInstallMode returned: 1
21:42:02 InstallMode : 0x2
21:42:02 End Action DialogShowSdInstallMode
21:42:02 begin ShowDialogsUpdateMask
21:42:02 nFullMask = 0xb73c037, nCurrent = 0x4, nDirection = 1
21:42:02 Updated Dialog Mask: 0xb034607, Disable Back = 0x1
21:42:02 Dialog 0x4 returned: 1
21:42:02 End Action ShowDialogsHlpr
21:42:02 ShowDialogsGetDialog returned: nCurrent=0x200,index=9
21:42:02 Begin Action ShowDialogsHlpr: 0x200
21:42:02 Begin Action: DialogShowSdInstanceName
21:42:02 Begin Action: ShowDlgInstanceName
21:42:02 SKU is : Enterprise Edition
21:42:02 End Action: ShowDlgInstanceName
21:42:02 ShowDlgInstanceName returned : 0
21:42:02 InstanceName : MSSQLSERVER
21:42:02 End Action DialogShowSdInstanceName
21:42:02 begin ShowDialogsUpdateMask
21:42:02 nFullMask = 0xb034607, nCurrent = 0x200, nDirection = 0
21:42:02 Updated Dialog Mask: 0xb034603, Disable Back = 0x1
21:42:02 Dialog 0x200 returned: 0
21:42:02 End Action ShowDialogsHlpr
21:42:02 ShowDialogsGetDialog returned: nCurrent=0x400,index=10
21:42:02 Begin Action ShowDialogsHlpr: 0x400
21:42:02 Begin Action: DialogShowSdMaintain
21:42:02 ShowDlgMaintainInstall returned : 1
21:42:02 Type : 0xc
21:42:02 CreateSetupTopology(OMF-DBCLUSTER-A), Handle : 0x12648e0, returned
: 0
21:42:02 CreateSetupTopology returned : 0, Handle : 0x12648e0
21:42:02 Topology Type : 1, Return Value : 0
21:42:02 ST_GetPhysicalNode returned : 0, PNHandle : 0x1264928
21:42:02 PN_EnumerateEx returned : 0
21:42:02 PN_GetSQLStates returned : 0, SqlStates : 0x88008221
21:42:02 PN_GetInstance for MSSQLSERVER [0x1264928] returned : 0
21:42:02 SQLI_GetPackageId [0x1264ec0] returned : 0, PackageId = 0x3
21:42:02 SQLI_GetVersion [0x1264ec0] returned : 0, Version = 8.00.194
21:42:02 SQLI_GetSQLStates for MSSQLSERVER [0x1264ec0] returned : 0,
SQLStates: 0x400209
21:42:02 SQLI_GetInstallPath [0x1264ec0] returned : 0, Path = C:\Program
Files\Microsoft SQL Server\MSSQL
21:42:02 SQLI_GetDataPath [0x1264ec0] returned : 0, DataPath = F:\Program
Files\Microsoft SQL Server\MSSQL
21:42:02 SQLI_GetVersion [0x1264ec0] returned : 0, Version = 8.00.194
21:42:02 SQLI_GetRegKeyRoot [0x1264ec0] returned : 0, RegKeyRoot =
Software\Microsoft\MSSQLServer
21:42:02 SQLI_GetPackageName [0x1264ec0] returned : 0, szPackage =
Enterprise Edition
21:42:02 SQLI_GetPackageId [0x1264ec0] returned : 0, PackageId = 0x3
21:42:02 Previous Install Path: C:\Program Files\Microsoft SQL Server\MSSQL
21:42:02 Previous Install Data: F:\Program Files\Microsoft SQL Server\MSSQL
21:42:02 Previous Install Version: 8.00.194
21:42:02 ReleaseSetupTopology
21:42:02 End Action DialogShowSdMaintain
21:42:02 begin ShowDialogsUpdateMask
21:42:02 nFullMask = 0xb034603, nCurrent = 0x400, nDirection = 1
21:42:02 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
21:42:02 Dialog 0x400 returned: 1
21:42:02 End Action ShowDialogsHlpr
21:42:02 ShowDialogsGetDialog returned: nCurrent=0x2000,index=13
21:42:02 Begin Action ShowDialogsHlpr: 0x2000
21:42:02 Begin Action: DialogShowSdUpgrade
21:42:02 ShowDlgUpgrade returned : 1
21:42:02 Checking databases on instance 'MSSQLSERVER'
21:42:02 Begin Action: Check for VS Node
21:42:02 Begin Action: Check for VS Node
21:42:02 Begin Action: Cluster Resources Offline
21:42:06 End Action: Cluster Resources Offline
21:42:06 Authenticate access
21:42:06 Begin SDPassword Dialog
21:42:09 End SDPassword Dialog
21:42:09 C:\DOCUME~1\datacom\LOCALS~1\Temp\1\SqlSetup\Bin\s cm.exe -Silent 1
-Action 6 -Service MSSQLSERVER
21:42:09 Process Exit Code: (0)
21:42:09 C:\DOCUME~1\datacom\LOCALS~1\Temp\1\SqlSetup\Bin\s cm.exe -Silent 1
-Action 1 -Service MSSQLSERVER -StartupOptions \-T4022
21:42:30 Process Exit Code: (0)
21:42:30 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:OMF-DBCLUSTER -n -d master -Q
"exit" -o "C:\DOCUME~1\datacom\LOCALS~1\Temp\1\sqlsp.out " -E
21:42:30 Process Exit Code: (0)
21:42:30 Begin: CheckSAPassword
21:42:30 Begin: LogOnUsingBlankSA
21:42:30 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:OMF-DBCLUSTER -n -d master -o
"C:\DOCUME~1\datacom\LOCALS~1\Temp\1\sqlsp.out " -Q"Exit(declare @.ret int if
(select count(*) from master..syslogins where name='sa' AND ( (1 = pwd
21:42:30 Process Exit Code: (0)
21:42:30 End: LogOnUsingBlankSA
21:42:30 Begin: SdBlankPwd
21:42:30 End: SdBlankPwd
21:42:30 End: CheckSAPassword
21:42:30 Begin : SdErrorReportingDlg
21:45:02 End: SdErrorReportingDlg
21:45:02 Access authenticated
21:45:02 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:OMF-DBCLUSTER -n -b -d master
-o "C:\DOCUME~1\datacom\LOCALS~1\Temp\1\~sqldb0.t xt" -i
"C:\DOCUME~1\datacom\LOCALS~1\Temp\1\SqlSetup\Bin\ dbverify.sql" -E
21:45:02 Process Exit Code: (0)
21:45:02 C:\DOCUME~1\datacom\LOCALS~1\Temp\1\SqlSetup\Bin\s cm.exe -Silent 1
-Action 6 -Service MSSQLSERVER
21:45:17 Process Exit Code: (0)
21:45:18 Setup Type: Custom (303)
21:45:18 Processing: SQLProg
21:45:18 Processing: SQLProg\SQLServr
21:45:18 Processing: SQLProg\UpgTools
21:45:18 Processing: SQLProg\ReplSupp
21:45:18 Processing: SQLProg\Install
21:45:18 Processing: SQLProg\System
21:45:18 Processing: SQLProg\SvrExt
21:45:18 Processing: SQLProg\Dat
21:45:18 Processing: SQLProg\DatSmpl
21:45:18 Processing: SQLProg\BaseSys
21:45:18 Processing: SQLProg\BaseBinn
21:45:18 Processing: SQLProg\MSSearch
21:45:18 Processing: SQLProg\BaseInst
21:45:18 Processing: SQLProg\UI
21:45:18 Processing: SQLProg\Symbols
21:45:18 Processing: SQLProg\Perfmon
21:45:18 Processing: SQLProg\Root
21:45:18 Processing: SQLProg\EXE
21:45:18 Processing: SQLProg\DLL
21:45:18 Processing: MgtTool
21:45:18 Processing: MgtTool\SEM
21:45:18 Processing: MgtTool\Profiler
21:45:18 Processing: MgtTool\Qryanlz
21:45:18 Processing: MgtTool\DTCCLi
21:45:18 Processing: MgtTool\Wzcnflct
21:45:18 Processing: MgtTool\UtilSys
21:45:18 Processing: MgtTool\UtilBinn
21:45:18 Processing: Connect
21:45:18 Processing: Connect\ConnSys
21:45:18 Processing: Books
21:45:18 Processing: Books\Bookso
21:45:18 Processing: DevTools
21:45:18 Processing: DevTools\Headers and Libraries
21:45:18 Processing: DevTools\MDAC SDKs
21:45:18 Processing: DevTools\VDI
21:45:18 Processing: DevTools\Dbg Int
21:45:18 Processing: Samples
21:45:18 Processing: Samples\ADO
21:45:18 Processing: Samples\DBLIB
21:45:18 Processing: Samples\Desktop
21:45:18 Processing: Samples\DTS
21:45:18 Processing: Samples\ESQLC
21:45:18 Processing: Samples\Misc
21:45:18 Processing: Samples\MSDTC
21:45:18 Processing: Samples\ODBC
21:45:18 Processing: Samples\ODS
21:45:18 Processing: Samples\OLEAut
21:45:18 Processing: Samples\Repl
21:45:18 Processing: Samples\SilverstoneDB
21:45:18 Processing: Samples\SQLDMO
21:45:18 Processing: Samples\SQLNS
21:45:18 Processing: Samples\Utils
21:45:18 Processing: Samples\XML
21:45:18 Processing: CoreRepl
21:45:18 Processing: CoreRepl\Res1033
21:45:18 Processing: CoreRepl\ResIntl
21:45:18 Processing: Core
21:45:18 Processing: Core\Res1033
21:45:18 Processing: Core\ResOther
21:45:18 Processing: Repostry
21:45:18 Processing: Repostry\RepstSys
21:45:18 Processing: Repostry\Res1033
21:45:18 Processing: Repostry\ResIntl
21:45:18 Processing: CoreMisc
21:45:18 Processing: CoreMisc\ActiveX
21:45:18 Processing: CoreMisc\Res1033
21:45:18 Processing: Monarch
21:45:18 Processing: Monarch\Monr1033
21:45:18 Processing: Monarch\MonrIntl
21:45:18 Processing: Jet
21:45:18 Processing: CoreInst
21:45:18 Processing: CoreCOM
21:45:18 Processing: CoreCOM\Res1033
21:45:18 Processing: CoreCOM\ResIntl
21:45:18 Processing: CoreTool
21:45:18 Processing: CoreTool\Res1033
21:45:18 Processing: CoreTool\ResOther
21:45:18 Processing: DBLibCli
21:45:18 Processing: SFExt
21:45:18 Processing: SFExt\ActiveX
21:45:18 Processing: SFExt\Res1033
21:45:18 Processing: SFExt\ResIntl
21:45:18 Processing: Trace
21:45:18 Processing: Trace\Res1033
21:45:18 Processing: Trace\ResOther
21:45:18 Processing: CnctBinn
21:45:18 Processing: MiscCore
21:45:18 Processing: MC
21:45:18 Processing: MC\MC1033
21:45:18 Processing: MC\MCIntl
21:45:18 Processing: MC\Help
21:45:18 Processing: UI
21:45:18 Processing: UI\UIHlp
21:45:18 Processing: UI\UI1033
21:45:18 Processing: UI\UIIntl
21:45:18 Processing: ClstSys
21:45:18 Processing: SQLMgr
21:45:18 Processing: SQLMgr\Res1033
21:45:18 Processing: SQLMgr\ResIntl
21:45:18 Processing: SvrTool
21:45:18 Processing: SvrTool\Res1033
21:45:18 Processing: SvrTool\ResIntl
21:45:18 Processing: DTSUI
21:45:18 Processing: DTSUI\Res1033
21:45:18 Processing: DTSUI\ResIntl
21:45:18 Processing: ClFTSys
21:45:18 Processing: ClFtdata
21:45:18 Processing: MSOlap
21:45:18 Processing: MSOlap\Res1033
21:45:18 Processing: MSOlap\ResIntl
21:45:18 Processing: ATL
21:45:18 Processing: ATL\winnt
21:45:18 Processing: ATL\win9x
21:45:18 Processing: MFC42U
21:45:18 Processing: VC
21:45:18 Processing: VB
21:45:18 Processing: OCX1
21:45:18 Processing: SQLAdHlp
21:45:18 Processing: SQLAdHlp\Res1033
21:45:18 Processing: SQLAdHlp\ResOther
21:45:18 Setup type: Custom
21:45:18 End Action DialogShowSdUpgrade
21:45:18 begin ShowDialogsUpdateMask
21:45:18 nFullMask = 0xb03e607, nCurrent = 0x2000, nDirection = 1
21:45:18 Updated Dialog Mask: 0xb03e003, Disable Back = 0x1
21:45:18 Dialog 0x2000 returned: 1
21:45:18 End Action ShowDialogsHlpr
21:45:18 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
21:45:18 Begin Action ShowDialogsHlpr: 0x4000
21:45:18 Skipping DialogShowSdVirtualServer
21:45:18 begin ShowDialogsUpdateMask
21:45:18 nFullMask = 0xb03e003, nCurrent = 0x4000, nDirection = 1
21:45:18 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
21:45:18 Dialog 0x4000 returned: 1
21:45:18 End Action ShowDialogsHlpr
21:45:18 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
21:45:18 Begin Action ShowDialogsHlpr: 0x8000
21:45:18 Begin Action : DialogShowSdDiskGroups
21:45:18 ShowDlgDiskGroups returned: 1
21:45:18 Disk Group = SQL Group
21:45:18 End Action : DialogShowSdDiskGroups
21:45:18 begin ShowDialogsUpdateMask
21:45:18 nFullMask = 0xb03e607, nCurrent = 0x8000, nDirection = 1
21:45:18 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
21:45:18 Dialog 0x8000 returned: 1
21:45:18 End Action ShowDialogsHlpr
21:45:18 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
21:45:18 Begin Action ShowDialogsHlpr: 0x10000
21:45:18 Begin Action: DialogShowSdClusterDef
21:45:18 Before !! The Prefowner list is : . g_szSpNeededNodelst is : .
g_nNumnodes :0 g_szOwners :, g_szDiskGroup SQL Group
21:45:18 ShowDlgClusterDef returned: 1
21:45:18 PrefOwners = OMF-DBCLUSTER-A,OMF-DBCLUSTER-B, NumIp = 2
21:45:18 Begin Action : ValidateNodeActions
21:45:18 Begin Action : EnumerateInstancesForVirtualServer
21:45:18 End Action : EnumerateInstancesForVirtualServer
21:45:18 Begin Action : ValidateNodeActions
21:45:18 End Action : ValidateNodeActions
21:45:18 End Action : ValidateNodeActions
21:45:18 End Action DialogShowSdClusterDef
21:45:18 begin ShowDialogsUpdateMask
21:45:18 nFullMask = 0xb03e607, nCurrent = 0x10000, nDirection = 1
21:45:18 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
21:45:18 Dialog 0x10000 returned: 1
21:45:18 End Action ShowDialogsHlpr
21:45:18 ShowDialogsGetDialog returned: nCurrent=0x20000,index=17
21:45:18 Begin Action ShowDialogsHlpr: 0x20000
21:45:18 Begin Action : Cluster Security - DlgAcct

Problem installing some components SQL 2005

Hi,

I'm having trouble installing SQL2005 completely. I get a 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."

It concerns "Integration services", "Notification services" and "Workstation Components, Books Online and Development Tools"

What should I do?

Regards,
Ronald

Here is the complete listing of summary.txt:

Microsoft SQL Server 2005 9.00.1399.06

==============================

OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)

Time : Sat Nov 12 21:29:32 2005

Machine : VL023188

Product : Microsoft SQL Server Setup Support Files (English)

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQLSupport_1.log

--

Machine : VL023188

Product : Microsoft SQL Server Native Client

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQLNCLI_1.log

--

Machine : VL023188

Product : Microsoft Office 2003 Web Components

Product Version : 11.0.6558.0

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_OWC11_1.log

--

Machine : VL023188

Product : Microsoft SQL Server 2005 Backward compatibility

Product Version : 8.05.1054

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_BackwardsCompat_1.log

--

Machine : VL023188

Product : MSXML 6.0 Parser

Product Version : 6.00.3883.8

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_MSXML6_1.log

--

Machine : VL023188

Product : Microsoft SQL Server Setup Support Files (English)

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQLSupport_2.log

--

Machine : VL023188

Product : Microsoft SQL Server Native Client

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQLNCLI_2.log

--

Machine : VL023188

Product : Microsoft Office 2003 Web Components

Product Version : 11.0.6558.0

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_OWC11_2.log

--

Machine : VL023188

Product : Microsoft SQL Server 2005 Backward compatibility

Product Version : 8.05.1054

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_BackwardsCompat_2.log

--

Machine : VL023188

Product : MSXML 6.0 Parser

Product Version : 6.00.3883.8

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_MSXML6_2.log

--

Machine : VL023188

Product : Microsoft SQL Server Setup Support Files (English)

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQLSupport_3.log

--

Machine : VL023188

Product : Microsoft Office 2003 Web Components

Product Version : 11.0.6558.0

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_OWC11_3.log

--

Machine : VL023188

Product : Microsoft SQL Server 2005 Backward compatibility

Product Version : 8.05.1054

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_BackwardsCompat_3.log

--

Machine : VL023188

Product : Microsoft SQL Server Setup Support Files (English)

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQLSupport_4.log

--

Machine : VL023188

Product : Microsoft SQL Server Native Client

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQLNCLI_3.log

--

Machine : VL023188

Product : Microsoft Office 2003 Web Components

Product Version : 11.0.6558.0

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_OWC11_4.log

--

Machine : VL023188

Product : Microsoft SQL Server VSS Writer

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SqlWriter_1.log

--

Machine : VL023188

Product : Microsoft SQL Server 2005 Backward compatibility

Product Version : 8.05.1054

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_BackwardsCompat_4.log

--

Machine : VL023188

Product : MSXML 6.0 Parser

Product Version : 6.00.3883.8

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_MSXML6_3.log

--

Machine : VL023188

Product : Microsoft SQL Server Setup Support Files (English)

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQLSupport_5.log

--

Machine : VL023188

Product : Microsoft SQL Server Native Client

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQLNCLI_4.log

--

Machine : VL023188

Product : Microsoft Office 2003 Web Components

Product Version : 11.0.6558.0

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_OWC11_5.log

--

Machine : VL023188

Product : Microsoft SQL Server 2005 Books Online (English)

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_BOL_1.log

--

Machine : VL023188

Product : Microsoft SQL Server 2005 Backward compatibility

Product Version : 8.05.1054

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_BackwardsCompat_5.log

--

Machine : VL023188

Product : MSXML 6.0 Parser

Product Version : 6.00.3883.8

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_MSXML6_4.log

--

Machine : VL023188

Product : Integration Services

Error : 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.

--

Machine : VL023188

Product : Microsoft SQL Server 2005 Integration Services

Product Version : 9.00.1399.06

Install : Failed

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_DTS.log

Error Number : 1603

--

Machine : VL023188

Product : SQLXML4

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQLXML4_1.log

--

Machine : VL023188

Product : Microsoft SQL Server 2005

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQL.log

--

Machine : VL023188

Product : SQLXML4

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQLXML4_2.log

--

Machine : VL023188

Product : Notification Services

Error : 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.

--

Machine : VL023188

Product : Microsoft SQL Server 2005 Notification Services

Product Version : 9.00.1399.06

Install : Failed

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_NS.log

Error Number : 1603

--

Machine : VL023188

Product : Microsoft SQL Server 2005 Reporting Services

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_RS.log

--

Machine : VL023188

Product : Workstation Components, Books Online and Development Tools

Error : 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.

--

Machine : VL023188

Product : Microsoft SQL Server 2005 Tools

Product Version : 9.00.1399.06

Install : Failed

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_Tools.log

Error Number : 1603

--

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

Let's start by looking at what's already installed on your machine. The error you're getting usually means the component is already installed. To figure out what's installed, go to Add/Remove Programs and find the entry for "SQL Server 2005". Select that entry and click Change. Once the dialog appears you should see a button named "Report". Click that button and you'll get a report detailing your installation. Select the contents of that report and copy/paste them into a reply here. Once we determine what you have installed we can figure out what you need to do.

Dan|||

Below the output of "Report". I also found out that there are a number of CTP rows in the add/remove software list. I thought I removed all SQL components but this morning after rebooting I discovered these components and I don't know where they come from. I have installed VS2005 also after installing SQL2005. Should I remove those CTP components? And in what order?
Perhaps you should also know that I removed all SQL branches in the registry (9.00....) because the installation of SQL2005 wouldn't start.
VL023188

The following components are installed on this server

MSSQLSERVER

Analysis Services

[Version: 9.00.1399.06 Edition: Developer Edition Patch level: 9.00.1399.06 Language: Engels (Verenigde Staten)]

Database Engine

[Version: 9.00.1399.06 Edition: Developer Edition Patch level: 9.00.1399.06 Language: Engels (Verenigde Staten)]

Reporting Services

[Version: 9.00.1399.06 Edition: Developer Edition Patch level: 9.00.1399.06 Language: Engels (Verenigde Staten)]

SQLEXPRESS

Database Engine

[Version: 9.00.1399.06 Edition: Express Edition Patch level: 9.00.1399.06 Language: Engels (Verenigde Staten)]

|||

Well, I managed to uninstall most of the CTP components. Just one is left that I cannot uninstall: Microsoft SQL Server Tools CTP. This one is looking into a directory that doesn't exist anymore. I can see that it was the SQL 2005 September CTP enterprise edition but I don't have that one anymore (also not available for subscribers?). How can I uninstall this one?

|||I found out that the report services weren't functioning very well (I was not able to open an existing report project). So I uninstalled the component reporting services (in add/remove, change on SQL2005). But after that I am not able to reinstall reporting services because:

Machine : VL023188
Product : Reporting Services

Error : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
-
Machine : VL023188
Product : Microsoft SQL Server 2005 Reporting Services
Product Version : 9.00.1399.06
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0023_VL023188_RS.log
Last Action : DetectInstanceClash
Error String : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
Error Number : 28086
-

What to do?

|||

Plenty wrote:

Well, I managed to uninstall most of the CTP components. Just one is left that I cannot uninstall: Microsoft SQL Server Tools CTP. This one is looking into a directory that doesn't exist anymore. I can see that it was the SQL 2005 September CTP enterprise edition but I don't have that one anymore (also not available for subscribers?). How can I uninstall this one?

I got a solution for this problem:
http://blogs.msdn.com/brada/archive/2005/06/24/432209.aspx

This helped me, now I could install the tools

But the one above still isn't solved (reporting services, existing instance). How can I remove that exsiting instance?|||

Try the following:

1. Kill the service with command sc if it still exists.

2. Go to Registry editor, remove those registy keys related to the service. You need to search the whole regisgtry tree.

3. Reboot the machine.

Problem installing server instance on windows xp sp2

Hello all (sorry for the cross post, I previously posted that message in getting started)

I have a problem installing a SQL Server 2005 (developper edition) on my windows XP SP2 machine.

When I launch the setup, all the requirements are ok, but I'm just allowed to install client components and documentations. I can't install the database server instance.

The Sql Server is downloaded from MSDN (2 iso files extracted to my HD)

My machine is a P4 2.8Ghz HT with 1Gig of RAM.

Thanks for your help

FYI, here's the Report for the system configuration check:

System Configuration Check

- WMI Service Requirement (Success)

Messages

WMI Service Requirement

Check Passed

- MSXML Requirement (Success)

Messages

MSXML Requirement

Check Passed

- Operating System Minimum Level Requirement (Success)

Messages

Operating System Minimum Level Requirement

Check Passed

- Operating System Service Pack Level Requirement. (Success)

Messages

Operating System Service Pack Level Requirement.

Check Passed

- SQL Server Edition Operating System Compatibility (Success)

Messages

SQL Server Edition Operating System Compatibility

Check Passed

- Minimum Hardware Requirement (Success)

Messages

Minimum Hardware Requirement

Check Passed

- IIS Feature Requirement (Success)

Messages

IIS Feature Requirement

Check Passed

- Pending Reboot Requirement (Success)

Messages

Pending Reboot Requirement

Check Passed

- Performance Monitor Counter Requirement (Success)

Messages

Performance Monitor Counter Requirement

Check Passed

- Default Installation Path Permission Requirement (Success)

Messages

Default Installation Path Permission Requirement

Check Passed

- Internet Explorer Requirement (Success)

Messages

Internet Explorer Requirement

Check Passed

- COM Plus Catalog Requirement (Success)

Messages

COM Plus Catalog Requirement

Check Passed

- ASP.Net Version Registration Requirement (Success)

Messages

ASP.Net Version Registration Requirement

Check Passed

- Minimum MDAC Version Requirement (Success)

Messages

Minimum MDAC Version Requirement

Check Passed

try launching setup from the other ISO.

problem installing msde

after uninstalling my msde now i am not able to reinstall it. In logfile message in "failed due to stop my service of control manager".
i couldnot understand it means.
plz help.that doesn't sound like an MS error message to me. please provide the error messageexactly, word for word (makes searching easier)

problem installing MSDE

I get the following message and I am not in safe mode

any ideas

The windows installer service could not be accessed.
This can occur if you are running Windows on safe mode or
if the Windows installer is not correctly installed.
Contact your support personnel for assistance.

I'd search Google for ideas on what to do with that errormessage. It sounds like you have a problem with the Windowsinstaller, not with MSDE.