Good day.
When connecting to sql server database in LNDB using windows authentication, instead of using my actual DOMAN\USERNAME, for some reason LNDB is using my DOMAIN\HOSTNAME. Hostname being my computer name.
Eg:
Domain: ec_atlantic
user: benoitd
Hostname: WMON01DTDABENO
I am getting error:
Error Connecting to database. Login failed for user "EC_ATLANTIC\WMON01DTDABENO$"
is this a common issue with LNDB?
Thanks
Dave
The LNDB service runs under a local system account by default. I believe that's why it's using your computer name. Go to Control Panel \ Administrative Tools \ Services and set it to run under your user name.