Post reply

Problems with one login

  • November 7, 2006 at 9:09 am

    #170955

    Hello everybody,

    I've been searching something but I've not found the answer...

    I have a stored procedure, and within it I call sp_password for changing the password of the logins,  the application connects with the login "claves" and this login has the Security Administrator permission to execute the stored procedure, actually when I execute the stored procedure and connecting as "claves" it's successful, but if I do it since the application, the application doesn't connect with the login claves and it send the message "unknown database alias login".

    I know that probably this a mistake in the application, but maybe you could tell me if I'm missing something in SQL.

     

    Thanks a lot!


    L.I. Amaury C.R.

  • November 7, 2006 at 9:15 am

    #670307

    Who owns the procedure?

     

    Does the application user has execution rights on the procedure?

     

    What code are you using the call the procedure ( exec myproc or exec Claves.myproc)?

  • November 7, 2006 at 9:28 am

    #670312

    The proc is own by the dbo

    The application calls the proc as exec myproc connected as login "claves"


    L.I. Amaury C.R.

  • November 7, 2006 at 9:31 am

    #670313

    try Exec dbo.MyProc

    Also make sure that the user has exec permission on the procedure.

  • November 7, 2006 at 9:44 am

    #670319

    OK, Let me check...thanks a lot...


    L.I. Amaury C.R.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply