Re: Create Certificate Error - Service Broker Question

If this is indeed your code then I assume the problem is you are creating
user: Server_2_DB2_User
and assigning authorization to: Server_2_DB_2_User_Cert
Notice DB2 != DB_2

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"Philip" <Philip@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:98B7D74D-8C2E-4C7D-83ED-C5A0550ABE55@xxxxxxxxxxxxxxxx

I'm trying to create a certificate for use with a remote service broker
instance.

Code:
create login sbLogin
create user Server_2_DB2_User from login sbLogin

create certificate Server_2_DB_2_User_Cert
authorization Server_2_DB_2_User
from file = 'c:\Server_2_DB_2_User_Cert.cer'

The last statement returns the following error:

Msg 15151, Level 16, State 1, Line 2
Cannot find the user 'Server_2_DB_2_User', because it does not exist or
you
do not have permission.

Note I am a sys admin on the sql server 2005 instance.

Please help.





.