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
Kim Andersen
Guest





PostPosted: Fri Apr 23, 2004 8:23 am    Post subject: Login issue Reply with quote

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
Brian Donahue



Joined: 23 Aug 2004
Posts: 6577

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
Kim Andersen
Guest





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

Hi Brian,

Thanks for your replay - yes Microsoft knowledge base answer was a little
longhaired, but it solved the problem...

The problem was: There had bee some changes in my local domains, the result
of this was a Kerberos Event Logging fail... but anyway I removed my domain
users from both the web server and the SQL server, added them again, an
restarted them both - and that helped Smile

/Kim

"Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message
news:#hGu67SKEHA.1428@server53...
> 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
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