70-450 · Question #49
You administer two SQL Server 2008 instances named Instance1 and Instance2. A database named Customers resides on Instance1. You move the Customers database from Instance1 to Instance2. A SQL Server…
The correct answer is A. USE Customers; ALTER USER User1 WITH LOGIN = User1. See the full explanation below for the reasoning.
Question
You administer two SQL Server 2008 instances named Instance1 and Instance2. A database named Customers resides on Instance1. You move the Customers database from Instance1 to Instance2. A SQL Server login named User1 that has the password "111999" is used by a user to access the database on Instance1. You create the same SQL Server login on Instance2. The user attempts to access the Customers database on Instance2 by using the SQL Server login User1. However, the user receives an error message which indicates that the access to the Customers database is denied. You need to ensure that User1 can access the Customers database. Which Transact-SQL statements should you execute on Instance2?
Options
- AUSE Customers; ALTER USER User1 WITH LOGIN = User1;
- BUSE Customers; ALTER USER User1 ENABLE;
- CUSE Customers; ALTER LOGIN User1 WITH PASSWORD = '111999' UNLOCK;
- DUSE Customers; ALTER LOGIN User1 WITH DEFAULT_DATABASE = Customers;
How the community answered
(55 responses)- A71% (39)
- B9% (5)
- C4% (2)
- D16% (9)
Community Discussion
No community discussion yet for this question.