Windows 10: 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

:)

 

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.

 

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?

 

Announcing SQL Server Management Studio – 16.5.1 Release

Source: Announcing SQL Server Management Studio 16.5.1 Release | SQL Server Release Services