Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Khurram Muhammad]

I am trying to get data from SQL database but it has not connected, error is below mentioned

——————————
Khurram Muhammad
Data Analyst
Karachi
——————————

[Lutz Bendlin]

maybe your database requires basic (SQL user) login while you are trying to use your domain login?

——————————
Lutz
——————————
——————————————-

[Christopher Majka]

Hi Khurram – 

I would recommend messaging the SQL server DBA or admin to find out what kind of authentication you need…it could be Windows Authentication, SQL Server login, or even Azure Active Directory.

Thanks

Chris

——————————
Christopher Majka
Manager, Business Intelligence
4018682000
——————————
——————————————-

[Pulendar vadde]

Check below options if you can, else reachout DBA admin and ask DBA to test the connectivity using WidowsAD/Basic etc. Sometimes issue could be with ports(use telnet to test it) also.
Verify that the domain to which you log on can communicate with the domain to which the computer that is running SQL Server belongs. There must also be correct name resolution in the domain.

1. You must make sure that you can successfully log on to Windows by using the same domain account and password as the startup account of the SQL Server service. For example, the SSPI error may occur in one of the following situations:
   • The domain account is locked out.
   • The password of the account was changed. However, you never restart the SQL Server service after the password was changed.
2. If your logon domain differs from the domain of the computer that is running SQL Server, check the trust relationship between the domains.
3. Check whether the domain that the server belongs to and the domain account that you use to connect are in the same forest. This is required for SSPI to work.
4. Use the Account is Trusted for Delegation option in Active Directory Users and Computers when you start SQL Server.

Reference : https://support.microsoft.com/en-us/help/811889/how-to-troubleshoot-the-cannot-generate-sspi-context-error-message

——————————
Pulendar vadde
IT consultant
——————————
——————————————-