cant login

Hi friends
I installed sql2000 dev edition on XP professional.i created a login in
sql.but whenver try to login to sql it says "this login is not associated
with trusted connection" and i cant login!!
am wondering how to fix that.
Thanks
Cheers
cheers
Hi
SQL Server is only setup to be using NT Integrated security.
On the Server Properties page, you can configure SQL Server to be "Mixed
Mode" and restart SQL Server.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"rajani" <rajani@.discussions.microsoft.com> wrote in message
news:B8A81541-B555-430E-8067-4F2C00BB24EE@.microsoft.com...
> Hi friends
> I installed sql2000 dev edition on XP professional.i created a login in
> sql.but whenver try to login to sql it says "this login is not associated
> with trusted connection" and i cant login!!
> am wondering how to fix that.
> Thanks
> Cheers
> --
> cheers
|||Thanks Mike.
i was looking for that option everywhere.
cheers
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> SQL Server is only setup to be using NT Integrated security.
> On the Server Properties page, you can configure SQL Server to be "Mixed
> Mode" and restart SQL Server.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "rajani" <rajani@.discussions.microsoft.com> wrote in message
> news:B8A81541-B555-430E-8067-4F2C00BB24EE@.microsoft.com...
>
>
|||I'm still looking ...can you tell me where you found it? I'm not
sure where the Server Properties page is...
jared
On Sun, 10 Jul 2005 21:25:01 -0700, rajani
<rajani@.discussions.microsoft.com> wrote:

>Thanks Mike.
>i was looking for that option everywhere.
|||Hi jaredea
if u open enterprise manager on left hand side look for ur server name(under
"sql server group")
normally server names (local), server etc.,
right click and properties and go to security tab and you'll find it there.
if u still cant find it then send me ur emailid i will send u screenshot
cheers
"jaredea" wrote:

> I'm still looking ...can you tell me where you found it? I'm not
> sure where the Server Properties page is...
> jared
> On Sun, 10 Jul 2005 21:25:01 -0700, rajani
> <rajani@.discussions.microsoft.com> wrote:
>
>