Forum Discussion
Jake216
Nov 24, 2021Copper Contributor
SQL login screen
Hi Everyone, I was recently given a file to work on however it asked for my credentials. I clicked on Microsoft account, entered my information but it gives me an error code. The problem that I'm ...
olafhelper
Nov 24, 2021Bronze Contributor
Hello Jake216 ,
What for an application is this?
Have you entered (somewhere) the right server and database name?
On first hand it looks like you entered wrong server name or you have no permissions to access the SQL Server / database.
Ask your DBA to assist you.
- Jake216Nov 26, 2021Copper Contributor
Hi olafhelper, This is a report run through Excel. When they sent me the file, I wasn't given the credentials to login so I tried my Microsoft account info. The information created a link with the server but would not login. after this I was given the correct login/password however, the screen where I enter this does not appear anymore.
Not sure how I stop the file from automatically using the credentials I've entered incorrectly.
I'll reach back out to them to see if they can help me.- olafhelperNov 29, 2021Bronze ContributorAsk your DBA which credentials to use and/or ask him to grant access for your Windows login.
- Jake216Nov 30, 2021Copper ContributorThey sent me the correct information to access the file however, there is nowhere for me to enter it. There used to be a login/password screen that appeared when the file would first open (picture 1), now it opens with the error message (picture 2).
The error message says "A connection was successfully established with the server, but then an error occurred during the login process" Somehow it has the wrong information saved from the first time and wont let me go back to enter anything else.
Thanks again for the information you've provided.