Author |
Topic |
hdv212
Posting Yak Master
140 Posts |
Posted - 2011-12-03 : 15:39:42
|
Hii have some t-sql commands which used xp_cmdShell proc. it works correctly in query window, but when i create a job to run this command periodically and start job to test operation, i'm facing this error :Executed as user: WORKGROUP\SERVER-PC$. The process could not be created for step 1 of job 0xEE190A45B7C8764595062A575858EC1E (reason: 2). The step failed.Also i changed all objects to MyDatabase.dbo.MyObject but the problem was not solved.where is the problem and how to solve it ?I'm using sql server 2008 in workgroup and win 7. |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-03 : 22:53:16
|
does the login job uses have access to execute xp_cmdshell------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
hdv212
Posting Yak Master
140 Posts |
Posted - 2011-12-04 : 00:00:18
|
Hihow to i deteremine the given user have access ? i'm login to sql server as 'sa' |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-04 : 00:24:25
|
not you...but open the database and see what role the account WORKGROUP\SERVER-PC$ is mapped to------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
hdv212
Posting Yak Master
140 Posts |
Posted - 2011-12-04 : 00:45:42
|
in my own database (not master database) i have only this user 'SERVER-PC\Ghasedak' |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-04 : 01:11:45
|
quote: Originally posted by hdv212 in my own database (not master database) i have only this user 'SERVER-PC\Ghasedak'
nope. check beneath Security->Logins inside your server------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
hdv212
Posting Yak Master
140 Posts |
Posted - 2011-12-04 : 02:17:38
|
Also in my server logins i don't have this account : WORKGROUP\SERVER-PC$ |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-04 : 02:18:46
|
quote: Originally posted by hdv212 Also in my server logins i don't have this account : WORKGROUP\SERVER-PC$
then how is sql server agent using it? are you hosting jobs in some other server?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
hdv212
Posting Yak Master
140 Posts |
Posted - 2011-12-04 : 07:02:35
|
No, all service whithin a single computer and all services run under 'Local System' account.Another problem (maybe this clarify my problem) : i can not login to my sql server via windows authentication. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-04 : 07:17:45
|
that means your windows account is not yet set up as a login in sql server------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
hdv212
Posting Yak Master
140 Posts |
Posted - 2011-12-04 : 09:23:13
|
quote: Originally posted by visakh16 that means your windows account is not yet set up as a login in sql server------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
How can i solve this problem ?can u plz tell me step-by-step guidance ?thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
hdv212
Posting Yak Master
140 Posts |
Posted - 2011-12-04 : 12:52:51
|
The current windows account (Server-PC\Ghasedak) exists in sql server logins. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-04 : 23:48:42
|
quote: Originally posted by hdv212 The current windows account (Server-PC\Ghasedak) exists in sql server logins.
if thats case you should be able to login with it. I didnt understand how you got error posted in previous post thenAre you sure you've correct default database set up against your login?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|