add user to database role

Hello,
When i add a user to a database role, enterprise manager
ask me for the user password. I do the same in other
server and and i don't need to give any password.
I've yet the same problem but i cant remember what i've
done to correct this situation.
Best Regards
Hi;
Not sure about this issue. I recommend you to add the server / database
fixed roles
from query analyzer.
For the Server wide roles use :-
sp_addsrvrolemember 'login','sysadmin'
For the Database wide roles use:-
use paytest
go
sp_addrolemember 'db_owner','user'
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:18df601c44c75$c16bd250$a301280a@.phx.gbl...
> Hello,
> When i add a user to a database role, enterprise manager
> ask me for the user password. I do the same in other
> server and and i don't need to give any password.
> I've yet the same problem but i cant remember what i've
> done to correct this situation.
> Best Regards
|||You may be running into the following:
FIX: You Are Prompted for Password Confirmation After You
Change a Standard SQL Server Login
http://support.microsoft.com/?id=826161
-Sue
On Mon, 7 Jun 2004 02:56:51 -0700, "CC&JM"
<anonymous@.discussions.microsoft.com> wrote:

>Hello,
>When i add a user to a database role, enterprise manager
>ask me for the user password. I do the same in other
>server and and i don't need to give any password.
>I've yet the same problem but i cant remember what i've
>done to correct this situation.
>Best Regards
|||Thanks Sue
I apply the patch and now i've got no problem
Thanks again,
bye

>--Original Message--
>You may be running into the following:
>FIX: You Are Prompted for Password Confirmation After You
>Change a Standard SQL Server Login
>http://support.microsoft.com/?id=826161
>-Sue
>On Mon, 7 Jun 2004 02:56:51 -0700, "CC&JM"
><anonymous@.discussions.microsoft.com> wrote:
>
>.
>

add user to database role

Hello,
When i add a user to a database role, enterprise manager
ask me for the user password. I do the same in other
server and and i don't need to give any password.
I've yet the same problem but i cant remember what i've
done to correct this situation.
Best RegardsHi;
Not sure about this issue. I recommend you to add the server / database
fixed roles
from query analyzer.
For the Server wide roles use :-
sp_addsrvrolemember 'login','sysadmin'
For the Database wide roles use:-
use paytest
go
sp_addrolemember 'db_owner','user'
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:18df601c44c75$c16bd250$a301280a@.phx
.gbl...
> Hello,
> When i add a user to a database role, enterprise manager
> ask me for the user password. I do the same in other
> server and and i don't need to give any password.
> I've yet the same problem but i cant remember what i've
> done to correct this situation.
> Best Regards|||You may be running into the following:
FIX: You Are Prompted for Password Confirmation After You
Change a Standard SQL Server Login
http://support.microsoft.com/?id=826161
-Sue
On Mon, 7 Jun 2004 02:56:51 -0700, "CC&JM"
<anonymous@.discussions.microsoft.com> wrote:

>Hello,
>When i add a user to a database role, enterprise manager
>ask me for the user password. I do the same in other
>server and and i don't need to give any password.
>I've yet the same problem but i cant remember what i've
>done to correct this situation.
>Best Regards|||Thanks Sue
I apply the patch and now i've got no problem
Thanks again,
bye

>--Original Message--
>You may be running into the following:
>FIX: You Are Prompted for Password Confirmation After You
>Change a Standard SQL Server Login
>http://support.microsoft.com/?id=826161
>-Sue
>On Mon, 7 Jun 2004 02:56:51 -0700, "CC&JM"
><anonymous@.discussions.microsoft.com> wrote:
>
>.
>

add user to database role

Hello,
When i add a user to a database role, enterprise manager
ask me for the user password. I do the same in other
server and and i don't need to give any password.
I've yet the same problem but i cant remember what i've
done to correct this situation.
Best RegardsHi;
Not sure about this issue. I recommend you to add the server / database
fixed roles
from query analyzer.
For the Server wide roles use :-
sp_addsrvrolemember 'login','sysadmin'
For the Database wide roles use:-
use paytest
go
sp_addrolemember 'db_owner','user'
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:18df601c44c75$c16bd250$a301280a@.phx.gbl...
> Hello,
> When i add a user to a database role, enterprise manager
> ask me for the user password. I do the same in other
> server and and i don't need to give any password.
> I've yet the same problem but i cant remember what i've
> done to correct this situation.
> Best Regards|||You may be running into the following:
FIX: You Are Prompted for Password Confirmation After You
Change a Standard SQL Server Login
http://support.microsoft.com/?id=826161
-Sue
On Mon, 7 Jun 2004 02:56:51 -0700, "CC&JM"
<anonymous@.discussions.microsoft.com> wrote:
>Hello,
>When i add a user to a database role, enterprise manager
>ask me for the user password. I do the same in other
>server and and i don't need to give any password.
>I've yet the same problem but i cant remember what i've
>done to correct this situation.
>Best Regards|||Thanks Sue
I apply the patch and now i've got no problem
Thanks again,
bye
>--Original Message--
>You may be running into the following:
>FIX: You Are Prompted for Password Confirmation After You
>Change a Standard SQL Server Login
>http://support.microsoft.com/?id=826161
>-Sue
>On Mon, 7 Jun 2004 02:56:51 -0700, "CC&JM"
><anonymous@.discussions.microsoft.com> wrote:
>>Hello,
>>When i add a user to a database role, enterprise manager
>>ask me for the user password. I do the same in other
>>server and and i don't need to give any password.
>>I've yet the same problem but i cant remember what i've
>>done to correct this situation.
>>Best Regards
>.
>

add 1000 users...

hi
how can I add 1000 users (user_name, password) from txt, csv file to
aspnetdb.mdf database?
thanks
ereszBCP the data into a table. Then construct an sp_adduser statement for each
row in the table and dynamically execute it. If it is 2005, you would use a
CREATE USER command instead of sp_adduser.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
<eresz@.op.pl> wrote in message
news:1145538712.170169.133870@.j33g2000cwa.googlegroups.com...
> hi
> how can I add 1000 users (user_name, password) from txt, csv file to
> aspnetdb.mdf database?
>
> thanks
> eresz
>|||> If it is 2005, you would use a CREATE USER command instead of sp_adduser.
And if eresz's intent is to add application users, the appropriate aspnetdb
procs are dbo.aspnet_Membership_CreateUser and perhaps
dbo.aspnet_UsersInRoles_AddUsersToRoles.
Hope this helps.
Dan Guzman
SQL Server MVP
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:OwiO$YPZGHA.3400@.TK2MSFTNGP02.phx.gbl...
> BCP the data into a table. Then construct an sp_adduser statement for
> each row in the table and dynamically execute it. If it is 2005, you
> would use a CREATE USER command instead of sp_adduser.
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
>
> <eresz@.op.pl> wrote in message
> news:1145538712.170169.133870@.j33g2000cwa.googlegroups.com...
>

AD synchronization interval with SQL Server

Hi. Please help.
Background:
A user changes their Active Directory windows password on logon and then
attempts to connect to SQL Server but fails. Once a manual synchronisation o
f
the windows accounts on SQL server are done then the user can authenticate
again.
Question:
How long does AD take to auto synchronise with SQL (or vice versa)? Can this
value be changed? How?
Many thanksMorne wrote:

> Background:
> A user changes their Active Directory windows password on logon and then
> attempts to connect to SQL Server but fails. Once a manual synchronisation
> of
> the windows accounts on SQL server are done then the user can authenticate
> again.
> Question:
> How long does AD take to auto synchronise with SQL (or vice versa)? Can
> this
> value be changed? How?
I believe the delay is due to AD replication. The DC that SQL Server used
for authentication must not have been the DC the user authenticated to and
the new password had not yet replicated. Perhaps the SQL Server is in
another site. I don't know of a solution, other than to force replication,
perhaps with the repadmin utility on the DC (which is not of help to the
user).
Richard Mueller
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net
--|||Thanks Richard
I'll look into it. Appreciated.
Morne
"Richard Mueller [MVP]" wrote:

> Morne wrote:
>
> I believe the delay is due to AD replication. The DC that SQL Server used
> for authentication must not have been the DC the user authenticated to and
> the new password had not yet replicated. Perhaps the SQL Server is in
> another site. I don't know of a solution, other than to force replication,
> perhaps with the repadmin utility on the DC (which is not of help to the
> user).
> --
> Richard Mueller
> Microsoft MVP Scripting and ADSI
> Hilltop Lab - http://www.rlmueller.net
> --
>
>

AD password & SQL database syncronisation

Hi Fred
"Fred" wrote:

> Hi, my company currently runs a native domain, and within the domain, a
> corporate SQL database.
> At the moment i need to add new users to the AD infrastructure, and then to
> the SQL database.
> is there anyway i can link the SQL table containing u/names & passwords to
> AD, so i do not need to keep updating both?
> TIA
>
You would be better adding the users to a AD group and then giving that
group access to SQL Server, then all the admin of adding users is done in the
AD.
John
Fred wrote:
> Many thanks for the reply,
> i may have not myself clear, but the users credentials are currently
> stored within the SQL database and also obviously in AD.
> I'm looking to get AD to populate whats in the SQL database automaticaly.
>
Hi Fred,
I think you need to read up on Security in SQL Server. In SQL Server you
can use Windows authentication and/or SQL Server authentication.
SQL Server authentication means that the loginname/userid (and password)
ONLY exists in SQL server and has nothing to do with your AD.
Windows authentication means that you give an Active Directoy userid
access to you SQL server databases. This can be done either via group
memberships as suggested by John or you can give single users various
rights in SQL Server. If you give access based on AD groups, you can
don't have to go to the SQL server to assign rights, but you can do it
directly from the AD gui. This will of course require that you can
define some general rights for a group of users.
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
|||Hi
"Fred" wrote:

> Many thanks for the reply,
> i may have not myself clear, but the users credentials are currently stored
> within the SQL database and also obviously in AD.
> I'm looking to get AD to populate whats in the SQL database automaticaly.
>
As Steen points out this should not be necessary for logins, but if a list
is needed for some other reason you can query AD through an ADSI linked
server see
http://msdn2.microsoft.com/en-us/library/aa772170.aspx
http://msdn2.microsoft.com/en-us/library/aa746379.aspx
or through a scripting such as http://support.microsoft.com/kb/319716
John

AD password & SQL database syncronisation

Hi, my company currently runs a native domain, and within the domain, a
corporate SQL database.
At the moment i need to add new users to the AD infrastructure, and then to
the SQL database.
is there anyway i can link the SQL table containing u/names & passwords to
AD, so i do not need to keep updating both?
TIAHi Fred
"Fred" wrote:

> Hi, my company currently runs a native domain, and within the domain, a
> corporate SQL database.
> At the moment i need to add new users to the AD infrastructure, and then t
o
> the SQL database.
> is there anyway i can link the SQL table containing u/names & passwords to
> AD, so i do not need to keep updating both?
> TIA
>
You would be better adding the users to a AD group and then giving that
group access to SQL Server, then all the admin of adding users is done in th
e
AD.
John|||Many thanks for the reply,
i may have not myself clear, but the users credentials are currently stored
within the SQL database and also obviously in AD.
I'm looking to get AD to populate whats in the SQL database automaticaly.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:056B6E3C-3AF7-46E3-9BD5-4E0B2318EC7A@.microsoft.com...
> Hi Fred
> "Fred" wrote:
>
> You would be better adding the users to a AD group and then giving that
> group access to SQL Server, then all the admin of adding users is done in
> the
> AD.
> John|||Fred wrote:
> Many thanks for the reply,
> i may have not myself clear, but the users credentials are currently
> stored within the SQL database and also obviously in AD.
> I'm looking to get AD to populate whats in the SQL database automaticaly.
>
Hi Fred,
I think you need to read up on Security in SQL Server. In SQL Server you
can use Windows authentication and/or SQL Server authentication.
SQL Server authentication means that the loginname/userid (and password)
ONLY exists in SQL server and has nothing to do with your AD.
Windows authentication means that you give an Active Directoy userid
access to you SQL server databases. This can be done either via group
memberships as suggested by John or you can give single users various
rights in SQL Server. If you give access based on AD groups, you can
don't have to go to the SQL server to assign rights, but you can do it
directly from the AD gui. This will of course require that you can
define some general rights for a group of users.
Regards
Steen Schlüter Persson
Database Administrator / System Administrator|||Hi
"Fred" wrote:

> Many thanks for the reply,
> i may have not myself clear, but the users credentials are currently stor
ed
> within the SQL database and also obviously in AD.
> I'm looking to get AD to populate whats in the SQL database automaticaly.
>
As Steen points out this should not be necessary for logins, but if a list
is needed for some other reason you can query AD through an ADSI linked
server see
http://msdn2.microsoft.com/en-us/library/aa772170.aspx
http://msdn2.microsoft.com/en-us/library/aa746379.aspx
or through a scripting such as http://support.microsoft.com/kb/319716
John|||Many thanks for your input guys,
i'll start reading up on this through your links etc.
Cheers
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:29C53C3C-41EF-4C6C-A9F8-F4783BE4E9F1@.microsoft.com...
> Hi
> "Fred" wrote:
>
> As Steen points out this should not be necessary for logins, but if a list
> is needed for some other reason you can query AD through an ADSI linked
> server see
> http://msdn2.microsoft.com/en-us/library/aa772170.aspx
> http://msdn2.microsoft.com/en-us/library/aa746379.aspx
> or through a scripting such as http://support.microsoft.com/kb/319716
> John

AD password & SQL database syncronisation

Hi, my company currently runs a native domain, and within the domain, a
corporate SQL database.
At the moment i need to add new users to the AD infrastructure, and then to
the SQL database.
is there anyway i can link the SQL table containing u/names & passwords to
AD, so i do not need to keep updating both?
TIAHi Fred
"Fred" wrote:
> Hi, my company currently runs a native domain, and within the domain, a
> corporate SQL database.
> At the moment i need to add new users to the AD infrastructure, and then to
> the SQL database.
> is there anyway i can link the SQL table containing u/names & passwords to
> AD, so i do not need to keep updating both?
> TIA
>
You would be better adding the users to a AD group and then giving that
group access to SQL Server, then all the admin of adding users is done in the
AD.
John|||Many thanks for the reply,
i may have not myself clear, but the users credentials are currently stored
within the SQL database and also obviously in AD.
I'm looking to get AD to populate whats in the SQL database automaticaly.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:056B6E3C-3AF7-46E3-9BD5-4E0B2318EC7A@.microsoft.com...
> Hi Fred
> "Fred" wrote:
>> Hi, my company currently runs a native domain, and within the domain, a
>> corporate SQL database.
>> At the moment i need to add new users to the AD infrastructure, and then
>> to
>> the SQL database.
>> is there anyway i can link the SQL table containing u/names & passwords
>> to
>> AD, so i do not need to keep updating both?
>> TIA
> You would be better adding the users to a AD group and then giving that
> group access to SQL Server, then all the admin of adding users is done in
> the
> AD.
> John|||Fred wrote:
> Many thanks for the reply,
> i may have not myself clear, but the users credentials are currently
> stored within the SQL database and also obviously in AD.
> I'm looking to get AD to populate whats in the SQL database automaticaly.
>
Hi Fred,
I think you need to read up on Security in SQL Server. In SQL Server you
can use Windows authentication and/or SQL Server authentication.
SQL Server authentication means that the loginname/userid (and password)
ONLY exists in SQL server and has nothing to do with your AD.
Windows authentication means that you give an Active Directoy userid
access to you SQL server databases. This can be done either via group
memberships as suggested by John or you can give single users various
rights in SQL Server. If you give access based on AD groups, you can
don't have to go to the SQL server to assign rights, but you can do it
directly from the AD gui. This will of course require that you can
define some general rights for a group of users.
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator|||Hi
"Fred" wrote:
> Many thanks for the reply,
> i may have not myself clear, but the users credentials are currently stored
> within the SQL database and also obviously in AD.
> I'm looking to get AD to populate whats in the SQL database automaticaly.
>
As Steen points out this should not be necessary for logins, but if a list
is needed for some other reason you can query AD through an ADSI linked
server see
http://msdn2.microsoft.com/en-us/library/aa772170.aspx
http://msdn2.microsoft.com/en-us/library/aa746379.aspx
or through a scripting such as http://support.microsoft.com/kb/319716
John|||Many thanks for your input guys,
i'll start reading up on this through your links etc.
Cheers
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:29C53C3C-41EF-4C6C-A9F8-F4783BE4E9F1@.microsoft.com...
> Hi
> "Fred" wrote:
>> Many thanks for the reply,
>> i may have not myself clear, but the users credentials are currently
>> stored
>> within the SQL database and also obviously in AD.
>> I'm looking to get AD to populate whats in the SQL database automaticaly.
> As Steen points out this should not be necessary for logins, but if a list
> is needed for some other reason you can query AD through an ADSI linked
> server see
> http://msdn2.microsoft.com/en-us/library/aa772170.aspx
> http://msdn2.microsoft.com/en-us/library/aa746379.aspx
> or through a scripting such as http://support.microsoft.com/kb/319716
> John

Activity Captured by profiler

Hi
Does the profiler catch every activity on the server. I mean what about
the various username & password screens , dont you think then its a
threat to security .
& I wanted to knw how to get the last 10 SQL Statments issued by the
users client to the SQL Server.
dbcc inputbuffer (spid) gives us the last statement how to get a
history of statments by a SPID.
Thanks
Hi
Profiler will not display sensitive data such as passwords etc. If you are
worried about passwords and usernames you should also use protocol encryption
between client and server.
You can use a filter in profiler to restict information display to a given
SPID or use the search options to jump between entries for a given SPID.
John
"Double_B" wrote:

> Hi
> Does the profiler catch every activity on the server. I mean what about
> the various username & password screens , dont you think then its a
> threat to security .
> & I wanted to knw how to get the last 10 SQL Statments issued by the
> users client to the SQL Server.
> dbcc inputbuffer (spid) gives us the last statement how to get a
> history of statments by a SPID.
>
> Thanks
>

Activity Captured by profiler

Hi
Does the profiler catch every activity on the server. I mean what about
the various username & password screens , dont you think then its a
threat to security .
& I wanted to knw how to get the last 10 SQL Statments issued by the
users client to the SQL Server.
dbcc inputbuffer (spid) gives us the last statement how to get a
history of statments by a SPID.
ThanksHi
Profiler will not display sensitive data such as passwords etc. If you are
worried about passwords and usernames you should also use protocol encryptio
n
between client and server.
You can use a filter in profiler to restict information display to a given
SPID or use the search options to jump between entries for a given SPID.
John
"Double_B" wrote:

> Hi
> Does the profiler catch every activity on the server. I mean what about
> the various username & password screens , dont you think then its a
> threat to security .
> & I wanted to knw how to get the last 10 SQL Statments issued by the
> users client to the SQL Server.
> dbcc inputbuffer (spid) gives us the last statement how to get a
> history of statments by a SPID.
>
> Thanks
>

Activity Captured by profiler

Hi
Does the profiler catch every activity on the server. I mean what about
the various username & password screens , dont you think then its a
threat to security .
& I wanted to knw how to get the last 10 SQL Statments issued by the
users client to the SQL Server.
dbcc inputbuffer (spid) gives us the last statement how to get a
history of statments by a SPID.
ThanksHi
Profiler will not display sensitive data such as passwords etc. If you are
worried about passwords and usernames you should also use protocol encryption
between client and server.
You can use a filter in profiler to restict information display to a given
SPID or use the search options to jump between entries for a given SPID.
John
"Double_B" wrote:
> Hi
> Does the profiler catch every activity on the server. I mean what about
> the various username & password screens , dont you think then its a
> threat to security .
> & I wanted to knw how to get the last 10 SQL Statments issued by the
> users client to the SQL Server.
> dbcc inputbuffer (spid) gives us the last statement how to get a
> history of statments by a SPID.
>
> Thanks
>