31 October 2011

Invalid object name 'sys.configurations' while connecting to SQL Azure


If you connect the SQL Azure from SQL Management Studio (Database Engine) by using the Full qualified server name given by Azure, you will hit some invalid object name type of error alert.
Workaround/ solution:
  1. Close the connection dialog
  2. Click on the "New query"
  3. It will prompt similar connection dialog, this will be working fine.
*Remember to set your database name by clicking the option button in connection dialog
screen. :)

No comments:

Post a Comment