Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2010-05-06 : 13:33:08
|
| Hi,we have added a hotfix in our sql server 2005 ent edition,later i'm getting the error "cannot generate sspi context". from inside the server, i'm able to connect. but from other machines i'm not. thanks in advance.what is the solution.....ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2010-05-06 : 13:42:08
|
| i'mreading some articleson this, but that is aproduction, and this is a banking environment. you experienced suggesionis helpful TaraArnavEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2010-05-11 : 06:03:12
|
| Why the problem arised : we tried to install a hot fix using service account, it has not accepted. so we changed to built-in account and installed successfully, again changed back to service account. then the problem started. we are able to connect from the server to sql server. but from any other client machine, we are not able to connect.Solution for this: we tried all the ways, but no success. finally, we changed the account to built in account, and restarted the server (i mean service). then changed the account to service account again. now there are no issues, and we are able to connect from other client machines also.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
cannot generate sspi context