sql server - change user database access

From: Kazuya (independersday_at_hotmail.com)
Date: 07/24/04

  • Next message: Jasper Smith: "Re: sql server - change user database access" 
    Date: 24 Jul 2004 04:15:20 -0700

    I use ms sql server, when I edit the properties of a sql user I can
    assign databases to the account with the list in the 3rd screen of the
    properties.

    When I add some checks in front of a couple of databases and I click
    OK sql server asks me to confirm the password. I don't know what
    password to use at that point, cause I used the password of the
    account itself and of the admins and it still tells me that the
    password is not correct.

    Anyone?

  • Next message: Jasper Smith: "Re: sql server - change user database access"

    Relevant Pages

    • Re: Joining tables from two databases
      ... Hitchhiker's Guide to Visual Studio and SQL Server ... account with rights to both tables. ... to create a connection I need to use a connection ... Are these 2 databases are SQL Server? ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Databases connections not working more with all web sites
      ... First check for permission problems. ... account for one of the sites with a problem to an account with administrator ... > Databases connections, both, for MS SQL Server 2000 and MS Access ...
      (microsoft.public.inetserver.asp.db)
    • Re: Joining tables from two databases
      ... This posting is provided "AS IS" with no warranties, and confers no rights. ... Hitchhiker's Guide to Visual Studio and SQL Server ... I'm not really following how you are solving it using a service account. ... Are these 2 databases are SQL Server? ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: public role???
      ... The guest user account cannot be removed from ... > databases, but not ... then that's the way SQL Server ...
      (microsoft.public.sqlserver.security)
    • Re: DBO Best Practices
      ... databases are owned by the sa account. ... Columnist, SQL Server Professional ... Could some please tell we the best practices for the dbo user. ...
      (microsoft.public.sqlserver.security)