There is some advice in the KB topic How to troubleshoot the "Cannot
generate SSPI context" error message
http://support.microsoft.com/kb/811889
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.
"dbuchanan" <(E-Mail Removed)> wrote in message
news:c5392ad4-d5ff-49fb-bee4-(E-Mail Removed)...
I have a Reporting services development environment within a virtual
network consisting of two machines. Both machines are Windows Server
2003 SP2 with the latest updates.
The server machine (A) is located in Hyper-V and the client machine
(B) is located in virtual PC 2007 on a client machine of the host
network.
The server (A) is configured as an Application server (IIS, ASP.NET),
a DomainController (Active Directory) and a DNS server. Also installed
on this server is SQL Server 2005 (SQL Server 9.0.3073).
The client (B) is configured only as an Application server (IIS,
ASP.NET). and has installed SQL Server 2005 (SQL Server 9.0.3073) and
Visual Studio 2005
=======================
Microsoft Visual Studio 2005
Version 8.0.50727.762 (SP.050727-7600)
Microsoft .NET Framework
Version 2.0.50727 SP1
Installed Edition: Professional
Microsoft Visual Basic 2005 77626-009-0000007-41028
Microsoft Visual Basic 2005
Microsoft Visual C# 2005 77626-009-0000007-41028
Microsoft Visual C# 2005
Microsoft Visual C++ 2005 77626-009-0000007-41028
Microsoft Visual C++ 2005
Microsoft Visual J# 2005 77626-009-0000007-41028
Microsoft Visual J# 2005
Microsoft Visual Web Developer 2005 77626-009-0000007-41028
Microsoft Visual Web Developer 2005
Microsoft Web Application Projects 2005 77626-009-0000007-41028
Microsoft Web Application Projects 2005
Version 8.0.50727.762
Crystal Reports AAC60-G0CSA4B-V7000AY
Crystal Reports for Visual Studio 2005
Microsoft Visual Studio 2005 Professional Edition - ENU Service Pack 1
(KB926601)
This service pack is for Microsoft Visual Studio 2005 Professional
Edition - ENU.
If you later install a more recent service pack, this service pack
will be uninstalled automatically.
For more information, visit
http://support.microsoft.com/kb/926601
Security Update for Microsoft Visual Studio 2005 Professional Edition
- ENU (KB937061)
This Security Update is for Microsoft Visual Studio 2005 Professional
Edition - ENU.
If you later install a more recent service pack, this Security Update
will be uninstalled automatically.
For more information, visit
http://support.microsoft.com/kb/937061
Security Update for Microsoft Visual Studio 2005 Professional Edition
- ENU (KB947738)
This Security Update is for Microsoft Visual Studio 2005 Professional
Edition - ENU.
If you later install a more recent service pack, this Security Update
will be uninstalled automatically.
For more information, visit
http://support.microsoft.com/kb/947738
SQL Server Analysis Services
Microsoft SQL Server Analysis Services Designer
Version 9.00.3042.00
SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 9.00.1399.00
SQL Server Reporting Services
Microsoft SQL Server Reporting Services Designers
Version 9.00.1399.00
=======================
Both machines are consistently able to ping one another.
However the client (B) is inconsistently able to connect to the server
(A).
The behavior can typically follow like this;
After the client (B) is started and I logon I start up SQL Server and
connect to the default instance on the server (A). I open Visual
Studio and open the project and able to connect to the shared data
source that accesses the default SQL Server instance on the server
(A). After a time of working on reports I open another report and find
I cannot connect. I switch to SQL Server Management Studio and attempt
to open a new query and it fails with the error; “Cannot generate SSPI
context. (Microsoft SQL Server, Error: 0)”
=======================
TITLE: Connect to Database Engine
------------------------------
Cannot connect to SPSDEV.
------------------------------
ADDITIONAL INFORMATION:
Cannot generate SSPI context. (Microsoft SQL Server, Error: 0)
For help, click:
http://go.microsoft.com/fwlink?ProdN...0&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
=======================
However I can still ping the server (A) from the client (B) and (B)
from (A) yet in order to reestablish a connection to server (A) I must
shout down and restart the client (B).
(An associate has experienced this same behavior with reporting
services with physical machines when working with xml datasources. My
present problem is however with standard datasources.)
What is the possible cause of this behavior and how can it be
remedied.
Similar Threads
Linear Mode
