03-28-2011 11:46 PM
hi all,
iam trying to create a SQL selection list. The sql server is not joined to domain and it is windows 2008. so i created a user Badmin in the sql server locally, and i made it administrator, backup operator, and under local security i added it to log on as batch job.Still when i select the badmin fro selection list it showing wrong credential, all other resources like its system state normal files all are accessible. only proble is while trying to access SQL database. please help on this issue.
thanks
Yunus Hussian K
03-28-2011 11:50 PM
Is that account have sufficient privileges to access SQL databases? Means sql admin privileges?
Regards...
03-28-2011 11:53 PM
hi kiren,
i added that to all SQL groups available there in the groups. But there is nothign specific as SQLAdmin group.
03-29-2011 12:05 AM
Make sure the remote agent service on the Sql server is running on Local system account and try creating a new backup Job .
03-29-2011 12:28 AM
...did you add that account under Network --> Logon Accounts as servername\account? You can also try IP_address\account if you haven't put something into the HOSTS file of the media server.
03-29-2011 09:10 AM
hi all,
i have added this account under network--> logon account as servername\accountname
i confirmed the agent is running.
still the problem is there.
03-29-2011 12:29 PM
Hi ,
have you added this account Badmin in SQL logins .
and does it have dbcreator , serveradmin and sysadmin roles in SQL .
can you check the same and update the result .
Thanks & Regards
Sharad Ail