| Posted by: berkscompsltd - 29 July 2024 12:55:10 |
|---|
| Connection failed: SQLstate: 'HY000' SQL Server Error: 0 [Microsoft][ODBC SQL Server Driver] Cannot Generate SSPI Content |
| Posted by: berkscompsltd - 29 July 2024 13:12:19 |
|---|
| I can connect to the other SQL server instance on the same server no problem. I can connect locally... What's going on? |
| Posted by: berkscompsltd - 29 July 2024 14:24:53 |
|---|
| The SQL Server Network Interface library could not register the Service Principal Name (SPN) is also showing |
| Posted by: berkscompsltd - 29 July 2024 16:11:43 |
|---|
| After messing about with kerberos utilities and SPNs I had to configure the NAV server to use the SQL logins to get around this as I never figured out why it would start behaving this way - it was something to do with the dynamic ports and there being a static 2008 SQL server instance on the same box. Bluugh! |