Re: SQL Trust issue

Tech-Archive recommends: Speed Up your PC by fixing your registry

http://support.microsoft.com/?kbid=841249
Is my immediate thought... firewall, but it may not be the issue. Here is
the Microsoft troubleshooting site for SP2 and MSDE (SQL Server)
http://www.microsoft.com/sql/techinfo/administration/2000/security/winxpsp2faq.asp
"Microsoft News Group" <sekoon@xxxxxxxxxx> wrote in message
news:ej$q0wlQFHA.356@xxxxxxxxxxxxxxxxxxxxxxx
>I have tried your suggestions, The logged on user accout is the same as the
>SQL instante log account. And the LoginMode is set correctly. This is
>driving me crazy in that I can uninstall the SP2 and things start working
>again, yet re-apply the SP2 and it break my SQL trust.
>
> Steve
>
>
> "jamie" <anonymous@xxxxxxxxxxxxxxxxxxxx> wrote in message
> news:O8jhXdgQFHA.2520@xxxxxxxxxxxxxxxxxxxxxxx
>> One thing to try when you have a login error is to go to (MYComputer -
>> Manage - Services and Applications - Services) the services and check to
>> see what the login id is for that particular instance or if the primary
>> instance, that too. Sometimes the account gets confused on the SP2
>> install. I can't tell you why, but I know when I installed the SP2, I had
>> to make an adjustment.
>>
>> Right click - Slect Properties - Log On. Should say the Local System
>> account. (Provided that the local system account is an administrator).
>> There is also a registry setting you shouldn't need to mess with but if
>> it still doesn't work, check HKCU\SOFTWARE\Microsoft\Microsoft SQL
>> Server\[instance name]\MSSQLServer and the value to change is LoginMode
>> and the value you want is 1 for integrated security or (0) 2 for
>> integrated security (which I assume you do not want since you are getting
>> a trusted server denial).
>>
>> Jamie
>>
>> "Microsoft News Group" <sekoon@xxxxxxxxxx> wrote in message
>> news:u52GNifQFHA.3336@xxxxxxxxxxxxxxxxxxxxxxx
>>>I have an application running on my desktop that access the SQL database
>>>and as long as I am not running XP SP2 things run fine. As soon as I
>>>install XP SP2 then I keeping getting this message "Database Error: Login
>>>failed for the user. Reason:Not associated with a trusted SQL Server
>>>connection". I have tried everything and change not get this problem
>>>resolved, anyone have a clue as to where I should start looking at again
>>>to get this fixed?
>>>
>>> Steve
>>>
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: SQL Trust issue
    ... > One thing to try when you have a login error is to go to (MYComputer - ... Sometimes the account gets confused on the SP2 ... >>I have an application running on my desktop that access the SQL database ...
    (microsoft.public.sqlserver.msde)
  • Re: SQL Trust issue
    ... SQL instante log account. ... And the LoginMode is set correctly. ... yet re-apply the SP2 and it break my SQL trust. ... Sometimes the account gets confused on the SP2 ...
    (microsoft.public.sqlserver.msde)
  • RE: Integration Services Fehler
    ... konnte bei diversen Kunden Probleme mit den SSIS durch reSetup des SP2 ... manuelle Registrierung der dts.dll im 90er Ordner funktionierte SQL ... Konfigurieren des SQL Server Integration Services-Dienstes: ...
    (microsoft.public.de.sqlserver)
  • Ent MS Svr 2003, Ent MS SQL Svr 2005, SQL SP2 failed at end
    ... I have a Enterprise edition Server 2003 running the Enterprise Edition of SQL ... I recently upgraded the MS Server 2003 to SP2, we also have the SQL Express ...
    (microsoft.public.sqlserver.setup)
  • Re: cannot see SQL Jobs on remote server
    ... Now I installed SP2 for SQL Server and the problem ... Try applying SQL ... Server 2005 SP2 on your PC. ...
    (microsoft.public.sqlserver.connect)