Cannot Generate SSPI Context
Article ID
ias-9076
Article Name
Cannot Generate SSPI Context
Created Date
19th August 2010
Product
Problem
It has been identified that when trying to run CreatePracticeLogin the following error can occur Error 1007 Could not drop existing login [Irisdbo] Error Cannot Generate SSPI Context
Resolution
The following steps may help to resolve the error.
- Click Start
- Click Programs
- Click Microsoft SQL Server
- Click Configuration Tools.
- Click SQL Server Configuration Manager
- Click SQL Server Network Configuration.
- Select the TCP/IP from the list of protocols, right click and set to Disabled.
- Select SQL Server Services, right click SQL Server (IRISPRACTICE) and then select properties.
- Change the Built in Account from Network Service to Local System
- Retry CreatePracticeLogin
We are sorry you did not find this KB article helpful. Please use the box below to let us know how we can improve it.