xp cmdshell: permissions

Showing posts with label permissions. Show all posts

Monday, March 12, 2012

Problem of Permissions for Linked Servers in .net page

I searching using Keywords in MS Word and pdf documents for which i
have used the Index Server and linked with SQL Server but when i am
running the stored procedure thro my webpage i'm getting these errors.
And when i run this code in Query Analyzer its giving expeceted
results. I dont know where the problem is can anyone help please . I'm
really badly stuck. Thanks in Advacne
User does not have permission to perform this action. Line 3: Incorrect
syntax near '@.searchstring'. Invalid object name 'FileSearchResults'.
And my stored procedure is given below
CREATE PROCEDURE SelectIndexServerCVpaths
(
@.searchstring varchar(100)
)
AS
Exec sp_addlinkedserver FileSystem,
'Index Server',
'MSIDXS',
'Web',
'c:\inetpub\wwwroot\sap-resources\Uploads'
IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS
WHERE TABLE_NAME = 'FileSearchResults')
DROP VIEW FileSearchResults
EXEC ('CREATE VIEW FileSearchResults AS SELECT * FROM
OPENQUERY(FileSystem,''SELECT Directory, FileName,
DocAuthor, Size, Create, Write, Path FROM
SCOPE() WHERE FREETEXT(''@.searchstring'')'')')
SELECT * FROM FileSearchResults F, CVdetails C WHERE C.CV_Path = F.PATH
AND C.DefaultID=1
GONext time print out the strings you build before executing them.
See if this helps:
exec ('CREATE VIEW FileSearchResults AS SELECT * FROM
OPENQUERY(FileSystem,''SELECT Directory, FileName,
DocAuthor, Size, Create, Write, Path FROM
SCOPE() WHERE FREETEXT(' + @.searchstring + ')'')')
ML
http://milambda.blogspot.com/|||Thanks for your reply
its not working out.
I modified the stored procedure as shown below
its giving no errors but no results but if i execute the same without
the stored i'm gettting the expected results
Thanks in Advance
IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS
WHERE TABLE_NAME = 'FileSearchResults')
DROP VIEW FileSearchResults
EXEC ('CREATE VIEW FileSearchResults AS SELECT * FROM
OPENQUERY(FileSystem,''SELECT Directory, FileName,
DocAuthor, Size, Create, Write, Path FROM
SCOPE('''' "c:\inetpub\wwwroot\sap-resources\Uploads" '''') WHERE
FREETEXT(''''@.searchstring'''')'')')
SELECT * FROM FileSearchResults F, CVdetails C WHERE C.CV_Path = F.PATH
AND C.DefaultID=1

Saturday, February 25, 2012

Problem installing SP2

)
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

)
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

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_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 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_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...
>> 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_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 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:
http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506%22#fc225bccf807fe1c
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...
>> 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_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.
>>
>|||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:
> http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506%22#fc225bccf807fe1c
> 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...
>> 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_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.
>>
>>
>|||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 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:
>> http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506%22#fc225bccf807fe1c
>> 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...
>> 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_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 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...
>> 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:
>> http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506%22#fc225bccf807fe1c
>> 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...
>> 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_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.
>>
>>
>>
>>
>

Monday, March 12, 2012

Problem of Permissions for Linked Servers in .net page

Saturday, February 25, 2012

Problem installing SP2

Problem installing SP2

Problem installing SP2

xp cmdshell

Blog Archive

About Me