Problem accessing SQL Express 2008 R2 after VS package install RRS feed

  • Question

  • I've written an application package in Visual Studio 2010 which requires SQL Express 2008 R2. I've also created a separate setup package and set SQL Express as a prerequisite. Everything runs as expected except that after the install on target machine I do not have adequate permissions in SQL to attach the database or set up the user via SQLCMD script. This happens on WIN 7 and up. I know it is a permissions issue with the default install of SQL but do not know how to otherwise perform the install and make it work. Looking for someone to walk me through and resolve this issue.
    Tuesday, November 11, 2014 7:52 PM