Connection failed: SQLstate: 'HY000' · PC & Mac Help and Assistance

berkscompsltd
100% (Exalted)
Newbie Topic Starter

3 months ago

Connection failed:
SQLstate: 'HY000'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver] Cannot Generate SSPI Content

Sponsor

Want to thank us? Use: Patreon or PayPal or Bitcoins: bc1q4whppe29dw77rm4kv4pln0gqae4yjnxly0dny0hky6yhnafukzjsyrsqhk

All opinions expressed within these pages are sent in by members of the public or by our staff in their spare time, and as such do not represent any opinion held by sircles.net Ltd or their partners.

Wanna join the discussion?! Login to your PC & Mac Help and Assistance forum account or Register a new forum account

berkscompsltd
100% (Exalted)
Newbie Topic Starter

3 months ago

I can connect to the other SQL server instance on the same server no problem.

I can connect locally...

What's going on?

berkscompsltd
100% (Exalted)
Newbie Topic Starter

3 months ago

The SQL Server Network Interface library could not register the Service Principal Name (SPN) is also showing

berkscompsltd
100% (Exalted)
Newbie Topic Starter

3 months ago

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!

Important Information:

The PC & Mac Help and Assistance uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close