Problem Running Sql Server 2005 Express on Vista

I have been trying to get Sql Server 2005 Express Advanced with SP2 installed and operating on my Vista machine. It seems to install ok but when I open Management Studio Express and try to create a new db or attach an existing one, I get error messages. So although it seems to be installed, I can't really use it.

When I try to create a new database I get:

TITLE: Microsoft SQL ServerManagement Studio Express

----------

Create failed for Database'practice'. (Microsoft.SqlServer.Express.Smo)

For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476

----------

ADDITIONAL INFORMATION:

An exception occurred whileexecuting a Transact-SQL statement or batch.(Microsoft.SqlServer.Express.ConnectionInfo)

----------

CREATE DATABASE permission denied indatabase 'master'. (Microsoft SQL Server, Error: 262)

For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476

----------

BUTTONS:

OK

----------

When I try to attach an existing database I get:

TITLE: Microsoft SQL ServerManagement Studio Express

----------

Failed to retrieve data for thisrequest. (Microsoft.SqlServer.Express.SmoEnum)

For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

----------

ADDITIONAL INFORMATION:

An exception occurred whileexecuting a Transact-SQL statement or batch.(Microsoft.SqlServer.Express.ConnectionInfo)

----------

The server principal"Dave-PC\Dave" is not able to access the database "model"under the current security context. (Microsoft SQL Server, Error: 916)

For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476

----------

BUTTONS:

OK

----------

I have tried following the links in the error messages but the result is: "We're sorryThereis no additional information about this issue in the Error and EventLog Messages or Knowledge Base databases at this time. You can use thelinks in the Support area to determine whether any additionalinformation might be available elsewhere."

I am successfully using both programs on my XP SP2 machines, so I know how to install and run them on XP, just not on Vista (yet). Any suggestions on how to proceed?

I had alot of VS issues when I switched to Vista. Are you running the management studio as an admin? As a test you may want to turn off UAC and see if that fixes your issue. If it does then you just need to change the permissions that you are running with.

|||

Thanks for the suggestion. It worked and I am able to run Sql Server 2005 Express via Management Studio to create and attached databases.

Question: Do I have to toggle the UAC on and off every time I want to use SQL Server Express (or leave it off always if I am willing to accept the security issues)? Or do I have other options?

|||

I personally turned mine off just because I am the only user of the PC and I'm fairly certain that if I was going to do something harmful to my own PC I'd just turn UAC off at the time I was doing it anyway. There is however a way to set the program to always run in admin mode. I'm on an XP machine right now so I can't post instructions myself but step 3 in the below article should be what you need.

http://4sysops.com/archives/vista%E2%80%99s-uac-8-ways-how-to-elevate-an-application-to-run-it-with-administrator-rights/

|||

Thanks for help. I hope I get equally good advice as I sort out some of my other Vista problems!

Problem passing variables as parameters to extended stored procedure

Hello all,

I have written an XP for SQL Server 2000 SP2. It performs as expected if I call the XP with literal values for the parameters, however when I wrap the XP call into a regular stored procedure, only the first character of each input string is seen by the XP! Here are the relevant code snippets:

C++ Extended Stored Procedure:

(Basically all this code is doing is retrieving the parameters and printing them back out)

srv_paraminfo(srvproc, 1, &bType, &uMaxLen, &uLen, NULL, &bNull);

param1 = new BYTE[uLen + 1];

srv_paraminfo(srvproc, 1, &bType, &uMaxLen, &uLen, param1, &bNull);

param1[uLen] = '\0';

srv_paraminfo(srvproc, 2, &bType, &uMaxLen, &uLen, NULL, &bNull);

param2 = new BYTE[uLen + 1];

srv_paraminfo(srvproc, 2, &bType, &uMaxLen, &uLen, param2, &bNull);

param2[uLen] = '\0';

srv_paraminfo(srvproc, 3, &bType, &uMaxLen, &uLen, NULL, &bNull);

param3 = new BYTE[uLen + 1];

srv_paraminfo(srvproc, 3, &bType, &uMaxLen, &uLen, param3, &bNull);

param3[uLen] = '\0';

sprintf(msgText, "Params received by xp: %s, %s, %s", param1, param2, param3);

srv_sendmsg( srvproc, SRV_MSG_ERROR, 0,(DBTINYINT)0, (DBTINYINT)0,NULL,0,0,msgText,SRV_NULLTERM);

srv_senddone(srvproc, SRV_DONE_ERROR, (DBUSMALLINT)0, (DBINT)0);

Calling the XP with literal values:

EXEC xp_mytest 'one','two','three'

Output:

Params received by xp: one, two, three

Calling XP via a stored procedure:

create procedure sp_mytest

(

@.myvar1 nvarchar(200),

@.myvar2 nvarchar(50),

@.myvar3 nvarchar(50)

)

as BEGIN

PRINT @.myvar1

PRINT @.myvar2

PRINT @.myvar3

EXEC xp_mytest @.myvar1, @.myvar2, @.myvar3

END

EXEC sp_mytest 'one','two','three'

Output:

one

two

three

Params received by xp: o,t,t

Any insight or assistance is greatly appreciated!!!

Your definition of sp_mytest implies that its input parameters are not unicode. The first 0 character implies end-of-string. You pass unicode parameters to it from within sp_mytest (you declare them as nvarchar), and these characters are 2-byte with second byte zero, that's why you get back only the first character from the string.

Either change your sp_mytest definition to use varchar instead of nvarchar, or your xp_mytest definition to use wchar instead of char.

Problem passing variables as parameters to extended stored procedure

Hello all,

I have written an XP for SQL Server 2000 SP2. It performs as expected if I call the XP with literal values for the parameters, however when I wrap the XP call into a regular stored procedure, only the first character of each input string is seen by the XP! Here are the relevant code snippets:

C++ Extended Stored Procedure:

(Basically all this code is doing is retrieving the parameters and printing them back out)

srv_paraminfo(srvproc, 1, &bType, &uMaxLen, &uLen, NULL, &bNull);

param1 = new BYTE[uLen + 1];

srv_paraminfo(srvproc, 1, &bType, &uMaxLen, &uLen, param1, &bNull);

param1[uLen] = '\0';

srv_paraminfo(srvproc, 2, &bType, &uMaxLen, &uLen, NULL, &bNull);

param2 = new BYTE[uLen + 1];

srv_paraminfo(srvproc, 2, &bType, &uMaxLen, &uLen, param2, &bNull);

param2[uLen] = '\0';

srv_paraminfo(srvproc, 3, &bType, &uMaxLen, &uLen, NULL, &bNull);

param3 = new BYTE[uLen + 1];

srv_paraminfo(srvproc, 3, &bType, &uMaxLen, &uLen, param3, &bNull);

param3[uLen] = '\0';

sprintf(msgText, "Params received by xp: %s, %s, %s", param1, param2, param3);

srv_sendmsg( srvproc, SRV_MSG_ERROR, 0,(DBTINYINT)0, (DBTINYINT)0,NULL,0,0,msgText,SRV_NULLTERM);

srv_senddone(srvproc, SRV_DONE_ERROR, (DBUSMALLINT)0, (DBINT)0);

Calling the XP with literal values:

EXECxp_mytest 'one','two','three'

Output:

Params received by xp: one, two, three

Calling XP via a stored procedure:

create procedure sp_mytest

(

@.myvar1 nvarchar(200),

@.myvar2 nvarchar(50),

@.myvar3 nvarchar(50)

)

as BEGIN

PRINT @.myvar1

PRINT @.myvar2

PRINT @.myvar3

EXECxp_mytest @.myvar1, @.myvar2, @.myvar3

END

EXEC sp_mytest 'one','two','three'

Output:

one

two

three

Params received by xp: o,t,t

Any insight or assistance is greatly appreciated!!!

Your definition of sp_mytest implies that its input parameters are not unicode. The first 0 character implies end-of-string. You pass unicode parameters to it from within sp_mytest (you declare them as nvarchar), and these characters are 2-byte with second byte zero, that's why you get back only the first character from the string.

Either change your sp_mytest definition to use varchar instead of nvarchar, or your xp_mytest definition to use wchar instead of char.

Problem migrating RS 2000 database to RS 2005

Hi all,
I have RS 2000 SP2 (8.00.1038.00) installed on one server. RS 2005 is
installed on another server and I followed the steps from Migrating Reporting
Services (SQL Server 2005 Books Online).
I managed to copy the MDF files ReportServer and ReportServerTempDB and
their associated log files from the SQL 2000 server to the SQL 2005 server.
They were attached in SQL 2005 successfully.
However error occurred when I tried to upgrade the database from the RS
Configuration Manager.
"There was a problem applying the database upgrade script."
----
System.Data.SqlClient.SqlException: Cannot find the user 'RSExecRole',
because it does not exist or you do not have permission.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String
connectionString, String script)
The weird thing is when I repeated the procedure, I didn't see the above
error again and it managed to proceed but with errors.
"Creating a Grant Rights script for NT AUTHORITY\NetworkService
The grant rights script was generated successfully."
"The Reporting Services rights were not applied properly. The user may
still not have appropriate access to Reporting Services resources.
----
System.Data.SqlClient.SqlException: The role 'RSExecRole' does not exist in
the current database.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String
connectionString, String script)
The creation of grant right script was repeated.
"Creating a Grant Rights script for NT Authority\NetworkService
The grant rights script was generated successfully."
"The Reporting Services rights were not applied properly. The user may
still not have appropriate access to Reporting Services resources.
-----
System.Data.SqlClient.SqlException: The role 'RSExecRole' does not exist in
the current database.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String
connectionString, String script)
It looks like the main culprit is 'RSExecRole'. Any idea how to correct this?
Thanks.
--
Best regards,
JudeHi all,
After some investigations, I managed to get it to work and thought I'd share
it here for the benefit of all.
To migrate a RS 2000 database from a SQL Server 2000 server to another
server running SQL Server 2005, follow the steps in SQL Server 2005 Books
Online under Migrating Reporting Services.
As mentioned in my previous post, it failed at the step where the database
was upgraded. The workaround is: create a new RS database in the RS
Configuration Manager before upgrading. Do not give it the same name as the
RS database.
When this is done, you can upgrade the RS 2000 database. I managed to
migrate the RS 2000 database to RS 2005 successfully using this workaround.
Good luck.
Best regards,
Jude
"Jude Wong" wrote:
> Hi all,
> I have RS 2000 SP2 (8.00.1038.00) installed on one server. RS 2005 is
> installed on another server and I followed the steps from Migrating Reporting
> Services (SQL Server 2005 Books Online).
> I managed to copy the MDF files ReportServer and ReportServerTempDB and
> their associated log files from the SQL 2000 server to the SQL 2005 server.
> They were attached in SQL 2005 successfully.
> However error occurred when I tried to upgrade the database from the RS
> Configuration Manager.
> "There was a problem applying the database upgrade script."
> ----
> System.Data.SqlClient.SqlException: Cannot find the user 'RSExecRole',
> because it does not exist or you do not have permission.
> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> Boolean breakConnection)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, Boolean breakConnection)
> at
> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
> stateObj)
> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> bulkCopyHandler, TdsParserStateObject stateObj)
> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
> methodName, Boolean async)
> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
> result, String methodName, Boolean sendToPipe)
> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String
> connectionString, String script)
> The weird thing is when I repeated the procedure, I didn't see the above
> error again and it managed to proceed but with errors.
> "Creating a Grant Rights script for NT AUTHORITY\NetworkService
> The grant rights script was generated successfully."
> "The Reporting Services rights were not applied properly. The user may
> still not have appropriate access to Reporting Services resources."
> ----
> System.Data.SqlClient.SqlException: The role 'RSExecRole' does not exist in
> the current database.
> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> Boolean breakConnection)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, Boolean breakConnection)
> at
> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
> stateObj)
> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> bulkCopyHandler, TdsParserStateObject stateObj)
> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
> methodName, Boolean async)
> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
> result, String methodName, Boolean sendToPipe)
> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String
> connectionString, String script)
> The creation of grant right script was repeated.
> "Creating a Grant Rights script for NT Authority\NetworkService
> The grant rights script was generated successfully."
> "The Reporting Services rights were not applied properly. The user may
> still not have appropriate access to Reporting Services resources."
> -----
> System.Data.SqlClient.SqlException: The role 'RSExecRole' does not exist in
> the current database.
> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> Boolean breakConnection)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, Boolean breakConnection)
> at
> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
> stateObj)
> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> bulkCopyHandler, TdsParserStateObject stateObj)
> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
> methodName, Boolean async)
> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
> result, String methodName, Boolean sendToPipe)
> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String
> connectionString, String script)
> It looks like the main culprit is 'RSExecRole'. Any idea how to correct this?
> Thanks.
>
> --
> Best regards,
> Jude

Problem looping DTS and BCP within a Stored procedure

All,

This is the scenerio

SP=Stored Procedure

I call SP1 which calls a DTS package.

DTS package calls SP2 and SP2 calls SP3 and SP 4 using an IF condition

SP3 has 3 BCP OUT commands after which it calls SP1 again

Now, the problem is that if I follow all the steps, then only 1 of the BCP command executes and the control exits out of SP3 and returns control to SP1.

If I ignore SP1 and DTS and run SP2 independently, then all BCP steps in SP3 are executed and control returns to SP2

I ma not sure if using DTS and BCP in SQL stored procedures might cause any problems

Appreciate your helpIt seems like your DTS is executing under a different security context than when you execute your SP3 from QA. Are you checking for errors after each BCP in your SP3? If you're calling your BCP using xp_cmdshell, - consider doing INSERT @.temp_tbl exec master.dbo.xp_cmdshell [....].

Problem installing SQL Server 2005 SP2

The problem seems to be with the authentication. It froze when Windows
updates attempted to install it, so I downloaded the exe from the ms
site. However this freezes too while running the "Authentication
Verification". This also happens if I just click the Test button.
I tried both Windows Authentication and SQL authentication and same
happens on both.
Any ideas what could cause this problem?
Thanks,
zoro.
I've seen it during upgrade of a piece of ... PC ( 4GB HD, 128MB RAM, P
III ). It didn't really locked up though,
but it took good 10 minutes... could it be resource related in your case
too?
r
"Zoro" <ilzoro@.gmail.com> wrote in message
news:1175276243.694408.227930@.l77g2000hsb.googlegr oups.com...
> The problem seems to be with the authentication. It froze when Windows
> updates attempted to install it, so I downloaded the exe from the ms
> site. However this freezes too while running the "Authentication
> Verification". This also happens if I just click the Test button.
> I tried both Windows Authentication and SQL authentication and same
> happens on both.
> Any ideas what could cause this problem?
> Thanks,
> zoro.
>
|||On 30 Mar, 21:26, "Rafael Lenartowicz" <rafa...@.rcl-consulting.com>
wrote:[vbcol=seagreen]
> I've seen it during upgrade of a piece of ... PC ( 4GB HD, 128MB RAM, P
> III ). It didn't really locked up though,
> but it took good 10 minutes... could it be resource related in your case
> too?
> r
> "Zoro" <ilz...@.gmail.com> wrote in message
> news:1175276243.694408.227930@.l77g2000hsb.googlegr oups.com...
No - this pc is a P4 3 GHz, 1GB memory and about 6 GB free disk space.
I also let it run for about an hour before I used the Task Manager to
kill it.
zoro.
|||Hi
"Zoro" wrote:

> On 30 Mar, 21:26, "Rafael Lenartowicz" <rafa...@.rcl-consulting.com>
> wrote:
> No - this pc is a P4 3 GHz, 1GB memory and about 6 GB free disk space.
> I also let it run for about an hour before I used the Task Manager to
> kill it.
> zoro.
>
You may have connectivity problems to the AD? What do the upgrade logs say?
John

Problem installing SQL Server 2005 SP2

The problem seems to be with the authentication. It froze when Windows
updates attempted to install it, so I downloaded the exe from the ms
site. However this freezes too while running the "Authentication
Verification". This also happens if I just click the Test button.
I tried both Windows Authentication and SQL authentication and same
happens on both.
Any ideas what could cause this problem?
Thanks,
zoro.I've seen it during upgrade of a piece of ... PC ( 4GB HD, 128MB RAM, P
III ). It didn't really locked up though,
but it took good 10 minutes... could it be resource related in your case
too?
r
"Zoro" <ilzoro@.gmail.com> wrote in message
news:1175276243.694408.227930@.l77g2000hsb.googlegroups.com...
> The problem seems to be with the authentication. It froze when Windows
> updates attempted to install it, so I downloaded the exe from the ms
> site. However this freezes too while running the "Authentication
> Verification". This also happens if I just click the Test button.
> I tried both Windows Authentication and SQL authentication and same
> happens on both.
> Any ideas what could cause this problem?
> Thanks,
> zoro.
>|||On 30 Mar, 21:26, "Rafael Lenartowicz" <rafa...@.rcl-consulting.com>
wrote:
> I've seen it during upgrade of a piece of ... PC ( 4GB HD, 128MB RAM, P
> III ). It didn't really locked up though,
> but it took good 10 minutes... could it be resource related in your case
> too?
> r
> "Zoro" <ilz...@.gmail.com> wrote in message
> news:1175276243.694408.227930@.l77g2000hsb.googlegroups.com...
> > The problem seems to be with the authentication. It froze when Windows
> > updates attempted to install it, so I downloaded the exe from the ms
> > site. However this freezes too while running the "Authentication
> > Verification". This also happens if I just click the Test button.
> > I tried both Windows Authentication and SQL authentication and same
> > happens on both.
> > Any ideas what could cause this problem?
> > Thanks,
> > zoro.
No - this pc is a P4 3 GHz, 1GB memory and about 6 GB free disk space.
I also let it run for about an hour before I used the Task Manager to
kill it.
zoro.|||Hi
"Zoro" wrote:
> On 30 Mar, 21:26, "Rafael Lenartowicz" <rafa...@.rcl-consulting.com>
> wrote:
> > I've seen it during upgrade of a piece of ... PC ( 4GB HD, 128MB RAM, P
> > III ). It didn't really locked up though,
> > but it took good 10 minutes... could it be resource related in your case
> > too?
> > r
> >
> > "Zoro" <ilz...@.gmail.com> wrote in message
> >
> > news:1175276243.694408.227930@.l77g2000hsb.googlegroups.com...
> >
> > > The problem seems to be with the authentication. It froze when Windows
> > > updates attempted to install it, so I downloaded the exe from the ms
> > > site. However this freezes too while running the "Authentication
> > > Verification". This also happens if I just click the Test button.
> > > I tried both Windows Authentication and SQL authentication and same
> > > happens on both.
> > > Any ideas what could cause this problem?
> > > Thanks,
> > > zoro.
> No - this pc is a P4 3 GHz, 1GB memory and about 6 GB free disk space.
> I also let it run for about an hour before I used the Task Manager to
> kill it.
> zoro.
>
You may have connectivity problems to the AD? What do the upgrade logs say?
John

Problem installing SQL Server 2005 SP2

The problem seems to be with the authentication. It froze when Windows
updates attempted to install it, so I downloaded the exe from the ms
site. However this freezes too while running the "Authentication
Verification". This also happens if I just click the Test button.
I tried both Windows Authentication and SQL authentication and same
happens on both.
Any ideas what could cause this problem?
Thanks,
zoro.I've seen it during upgrade of a piece of ... PC ( 4GB HD, 128MB RAM, P
III ). It didn't really locked up though,
but it took good 10 minutes... could it be resource related in your case
too?
r
"Zoro" <ilzoro@.gmail.com> wrote in message
news:1175276243.694408.227930@.l77g2000hsb.googlegroups.com...
> The problem seems to be with the authentication. It froze when Windows
> updates attempted to install it, so I downloaded the exe from the ms
> site. However this freezes too while running the "Authentication
> Verification". This also happens if I just click the Test button.
> I tried both Windows Authentication and SQL authentication and same
> happens on both.
> Any ideas what could cause this problem?
> Thanks,
> zoro.
>|||On 30 Mar, 21:26, "Rafael Lenartowicz" <rafa...@.rcl-consulting.com>
wrote:[vbcol=seagreen]
> I've seen it during upgrade of a piece of ... PC ( 4GB HD, 128MB RAM, P
> III ). It didn't really locked up though,
> but it took good 10 minutes... could it be resource related in your case
> too?
> r
> "Zoro" <ilz...@.gmail.com> wrote in message
> news:1175276243.694408.227930@.l77g2000hsb.googlegroups.com...
>
No - this pc is a P4 3 GHz, 1GB memory and about 6 GB free disk space.
I also let it run for about an hour before I used the Task Manager to
kill it.
zoro.|||Hi
"Zoro" wrote:

> On 30 Mar, 21:26, "Rafael Lenartowicz" <rafa...@.rcl-consulting.com>
> wrote:
> No - this pc is a P4 3 GHz, 1GB memory and about 6 GB free disk space.
> I also let it run for about an hour before I used the Task Manager to
> kill it.
> zoro.
>
You may have connectivity problems to the AD? What do the upgrade logs say?
John

Problem installing SQL Server 2005 Service Pack 2

I tried to run the new SP2 and it crashes. I get the dialog asking to send
the crash data to microsoft.
I then checked the upgrade log and found a message saying that it could not
log into the server. I know it had the right password because the service
pack checks that near the begining.
I then checked the service and noticed that is was stopped. I then tried to
manually start and stop the service during the upgrade each time I saw that
it needed to start or stop it by the messages that came up. That didn't work
.
It got to a point later that said it could not stop the service.
I then changed the login of the services themselves to be tan admin user.
That seemed to allow the service pack to start and stop the service ok, but
it still crashes near the end now. The message is again that it can't log in
.
I also must mention that after the first time this happened the small icon
on the lower right of the tray that is the sql server is gone.
Please help. I need to get the SP2 to succeed so that it will be back to
normal.Hi
Now that you changed the login from sql server service , did you try
manually start it? Is it started? Does the account that sql server run under
have an efficient permission (member of domain admins..)?
"apitman" <apitman@.discussions.microsoft.com> wrote in message
news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
>I tried to run the new SP2 and it crashes. I get the dialog asking to send
> the crash data to microsoft.
> I then checked the upgrade log and found a message saying that it could
> not
> log into the server. I know it had the right password because the service
> pack checks that near the begining.
> I then checked the service and noticed that is was stopped. I then tried
> to
> manually start and stop the service during the upgrade each time I saw
> that
> it needed to start or stop it by the messages that came up. That didn't
> work.
> It got to a point later that said it could not stop the service.
> I then changed the login of the services themselves to be tan admin user.
> That seemed to allow the service pack to start and stop the service ok,
> but
> it still crashes near the end now. The message is again that it can't log
> in.
> I also must mention that after the first time this happened the small icon
> on the lower right of the tray that is the sql server is gone.
> Please help. I need to get the SP2 to succeed so that it will be back to
> normal.
>|||I did try it again without luck. It still crashes just at a later time in th
e
install.
Tony
"Uri Dimant" wrote:

> Hi
> Now that you changed the login from sql server service , did you try
> manually start it? Is it started? Does the account that sql server run und
er
> have an efficient permission (member of domain admins..)?
>
> "apitman" <apitman@.discussions.microsoft.com> wrote in message
> news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
>
>

Problem installing SQL Server 2005 Service Pack 2

I tried to run the new SP2 and it crashes. I get the dialog asking to send
the crash data to microsoft.
I then checked the upgrade log and found a message saying that it could not
log into the server. I know it had the right password because the service
pack checks that near the begining.
I then checked the service and noticed that is was stopped. I then tried to
manually start and stop the service during the upgrade each time I saw that
it needed to start or stop it by the messages that came up. That didn't work.
It got to a point later that said it could not stop the service.
I then changed the login of the services themselves to be tan admin user.
That seemed to allow the service pack to start and stop the service ok, but
it still crashes near the end now. The message is again that it can't log in.
I also must mention that after the first time this happened the small icon
on the lower right of the tray that is the sql server is gone.
Please help. I need to get the SP2 to succeed so that it will be back to
normal.
Hi
Now that you changed the login from sql server service , did you try
manually start it? Is it started? Does the account that sql server run under
have an efficient permission (member of domain admins..)?
"apitman" <apitman@.discussions.microsoft.com> wrote in message
news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
>I tried to run the new SP2 and it crashes. I get the dialog asking to send
> the crash data to microsoft.
> I then checked the upgrade log and found a message saying that it could
> not
> log into the server. I know it had the right password because the service
> pack checks that near the begining.
> I then checked the service and noticed that is was stopped. I then tried
> to
> manually start and stop the service during the upgrade each time I saw
> that
> it needed to start or stop it by the messages that came up. That didn't
> work.
> It got to a point later that said it could not stop the service.
> I then changed the login of the services themselves to be tan admin user.
> That seemed to allow the service pack to start and stop the service ok,
> but
> it still crashes near the end now. The message is again that it can't log
> in.
> I also must mention that after the first time this happened the small icon
> on the lower right of the tray that is the sql server is gone.
> Please help. I need to get the SP2 to succeed so that it will be back to
> normal.
>
|||I did try it again without luck. It still crashes just at a later time in the
install.
Tony
"Uri Dimant" wrote:

> Hi
> Now that you changed the login from sql server service , did you try
> manually start it? Is it started? Does the account that sql server run under
> have an efficient permission (member of domain admins..)?
>
> "apitman" <apitman@.discussions.microsoft.com> wrote in message
> news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
>
>

Problem installing SQL Server 2005 Service Pack 2

I tried to run the new SP2 and it crashes. I get the dialog asking to send
the crash data to microsoft.
I then checked the upgrade log and found a message saying that it could not
log into the server. I know it had the right password because the service
pack checks that near the begining.
I then checked the service and noticed that is was stopped. I then tried to
manually start and stop the service during the upgrade each time I saw that
it needed to start or stop it by the messages that came up. That didn't work.
It got to a point later that said it could not stop the service.
I then changed the login of the services themselves to be tan admin user.
That seemed to allow the service pack to start and stop the service ok, but
it still crashes near the end now. The message is again that it can't log in.
I also must mention that after the first time this happened the small icon
on the lower right of the tray that is the sql server is gone.
Please help. I need to get the SP2 to succeed so that it will be back to
normal.Hi
Now that you changed the login from sql server service , did you try
manually start it? Is it started? Does the account that sql server run under
have an efficient permission (member of domain admins..)?
"apitman" <apitman@.discussions.microsoft.com> wrote in message
news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
>I tried to run the new SP2 and it crashes. I get the dialog asking to send
> the crash data to microsoft.
> I then checked the upgrade log and found a message saying that it could
> not
> log into the server. I know it had the right password because the service
> pack checks that near the begining.
> I then checked the service and noticed that is was stopped. I then tried
> to
> manually start and stop the service during the upgrade each time I saw
> that
> it needed to start or stop it by the messages that came up. That didn't
> work.
> It got to a point later that said it could not stop the service.
> I then changed the login of the services themselves to be tan admin user.
> That seemed to allow the service pack to start and stop the service ok,
> but
> it still crashes near the end now. The message is again that it can't log
> in.
> I also must mention that after the first time this happened the small icon
> on the lower right of the tray that is the sql server is gone.
> Please help. I need to get the SP2 to succeed so that it will be back to
> normal.
>|||I did try it again without luck. It still crashes just at a later time in the
install.
Tony
"Uri Dimant" wrote:
> Hi
> Now that you changed the login from sql server service , did you try
> manually start it? Is it started? Does the account that sql server run under
> have an efficient permission (member of domain admins..)?
>
> "apitman" <apitman@.discussions.microsoft.com> wrote in message
> news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
> >I tried to run the new SP2 and it crashes. I get the dialog asking to send
> > the crash data to microsoft.
> >
> > I then checked the upgrade log and found a message saying that it could
> > not
> > log into the server. I know it had the right password because the service
> > pack checks that near the begining.
> >
> > I then checked the service and noticed that is was stopped. I then tried
> > to
> > manually start and stop the service during the upgrade each time I saw
> > that
> > it needed to start or stop it by the messages that came up. That didn't
> > work.
> > It got to a point later that said it could not stop the service.
> >
> > I then changed the login of the services themselves to be tan admin user.
> > That seemed to allow the service pack to start and stop the service ok,
> > but
> > it still crashes near the end now. The message is again that it can't log
> > in.
> >
> > I also must mention that after the first time this happened the small icon
> > on the lower right of the tray that is the sql server is gone.
> >
> > Please help. I need to get the SP2 to succeed so that it will be back to
> > normal.
> >
>
>

Problem installing SQL Server 2005 Express Edition with Advanced Services SP2

Don't know if this is the appropriate forum...

I have encountered a showstopper problem during installation. I have installed SSEE on a fresh XP, all the checks but memory requirements passed. In the final stage of the install, during the "real work", the Client Component installation failed due to missing ASP.NET state service (? spelling). After the failure the installation continued, but marked both the db engine and the management studio failed. Despite this, management studio was installed and later I have removed it with the control panel applet.

I have found a service (executable: aspnet_state.exe), started it and retried the installation. It failed again so I have removed everything installed except the VSS writer and started it again. This time the installation completed (and finally got BIDS).

Is it enough to start this ASP service manually for a painless install? I don't want to play this "on the field" ever...

I'd need to see the install log from a failed attempt to really understand the problem. This is the first time I've heard mention of the asp.net state service, so this doesn't seem like a common issue. We should get to the bottom of what is really happening before you start trying to start random services on your customers computers.

Mike

|||Is earlier install logs kept? There were two attempts after it, one successfull and one uninstall. At the end of the first failed attempt the installer sent an error report on a form looked like the standard error reporting form - had the installer an unhandled exception or was it my installation feedback?|||

Mike,

I hate to post in someone elses thread, but this sounds like the exact same issue I am having. Here is the ERRORLOG:

2007-04-30 14:15:39.88 Server Microsoft SQL Server 2005 - 9.00.2050.00 (Intel X86)
Feb 13 2007 23:02:48
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition with Advanced Services on Windows NT 5.1 (Build 2600: Service Pack 2)

2007-04-30 14:15:39.88 Server (c) 2005 Microsoft Corporation.
2007-04-30 14:15:39.88 Server All rights reserved.
2007-04-30 14:15:39.88 Server Server process ID is 2088.
2007-04-30 14:15:39.88 Server Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2007-04-30 14:15:39.88 Server This instance of SQL Server last reported using a process ID of 3108 at 4/30/2007 2:08:46 PM (local) 4/30/2007 6:08:46 PM (UTC). This is an informational message only; no user action is required.
2007-04-30 14:15:39.88 Server Registry startup parameters:
2007-04-30 14:15:39.88 Server -d c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2007-04-30 14:15:39.88 Server -e c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-04-30 14:15:39.88 Server -l c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2007-04-30 14:15:39.93 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-04-30 14:15:39.93 Server Detected 1 CPUs. This is an informational message; no user action is required.
2007-04-30 14:15:40.10 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2007-04-30 14:15:40.19 Server Could not query the FIPS compliance mode flag from registry. Error 2(The system cannot find the file specified.).
2007-04-30 14:15:40.26 Server Database mirroring has been enabled on this instance of SQL Server.
2007-04-30 14:15:40.27 spid5s Starting up database 'master'.
2007-04-30 14:15:40.30 spid5s Error: 5118, Severity: 16, State: 1.
2007-04-30 14:15:40.30 spid5s The file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
2007-04-30 14:15:40.30 spid5s Error: 5118, Severity: 16, State: 1.
2007-04-30 14:15:40.30 spid5s The file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
2007-04-30 14:15:40.32 spid5s Error: 5118, Severity: 16, State: 1.
2007-04-30 14:15:40.32 spid5s The file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
2007-04-30 14:15:40.32 spid5s Error: 5118, Severity: 16, State: 1.
2007-04-30 14:15:40.32 spid5s The file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.

I went into the Computer Management console and tried to restart the SQLEXPRESS service (SQL Server Active Directory Helper also) and it gives me "server-specific error code 3417"

Thanks in advance,

Nick

|||According to the end of your log your problem is that your database is in a compressed folder (usually blue letters in Explorer). I think you should uncompress the c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA folder (right-click on the folder, Properties, Special button and uncheck). Or mark it as a read-only database but I don't think you want to do that.|||

All your logs should be sitting in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files. They are number sequentially and you can also use the create date to identify the correct log. The standard error reporting dialog does not collect personal informaiton, nor does it collect the install logs, so I can access anything related to that.

MIke

|||

Regarding Nick's issue - We don't support installing to compressed folders so you'll need to uncompress before doing any install/upgrade.

Mike

|||There is no "Special" button|||

"Unfortunatelly" I have a hungarian XP so the button label re-translation failed. It is the button on the right side of attributes read only and hidden.

Here is an official description:

To set the compression state of a folder or file

1.

In My Computer or Windows Explorer, right-click the file or folder to compress or decompress.

2.

Click Properties to display the Properties dialog box.

3.

On the General tab, click Advanced.

4.

In the Advanced Attributes dialog box, select or clear the Compress contents to save disk space check box and then click OK.

5.

In the Properties dialog box, click OK.

6.

If the compression state was altered for a folder, in the Confirm Attribute Changes dialog box, select whether to make the compression apply only to the selected folder or to the selected folder and all its files and subfolders. Click OK when done.

Note Windows XP Professional can compress closed paging files. However, when you restart Windows XP Professional, the paging files revert to an uncompressed state. For information about paging files, see the topics on virtual memory in Windows XP Professional Help.

You can set Windows Explorer to display alternate colors for compressed files and folders by using the following procedure:

To display alternate colors for compressed files and folders

1.

In My Computer or Windows Explorer, click the Tools menu, and then click Folder Options.

2.

On the View tab, select the Show encrypted or compressed NTFS files in color check box.

3.

Click OK to return to Windows Explorer or My Computer.

|||

I was having a similar problem, only that for me I could not restart the service after it had stopprd.

Setting permissions on the ...sql server\MSSQL1\data folder sorted me out.

I granted full control on the folder to the machine\users group.

Problem installing SQL Server 2005 Express Edition with Advanced Services SP2

Don't know if this is the appropriate forum...

I have encountered a showstopper problem during installation. I have installed SSEE on a fresh XP, all the checks but memory requirements passed. In the final stage of the install, during the "real work", the Client Component installation failed due to missing ASP.NET state service (? spelling). After the failure the installation continued, but marked both the db engine and the management studio failed. Despite this, management studio was installed and later I have removed it with the control panel applet.

I have found a service (executable: aspnet_state.exe), started it and retried the installation. It failed again so I have removed everything installed except the VSS writer and started it again. This time the installation completed (and finally got BIDS).

Is it enough to start this ASP service manually for a painless install? I don't want to play this "on the field" ever...

I'd need to see the install log from a failed attempt to really understand the problem. This is the first time I've heard mention of the asp.net state service, so this doesn't seem like a common issue. We should get to the bottom of what is really happening before you start trying to start random services on your customers computers.

Mike

|||Is earlier install logs kept? There were two attempts after it, one successfull and one uninstall. At the end of the first failed attempt the installer sent an error report on a form looked like the standard error reporting form - had the installer an unhandled exception or was it my installation feedback?|||

Mike,

I hate to post in someone elses thread, but this sounds like the exact same issue I am having. Here is the ERRORLOG:

2007-04-30 14:15:39.88 Server Microsoft SQL Server 2005 - 9.00.2050.00 (Intel X86)
Feb 13 2007 23:02:48
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition with Advanced Services on Windows NT 5.1 (Build 2600: Service Pack 2)

2007-04-30 14:15:39.88 Server (c) 2005 Microsoft Corporation.
2007-04-30 14:15:39.88 Server All rights reserved.
2007-04-30 14:15:39.88 Server Server process ID is 2088.
2007-04-30 14:15:39.88 Server Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2007-04-30 14:15:39.88 Server This instance of SQL Server last reported using a process ID of 3108 at 4/30/2007 2:08:46 PM (local) 4/30/2007 6:08:46 PM (UTC). This is an informational message only; no user action is required.
2007-04-30 14:15:39.88 Server Registry startup parameters:
2007-04-30 14:15:39.88 Server -d c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2007-04-30 14:15:39.88 Server -e c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-04-30 14:15:39.88 Server -l c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2007-04-30 14:15:39.93 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-04-30 14:15:39.93 Server Detected 1 CPUs. This is an informational message; no user action is required.
2007-04-30 14:15:40.10 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2007-04-30 14:15:40.19 Server Could not query the FIPS compliance mode flag from registry. Error 2(The system cannot find the file specified.).
2007-04-30 14:15:40.26 Server Database mirroring has been enabled on this instance of SQL Server.
2007-04-30 14:15:40.27 spid5s Starting up database 'master'.
2007-04-30 14:15:40.30 spid5s Error: 5118, Severity: 16, State: 1.
2007-04-30 14:15:40.30 spid5s The file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
2007-04-30 14:15:40.30 spid5s Error: 5118, Severity: 16, State: 1.
2007-04-30 14:15:40.30 spid5s The file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
2007-04-30 14:15:40.32 spid5s Error: 5118, Severity: 16, State: 1.
2007-04-30 14:15:40.32 spid5s The file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
2007-04-30 14:15:40.32 spid5s Error: 5118, Severity: 16, State: 1.
2007-04-30 14:15:40.32 spid5s The file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.

I went into the Computer Management console and tried to restart the SQLEXPRESS service (SQL Server Active Directory Helper also) and it gives me "server-specific error code 3417"

Thanks in advance,

Nick

|||According to the end of your log your problem is that your database is in a compressed folder (usually blue letters in Explorer). I think you should uncompress the c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA folder (right-click on the folder, Properties, Special button and uncheck). Or mark it as a read-only database but I don't think you want to do that.|||

All your logs should be sitting in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files. They are number sequentially and you can also use the create date to identify the correct log. The standard error reporting dialog does not collect personal informaiton, nor does it collect the install logs, so I can access anything related to that.

MIke

|||

Regarding Nick's issue - We don't support installing to compressed folders so you'll need to uncompress before doing any install/upgrade.

Mike

|||There is no "Special" button|||

"Unfortunatelly" I have a hungarian XP so the button label re-translation failed. It is the button on the right side of attributes read only and hidden.

Here is an official description:

To set the compression state of a folder or file

1.

In My Computer or Windows Explorer, right-click the file or folder to compress or decompress.

2.

Click Properties to display the Properties dialog box.

3.

On the General tab, click Advanced.

4.

In the Advanced Attributes dialog box, select or clear the Compress contents to save disk space check box and then click OK.

5.

In the Properties dialog box, click OK.

6.

If the compression state was altered for a folder, in the Confirm Attribute Changes dialog box, select whether to make the compression apply only to the selected folder or to the selected folder and all its files and subfolders. Click OK when done.

Note Windows XP Professional can compress closed paging files. However, when you restart Windows XP Professional, the paging files revert to an uncompressed state. For information about paging files, see the topics on virtual memory in Windows XP Professional Help.

You can set Windows Explorer to display alternate colors for compressed files and folders by using the following procedure:

To display alternate colors for compressed files and folders

1.

In My Computer or Windows Explorer, click the Tools menu, and then click Folder Options.

2.

On the View tab, select the Show encrypted or compressed NTFS files in color check box.

3.

Click OK to return to Windows Explorer or My Computer.

|||

I was having a similar problem, only that for me I could not restart the service after it had stopprd.

Setting permissions on the ...sql server\MSSQL1\data folder sorted me out.

I granted full control on the folder to the machine\users group.

Problem installing SP2 on active-passive x64 cluster

I just tried to apply SQL 2005 Std SP2 on a cluster, and all succeeded except for the Database Services. I've looked about and can't see any specific information for this. The Summary.Txt is below. I thought I was following the appropriate steps, according to the SP2 Readme.

Thanks for any help. (I'm at the client today)

Bob Coppedge

me at RLCoppedge dot com

Time: 04/04/2007 10:55:44.249
KB Number: KB921896
Machine: SQL01
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x64
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: Yes
Log Location on Passive Nodes:
(SQL01) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
(SQL02) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.1.2047 x64
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x64 STANDARD
Notification Services ENU SP1 9.00.2047.00 x64 STANDARD
Integration Services ENU SP1 9.00.2047.00 x64 STANDARD
SQL Server Native Client ENU 9.00.2047.00 x64
Client Components ENU SP1 9.1.2047 x64 STANDARD
MSXML 6.0 Parser ENU 6.00.3890.0 x64
SQLXML4 ENU 9.00.2047.00 x64
Backward Compatibility ENU 8.05.1704 x64
Microsoft SQL Server VSS Writer ENU 9.00.2047.00 x64

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
-
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File :
Error Number : 11009
Error Description : No passive nodes were successfully patched
-
Product : Notification Services
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\NS9_Hotfix_KB921896_sqlrun_ns.msp.log
Error Number : 3010
Error Description :
-
Product : Integration Services
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 0
Error Description :
-
Product : SQL Server Native Client
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_sqlncli.msi.log
Error Number : 3010
Error Description :
-
Product : Client Components
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 3010
Error Description :
-
Product : MSXML 6.0 Parser
Product Version (Previous): 3890
Product Version (Final) : 6.10.1129.0
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_msxml6.msi.log
Error Number : 0
Error Description :
-
Product : SQLXML4
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_sqlxml4.msi.log
Error Number : 0
Error Description :
-
Product : Backward Compatibility
Product Version (Previous): 1704
Product Version (Final) : 2004
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
-
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlWriter.msi.log
Error Number : 0
Error Description :
-

**********************************************************************************
Summary
No passive nodes were successfully patched
Exit Code Returned: 11009

Hey Bob,

Check out this KB Article: http://support.microsoft.com/kb/929151

It references a slightly different error number, but the error messages appear to be the same.

Eric

|||

Thanks for the information. That actually led to the solution. It turns out that the log on the passive node held the answer. The system couldn't add the account to the AD group. Now, why it couldn't I don't know (the account had rights to change membership to the group), but I had to run the SP2 installation using Domain Admin rights. Once I did that, life was good.

Thanks again for the lead!

Bob

|||

Glad to help out and glad you got it working!

Eric

|||

I had the same problem, even though it was on the active node, and with a 32-bit cluster. The fix was to add the account that SQL Server was running under into the Domain Admins Group. Then it installed, then I removed that user from the Domain Admins group.

Thanks

|||

I followed the fix above and it fixed my problem. I running 2k3enterprise with sql2005entx64. I had to add the virtual network name to lmhosts and enable netbios(and lmhosts) on the public nic of each node(two node cluster). Will we ever turn off netbios?

Thanks to the above users for the good links...(Eric)

Forrest

Problem installing SP2 on active-passive x64 cluster

I just tried to apply SQL 2005 Std SP2 on a cluster, and all succeeded except for the Database Services. I've looked about and can't see any specific information for this. The Summary.Txt is below. I thought I was following the appropriate steps, according to the SP2 Readme.

Thanks for any help. (I'm at the client today)

Bob Coppedge

me at RLCoppedge dot com

Time: 04/04/2007 10:55:44.249
KB Number: KB921896
Machine: SQL01
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x64
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: Yes
Log Location on Passive Nodes:
(SQL01) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
(SQL02) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.1.2047 x64
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x64 STANDARD
Notification Services ENU SP1 9.00.2047.00 x64 STANDARD
Integration Services ENU SP1 9.00.2047.00 x64 STANDARD
SQL Server Native Client ENU 9.00.2047.00 x64
Client Components ENU SP1 9.1.2047 x64 STANDARD
MSXML 6.0 Parser ENU 6.00.3890.0 x64
SQLXML4 ENU 9.00.2047.00 x64
Backward Compatibility ENU 8.05.1704 x64
Microsoft SQL Server VSS Writer ENU 9.00.2047.00 x64

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
-
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File :
Error Number : 11009
Error Description : No passive nodes were successfully patched
-
Product : Notification Services
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\NS9_Hotfix_KB921896_sqlrun_ns.msp.log
Error Number : 3010
Error Description :
-
Product : Integration Services
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 0
Error Description :
-
Product : SQL Server Native Client
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_sqlncli.msi.log
Error Number : 3010
Error Description :
-
Product : Client Components
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 3010
Error Description :
-
Product : MSXML 6.0 Parser
Product Version (Previous): 3890
Product Version (Final) : 6.10.1129.0
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_msxml6.msi.log
Error Number : 0
Error Description :
-
Product : SQLXML4
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_sqlxml4.msi.log
Error Number : 0
Error Description :
-
Product : Backward Compatibility
Product Version (Previous): 1704
Product Version (Final) : 2004
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
-
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlWriter.msi.log
Error Number : 0
Error Description :
-

**********************************************************************************
Summary
No passive nodes were successfully patched
Exit Code Returned: 11009

Hey Bob,

Check out this KB Article: http://support.microsoft.com/kb/929151

It references a slightly different error number, but the error messages appear to be the same.

Eric

|||

Thanks for the information. That actually led to the solution. It turns out that the log on the passive node held the answer. The system couldn't add the account to the AD group. Now, why it couldn't I don't know (the account had rights to change membership to the group), but I had to run the SP2 installation using Domain Admin rights. Once I did that, life was good.

Thanks again for the lead!

Bob

|||

Glad to help out and glad you got it working!

Eric

|||

I had the same problem, even though it was on the active node, and with a 32-bit cluster. The fix was to add the account that SQL Server was running under into the Domain Admins Group. Then it installed, then I removed that user from the Domain Admins group.

Thanks

|||

I followed the fix above and it fixed my problem. I running 2k3enterprise with sql2005entx64. I had to add the virtual network name to lmhosts and enable netbios(and lmhosts) on the public nic of each node(two node cluster). Will we ever turn off netbios?

Thanks to the above users for the good links...(Eric)

Forrest

Problem installing SP2 on active-passive x64 cluster

I just tried to apply SQL 2005 Std SP2 on a cluster, and all succeeded except for the Database Services. I've looked about and can't see any specific information for this. The Summary.Txt is below. I thought I was following the appropriate steps, according to the SP2 Readme.

Thanks for any help. (I'm at the client today)

Bob Coppedge

me at RLCoppedge dot com

Time: 04/04/2007 10:55:44.249
KB Number: KB921896
Machine: SQL01
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x64
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: Yes
Log Location on Passive Nodes:
(SQL01) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
(SQL02) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.1.2047 x64
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x64 STANDARD
Notification Services ENU SP1 9.00.2047.00 x64 STANDARD
Integration Services ENU SP1 9.00.2047.00 x64 STANDARD
SQL Server Native Client ENU 9.00.2047.00 x64
Client Components ENU SP1 9.1.2047 x64 STANDARD
MSXML 6.0 Parser ENU 6.00.3890.0 x64
SQLXML4 ENU 9.00.2047.00 x64
Backward Compatibility ENU 8.05.1704 x64
Microsoft SQL Server VSS Writer ENU 9.00.2047.00 x64

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
-
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File :
Error Number : 11009
Error Description : No passive nodes were successfully patched
-
Product : Notification Services
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\NS9_Hotfix_KB921896_sqlrun_ns.msp.log
Error Number : 3010
Error Description :
-
Product : Integration Services
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 0
Error Description :
-
Product : SQL Server Native Client
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_sqlncli.msi.log
Error Number : 3010
Error Description :
-
Product : Client Components
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 3010
Error Description :
-
Product : MSXML 6.0 Parser
Product Version (Previous): 3890
Product Version (Final) : 6.10.1129.0
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_msxml6.msi.log
Error Number : 0
Error Description :
-
Product : SQLXML4
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_sqlxml4.msi.log
Error Number : 0
Error Description :
-
Product : Backward Compatibility
Product Version (Previous): 1704
Product Version (Final) : 2004
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
-
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlWriter.msi.log
Error Number : 0
Error Description :
-

**********************************************************************************
Summary
No passive nodes were successfully patched
Exit Code Returned: 11009

Hey Bob,

Check out this KB Article: http://support.microsoft.com/kb/929151

It references a slightly different error number, but the error messages appear to be the same.

Eric

|||

Thanks for the information. That actually led to the solution. It turns out that the log on the passive node held the answer. The system couldn't add the account to the AD group. Now, why it couldn't I don't know (the account had rights to change membership to the group), but I had to run the SP2 installation using Domain Admin rights. Once I did that, life was good.

Thanks again for the lead!

Bob

|||

Glad to help out and glad you got it working!

Eric

|||

I had the same problem, even though it was on the active node, and with a 32-bit cluster. The fix was to add the account that SQL Server was running under into the Domain Admins Group. Then it installed, then I removed that user from the Domain Admins group.

Thanks

Problem installing SP2

having an issue installing sp2, ive looked around for other solutions but
none apply, the permissions are fine for that folder.
seems a fairly common problem too, is there a definitive answer ?
cheers
mark
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB92189
6_sqlrun_sql.msp.log
Error Number : 29506
Error Description : MSP Error: 29506 SQL Server Setup failed to
modify security permissions on file C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
the account and domain running SQL Server Setup exist, that the account
running SQL Server Setup has administrator privileges, and that exists on
the destination drive.
MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 29506
MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
(64-bit) -- Error 29506. SQL Server Setup failed to modify security
permissions on file C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
the account and domain running SQL Server Setup exist, that the account
running SQL Server Setup has administrator privileges, and that exists on
the destination drive.
Error 29506. SQL Server Setup failed to modify security permissions on file
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
Administrator. To proceed, verify that the account and domain running SQL
Server Setup exist, that the account running SQL Server Setup has
administrator privileges, and that exists on the destination drive.
<EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is 0
MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback' i
s 0
Action ended 08:54:08: InstallFinalize. Return value 3.Hi Mark
Have you checked the acls on the files within the directory?
Have you excluded database files/directories from any anti-virus software
being used?
Have you switched of the indexing service?
John
"luna" <luna_s@.themoon.com> wrote in message
news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
> having an issue installing sp2, ive looked around for other solutions but
> none apply, the permissions are fine for that folder.
> seems a fairly common problem too, is there a definitive answer ?
> cheers
> mark
>
> Product : Database Services (MSSQLSERVER)
> Product Version (Previous): 3042
> Product Version (Final) :
> Status : Failure
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB92189
6_sqlrun_sql.msp.log
> Error Number : 29506
> Error Description : MSP Error: 29506 SQL Server Setup failed to
> modify security permissions on file C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
> the account and domain running SQL Server Setup exist, that the account
> running SQL Server Setup has administrator privileges, and that exists on
> the destination drive.
>
> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> Error Code: 29506
> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
> permissions on file C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
> the account and domain running SQL Server Setup exist, that the account
> running SQL Server Setup has administrator privileges, and that exists on
> the destination drive.
> Error 29506. SQL Server Setup failed to modify security permissions on
> file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
> Administrator. To proceed, verify that the account and domain running SQL
> Server Setup exist, that the account running SQL Server Setup has
> administrator privileges, and that exists on the destination drive.
> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is
0
> MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback'
is
> 0
> Action ended 08:54:08: InstallFinalize. Return value 3.
>|||hi jonh,
ive not checked all the individual files in the directory, the directory
owner is administrator tho ?
is there a easy way to list the acls on the files ? (ive a few to go throo..
)
indexing is off and no AV pointing to that directory, so i suspect some file
in the dir
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
> Hi Mark
> Have you checked the acls on the files within the directory?
> Have you excluded database files/directories from any anti-virus software
> being used?
> Have you switched of the indexing service?
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>|||Hi Mark
There seems to be some issue with Backup exec files (which start with a $)
if you searched google you could find out more, it may be that you only need
to delete these files. For example:
807fe1c" target="_blank">http://groups.google.com/group/micr...
807fe1c
To see the ACLs right click the file and look on the security tab. Using the
advanced options will allow you to take ownerships if necessary which was
one method that stopped the issue.
John
"luna" <luna_s@.themoon.com> wrote in message
news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
> hi jonh,
> ive not checked all the individual files in the directory, the directory
> owner is administrator tho ?
> is there a easy way to list the acls on the files ? (ive a few to go
> throo.. )
> indexing is off and no AV pointing to that directory, so i suspect some
> file in the dir
> mark
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
>|||cheers john,
I went throo the files (slow friday ) there was a few without
administrator privs, so ive added admin to them
ill give it another go, when the server isn't busy
cheers
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
> Hi Mark
> There seems to be some issue with Backup exec files (which start with a $)
> if you searched google you could find out more, it may be that you only
> need to delete these files. For example:
> cf807fe1c" target="_blank">http://groups.google.com/group/micr...r />
cf807fe1c
> To see the ACLs right click the file and look on the security tab. Using
> the advanced options will allow you to take ownerships if necessary which
> was one method that stopped the issue.
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
>|||That is probably good then! Let us know how it goes!
John
"luna" <luna_s@.themoon.com> wrote in message
news:NG8dj.23854$KC3.23654@.newsfe6-gui.ntli.net...
> cheers john,
> I went throo the files (slow friday ) there was a few without
> administrator privs, so ive added admin to them
> ill give it another go, when the server isn't busy
> cheers
> mark
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
>|||hi john,
worked great - sorted it all today,
cheers again and happy new year
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:epLt4paSIHA.1204@.TK2MSFTNGP03.phx.gbl...
> That is probably good then! Let us know how it goes!
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:NG8dj.23854$KC3.23654@.newsfe6-gui.ntli.net...
>

Problem installing SP2

having an issue installing sp2, ive looked around for other solutions but
none apply, the permissions are fine for that folder.
seems a fairly common problem too, is there a definitive answer ?
cheers
mark
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_s ql.msp.log
Error Number : 29506
Error Description : MSP Error: 29506 SQL Server Setup failed to
modify security permissions on file C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
the account and domain running SQL Server Setup exist, that the account
running SQL Server Setup has administrator privileges, and that exists on
the destination drive.
MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 29506
MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
(64-bit) -- Error 29506. SQL Server Setup failed to modify security
permissions on file C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
the account and domain running SQL Server Setup exist, that the account
running SQL Server Setup has administrator privileges, and that exists on
the destination drive.
Error 29506. SQL Server Setup failed to modify security permissions on file
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
Administrator. To proceed, verify that the account and domain running SQL
Server Setup exist, that the account running SQL Server Setup has
administrator privileges, and that exists on the destination drive.
<EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is 0
MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback' is 0
Action ended 08:54:08: InstallFinalize. Return value 3.
Hi Mark
Have you checked the acls on the files within the directory?
Have you excluded database files/directories from any anti-virus software
being used?
Have you switched of the indexing service?
John
"luna" <luna_s@.themoon.com> wrote in message
news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
> having an issue installing sp2, ive looked around for other solutions but
> none apply, the permissions are fine for that folder.
> seems a fairly common problem too, is there a definitive answer ?
> cheers
> mark
>
> Product : Database Services (MSSQLSERVER)
> Product Version (Previous): 3042
> Product Version (Final) :
> Status : Failure
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_s ql.msp.log
> Error Number : 29506
> Error Description : MSP Error: 29506 SQL Server Setup failed to
> modify security permissions on file C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
> the account and domain running SQL Server Setup exist, that the account
> running SQL Server Setup has administrator privileges, and that exists on
> the destination drive.
>
> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> Error Code: 29506
> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
> permissions on file C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
> the account and domain running SQL Server Setup exist, that the account
> running SQL Server Setup has administrator privileges, and that exists on
> the destination drive.
> Error 29506. SQL Server Setup failed to modify security permissions on
> file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
> Administrator. To proceed, verify that the account and domain running SQL
> Server Setup exist, that the account running SQL Server Setup has
> administrator privileges, and that exists on the destination drive.
> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is 0
> MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback' is
> 0
> Action ended 08:54:08: InstallFinalize. Return value 3.
>
|||hi jonh,
ive not checked all the individual files in the directory, the directory
owner is administrator tho ?
is there a easy way to list the acls on the files ? (ive a few to go throo..
)
indexing is off and no AV pointing to that directory, so i suspect some file
in the dir
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
> Hi Mark
> Have you checked the acls on the files within the directory?
> Have you excluded database files/directories from any anti-virus software
> being used?
> Have you switched of the indexing service?
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>
|||Hi Mark
There seems to be some issue with Backup exec files (which start with a $)
if you searched google you could find out more, it may be that you only need
to delete these files. For example:
[url]http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506% 22#fc225bccf807fe1c[/url]
To see the ACLs right click the file and look on the security tab. Using the
advanced options will allow you to take ownerships if necessary which was
one method that stopped the issue.
John
"luna" <luna_s@.themoon.com> wrote in message
news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
> hi jonh,
> ive not checked all the individual files in the directory, the directory
> owner is administrator tho ?
> is there a easy way to list the acls on the files ? (ive a few to go
> throo.. )
> indexing is off and no AV pointing to that directory, so i suspect some
> file in the dir
> mark
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
>
|||cheers john,
I went throo the files (slow friday ) there was a few without
administrator privs, so ive added admin to them
ill give it another go, when the server isn't busy
cheers
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
> Hi Mark
> There seems to be some issue with Backup exec files (which start with a $)
> if you searched google you could find out more, it may be that you only
> need to delete these files. For example:
> [url]http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506% 22#fc225bccf807fe1c[/url]
> To see the ACLs right click the file and look on the security tab. Using
> the advanced options will allow you to take ownerships if necessary which
> was one method that stopped the issue.
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
>
|||That is probably good then! Let us know how it goes!
John
"luna" <luna_s@.themoon.com> wrote in message
news:NG8dj.23854$KC3.23654@.newsfe6-gui.ntli.net...
> cheers john,
> I went throo the files (slow friday ) there was a few without
> administrator privs, so ive added admin to them
> ill give it another go, when the server isn't busy
> cheers
> mark
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
>
|||hi john,
worked great - sorted it all today,
cheers again and happy new year
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:epLt4paSIHA.1204@.TK2MSFTNGP03.phx.gbl...
> That is probably good then! Let us know how it goes!
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:NG8dj.23854$KC3.23654@.newsfe6-gui.ntli.net...
>