Hi, at this moment I have a user that is member of sysadmin in a msde. I
need to remove this user from this group but the user use the
xp_cmdshell.
I configured the proxy account on this intance with a user that is
domain admin and also grant the exec permissions on the xp_cmdshell
extended store procedure, and when I execute a simple query:
exec master.dbo.xp_cmdshell 'dir c:'
returns this error message:
Msg 50001, Level 1, State 50001
xpsql.cpp: Error 1813 from CreateProcessAsUser on line 636
I already restart de sqlserveragent service, but it doesnt work.
Do someone know what could be the reason.
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***
It seems like the service account for the SQL Server service lacks some of the windows Privileges
needed. Search for below in Books Online and you will find what those are:
"level token"
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Maria Isabel Guzman" <mariaisabelguzman@.icasa.com.gt> wrote in message
news:%237yaKpegHHA.4064@.TK2MSFTNGP02.phx.gbl...
> Hi, at this moment I have a user that is member of sysadmin in a msde. I
> need to remove this user from this group but the user use the
> xp_cmdshell.
> I configured the proxy account on this intance with a user that is
> domain admin and also grant the exec permissions on the xp_cmdshell
> extended store procedure, and when I execute a simple query:
> exec master.dbo.xp_cmdshell 'dir c:'
> returns this error message:
> Msg 50001, Level 1, State 50001
> xpsql.cpp: Error 1813 from CreateProcessAsUser on line 636
> I already restart de sqlserveragent service, but it doesnt work.
> Do someone know what could be the reason.
> Thanks a lot for your help.
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
|||Thanks a lot for your help. I already check and the service account i
use is a domainadmin and domainadmins are administrator of the server.
do you have any other clue?
*** Sent via Developersdex http://www.codecomments.com ***
|||Domain admin isn't enough. You need to make sure it has privileges like "Replace a Process Level
Token" and the other stuff mentioned in Books Online.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"MariaGuzman" <marisa@.devdex.com> wrote in message news:%236iAzLhgHHA.4284@.TK2MSFTNGP06.phx.gbl...
> Thanks a lot for your help. I already check and the service account i
> use is a domainadmin and domainadmins are administrator of the server.
> do you have any other clue?
>
> *** Sent via Developersdex http://www.codecomments.com ***
Showing posts with label member. Show all posts
Showing posts with label member. Show all posts
Wednesday, March 21, 2012
Saturday, February 25, 2012
Problem with values returned by Calculated Member
Dear Friends,
I have a problem with CM:
Example
Row Field1 Field2 Field3 Total
1 31662 1 14,75 467014,5
2 250000 1 6,94 1735000
Total for each row= Field1*Field3 / Field2
The value I want for Calculated Member is Total1 + Total 2, 2202014,5, but the value is wrong... The calculated member gives me the value from: SUM Field1* SUM Field3 / SUM Field2, 3054624,39
The MDX:
[Measures].[Open Pos]*[Measures].[New Price]/[Measures].[Fx Rate Rep Cur]
And all the measures are with AggregateFunction as SUM...
Where is the problem? How can I calculate each row in spite of the sum?
Thanks!!
More help to you:
For the date 29.12.2006 I want the calculated member with the value 2202014,5
And currently I'having the value 3054624,39.
|||Is the required calculation Sum(Field 1 * Field 3) / Sum (Field 2)? If so, try adding a calculated column to the DSV that does the (Field 1 * Field 3) calculation. Add this as a new measure, with Sum as the aggregation function. Then your calculated measure will be (New Measure) / (Field 2).|||for the date 29-12-2006 I need to calculate each line of fact Table...
Example:
As I did, in Calculated Member, the value returned is not 1900, but is 2200!! :-(
Understood?
Thanks!
|||Then just add the entire calculation ( (Field 1 * Field 3) / Field 2 ) as a calculated column in your DSV. Create a new measure on that column, and set the AggregationFunction to SUM.
Anytime you need something calculated at the fact level, it's usually best to either add it to fact table directly, or include it in the DSV.
|||But field1 is a named calculation, and I cant use this value to create a new named calculation... :-(|||You should be able to replicate the calculation for Field1 in your new calculated column.|||How can I do it?
When I am creating the second named calculation, in the expression textbox I wrote: [Field1]+1
and returned me the error message: Invalid column named 'Field1'
Field1 is a named calculation... :-(
|||Copy the expression from Field1 into Field2, and add the additional calculations that need to be performed.|||The problem is that the calculations in named calculation Field 1 is not so simple...
yeh.. but I understood that is no possible call a NC from another NC... thanks!
Problem with values returned by Calculated Member
Dear Friends,
I have a problem with CM:
Example
Row Field1 Field2 Field3 Total
1 31662 1 14,75 467014,5
2 250000 1 6,94 1735000
Total for each row= Field1*Field3 / Field2
The value I want for Calculated Member is Total1 + Total 2, 2202014,5, but the value is wrong... The calculated member gives me the value from: SUM Field1* SUM Field3 / SUM Field2, 3054624,39
The MDX:
[Measures].[Open Pos]*[Measures].[New Price]/[Measures].[Fx Rate Rep Cur]
And all the measures are with AggregateFunction as SUM...
Where is the problem? How can I calculate each row in spite of the sum?
Thanks!!
More help to you:
For the date 29.12.2006 I want the calculated member with the value 2202014,5
And currently I'having the value 3054624,39.
|||Is the required calculation Sum(Field 1 * Field 3) / Sum (Field 2)? If so, try adding a calculated column to the DSV that does the (Field 1 * Field 3) calculation. Add this as a new measure, with Sum as the aggregation function. Then your calculated measure will be (New Measure) / (Field 2).|||
for the date 29-12-2006 I need to calculate each line of fact Table...
Example:
As I did, in Calculated Member, the value returned is not 1900, but is 2200!! :-(
Understood?
Thanks!
|||
Then just add the entire calculation ( (Field 1 * Field 3) / Field 2 ) as a calculated column in your DSV. Create a new measure on that column, and set the AggregationFunction to SUM.
Anytime you need something calculated at the fact level, it's usually best to either add it to fact table directly, or include it in the DSV.
|||But field1 is a named calculation, and I cant use this value to create a new named calculation... :-(|||You should be able to replicate the calculation for Field1 in your new calculated column.|||How can I do it?
When I am creating the second named calculation, in the expression textbox I wrote: [Field1]+1
and returned me the error message: Invalid column named 'Field1'
Field1 is a named calculation... :-(
|||Copy the expression from Field1 into Field2, and add the additional calculations that need to be performed.|||The problem is that the calculations in named calculation Field 1 is not so simple...
yeh.. but I understood that is no possible call a NC from another NC... thanks!
Subscribe to:
Posts (Atom)