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. License for Windows Server and SQL Server

    in Windows 10 Software and Apps
    License for Windows Server and SQL Server: Hi,I have question regarding the license.Windows server running on VMBased on my knowledge, license on VM is required but how many core can I assign for the VM's.SQL server running on VMDoes SQL also required certain license running on VM's ? Or I can just go with the...

  3. 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...

  4. SQL server

    in Windows 10 Software and Apps
    SQL server: After upgrading the OS from Win 10 to Win 11 home edition the SQL doesn't work any more. https://answers.microsoft.com/en-us/windows/forum/all/sql-server/1c360899-de1f-4c76-ae53-cd415ef46ac1

  5. SQL server

    in Windows 10 Gaming
    SQL server: After upgrading the OS from Win 10 to Win 11 home edition the SQL doesn't work any more. https://answers.microsoft.com/en-us/windows/forum/all/sql-server/1c360899-de1f-4c76-ae53-cd415ef46ac1

  6. 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....

  7. 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....

  8. 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...

  9. Remote Desktop won't accept login credentials

    in Windows 10 Network and Sharing
    Remote Desktop won't accept login credentials: I have read several questions on this forum about this and the moderator keeps referring people to the TechNet Forum. He says this forum is basically for home users, not pro users or something. Remote Desktop is part of Windows 10 Pro. It's advertised as a feature by MS....

  10. Remote Desktop won't accept login credentials

    in Windows 10 Network and Sharing
    Remote Desktop won't accept login credentials: I have read several question on this forum about this and the moderator keeps referring people to the TechNet Forum. He says this forum is basically for home users, not pro users or something. Remote Desktop is part of Windows 10 Pro. It's advertised as a feature by MS....