Connecting to SQLExpress database with EW4 RRS feed

  • Question

  • I am trying to build a SQLdatasource connection to SQLExpress 2012 using EW4 SP2.  When I drill down to the location containing the appropriate database I get a message that I do not have permission to open the file.

    SQLexpress and EW4 are installed on the same machine, and were installed using the same user.  Excel (2010 and 2013) can find the table that I am trying to link to, can open it, and load it into a worksheet.  SSMS can find the table, and can execute queries against it. 

    Any suggestions as to how to get EW4 to be able to get permission to access the file so that it finalize the construction of the connection string?

    Saturday, August 24, 2013 7:14 PM

All replies