Red Gate forums :: View topic - Login issue
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Aardvark
Aardvark forum

Login issue

Search in Aardvark forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6677

PostPosted: Fri Apr 23, 2004 1:32 pm    Post subject: Re: Login issue Reply with quote

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
Server.

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.aspx?scid=kb;en-us;811889&product=sql2k

Regards,

Brian Donahue
Red Gate Technical Support

"Kim Andersen" <kan@saxobank.com> wrote in message
news:NJkVgRQKEHA.1236@server53...
> 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
Driver]Cannot
> generate SSPI context
> /logon.asp, line 137
>
> We have the Aardvark Application on one win2000 server and the SQL server
on
> another Win2000 server - I have tried to alter the connection from TCP/IP
to
> NamePipes, but it doesn't seem like that Aardvark support this form for
data
> 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
>
>


Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group