I am accessing SQL server via SQL express and i will encounter this error occasionally.
I have no problem to remote in to SQL server so I don't think it is due to connection loss.
It actually happened ONLY after we changed the server IP. It used to be 198.162.0.32 and we changed to 10.192.32.32.
Is it becauses any setup inside the SQL express that will make it try to connect to the old IP ?
Error details:
===================================
Cannot connect to ASIASQL1.
===================================
Cannot generate SSPI context. (.Net SqlClient Data Provider)
------------------------------
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476
------------------------------
Server Name: A ...
Go to the complete details ...