MSDE - Not associated with a trusted SQL Server connection

I have just installed MSDE on my PC running WinXP Pro. I set it up to use
mixed mode for security mode. However, when I try to log in to the database
using a user account I created I get the following error:
Login Failed for user 'username'. Reason: Not associated with a trusted SQL
server connection.
I am using DbaMgr 2k to view the database settings. I have provided all
admin level access to this user. However, I just cannot login using a
username. I have tried using the sa account to login and I get the same
error. I can only login using a Trusted NT Connection option. Any ideas what
I should try? When I searched it on the web, the only suggestion I can see
is to make sure the security mode is set to mixed mode, which seems to be
correct in this case.
Any help will be appreciated.
DeepaliHi
You don't say how you are trying to connect to the server? Try the following
from a command prompt
osql -S <Servername> -U <username> -P <Password>
John
"Deepali Garg" wrote:

> I have just installed MSDE on my PC running WinXP Pro. I set it up to use
> mixed mode for security mode. However, when I try to log in to the databas
e
> using a user account I created I get the following error:
> Login Failed for user 'username'. Reason: Not associated with a trusted SQ
L
> server connection.
> I am using DbaMgr 2k to view the database settings. I have provided all
> admin level access to this user. However, I just cannot login using a
> username. I have tried using the sa account to login and I get the same
> error. I can only login using a Trusted NT Connection option. Any ideas wh
at
> I should try? When I searched it on the web, the only suggestion I can see
> is to make sure the security mode is set to mixed mode, which seems to be
> correct in this case.
> Any help will be appreciated.
> Deepali
>
>|||SQL will not use the changes until it has been re-started... The error
seems to be saying it will only use trusted connections... perhaps you
simply need to re-start SQL...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Deepali Garg" <dgarg@.bigpond.net.au> wrote in message
news:mycTd.173155$K7.61651@.news-server.bigpond.net.au...
>I have just installed MSDE on my PC running WinXP Pro. I set it up to use
> mixed mode for security mode. However, when I try to log in to the
> database
> using a user account I created I get the following error:
> Login Failed for user 'username'. Reason: Not associated with a trusted
> SQL
> server connection.
> I am using DbaMgr 2k to view the database settings. I have provided all
> admin level access to this user. However, I just cannot login using a
> username. I have tried using the sa account to login and I get the same
> error. I can only login using a Trusted NT Connection option. Any ideas
> what
> I should try? When I searched it on the web, the only suggestion I can see
> is to make sure the security mode is set to mixed mode, which seems to be
> correct in this case.
> Any help will be appreciated.
> Deepali
>|||Wayne,
Thanks for your help. This is exactly what the problem was. As soon as I
restarted the SQL Server everything worked ok!
Deepali
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:eW1ECQnGFHA.3628@.TK2MSFTNGP15.phx.gbl...
> SQL will not use the changes until it has been re-started... The error
> seems to be saying it will only use trusted connections... perhaps you
> simply need to re-start SQL...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Deepali Garg" <dgarg@.bigpond.net.au> wrote in message
> news:mycTd.173155$K7.61651@.news-server.bigpond.net.au...
see[vbcol=seagreen]
be[vbcol=seagreen]
>