SQL 2005: SQL Server Integration Services
Transfer Logins Task
By: Zack Turnbow
Introduction
In the previous article, database maintenance tasks were introduced. The first maintenance task was the Transfer Database Task which is the most common maintenance task. The next task and last maintenance task to be covered is the Transfer Logins Task which closely resembles and operates much like the Transfer Database Task.
We are using Server Intellect and have found that by far, they are the most friendly, responsive, and knowledgeable support team we've ever dealt with!
Scenario
Last time a database was being moved to a new server, so in this article the scenario will be moving database logins to an existing SQL server. There are several reasons just to move or copy the database logins. The most common reason would be to better maintain each SQL server instance especially if the server architecture calls for the same roles on each instance. Also, one other benefit of using this task is to make sure the SIDs are all the same in each instance which solves the issue of manually creating the logins on each instance but having different SIDs.
Implementation
As with the previous article, a blank package will be needed to complete this task so create a new package and give it an intuitive name. Find the Transfer Logins Task in the toolbox and drag it into the work area.
[Click to enlarge]
Double click the component to open the configuration window. Next click on the Logins tab to see what needs to be configured.
[Click to enlarge]
Yes, it is possible to find a good web host. Sometimes it takes a while. After trying several, we went with Server Intellect and have been very happy. They are the most professional, customer service friendly and technically knowledgeable host we've found so far.
Like the previous article in the Connections table, create a new SourceConnection and a DestinationConnection to the appropriate SQL server instances. From here, there are two available options on what logins to transfer, one being transfer selected logins and the other being transfer all logins for a particular database. By default, the SelectedLogins option is selected. For this article, leave the option as default. Since the SelectedLogins option is chosen, click in the LoginsList box to open up a configuration window to select which logins need to be transferred.
[Click to enlarge]
Please note that when selecting the logins manually or selecting all logins from a database that the database the logins belongs to needs to be present on the destination SQL server instance. Otherwise an error will occur when the package is executed. Once the logins are selected, click OK. In the Options table the two available options is what to do if the login object already exists in the destination SQL server instance and whether to copy the SIDs of the login object. Since there is a need to make sure the logins are the same from one instance to another, the IfObjectExists option is set to Overwrite and the CopySids option is set to True.
[Click to enlarge]
We chose Server Intellect for its dedicated servers, for our web hosting. They have managed to handle virtually everything for us, from start to finish. And their customer service is stellar.
Once this is completed, click OK.
Testing the Package
It is time to test the package since everything to transfer logins is contained in this one component. Execute the package to transfer the selected logins.
[Click to enlarge]
When the package has completed running, open up SQL Management Studio to double check that the logins were transferred successfully.
[Click to enlarge]
What have we learned?
We migrated our web sites to Server Intellect over one weekend and the setup was so smooth that we were up and running right away. They assisted us with everything we needed to do for all of our applications. With Server Intellect's help, we were able to avoid any headaches!
How to configure a Transfer Logins Task.
The different uses for transferring database logins.
What the different transfer options are available whether it is Selected Logins or All Selected Database Logins.
Attachments
Leave a Comment
#1 poker hand rankings
Posted By: poker hand rankings | 3.31.2009 at 4:13 AM
The first maintenance task was the Transfer Database Task which is the most common maintenance task. The next task and last maintenance task to be covered is the Transfer Log ins Task which closely resembles and operates much like the Transfer Database Task.There are several reasons just to move or copy the database log ins. The most common reason would be to better maintain each SQL server instance especially if the server architecture calls for the same roles on each instance.the database the log ins belongs to needs to be present on the destination SQL server instance. Otherwise an error will occur when the package is executed. Once the log ins are selected, click OK. In the Options table the two available options is what to do if the log in object already exists in the destination SQL server instance and whether to copy the SIDS of the log in object.i found this informative and interesting blog so i think so its very useful and knowledge able.so it is great usability and good for us.
#2 flash game
Posted By: flash game | 3.07.2010 at 3:37 AM
Easily, the post is actually the greatest on this laudable subject. I fit in with your conclusions and will thirstily look forward to your upcoming updates. Just saying tnx will not just be sufficient, for the phenomenal clarity in your writing. I will instantly grab your rss feeds to stay informed of any updates. Authentic work and much success in your business efforts! Have a nice day, Vinay!
#3 350-030
Posted By: 350-030 | 3.19.2010 at 5:33 AM
For all I know this could be a really old entry, since there are no date marker on the article. In that case I apologize.
#4 wholesale laptop adapter
Posted By: wholesale laptop adapter | 5.21.2010 at 1:58 AM
base maintenance tasks were introduced. The first maintenance task was the Transfer Database Task which is the most common maintenance task. The next task and last maintenance task to be covered is the Trans
#5 air max shoes
Posted By: air max shoes | 5.23.2010 at 4:57 AM
nike air max sale
#6 wholesale shoes
Posted By: wholesale shoes | 5.24.2010 at 3:28 AM
Spring summer pocket perfect supporting role (figure) except heart shape brooch, earring, necklace,
#7 fire equipment
Posted By: fire equipment | 6.01.2010 at 5:52 AM
Wish I have the luxury of time to consider using the benefits these site can offer.....
#8 womens mbt shoes
Posted By: womens mbt shoes | 6.11.2010 at 3:58 AM
An excellent resource of information I will certainly return to check on the latest posts.
#9 coach purses
Posted By: coach purses | 6.12.2010 at 12:52 AM
you really have avery nice site,it's the first time to be here but it won't be the last untill then keep blogging..goodluck!
#10 michael jordan shoes
Posted By: michael jordan shoes | 6.18.2010 at 8:52 PM
good post!!thank you
#11 Bar Cocktail Shakers
Posted By: Bar Cocktail Shakers | 6.22.2010 at 2:51 AM
Fantastic site, where did you come up with the information in this piece of content? I’m happy I found it though, ill be checking back soon to see what other articles you have.
#12 dizi izle
Posted By: dizi izle | 6.22.2010 at 7:16 AM
Super-Duper site! I am loving it!! Will come back again - taking you feeds also, Thanks.
#13 integration services transfer
Posted By: integration services transfer | 7.08.2010 at 7:02 PM
I am new reader of your site but one thing i realize one thing that the way you plot the matter in your post that is amazing i am appreciating that. Add me a feedback reader.
Keep it up.
#14 chanel bagsbags
Posted By: chanel bagsbags | 7.18.2010 at 11:12 PM
I am really interested in this program but I do not know much about it. After reading your article, i have more experiences to work with it. Your post is interesting and picturesque. I hope i can get your post in next time. Keep on!
#15 chanel sunglasses
Posted By: chanel sunglasses | 7.18.2010 at 11:12 PM
I am really interested in this program but I do not know much about it. After reading your article, i have more experiences to work with it. Your post is interesting and picturesque. I hope i can get your post in next time. Keep on!
#16 louis vuitton bag
Posted By: louis vuitton bag | 7.18.2010 at 11:12 PM
I am really interested in this program but I do not know much about it. After reading your article, i have more experiences to work with it. Your post is interesting and picturesque. I hope i can get your post in next time. Keep on!
#17 louis vuitton handbag
Posted By: louis vuitton handbag | 7.18.2010 at 11:12 PM
I am really interested in this program but I do not know much about it. After reading your article, i have more experiences to work with it. Your post is interesting and picturesque. I hope i can get your post in next time. Keep on!
#18 rayban sunglasses
Posted By: rayban sunglasses | 7.18.2010 at 11:12 PM
I am really interested in this program but I do not know much about it. After reading your article, i have more experiences to work with it. Your post is interesting and picturesque. I hope i can get your post in next time. Keep on!
#19 tiffany jewelry
Posted By: tiffany jewelry | 7.18.2010 at 11:13 PM
I am really interested in this program but I do not know much about it. After reading your article, i have more experiences to work with it. Your post is interesting and picturesque. I hope i can get your post in next time. Keep on!
#20 tiffany and co
Posted By: tiffany and co | 7.18.2010 at 11:13 PM
I am really interested in this program but I do not know much about it. After reading your article, i have more experiences to work with it. Your post is interesting and picturesque. I hope i can get your post in next time. Keep on!
#21 tiffany co
Posted By: tiffany co | 7.21.2010 at 2:22 AM
For classic and quality genuine silver jewelry, many people choose Tiffany & Co brand.Now,we present you the hottest Tiffany silver jewelry .get more http://www.tiffanyonsale.com/
#22 tiffany jewelry
Posted By: tiffany jewelry | 7.21.2010 at 2:22 AM
For classic and quality genuine silver jewelry, many people choose Tiffany & Co brand.Now,we present you the hottest Tiffany silver jewelry .get more http://www.tiffanyonsale.com/
#23 tiffany jewellery
Posted By: tiffany jewellery | 7.21.2010 at 2:22 AM
For classic and quality genuine silver jewelry, many people choose Tiffany & Co brand.Now,we present you the hottest Tiffany silver jewelry .get more http://www.tiffanyonsale.com/
#24 tiffany ring
Posted By: tiffany ring | 7.26.2010 at 6:49 AM
Tiffany On Sale Offer a wide range of fashionable Tiffany & Co silver jewelry, including Necklaces, Pendants, Bracelets, Earrings, Rings and Accessories with fantastic discount.more http://www.tiffanyonsale.com/
#25 tiffany bracelet
Posted By: tiffany bracelet | 7.26.2010 at 6:49 AM
Tiffany On Sale Offer a wide range of fashionable Tiffany & Co silver jewelry, including Necklaces, Pendants, Bracelets, Earrings, Rings and Accessories with fantastic discount.more http://www.tiffanyonsale.com/
#26 tiffany necklace
Posted By: tiffany necklace | 7.26.2010 at 6:49 AM
Tiffany On Sale Offer a wide range of fashionable Tiffany & Co silver jewelry, including Necklaces, Pendants, Bracelets, Earrings, Rings and Accessories with fantastic discount.more http://www.tiffanyonsale.com/