What are the challenges you face when working across database platforms? Take the survey
Options

Security Requirements

Grant FritcheyGrant Fritchey Posts: 72
edited March 16, 2007 12:29PM in SQL Prompt Previous Versions
We've got a user that just installed SQL Prompt. She's getting an error connecting to a database on SQL Server 2005. She's a member of db_ddlamdin, db_datareader, db_datawriter and db_securityadmin, but she's getting an error that says SQL Prompt can't read the schema. What's up?

Comments

  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    Hi there,


    You don't say whether you're using SQL Server 2000 or 2005, however this article should answer your question:

    http://www.simple-talk.com/community/bl ... 19421.aspx

    Hope that helps.


    Thanks,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
  • Options
    Oops. Yeah, I left that out. It's on 2000, so it may be time to do some negotiation with some of our users. I'm not exactly jazzed about giving them dbo. I'll send them the suggestion on the beer though because that might grease the skids.
    Thanks for the help.
  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    Yeah, it's not ideal and it's something we want to address for the future: it's very much a limitation of our current meta-data model. If we find any other workaround for SQL Server 2000 I'll post another article along with a link on here.
    Thanks,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
Sign In or Register to comment.