Error creating first SQL Express database via VWD 2005 Express: "User does not have permission to perform this action"

Hot Topic

Domain group logins failing on SQL 2k5 workgroup
Could not find stored procedure 'msdb.dbo.xp_sqlagent_notify'
obtain the result of dynamic query with openrowset
Cache size lookup transformation
Giant White Space Shows Up When Viewing In Report Manager Only
Dimension and Hierachy
Reporting Services for SQL 2005 Standard
Insert Local Variable Value
Calculations in Mdx Query
Passing parameters to reports

SQL Server

How do I get Copy Database Wizard to work?
A Way To Go To First Row In A Parameter's DataSet?
Proxy Class is fine when used in C# project but returns error when Used with SSIS
Have any of you had an experience with deploying reports to SAP portal?
Using Variable/Expression to Log with Parent/Child Packages
how to invoke/call Drillthrough Action
Time intelligence
Alternative to Reporting Services
autogrow of log file possibly cause timeout?
parameters in sql task sub query

Error creating first SQL Express database via VWD 2005 Express: "User does not have permission to perform this action"


I get an error dialog when I try to create a new SQL database, both via the Add New Item dialog and the property wizard of a new SqlDataSource control. The error is:

Local Database File:

User does not have permission to perform this action.

I've searched for help with this.

  • I ensured the App_Data folder exists and I added the local ASP.NET account to the group that have R/W access to it (although the RO flag is in an unchangeable tri-state on the folder).
  • The SQL Server Express error log is clean and indicates full functionality.
  • Everything is running locally.
  • No VWD installation errors.

Any ideas

Thank you!

Answer this question

Error creating first SQL Express database via VWD 2005 Express: "User does not have permission to perform this action"

  • mrdolby

    VWD creates your database using a User Instance is your User Profile, it almost sounds like something is wrong with your profile. Let's start by seeing if SQL Express is working as expected, do the following:

    1. Open a command prompt.
    2. Type: SQLCmd -S .\sqlexpress -E
    3. At the 1> prompt, type: CREATE DATABASE Foo
    4. At the 2> prompt, type: Go

    Let me know what happens, hopefully it will succeed. If it does, then SQL Express is working as expected in the parent instance and it's likely that something is messed up about your profile or the permissions in your profile directory.

    Regards,

    Mike Wachal
    SQL Express team



  • Ajeeth Kumar

    Hi Mike,

    Thanks, we found the problem. Our Local Security Policy GPOs were preventing ASPNET from "Log on as a service". I was able to get a generic VWD install to run perfectly within a Virtual PC session.

    VWD is great--it's like my familiar IIS, Access, and FrontPage apps all rolled into a cohesive, integrated IDE--I'm loving VWD! I'm also pleased that our GPOs are working as designed, and that VPC (another utility Microsoft is giving away free) solves this (and other) problems in such an effective way.

    Thanks!

    A Satisfied Customer
    (John Kirkwood
    Canada IT
    PricewaterhouseCoopers)
  • Error creating first SQL Express database via VWD 2005 Express: "User does not have permission to perform this action"
Answer this question