Re: Associating a Windows account with a user

From: Juan Dent (JuanDent_at_discussions.microsoft.com)
Date: 07/06/04 

Date: Tue, 6 Jul 2004 13:24:01 -0700

Actually what I have is a database with three users but only one of them is associated with a Windows account.

Looking in SQLSErver Enterprise Manager, in the Users folder of the database, it looks something like this:

dbo DENTDEVELOPMENT\JuanDent
isadmin
isuser

See? What I want is to associate the login above with isadmin as well as dbo.
Is that possible? 

-- 
Thanks in advance,
Juan Dent, M.Sc.
"Narayana Vyas Kondreddi" wrote:
> Is this the case of an orphanned user, due to moving the db from one domain
> to another or something? There is a procedure called sp_change_users_login,
> but that will not work with Windows accounts.
> 
> Can you simply grant access to that Windows login to SQL Server using
> sp_grantlogin, and add associated user in the database using
> sp_grantdbaccess? You'll have to apply the permissions manually though.
> -- 
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> 
> 
> "Juan Dent" <JuanDent@discussions.microsoft.com> wrote in message
> news:5AF26949-D98D-4F0A-9F6E-2DF92469E88C@microsoft.com...
> > Hi,
> >
> > I need to associate an existing Windows account with an existing SQL
> Server 2000 user, but have not found the stored procedure for this.
> >
> > Can somebody guide me on this please?
> >
> > -- 
> > Thanks in advance,
> >
> > Juan Dent, M.Sc.
> 
> 
>

Relevant Pages

  • asp.net 2.0 login control
    ... A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.] ... These problems left me stranded for days, then today, on another machine, I hit a different set of problems I kept getting the following "Failed to generate user instance of SQL Server due to a failure in starting the process for the user instance. ... (Basically this is a new option in the connection string that allows you to point out where the ..mdf file resides eliminating the need to create database in some SQL instance.) ... Beware that the windows account of the user that first creates the connection in this databaseless manner, becomes exclusive user for this file and no other windows account will be able to create a connection to this file. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Help with database transfer
    ... your windows account is an admin on the sql server then i'd say the problem ... > reads the test connection to the database has failed. ... > forum of the ecommerce package, they said to check SQL permissions....which ...
    (microsoft.public.sqlserver.server)
  • Re: Error: SQL Server does not exist or access denied
    ... > "Patrice" wrote in message ... >> Data Source is the server name, the database name goes in Initial ... >> AFAIK when using a Windows account, ... >>> I am updating a project from Access to run on our SQL Server DB. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: via group membership
    ... were given access to the database. ... a Windows account and haven't granted that account access to ... even though they don't have a login set up on the server. ...
    (microsoft.public.sqlserver.security)
  • connection options to yukon
    ... 2005 database and make best use of connection pooling. ... CONS ... Domain Level Windows Account ... No need for application to store password ...
    (microsoft.public.dotnet.framework.adonet)
Loading