Cannot use a shared data source from a client

i trying edit reports client computer using microsoft sql server 2012 report builder 3.0, report using shared data source. every time click on 'select or enter stored procedure name:' combo box, being asked enter data source credentials , when entered them report builder throws error message:<o:p></o:p>

unable connect data source"<mydatasource>"<o:p></o:p>

cannot open databse "<mydatabase>" requested login. login failed.<o:p></o:p>

login failed user "domain\username"<o:p></o:p>

when same thing on server side, doesn't throw error.<o:p></o:p>

shared data sources useful when have data sources use often. recommended use shared data sources as possible. make reports , report access easier manage, , keep reports , data sources access more secure. if need shared data source, ask system administrator create 1 you.

in report builder, cannot create shared data source. can browse , select shared data source report server. more information, see data connections, data sources, , connection strings in report builder 3.0.

in report designer, cannot browse shared data source on report server. can create shared data sources part of project in solution explorer , choose whether deploy them report server. might choose use them locally because of differences in credentials required computer or report server. more information, see data connections, data sources, , connection strings (ssrs).

refer

https://technet.microsoft.com/en-us/library/dd239381%28v=sql.105%29.aspx?f=255&mspperror=-2147217396

---

please click mark answer if post helped.

SQL Server  >  SQL Server Reporting Services, Power View