<div>
<div class="content wysiwyg-content">
Restored production database to development<br />
<br />
Went into development and tried to change the credential of the users in development<br />
It does not let me do it. &quot;user already exists&quot; message I am getting<br />
I can not delete/create logins either<br />
<br />
What are the steps to accomplish this. I want to either modify their credentials to match development or delete and create them as new logins<br />
<br />
Thanks
</div>
</div>


Restored production database to development

Went into development and tried to change the credential of the users in development
It does not let me do it. "user already exists" message I am getting
I can not delete/create logins either

What are the steps to accomplish this. I want to either modify their credentials to match development or delete and create them as new logins

Thanks

recreate logins subsequent to restore

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.