Re: strange sql-server login problem

From: admin (admin_at_wol.be)
Date: 09/01/04 

Date: Wed, 1 Sep 2004 00:23:26 +0200

FYI:
I actually found out what the problem was: nothing to do with mssql
directly: the kerberos service on one of the domain controllers wasn't
active!
Once I got it started ok, everything was normal again.

"peter" <peter@mariejo.com> schreef in bericht
news:2s0ngc.9mq.ln@abit0.vdv.local...
> Hi,
> I've tried this and (to my surprise) it works both times (tcp & np): I can
> query the database and I can see the correct user in the process info.
> Database shows 'login succeeded for user xxx/yyy' so integrated security
> When I try to connect through ODBC however, it still fails ..
> To me, this looked like it might be a problem with the odbc-drivers, so
I've
> installed the most recent version of mdac, but that didn't help.
>
>
>
> "Kevin McDonnell [MSFT]" <kevmc@online.microsoft.com> wrote in message
> news:IeIojbWiEHA.2632@cpmsftngxa10.phx.gbl...
> > Try the following test:
> >
> > ISQL -Stcp:ServerNameHere -E
> > then
> > ISQL -Snp:ServerNameHere -E
> >
> > Post the results.
> >
> > Thanks,
> >
> > Kevin McDonnell
> > Microsoft Corporation
> >
> > This posting is provided AS IS with no warranties, and confers no
rights.
> >
> >
> >
>
>

Relevant Pages

  • Re: active directory will not start
    ... How is the file system on the Domain Controllers, ... Run check disk on the same volumes as the ntds.dit (ad database) ... We are unable to boot into active directory on ...
    (microsoft.public.windows.server.active_directory)
  • Re: Active Directory Maintenance
    ... Normally you have nothing to do with the database, ... database maintenance I should do? ... objects a system state backup is useful. ... our 2 domain controllers. ...
    (microsoft.public.windows.server.general)
  • Re: How to do maintenance repair in AD
    ... DC, RAID, and backup except that I'm only running the ... I'm looking for in Windows. ... In AD, changes are always replicated between all domain controllers, so, if ever one of them should have corrupted data, this would generate a replication conflict and the problem would emerge. ... Also, the database storage engine is the same one used by Exchange, and it's quite reliable; it sure is capable of detecting database corruptions. ...
    (microsoft.public.windows.server.active_directory)
  • Re: strange sql-server login problem
    ... I've tried this and it works both times (tcp & np): ... query the database and I can see the correct user in the process info. ... Database shows 'login succeeded for user xxx/yyy' so integrated security ...
    (microsoft.public.sqlserver.security)
  • Re: Size of object in active directory
    ... database. ... Paul Bergson wrote: ... domain controllers. ... consuming in a ntds.dit file? ...
    (microsoft.public.win2000.active_directory)
Quantcast