> Andrew,
>
> Here is link to the article about troubleshooting connectivity issues:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;827422.
>
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
> "Andrew Chalk" <achalk@XXXmagnacartasoftware.com> wrote in message
> news:eVdbwXjsEHA.2808@TK2MSFTNGP14.phx.gbl...
> > I have created a user (calladmin2) of a database in SQL Server
Enterprise
> > Manager. When I load SQL Query Analyzer and attempt to File->Connect
using
> > this user name I get:
> >
> > Msg. 18452, Level 16, State 1
> >
> > Login failed for user 'calladmin2'. reason: Not associated with a
trusted
> > SQL Server connection.
> >
> > It appears that I cannot connect to this instance of SQL Server, and am
> not
> > even getting to the single database to which I gave this new user access
> > rights. Is this correct?
> >
> > How do I create the 'trusted SQL Server connection' that SQL Server
wants
> > for this new user calladmin2?
> >
> > Many thanks.
> >
> >
>
>

"Andrew Chalk" <achalk@XXXmagnacartasoftware.com> wrote in message
news:eVdbwXjsEHA.2808@TK2MSFTNGP14.phx.gbl...
> I have created a user (calladmin2) of a database in SQL Server Enterprise
> Manager. When I load SQL Query Analyzer and attempt to File->Connect using
> this user name I get:
>
> Msg. 18452, Level 16, State 1
>
> Login failed for user 'calladmin2'. reason: Not associated with a trusted
> SQL Server connection.
>
> It appears that I cannot connect to this instance of SQL Server, and am
not
> even getting to the single database to which I gave this new user access
> rights. Is this correct?
>
> How do I create the 'trusted SQL Server connection' that SQL Server wants
> for this new user calladmin2?
>
> Many thanks.
>
>