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 Gaming 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 Gaming' 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
  2. MARIO IGNACIOGAJARDO CONSTENLA
    Mario IgnacioGajardo Constenla Win User

    SQL Server events after Windows update last week

    Hi EdBeery,

    Regardless of your SQL Server version, I would highly recommend you download the latest SSMS here (https://docs.microsoft.com/en-us/sql/ssms/downl...).

    As of this writing, it's version 17.4. Microsoft releases a new version of SSMS every month and I would encourage you to download the latest one because Microsoft fixes some bugs and new features are added. The only downside is you need to reboot your machine
    every time you update the SSMS.

    If you need the SQL Server Database Engine installed on your laptop, you can download it (https://www.microsoft.com/en-au/sql-server/sql-...). You can download SQL
    Server Express or SQL Server Developer Edition. I would suggest you download the Developer Edition as it has all the features of Enterprise edition so you can play around with the features of Enterprise.

    I hope to help you.
     
    Mario IgnacioGajardo Constenla, Jan 23, 2023
    #2
  3. PETER JAY 85
    Peter Jay 85 Win User
    Downloading SQL and accessing server

    Hello, I am attempting to download SQL and SSMS. Now I am trying to connect to the server but receive this error message:

    "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
    (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)"

    How do I fix this?
     
    Peter Jay 85, Jan 23, 2023
    #3
  4. BRINK
    Brink Win User

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

    Announcing SQL Server Management Studio – 16.5.1 Release


    Source: Announcing SQL Server Management Studio 16.5.1 Release | SQL Server Release Services
     
    Brink, Jan 23, 2023
    #4
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 Software and Apps
    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...