locked
"User does not have permission to perform this action" when add new mdf in VS2008 RRS feed

  • 問題

  • I am running VS2008 with SQL Express 2008.

    I created an ASP.NET Folder, App_Data. And then I add new item, in the "add New Item" windows, I selected SQL Server Database and click Add button. Then the message ""User does not have permission to perform this action"" pop up.

    I am sure that my current acct has sa right. And the SQL Express 2008 is configured in Mixed mode.
    I tried to open SQL Management Studio and I can create a testing DB.

    Anything that I need to do in VS?
    大家一齊探討、學習和研究,謝謝! Microsoft MVP, Microsoft Community Star(TW & HK), MCT, MCSD, MCAD, MCSE+I, MCDBA, MCDST, MCSA, MCTS, MCITP
    2009年8月17日 上午 07:34

解答

  • still cannot solve it.
    大家一齊探討、學習和研究,謝謝! Microsoft MVP, Microsoft Community Star(TW & HK), MCT, MCSD, MCAD, MCSE+I, MCDBA, MCDST, MCSA, MCTS, MCITP
    2010年3月26日 上午 09:06

所有回覆

  • Hi Ken,

    When you create the ASP.NET project, you have chosen to create the project using "File System" or "HTTP" location?

    Regards,
    Raymond
    2009年8月18日 上午 09:15
  • Local FS.


    大家一齊探討、學習和研究,謝謝! Microsoft MVP, Microsoft Community Star(TW & HK), MCT, MCSD, MCAD, MCSE+I, MCDBA, MCDST, MCSA, MCTS, MCITP
    2009年8月31日 上午 02:25
  • 1,pls install Visual Studio 2008 SP1
    2,check ConnectionStrings is right
    3.check SQLExpress Service is running
    4,try install 
    Microsoft SQL Server 2008 Management Objects from

    http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=228de03f-3b5a-428a-923f-58a033d316e1

    【孟子E章】
    2009年9月2日 下午 01:27
  • 1,pls install Visual Studio 2008 SP1
    2,check ConnectionStrings is right
    3.check SQLExpress Service is running
    4,try install 
    Microsoft SQL Server 2008 Management Objects from

    http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=228de03f-3b5a-428a-923f-58a033d316e1

    【孟子E章】

    1) Already is VS2008 SP1, version 9.0.30729.1
    2) ConnectionString is correct, cause now I tried to be connecting to SQL Express by SQLDataSource
    3) It is runing
    4) Installed.

    But still cannot make it.
    大家一齊探討、學習和研究,謝謝! Microsoft MVP, Microsoft Community Star(TW & HK), MCT, MCSD, MCAD, MCSE+I, MCDBA, MCDST, MCSA, MCTS, MCITP
    2009年9月4日 上午 09:35
  • Maybe, you have to run the VS2008 as "Run as administrator.."

    if it does not work, 

    run SSMS, check the permission properties of the database to grant sa to your current account.
    2009年11月4日 下午 12:21
  • still cannot solve it.
    大家一齊探討、學習和研究,謝謝! Microsoft MVP, Microsoft Community Star(TW & HK), MCT, MCSD, MCAD, MCSE+I, MCDBA, MCDST, MCSA, MCTS, MCITP
    2010年3月26日 上午 09:06