HI Im having an issue with connecting a crystal reporting server to a MSSQL database..

the report runs via odbc fine from the report developer but when i publish it to the reporting server is it fails to run..

I was told that if you change to the reporting page  server and job server  logins from local system account to a domain account that has access to the SQL server DB then it would run reports...

The issue that I have is that this report server isnt on the domain... AND I plan on running reports from multiple domains anyway.. also mixed Db types.. mostly Oracle and MSSQL..

How can I create an account that will run the page and job servers and not be on the domain?

So Any Ideas? thanks in Advance.