Re: Not associated with a trusted SQL Server connection - Windows Serv



Hi Thomas,

What is your connection string?

--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"Thomas Woods" <Thomas Woods@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:89EBC2EB-A11A-42F5-ADB9-604BD537F8D5@xxxxxxxxxxxxxxxx
> I'm developing a windows service on a workgroup. My database is set up
> for
> Mixed Mode Authentication and I'm logging on using a sql login. I've used
> sa
> and the blank password and I've also created a new user with a password
> and
> tried that as well. The service is running under the local machine
> account.
> All of the code works when I put it in a Windows Forms application, but
> not
> when it runs as a service. I'm using SQL Server 2000 on a Windows XP Pro
> machine. Can anyone explain this to me?
>
> The exact message is:
> Login failed for user 'sa'. Reason: Not associated with a trusted SQL
> Server
> connection.


.



Relevant Pages

  • Re: Login failed for user (null)
    ... Not associated with a trusted SQL Server connection. ... However, if you deal with the Domain controller, most of the controls there ... > (Windows 2003 server, domain member). ...
    (microsoft.public.inetserver.asp.db)
  • Re: Login failed for user (null)
    ... Not associated with a trusted SQL Server connection. ... However, if you deal with the Domain controller, most of the controls there ... > (Windows 2003 server, domain member). ...
    (microsoft.public.sqlserver.connect)
  • Re: Login failed for user (null)
    ... Not associated with a trusted SQL Server connection. ... However, if you deal with the Domain controller, most of the controls there ... > (Windows 2003 server, domain member). ...
    (microsoft.public.sqlserver.security)
  • Re: Login failed for user (null)
    ... Not associated with a trusted SQL Server connection. ... However, if you deal with the Domain controller, most of the controls there ... > (Windows 2003 server, domain member). ...
    (microsoft.public.inetserver.iis.security)
  • Re: Login failed for ServerGuest
    ... I think it is not a limitation in Windows 2000. ... access SQL server on Win2000 server by using Windows authenctication if I ... | I have noticed that when I try to log in using Windows Authentication ...
    (microsoft.public.sqlserver.connect)