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 sp2

We have a reporting server with SP1.
We tried to install SP2 while we were logged in with the domain admin account.
The installation program says 'please wait while windows configures
microsoft sql server 2000 reporting services enterprise edition' then we get
the error
'Failure modifying security permissions on file c:\Program Files\Microsoft
SQL Server\MSSQL\Reporting Services\RSTempFiles for user ...
Anyone any idea ?Franky,
Are you using a user account for the ReportServer windows services? In that
case, change the startup option for the service to use a LocalSystem account,
stop the service and then try to install the SP2. When the SP2 installation
program ends, go back to the service properties and change back the account.
Finnally restart your server.
Regards
"Franky" wrote:
> We have a reporting server with SP1.
> We tried to install SP2 while we were logged in with the domain admin account.
> The installation program says 'please wait while windows configures
> microsoft sql server 2000 reporting services enterprise edition' then we get
> the error
> 'Failure modifying security permissions on file c:\Program Files\Microsoft
> SQL Server\MSSQL\Reporting Services\RSTempFiles for user ...
> Anyone any idea ?

error in updating field thru stor_proc

I'm trying to update 'password' field in a table thru a stored procedure which is called from my program.

I'm passing the values for password and the key fields.

While debugging I can see the values in each parameter, but I get an error that the 'value for password was not passed'.

Here's the program snippet for calling the stored proc.

All three parameters are 'varchar' type

dbConn.Open();

dbConn.CreateParameters(3);

dbConn.AddParameters(0, Pwd, newPwd);

dbConn.AddParameters(1, Login, pwd_Login);

dbConn.AddParameters(2, IdNum, pwd_IdNum);

result = dbMgr.ExecuteNonQuery(CommandType.StoredProcedure, SP_UPDPWD);

--

EXEC @.return_value = [dbo].[usp_UsrMstUpdPwdParaPwdEmailCaseNum]

@.Pwd = N'3Sg7vqowIBRdfgdfgrgdjykFTjTFt5hfHfhFtFghzIG1haWRliBuYW1lPw==',

@.Login = N'xyz@.abc.com',

@.IdNumber = N'00009'

--

What am I missing?

Is Pwd a variable or constant set to "@.Pwd", login to "@.Login", IdNum to "@.IdNum", and "SP_UPDPWD" to the appropriate string for your stored procedure?

Also, is this using an IDBManager pattern?

Thanks,

John

|||

Never mind. found the problem

The parameter for Password was not spelt right!

Error in MSDE setup

When I install MSDE, I am getting an error and the installation stops. In
the log file that is created it looks like this:
Executing "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "CDC29999" -Q
"SQL_Latin1_General_CP1_CI_AS""
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
Action ended 10:31:21: InstallFinalize. Return value 3.
When I look in the server log, it gives me the same message. "Refer to the
server error logs and setup error logs for more information." Big help!
My setup.ini file looks like this:
[Options]
INSTANCENAME = "CDC"
SAPWD = "CDC2003"
I checked the Windows event log and found this:
The MSSQL$CDC service failed to start due to the following error:
MSSQL$CDC is not a valid Win32 application.
I think this is the problem, but have no idea what is going on or how to fix
this.
Any ideas?
Thanks
LanceTurns out there is a problems with some MS products that if there is a file
on the root of C drive called "Program" then it fails when it trys to start
the service.
Lance
"Lance Geeck" <lgeeck@.cox.net> wrote in message
news:uiWTb.7265$IF1.3090@.fed1read01...
> When I install MSDE, I am getting an error and the installation stops. In
> the log file that is created it looks like this:
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "CDC29999" -Q
> "SQL_Latin1_General_CP1_CI_AS""
> Setup failed to configure the server. Refer to the server error logs and
> setup error logs for more information.
> Action ended 10:31:21: InstallFinalize. Return value 3.
> When I look in the server log, it gives me the same message. "Refer to the
> server error logs and setup error logs for more information." Big help!
> My setup.ini file looks like this:
> [Options]
> INSTANCENAME = "CDC"
> SAPWD = "CDC2003"
> I checked the Windows event log and found this:
> The MSSQL$CDC service failed to start due to the following error:
> MSSQL$CDC is not a valid Win32 application.
> I think this is the problem, but have no idea what is going on or how to
fix
> this.
> Any ideas?
> Thanks
> Lance
>

Error in MSDE setup

When I install MSDE, I am getting an error and the installation stops. In
the log file that is created it looks like this:
Executing "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "CDC29999" -Q
"SQL_Latin1_General_CP1_CI_AS""
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
Action ended 10:31:21: InstallFinalize. Return value 3.
When I look in the server log, it gives me the same message. "Refer to the
server error logs and setup error logs for more information." Big help!
My setup.ini file looks like this:
[Options]
INSTANCENAME = "CDC"
SAPWD = "CDC2003"
I checked the Windows event log and found this:
The MSSQL$CDC service failed to start due to the following error:
MSSQL$CDC is not a valid Win32 application.
I think this is the problem, but have no idea what is going on or how to fix
this.
Any ideas?
Thanks
LanceTurns out there is a problems with some MS products that if there is a file
on the root of C drive called "Program" then it fails when it trys to start
the service.
Lance
"Lance Geeck" <lgeeck@.cox.net> wrote in message
news:uiWTb.7265$IF1.3090@.fed1read01...

quote:

---

> When I install MSDE, I am getting an error and the installation stops. In
> the log file that is created it looks like this:
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "CDC29999" -Q
> "SQL_Latin1_General_CP1_CI_AS""
> Setup failed to configure the server. Refer to the server error logs and
> setup error logs for more information.
> Action ended 10:31:21: InstallFinalize. Return value 3.
> When I look in the server log, it gives me the same message. "Refer to the
> server error logs and setup error logs for more information." Big help!
> My setup.ini file looks like this:
> [Options]
> INSTANCENAME = "CDC"
> SAPWD = "CDC2003"
> I checked the Windows event log and found this:
> The MSSQL$CDC service failed to start due to the following error:
> MSSQL$CDC is not a valid Win32 application.
> I think this is the problem, but have no idea what is going on or how to

---

fix

quote:

---

> this.
> Any ideas?
> Thanks
> Lance
>

---

Error in INSERT INTO

Hi,
I'm sure that this is quite a simple program. I am generating an INSERT INTO statement in the Query builder (!) of Visual Basic .NET, and I consistantly get the following error: "Missing semi-colon at the end of the end of the SQL statement." The SQL stat
ement in question is:
INSERT INTO tblBlocks
(ActualTotalHoles, Block_Name, BlockComment, ChargedHoles, PlannedTotalHoles, Site_Name)
VALUES (?, ?, ?, ?, ?, ?)
SELECT tblBlocks.Block_Name, tblBlocks.Site_Name
FROM tblBlocks
WHERE (tblBlocks.Block_Name =?),( tblBlocks.Site_Name = ?);
Would much appreciate some help - Thanks.
It's being interpreted as two SQL statements, not one. The missing
semi-colon should come after VALUES(?, ?, ?, ?, ?, ?);
"Lite" <anonymous@.discussions.microsoft.com> wrote in message
news:C052EA2E-9424-4E0C-9D30-8FAFC93F064B@.microsoft.com...
> Hi,
> I'm sure that this is quite a simple program. I am generating an INSERT
INTO statement in the Query builder (!) of Visual Basic .NET, and I
consistantly get the following error: "Missing semi-colon at the end of the
end of the SQL statement." The SQL statement in question is:
> INSERT INTO tblBlocks
> (ActualTotalHoles, Block_Name, BlockComment,
ChargedHoles, PlannedTotalHoles, Site_Name)
> VALUES (?, ?, ?, ?, ?, ?)
> SELECT tblBlocks.Block_Name, tblBlocks.Site_Name
> FROM tblBlocks
> WHERE (tblBlocks.Block_Name =?),( tblBlocks.Site_Name = ?);
> Would much appreciate some help - Thanks.

Error in INSERT INTO

Hi,
I'm sure that this is quite a simple program. I am generating an INSERT INTO
statement in the Query builder (!) of Visual Basic .NET, and I consistantly
get the following error: "Missing semi-colon at the end of the end of the S
QL statement." The SQL stat
ement in question is:
INSERT INTO tblBlocks
(ActualTotalHoles, Block_Name, BlockComment, ChargedHoles, PlannedTotalHoles
, Site_Name)
VALUES (?, ?, ?, ?, ?, ?)
SELECT tblBlocks.Block_Name, tblBlocks.Site_Name
FROM tblBlocks
WHERE (tblBlocks.Block_Name =?),( tblBlocks.Site_Name = ?);
Would much appreciate some help - Thanks.It's being interpreted as two SQL statements, not one. The missing
semi-colon should come after VALUES(?, ?, ?, ?, ?, ?);
"Lite" <anonymous@.discussions.microsoft.com> wrote in message
news:C052EA2E-9424-4E0C-9D30-8FAFC93F064B@.microsoft.com...
> Hi,
> I'm sure that this is quite a simple program. I am generating an INSERT
INTO statement in the Query builder (!) of Visual Basic .NET, and I
consistantly get the following error: "Missing semi-colon at the end of the
end of the SQL statement." The SQL statement in question is:
> INSERT INTO tblBlocks
> (ActualTotalHoles, Block_Name, BlockComment,
ChargedHoles, PlannedTotalHoles, Site_Name)
> VALUES (?, ?, ?, ?, ?, ?)
> SELECT tblBlocks.Block_Name, tblBlocks.Site_Name
> FROM tblBlocks
> WHERE (tblBlocks.Block_Name =?),( tblBlocks.Site_Name = ?);
> Would much appreciate some help - Thanks.