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.
Yunus Hussian K
...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.
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