<div>
The same SQL LOGINS and USERS exist on both servers and SQL instances. &nbsp;But how will this script fix the execute permissions on the stored procedures? &nbsp;What is it doing?
</div>


<div>
The assigned permissions are in the database that you restored. &nbsp;The problem is that the UID that is assigned to each user is different between the two servers, so the mapping between the SQL login at the server level and the database user is lost. &nbsp;That script will restore the mapping between the two. &nbsp;To verify that this is the issue, look at the properties of one of the database users. &nbsp;If you see a user name without a login name, it's an orphaned user. &nbsp;<br />
<br />
Greg<br />
<br />
<br />

</div>


<div>
&gt;&gt;What is it doing?<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms174378.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms174378.aspx</a><br />
&quot;Maps an existing database user to a SQL Server login. &quot;<br />
<br />
Greg has you on the right track w/ this, I'm pretty sure.<br />

</div>


<div>
The user exists AND the login exists. &nbsp;It is just the executable rights on the stored procedures that don't work (even though I can see the user in the PERMISSIONS section of the stored procedure properties). &nbsp;I have to take the user out. &nbsp;Put him back in and grant execute permission again. &nbsp;Then it works. &nbsp;So will the above script fix that?
</div>


<div>
<div class="content wysiwyg-content">
I have two servers. &nbsp;If I do a backup on Server 1 and restore it to Server 2, &nbsp;the execute permissions that I have granted for users on the stored procedures do not work. &nbsp; Why?<br />
<br />
<br />

</div>
</div>


I have two servers.  If I do a backup on Server 1 and restore it to Server 2,  the execute permissions that I have granted for users on the stored procedures do not work.   Why?




User permissions don't work after a restore

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

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.