You are probably using Windows authentication for SQL Server, change it to
Windows/SQL Server.

--
Manohar Kamath
Editor, .netBooks
[url]www.dotnetbooks.com[/url]


"Andy Smith" <someone@microsoft.com> wrote in message
news:wc6_a.5683$5K2.2500@news-binary.blueyonder.co.uk...
> Dear All,
>
> I am getting a error when connecting to SQL Server 7 MSDE.
>
> 'IUSR_PC'. Reason: Not associated with a trusted SQL Server connection.
>
> I have set up the login and assigned the permissions for this username in
> the database. Could anyone help me with my problem?
>
> Connection = "Provider=SQLOLEDB;DSN=DdataSourceName;Initial
> Catalog=DatabaseName;User Id=IUSER_PC;"
>
> Cheers,
> Andy
>
>