<div>
can you give &nbsp;db_owner role to your user? it may solve the problem
</div>


can you give  db_owner role to your user? it may solve the problem

<div>
I have SA role in server 2, I also gave db_owner. then tried again, it got the same error.
</div>


I have SA role in server 2, I also gave db_owner. then tried again, it got the same error.

<div>
it is working right now after I refreshed my login in EM. &nbsp;Thank you!!
</div>


it is working right now after I refreshed my login in EM.  Thank you!!

<div>
Thank you for your recommandation, it saved my time. 
</div>


Thank you for your recommandation, it saved my time.

<div>
<div class="content wysiwyg-content">
expert,<br />
<br />
I copied sproc from server 1 to server 2 and run it in server 2, it came out with error like<br />
Server: Msg 262, Level 14, State 1, Procedure ...<br />
CREATE PROCEDURE permission denied in database 'master'<br />
I am in sysAdmin level I am able to exec this sproc, but it doens't.<br />
<br />
Can you help? Thank you,
</div>
</div>


expert,

I copied sproc from server 1 to server 2 and run it in server 2, it came out with error like
Server: Msg 262, Level 14, State 1, Procedure ...
CREATE PROCEDURE permission denied in database 'master'
I am in sysAdmin level I am able to exec this sproc, but it doens't.

Can you help? Thank you,

permission denied for excution store procedure

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.