Updating a User and giveing him access to different db

From: Jerry Medina (jmedina_at_hafresno.org)
Date: 10/29/03 

Date: Wed, 29 Oct 2003 13:18:27 -0800

SQL Server ISSUE.
I ran into an issue at work where:
If I try to give a user access to a different database, a
popup box appears telling me to confirm a new password.
Since I don't want to give the user a new password I have
to cancel.
The way I go around this, is by going to the database I
want the user to be added to and select him from the list
of add new users to database, then I select...for example
if he/she should be dbo. Going to the database and adding
him from there works.
But what happens if I have (for testing purposes) 10
db's. Why should I have to go to each DB and add him
separately to each. I should be able to FROM SECURITY add
him to multiple DB's
Note://this is done with STANDARD EDITION OF SQL SERVER
2000

The other group in our same agency has SQL Server
Enterprise Edition. They do not have the same problem as
I do. They can add a user any which way they can with out
any problems

So this leads me to believe that it's the version of SQL
2000 that I purchased where the problem lies.

Reason I bought Standard - budget only allowed this one.

If you can please help.

Thank you ahead of time.

Jerry Medina

Relevant Pages

  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Word 2003/Access2000/SQLSVR
    ... SQL server being where the data is held and this is accessed through a MS ... entire database and that may be say a record for Berkshire. ... "Peter Jamieson" wrote: ... replaced with the first record on the table in use. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: MS Access DAO -> ADO.NET Migration
    ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS Access DAO -> ADO.NET Migration
    ... For that it is much harder to handle the incremental identifier, ... database but although they have the data, they are not connected at the same ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... SQL Server Management Studio is nowhere to be found on my ...
    (microsoft.public.dotnet.framework.adonet)