Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Job problem : The process could not be created for

Author  Topic 

hdv212
Posting Yak Master

140 Posts

Posted - 2011-12-03 : 15:39:42
Hi

i 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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

hdv212
Posting Yak Master

140 Posts

Posted - 2011-12-04 : 00:00:18
Hi
how to i deteremine the given user have access ? i'm login to sql server as 'sa'
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

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'
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

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$
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

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.
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

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 MVP
http://visakhm.blogspot.com/





How can i solve this problem ?
can u plz tell me step-by-step guidance ?
thanks in advance
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-04 : 09:44:33
see

http://msdn.microsoft.com/en-us/library/aa337562.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

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.
Go to Top of Page

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 then
Are you sure you've correct default database set up against your login?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -