I get error like"Login failed for domain\machinename" when I try to run the application. The machinename is the host name of my machine.
Details:
- Gemini is installed on the freshly formatted machine (hostname : machinename)
- Gemini DB is available on another machine. The scripts have been run and there are no errors ( I migrated from 2.0.2 to 3.6.5)
- The DB administrator has given me <domain name>\<loginname> permissions (below securit\logins in SQL server) for the Gemini DB as dbowner and dbadmin. Apart from me there is a sa account and nothing else.
- I try connecting using trusted connection = true.
Do I need to ask DB admin to add NETWORK_SERVICE as well?
Anything else I should be doing to bring the application up?