Windows security

From: pmcguire (pmcguire_at_discussions.microsoft.com)
Date: 07/16/05

  • Next message: heal my pc!: "Re: Disk level encryption" 
    Date: Fri, 15 Jul 2005 15:18:07 -0700

    I have 2 SQL servers (SQL1 and SQL2) residing on two Windows servers (Win1
    and Win2). I want to back up a database (mydbase) from SQL1 and restore it
    to SQL2. I am using Windows authentication, and I would LIKE to be able to
    do this without rebuilding the User list every time.

    For example, I want mydbowner to have db_owner rights on mydbase on both
    SQL1 and SQL2; Win1/mydbowner and Win2/mydbowner logins exist already, and
    Win1/mydbowner already has db_owner privileges to SQL1.mydbase. When I
    backup and restore, Win1/mydbowner exists as a user on SQL2.mydbase, but of
    course the login doesn't exist on SQL2.

    I guess what I would like to be able to do is create the user Win2/mydbowner
    (and grant it db_owner privileges) on SQL1.mydbase without creating the login
    on SQL1. Can this be done? 

    -- 
Pat
  • Next message: heal my pc!: "Re: Disk level encryption"

    Relevant Pages

    • SQL 2000 transactional replication is generating snapshot every hour
      ... SQL2 subcribed to SQL1, and publisher+distributor for SQL3 ... and at the same time SQL2 is generating a snapshot for every publication it ... 2GB) every hour for every publication. ...
      (microsoft.public.sqlserver.replication)
    • RE: Access to a remote SQL server through ISA server
      ... Make a network trace on both sides (SQL1) and (SQL2). ... Use osql.exe connect to the remote server and execute sp_tables. ...
      (microsoft.public.sqlserver.security)
    • Merge result of two queries?
      ... I need to 'fill in the gaps' in the results of SQL1 - notice that it ... SQL2 returns results for all dates, with a forced count of 0. ... How do I construct a query that would pad gaps in SQL1's results with the ... It has removed 452 spam emails to date. ...
      (comp.databases.oracle.misc)
    • Transactional replication
      ... SQL1 and SQL2 ... These server are windows 2003 and sql 2000 and both located in different ... offices connected by a 100MB WAN link. ...
      (microsoft.public.sqlserver.replication)