SQL Server Performance

window logins orpahned?

Discussion in 'SQL Server 2005 General DBA Questions' started by varun_3g, Jun 30, 2008.

  1. varun_3g New Member

    is microsoft script usefu lfor windows login transfers too when i move database from one machine to another, as the window SID's on the new machine would be different, and i have huge number of windows logins in my database.
  2. moh_hassan20 New Member

    Is your sql server member of domain or workgroup?
  3. varun_3g New Member

    is member of domain
  4. moh_hassan20 New Member

    window SID is the same , as your accounts are in the domain.
    You need only to add these accounts into the new server.
    You can generate scripts from old SQL server for these windows logins , and run it in the new SQL server.
  5. varun_3g New Member

    thanks hassan
    and i also want to know what if the servers are in the workgroup
  6. moh_hassan20 New Member

    when server is in workgroup we use sql authentication (not windows ), because there is not centralized security accounts .
  7. varun_3g New Member

    thanks alot hassan
  8. moh_hassan20 New Member

    Here is a trick method for Connecting to SQL Server from a workgroup using Windows Authentication
    check: http://blogs.msdn.com/sql_protocols/default.aspx?p=2
    Take into account effort and in consistency , in case changing password.
  9. satya Moderator

Share This Page