i can't login to sqlserver with a username and a password but works with NT integrated security

hi
i have created a username and a password in sqlserver 2000 from logins in Enterprise manager
and i permit him to the database i need to connect to ..
and i check all server roles for that user and i make sqlserver authentication for him with a password and then i goto the udl file to connect to that database using that user it fails !! and says

"login failed for that user 'myusername' reason not associated with a trusted sqlserver connection"

while i use NT integrated security it works well
so how can i connect to sqlserver using a username and a password

thanks in advance

Hi,

You need to make sure that SQL Server Authentication is set to "SQL Server and Windows Authentication mode". You do this by right clicking on the server name in Management Studio, selecting properties and then clicking on the Security page.

By default SQL Server is installed to use Windows Authentication mode only.

Cheers
Jeff

|||thanks alot man
you are goodsql

i can't login to sqlserver with a username and a password but works with NT integrated secu

hi
i have created a username and a password in sqlserver 2000 from logins in Enterprise manager
and i permit him to the database i need to connect to ..
and i check all server roles for that user and i make sqlserver authentication for him with a password and then i goto the udl file to connect to that database using that user it fails !! and says

"login failed for that user 'myusername' reason not associated with a trusted sqlserver connection"

while i use NT integrated security it works well
so how can i connect to sqlserver using a username and a password

thanks in advance

Hi,

You need to make sure that SQL Server Authentication is set to "SQL Server and Windows Authentication mode". You do this by right clicking on the server name in Management Studio, selecting properties and then clicking on the Security page.

By default SQL Server is installed to use Windows Authentication mode only.

Cheers
Jeff

|||thanks alot man
you are good

I can't add a user in "Security/Logins"

Under Security - Logins, right-click the user and hit properties. (IN
SQL 2000)Go to the database access tab, select the db you want to grant
access to then give the rights below. By default, you only grant
public.
natasha wrote:
> Good morning everyone,
> I've a user listed in "Security/Logins".
> If I right/click a database, Properties, "Permission" tab, I can't "Add" i
t
> to database's "Users or roles": if I "Browse" for users, it isn't listed.
How
> can I add?Yes, and in SQL 2005 "database access" tab has been substituted by "User
mapping" tab. But, owner of the database is dbo, and differently from other
DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
Is there any way to force a "take ownership" of the database?
"PSPDBA" ha scritto:

> Under Security - Logins, right-click the user and hit properties. (IN
> SQL 2000)Go to the database access tab, select the db you want to grant
> access to then give the rights below. By default, you only grant
> public.
> natasha wrote:
>|||Good morning everyone,
I've a user listed in "Security/Logins".
If I right/click a database, Properties, "Permission" tab, I can't "Add" it
to database's "Users or roles": if I "Browse" for users, it isn't listed. Ho
w
can I add?|||Under Security - Logins, right-click the user and hit properties. (IN
SQL 2000)Go to the database access tab, select the db you want to grant
access to then give the rights below. By default, you only grant
public.
natasha wrote:
> Good morning everyone,
> I've a user listed in "Security/Logins".
> If I right/click a database, Properties, "Permission" tab, I can't "Add" i
t
> to database's "Users or roles": if I "Browse" for users, it isn't listed.
How
> can I add?|||Yes, and in SQL 2005 "database access" tab has been substituted by "User
mapping" tab. But, owner of the database is dbo, and differently from other
DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
Is there any way to force a "take ownership" of the database?
"PSPDBA" ha scritto:

> Under Security - Logins, right-click the user and hit properties. (IN
> SQL 2000)Go to the database access tab, select the db you want to grant
> access to then give the rights below. By default, you only grant
> public.
> natasha wrote:
>|||Have you tried using the following stored procedure on the database where yo
u
wnat the user to have access to:
EXEC sp_adduser 'loginname', 'username'
See if that works or give any error?
Lucas
"natasha" wrote:
[vbcol=seagreen]
> Yes, and in SQL 2005 "database access" tab has been substituted by "User
> mapping" tab. But, owner of the database is dbo, and differently from othe
r
> DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> Is there any way to force a "take ownership" of the database?
>
> "PSPDBA" ha scritto:
>|||Have you tried using the following stored procedure on the database where yo
u
wnat the user to have access to:
EXEC sp_adduser 'loginname', 'username'
See if that works or give any error?
Lucas
"natasha" wrote:
[vbcol=seagreen]
> Yes, and in SQL 2005 "database access" tab has been substituted by "User
> mapping" tab. But, owner of the database is dbo, and differently from othe
r
> DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> Is there any way to force a "take ownership" of the database?
>
> "PSPDBA" ha scritto:
>|||I tried to, and I've quite a curious error:
Msg 15063, Level 16, State 1, Line 1
The login already has an account under a different user name.
"Lucas Kartawidjaja" ha scritto:
[vbcol=seagreen]
> Have you tried using the following stored procedure on the database where
you
> wnat the user to have access to:
> EXEC sp_adduser 'loginname', 'username'
> See if that works or give any error?
> Lucas
> "natasha" wrote:
>|||> Is there any way to force a "take ownership" of the database?
sp_changedbowner
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"natasha" <natasha@.discussions.microsoft.com> wrote in message
news:FBFC25FE-C6C8-4B8E-A769-419169EF1DDB@.microsoft.com...[vbcol=seagreen]
> Yes, and in SQL 2005 "database access" tab has been substituted by "User
> mapping" tab. But, owner of the database is dbo, and differently from othe
r
> DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> Is there any way to force a "take ownership" of the database?
>
> "PSPDBA" ha scritto:
>|||I tried to, and I've quite a curious error:
Msg 15063, Level 16, State 1, Line 1
The login already has an account under a different user name.
"Lucas Kartawidjaja" ha scritto:
[vbcol=seagreen]
> Have you tried using the following stored procedure on the database where
you
> wnat the user to have access to:
> EXEC sp_adduser 'loginname', 'username'
> See if that works or give any error?
> Lucas
> "natasha" wrote:
>sql

I can't add a user in "Security/Logins"

Good morning everyone,
I've a user listed in "Security/Logins".
If I right/click a database, Properties, "Permission" tab, I can't "Add" it
to database's "Users or roles": if I "Browse" for users, it isn't listed. How
can I add?Under Security - Logins, right-click the user and hit properties. (IN
SQL 2000)Go to the database access tab, select the db you want to grant
access to then give the rights below. By default, you only grant
public.
natasha wrote:
> Good morning everyone,
> I've a user listed in "Security/Logins".
> If I right/click a database, Properties, "Permission" tab, I can't "Add" it
> to database's "Users or roles": if I "Browse" for users, it isn't listed. How
> can I add?|||Yes, and in SQL 2005 "database access" tab has been substituted by "User
mapping" tab. But, owner of the database is dbo, and differently from other
DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
Is there any way to force a "take ownership" of the database?
"PSPDBA" ha scritto:
> Under Security - Logins, right-click the user and hit properties. (IN
> SQL 2000)Go to the database access tab, select the db you want to grant
> access to then give the rights below. By default, you only grant
> public.
> natasha wrote:
> > Good morning everyone,
> > I've a user listed in "Security/Logins".
> > If I right/click a database, Properties, "Permission" tab, I can't "Add" it
> > to database's "Users or roles": if I "Browse" for users, it isn't listed. How
> > can I add?
>|||Have you tried using the following stored procedure on the database where you
wnat the user to have access to:
EXEC sp_adduser 'loginname', 'username'
See if that works or give any error?
Lucas
"natasha" wrote:
> Yes, and in SQL 2005 "database access" tab has been substituted by "User
> mapping" tab. But, owner of the database is dbo, and differently from other
> DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> Is there any way to force a "take ownership" of the database?
>
> "PSPDBA" ha scritto:
> > Under Security - Logins, right-click the user and hit properties. (IN
> > SQL 2000)Go to the database access tab, select the db you want to grant
> > access to then give the rights below. By default, you only grant
> > public.
> >
> > natasha wrote:
> > > Good morning everyone,
> > > I've a user listed in "Security/Logins".
> > > If I right/click a database, Properties, "Permission" tab, I can't "Add" it
> > > to database's "Users or roles": if I "Browse" for users, it isn't listed. How
> > > can I add?
> >
> >|||I tried to, and I've quite a curious error:
Msg 15063, Level 16, State 1, Line 1
The login already has an account under a different user name.
"Lucas Kartawidjaja" ha scritto:
> Have you tried using the following stored procedure on the database where you
> wnat the user to have access to:
> EXEC sp_adduser 'loginname', 'username'
> See if that works or give any error?
> Lucas
> "natasha" wrote:
> > Yes, and in SQL 2005 "database access" tab has been substituted by "User
> > mapping" tab. But, owner of the database is dbo, and differently from other
> > DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> > Is there any way to force a "take ownership" of the database?
> >
> >
> >
> > "PSPDBA" ha scritto:
> >
> > > Under Security - Logins, right-click the user and hit properties. (IN
> > > SQL 2000)Go to the database access tab, select the db you want to grant
> > > access to then give the rights below. By default, you only grant
> > > public.
> > >
> > > natasha wrote:
> > > > Good morning everyone,
> > > > I've a user listed in "Security/Logins".
> > > > If I right/click a database, Properties, "Permission" tab, I can't "Add" it
> > > > to database's "Users or roles": if I "Browse" for users, it isn't listed. How
> > > > can I add?
> > >
> > >|||> Is there any way to force a "take ownership" of the database?
sp_changedbowner
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"natasha" <natasha@.discussions.microsoft.com> wrote in message
news:FBFC25FE-C6C8-4B8E-A769-419169EF1DDB@.microsoft.com...
> Yes, and in SQL 2005 "database access" tab has been substituted by "User
> mapping" tab. But, owner of the database is dbo, and differently from other
> DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> Is there any way to force a "take ownership" of the database?
>
> "PSPDBA" ha scritto:
>> Under Security - Logins, right-click the user and hit properties. (IN
>> SQL 2000)Go to the database access tab, select the db you want to grant
>> access to then give the rights below. By default, you only grant
>> public.
>> natasha wrote:
>> > Good morning everyone,
>> > I've a user listed in "Security/Logins".
>> > If I right/click a database, Properties, "Permission" tab, I can't "Add" it
>> > to database's "Users or roles": if I "Browse" for users, it isn't listed. How
>> > can I add?
>>|||Hmm... interesting.
I think you might want to try to run the following script on the database
that the user need to access:
EXEC sp_dropuser 'username'
GO
and then run the:
EXEC sp_adduser 'loginname', 'username'
GO
see if that works.
Lucas
"natasha" wrote:
> I tried to, and I've quite a curious error:
> Msg 15063, Level 16, State 1, Line 1
> The login already has an account under a different user name.
>
>
>
> "Lucas Kartawidjaja" ha scritto:
> > Have you tried using the following stored procedure on the database where you
> > wnat the user to have access to:
> > EXEC sp_adduser 'loginname', 'username'
> >
> > See if that works or give any error?
> >
> > Lucas
> >
> > "natasha" wrote:
> >
> > > Yes, and in SQL 2005 "database access" tab has been substituted by "User
> > > mapping" tab. But, owner of the database is dbo, and differently from other
> > > DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> > > Is there any way to force a "take ownership" of the database?
> > >
> > >
> > >
> > > "PSPDBA" ha scritto:
> > >
> > > > Under Security - Logins, right-click the user and hit properties. (IN
> > > > SQL 2000)Go to the database access tab, select the db you want to grant
> > > > access to then give the rights below. By default, you only grant
> > > > public.
> > > >
> > > > natasha wrote:
> > > > > Good morning everyone,
> > > > > I've a user listed in "Security/Logins".
> > > > > If I right/click a database, Properties, "Permission" tab, I can't "Add" it
> > > > > to database's "Users or roles": if I "Browse" for users, it isn't listed. How
> > > > > can I add?
> > > >
> > > >