none
BIDS - report file permissions issue on master, yet im a sysadmin when running the RDL from SSMS

    Question

  • Im building a report file and when I preview the report, it fails because my account cant access the master database.

    My dataset is just calling xp_readerrorlog, which is in master.

    I can call it just fine in a query window, but not from BIDS, using a connection with windows security.

    I can however, preview the dataset ok, but when I open the RDL file from SSMS under custom reports, I get an login error.

    However, if I preview the report...it fails and says the login failed, login failed for user mydomain\myuser ....

    • Edited by shiftbit Thursday, January 09, 2014 8:45 PM sdfgsdfg
    Thursday, January 09, 2014 8:42 PM

Answers

All replies