What are the challenges you face when working across database platforms? Take the survey

Login issue

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited April 23, 2004 8:32AM in Aardvark
Hi Kim,

Thanks for posting. This looks like an authentication problem between
the SQL Server and the Active Directory domain controller. The bottom line
is that the domain can't verify the Service Principal Name of the SQL

The first thing to try would be to log into the server with a domain
account. If that doesn't work, you should probably try to delete the SQL
Server's computer account and re-add it to the domain.

Here is a Microsoft Knowledge Base article that might help troubleshoot
the problem, although it's a bit long-winded:

http://support.microsoft.com/default.as ... duct=sql2k


Brian Donahue
Red Gate Technical Support

"Kim Andersen" <kan@saxobank.com> wrote in message
> Hi all,
> I have encountered a problem on my Aardvark installation.
> When I tries to login a get an error:
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> Error in Logon (0, -2147467259) - [Microsoft][ODBC SQL Server
> generate SSPI context
> /logon.asp, line 137
> We have the Aardvark Application on one win2000 server and the SQL server
> another Win2000 server - I have tried to alter the connection from TCP/IP
> NamePipes, but it doesn't seem like that Aardvark support this form for
> connection. - I might be wrong.
> I have tried every solution that I could find in this news group, but the
> result stays the same.
> Any ideas someone? - Because I'm all out of them. Please help!
> Regards
> Kim
This discussion has been closed.