Windows 10: Cannot login into an SQL server remotely through ssms when using windows credentials. This...

Discus and support Cannot login into an SQL server remotely through ssms when using windows credentials. This... in Windows 10 Software and Apps to solve the problem; We have a SQL Server 2008 R2 which locks all remote windows connections after a week. We get this error messageThe target principle name is incorrect.... Discussion in 'Windows 10 Software and Apps' started by Eudias, Jan 23, 2023.

  1. EUDIAS
    Eudias Win User

    Cannot login into an SQL server remotely through ssms when using windows credentials. This...


    We have a SQL Server 2008 R2 which locks all remote windows connections after a week. We get this error messageThe target principle name is incorrect. Cannot generate SSPI context.Upon reboot, connections are successful but this reoccurs exactly after 7daysWe use both windows an SQL authentication, but only windows accounts are not able to connectWe have checked the registered SPNs which seem just find. No duplicates, KCM shows the SPNs are okWhen pinged, the IP address resolves DNS.Your recommendations will be greatly valued. Thanks in advance

    :)
     
    Eudias, Jan 23, 2023
    #1
Thema:

Cannot login into an SQL server remotely through ssms when using windows credentials. This...

Loading...

  1. Cannot login into an SQL server remotely through ssms when using windows credentials. This... - Similar Threads - Cannot login SQL

  2. SQL server 2022 Express cannot be used after upgraded to Windows 11

    in Windows 10 Software and Apps
    SQL server 2022 Express cannot be used after upgraded to Windows 11: We have a HP desktop here that is running Windows 10 Pro and has SQL Server installed. After upgrading to Windows 11, SQL can neither be opened nor started. I tried reinstalling, but no luck....

  3. Using SQL Server on Windows 11

    in Windows 10 Gaming
    Using SQL Server on Windows 11: I would like to install SQL Server 2022 Express on a Windows 11 PC and use it as the database for an in-house developed Windows application.Would this usage violate the Windows 11 license terms?There will be about 5 users, and access to SQL Server will be limited to within...

  4. Using SQL Server on Windows 11

    in Windows 10 Software and Apps
    Using SQL Server on Windows 11: I would like to install SQL Server 2022 Express on a Windows 11 PC and use it as the database for an in-house developed Windows application.Would this usage violate the Windows 11 license terms?There will be about 5 users, and access to SQL Server will be limited to within...

  5. Windows Authentication for SQL MI from SSMS

    in Windows 10 Gaming
    Windows Authentication for SQL MI from SSMS: Is this link Complete: Configure Windows Authentication with Microsoft Entra ID - Azure SQL Managed Instance Microsoft Learn ? --I did all the steps mentioned above.But I see another link where it mentions - Configure group policy- where this has to be done ? How to set up...

  6. Windows Authentication for SQL MI from SSMS

    in Windows 10 Software and Apps
    Windows Authentication for SQL MI from SSMS: Is this link Complete: Configure Windows Authentication with Microsoft Entra ID - Azure SQL Managed Instance Microsoft Learn ? --I did all the steps mentioned above.But I see another link where it mentions - Configure group policy- where this has to be done ? How to set up...

  7. Cannot login into an SQL server remotely through ssms when using windows credentials. This...

    in Windows 10 Gaming
    Cannot login into an SQL server remotely through ssms when using windows credentials. This...: We have a SQL Server 2008 R2 which locks all remote windows connections after a week. We get this error messageThe target principle name is incorrect. Cannot generate SSPI context.Upon reboot, connections are successful but this reoccurs exactly after 7daysWe use both windows...

  8. File Explorer is Not Responding After Opening Query in SSMS SQL Server Management Studio...

    in Windows 10 Network and Sharing
    File Explorer is Not Responding After Opening Query in SSMS SQL Server Management Studio...: File Explorer Didn't respond for a moment while Alt+Tab Or Windows Switched via Mouse after opening query in SQL Server Management Studio This issue is arriving just now from September 12. Issue came in my Colleague PC too....

  9. File Explorer is Not Responding After Executing Query in SSMS SQL Server Management Studio

    in Windows 10 Network and Sharing
    File Explorer is Not Responding After Executing Query in SSMS SQL Server Management Studio: File Explorer Didn't respond for a moment while Alt+Tab Or App Switched via Mouse after executing query in SQL Server Management Studio This issue is arriving just now, I've also not checked Windows Update....

  10. Windows Defender Credential Guard does not allow using saved credentials when using remote...

    in Windows 10 Customization
    Windows Defender Credential Guard does not allow using saved credentials when using remote...: Hi all, I have a Microsoft Surface Pro 4 tablet. I completely reinstalled the tablet using the latest available recovery image with Windows 10 Version 1703. I set up a remote desktop connection to my desktop computer and the saved credentials were used so I don't have to...