Posted by Hari Prasad on 11/15/06 03:33

Hello,

Have you added the OS user into the SQL Server? If not add the particular
user into SQL Server Logins and try connecting.

Thanks
Hari




"Mad Scientist Jr" <usenet_daughter@yahoo.com> wrote in message
news:1163550792.558431.311470@k70g2000cwa.googlegroups.com...
>I am getting the following error when trying to access a database with
> a trusted connection:
>
> "Login failed for user '(null)'. Reason: Not associated with a trusted
> SQL Server connection."
>
> My connection string is:
>
> "Server=MyServer; Database=MyCatalog; Trusted_Connection=True;"
>
> Note that Anonymous Access is off in IIS, and I am able to read my
> Windows login with:
>
> Textbox1.text =
> System.Web.HttpContext.Current.User.Identity.Name.Substring(System.Web.HttpContext.Current.User.Identity.Name.IndexOf("\")
> + 1).ToLower()
>
> Can anyone explain how to query the db using a trusted connection?
>
> PS Is there a way to dynamically retrieve a list of databases the
> current user has SQL rights on, by specifying only the server, again
> using trusted connection?
>
> Thanks...
>

• Next in forum: Re: SQL to calculate surrounding suburbs
• Prev in forum: problem with trusted connection (asp.net)
• Thread view: Re: problem with trusted connection (asp.net)

[Reply to this message]