Migrating SQL logins

Finance and Operations/AX General discussions
1

You administer a Microsoft SQL Server 2012 instance named SQL2012. You are in the

process of migrating a database from a SQL Server 2008 instance named SQL2008 to the

SQL2012 instance.

You have upgraded a database from the SQL2008 instance by using the side-by-side

migration technique.

You need to migrate the SQL Server logins from the SQL2008 instance to the SQL2012

instance.

What should you do?

A. Back up the master database on the SQL2008 instance. Restore the master database

on the SQL2012 instance.

B. Use the Transfer Logins task in a Microsoft SQL Server Integrated Services package.

C. Use sp_grantlogin.

D. Use xp_logininfo.

I am sure c and D is not the right answer

2

This is a forum about Dynamics AX, not SQL Server. Also, may I ask you to name threads according to the topic, not “Answer Required ASAP”?

By the way, if you tried to put Transfer Logins Task to a search engine, you would already have had the answer.