Error 1 The specified schema name "Sales" either does not exist or you do not have permission to use it.

I'm playing with the AdventureWorks DB to test the DB Pro piece, however after importing the DB I get tons of errors like the above. Is this a known bug in this release or did I miss something

ciao

andreas



Answer this question

Error 1 The specified schema name "Sales" either does not exist or you do not have permission to use it.

  • Blader

    CTP5 is wrapping up now. While I don't have a specific date, you should see it this month. As soon as we have an official date, we'll post here and let you all know.

  • AzurianArcher

    Hello Steven,

    thank you for the feedback, good to know I didn't miss something.

    Don't mind to use CTP. The product overall looks very promising. :)


  • MaggieChan

    So are there any work arounds for this in CTP4 (hoping) And when do you suppose the CTP5 will be out, with this in place (gotta ask :-)

    Brumlemann



  • ChrisMcCabe

    Andreas -

    Support for SQL Server 2005 is still being implemented. In CTP4, there were still a number of SQL constructs that would result in errors. One significant issue in CTP4 was that schemas other than dbo weren't yet working correct (as you noticed with AdventureWorks). CTP5 should be better, but will still have some outstanding issues (fewer than CTP4).

    Unfortunately, with CTPs, you get to see the product as it moves towards being complete but you also get to experience the growing pains :).

    You might try working with a simpler SQL2005 database, or a SQL2000 database (like Northwind) if you want to work with CTP4.

    thanks,



  • Error 1 The specified schema name "Sales" either does not exist or you do not have permission to use it.