Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

数据库SQL服务器坏了,无法生成 SSPI 上下文。

34 views
Skip to first unread message

steve morris

unread,
Dec 2, 2008, 3:15:36 AM12/2/08
to
我的数据库服务硬件down,更换了整台机器,原来的数据库文件都在,Attach恢复数据库后,sharepoint依然不能运行,出错信息是找不到数据库

看了event LOG后,基本上是无法生成 SSPI 上下文。

数据库可以通过其它方式上去,也能看到里面的数据

请问我接下去应该检查些什么?

dwu

unread,
Jan 14, 2009, 5:31:01 PM1/14/09
to
Since you had new server replaced the broken one, i assume the new server
uses the same server name and ip as the old one. SSPI indicates NT
authentication related issue. Please reference to the following link to
troubleshoot SSPI error: http://support.microsoft.com/kb/811889

Make sure your new SQL server has all the sharepoint login ids(Window NT
accounts) created and have proper permission to the sharepoint dbs. Since you
attached sharepoint dbs, you might check any orphan id lingering in the dbs
or not. sp_change_users_login 'report'

SSPI
--
Hope it helps

dwu

0 new messages