Solved

Receive the error message "Cannot connect to mssql. Additional Information: Cannot generate SSPI context. (Microsoft SQL Server)" while using MSSQL Server Management studio to logon to SQL server

Posted on 2010-08-26
1
481 Views
Last Modified: 2012-05-10
Receive the error message "Cannot connect to mssql. Additional Information: Cannot generate SSPI context. (Microsoft SQL Server)" while using MSSQL Server Management studio to logon to SQL server (see screenshot).

What can be done to fix this?
MSSQL-error.png
0
Comment
Question by:Knowledgeable
1 Comment
 
LVL 16

Accepted Solution

by:
vdr1620 earned 500 total points
ID: 33535692
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Learn about cloud computing and its benefits for small business owners.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question