SQL SERVER – Fix : Error : Invalid object name ‘sys.configurations’. (Microsoft SQL Server, Error: 208)

As you all know that SQL Azure CTP has been released; here, I have included a step-by-step guide for how to configure the CTP: SQL SERVER – Azure Start Guide – Step by Step Installation Guide. For pricing and introduction, please read SQLAuthority News – SQL Azure – Microsoft SQL Data Services – Introduction and Pricing. I received many comments times when people are connected to the SQL Azure they receive following error.

Invalid object name ‘sys.configurations’. (Microsoft SQL Server, Error: 208)


Fix/Workaround/Solution:

1. Close out all the Connect to Server Dialogue
2. Click on the New Query button from the toolbar


3. Enter the following details
Server name: full servername (e.g. (name).database.windows.net)
Login: Your Username (no @…)
Password: Your Password

(optional) 4. Under the options in Connect to Database: type ‘master’ or ‘your own database name’

5. Hit connect

Once you hit Connect, it may give you additional warning, which depends on the server settings. Click OK and ignore all of them. Subsequently, you should be able to connect easily with the server.

If you need any additional details about Azure, I suggest you all to read more about it here.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

About these ads

6 thoughts on “SQL SERVER – Fix : Error : Invalid object name ‘sys.configurations’. (Microsoft SQL Server, Error: 208)

  1. Hello

    I have a question related to SQL Server DB

    I created a database from script and I added new tables to that DB .every thing have been done succesfully but when I start to use that db in Php page I got that the objects which created by the script are accissible but the ones I added are not

    it says that these objects are Invalid.

    so the objects created at the first time bz the script are accissible and the ones I added later on are not.

    could you help me please

  2. Hello Ibrahim,

    Check your default schema and verify that new table that you created is in desired schema. Always create and use objects with qualified naming (schemaName.ObjectName).
    If you are gettign some other issue then let us know.

    Regards,
    Pinal Dave

  3. Hello Dave, I have almost the same problem, i use an stored procedure to display states using cascading dropdown controls, locally i’m working fine but i’m just uploading to production sql box and i’m getting this message: Invalid object name ‘Cat_States’ .

    Obviously Cat_States is my table.

    I just read just last answer but I don’t understand what do you mean with schema i have never use that. Could you please be more explicit. Thanks in advance.
    Christian

  4. Hello Dave,
    I have Created the table named”Temp_tbl”..i just caught the error while executing the query..Invalid object name ‘Temp_tbl’..
    DB Location : Local Database.

    ..

    -Sakthi

  5. Hi Pinal,
    I have one issue regarding creating Database diagram in sql server 2008. When I m attempting to create diagram by right clicking on ‘Database Diagram’ I found following error. ‘ Invalid Object name ” statistics_DB.dbo.Audit (MS SQL Server Error 208).
    Please help me out. Thanks in Advance.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s