locked
Can we have different user access for connecting to the sql azure database??? RRS feed

  • Question

  • When trying to connect to sql azure database with co-admin credentials giving me an error:

    cannot connect to 1gaegwqh.database.windows.net

    login failed for user 'abc'

    Monday, December 13, 2010 8:48 PM

Answers

  • Hello,

    You have to explicitly name the DataBase name to which you are connecting (when connecting with non-admin user). You also have to create database user in addition to the login, and grant this user some role permissions to the database. Then you will have no issues.

    You can read this article for more details:

    http://msdn.microsoft.com/en-us/library/ee336235.aspx

     

    • Marked as answer by sowmya I Arth Wednesday, December 15, 2010 12:00 AM
    Tuesday, December 14, 2010 5:43 AM