|
 |
aspx thread: [OOT} MSSQL2000
Message #1 by "My" <bjs52@t...> on Sun, 31 Oct 2010 08:58:51 +0700
|
|
Hallo all,
I have a problem with MSSQL2000, I'm using winXP prof.
The problem is, I cann't login with "sa" or other username I have ever made,
but its working if I'm using
windows authentication mode. If I'm login with "sa" or other username this
message shown "unable to connect to server localhost ... Reason : Not
associated with a trusted SQL Server Connection".
would you like tell me, what should I do ?
T.I.A
----------------------------------------------------------------------------
Ikuti polling TELKOM Memo 166 di www.plasa.com dan menangkan hadiah masing-masing Rp 250.000 tunai
----------------------------------------------------------------------------
Message #2 by "Bernie Yaeger" <berniey@c...> on Tue, 26 Nov 2002 23:37:02 -0500
|
|
Hi,
I had the same problem and eventually figured it out, so I wrote this note
to myself:
(I'm also connecting to sql server 2000 on xp pro)
Remember this for the future: the reason a login/pwd didn't connect is
simply because the server's authentication was set to windows only; right
click the server (has green arrow) in enterprise manager; properties;
security; change authentication to sql server and windows (will require you
close and reopen sql server); now all of the appropriate logins will
connect;
HTH,
Bernie Yaeger
----- Original Message -----
From: "My" <bjs52@t...>
To: "ASP.NET" <aspx@p...>
Sent: Saturday, October 30, 2010 8:58 PM
Subject: [aspx] [OOT} MSSQL2000
> Hallo all,
>
> I have a problem with MSSQL2000, I'm using winXP prof.
> The problem is, I cann't login with "sa" or other username I have ever
made,
> but its working if I'm using
> windows authentication mode. If I'm login with "sa" or other username this
> message shown "unable to connect to server localhost ... Reason : Not
> associated with a trusted SQL Server Connection".
>
> would you like tell me, what should I do ?
>
>
> T.I.A
>
>
>
> --------------------------------------------------------------------------
--
>
> Ikuti polling TELKOM Memo 166 di www.plasa.com dan menangkan hadiah
masing-masing Rp 250.000 tunai
>
> -------------------------------------------------------------------------
---
>
>
Message #3 by "yohohuangtao0425" <yohohuangtao0425@s...> on Wed, 27 Nov 2002 12:38:56 -0800
|
|
you MSSQL maybe to become void.
i think you maybe reinstall it.
Hallo all,
I have a problem with MSSQL2000, I'm using winXP prof.
The problem is, I cann't login with "sa" or other username I have ever made,
but its working if I'm using
windows authentication mode. If I'm login with "sa" or other username this
message shown "unable to connect to server localhost ... Reason : Not
associated with a trusted SQL Server Connection".
would you like tell me, what should I do ?
T.I.A
----------------------------------------------------------------------------
Ikuti polling TELKOM Memo 166 di www.plasa.com dan menangkan hadiah masing-masing Rp 250.000 tunai
----------------------------------------------------------------------------
Message #4 by "Ken Schaefer" <ken@a...> on Wed, 27 Nov 2002 18:07:18 +1100
|
|
By default SQL Server 2000 installs in Windows Authentication mode only. You
can change this in Enterprise Manager if you really want (though I recommend
using Windows Authentication)
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "My" <bjs52@t...>
Subject: [aspx] [OOT} MSSQL2000
: Hallo all,
:
: I have a problem with MSSQL2000, I'm using winXP prof.
: The problem is, I cann't login with "sa" or other username I have ever
made,
: but its working if I'm using
: windows authentication mode. If I'm login with "sa" or other username this
: message shown "unable to connect to server localhost ... Reason : Not
: associated with a trusted SQL Server Connection".
:
: would you like tell me, what should I do ?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|
|
View Cart
