Copying and Moving SQL Server Logins
Description
The final step in moving and copying SQL Server Databases is to make sure that your Logins are successfully mapped to database users and roles. In this video you'll therefore see what makes this requirement necessary and watch a step-by-step walkthrough of exactly what you need to do to ensure proper mappings between SQL Server Logins and database users and roles.
This Video Covers
Database Management, Logins, Security, Roles and Users.
Details
Length: 09:56
Skill Level: 200 - Intermediate.
Series: Copying and Moving Databases
Author: Michael K. Campbell
Applies to SQL Server: 2000, 2005, and 2008.
Tags: Concepts, Security, Tips and Tricks, and Administration.
Code Download: 7 KB
Video Resources
Video References, Video Transcript, and Accompanying Source Code.
Related Videos
Options for Copying and Moving Databases, Copying and Moving SQL Server Databases, Attaching and Detaching SQL Server Databases, and Understanding Backup Options
Viewer Comments
SQL Server Videos are available free of charge.
But you must agree to the following terms before downloading:
Redistribution is prohibited.
Redistribution via any of the following means is prohibited.
• WebServer/HTTP, FTP,
• YouTube and similar sites,
• BitTorrent,
• CD/DVD, Portable Hard-drive, etc.
I already Agreed to these Terms
Non-registered users must agree to terms upon each new visit to the site.
Registration costs nothing, is painless, and is evil-free™. And SSV will never divulge your personal information to third parties. Ever.
Registered Users
Login Here.
sql15\WebApp still is on the DB SSV_Copy as a User when you run the script for checking the users on the db
after the migration even if you created the login on the server you didn't associated the login with the user
how will this work?