title: How to store credentials for a data source in SQL Server 2008?
body: <p>I have created the datasource in the SSRS by using option <strong>Credentials stored securely in the report server</strong> then I am accessing it through report builder to create report, included datasource then need to create a dataset using option <strong>Use a dataset embeded in my report</strong>
  Selecting included datsource and when clicks on <strong>Query Designer...</strong> its asking me Data souce credentials username and password.</p>
  
  <p>According to requirement we are allowing user to use the Datasource but do not want to share the credentials in that case how should I stored the credentials for a datasource in SQL Server 2008.</p>
  
  <p>I have found link <a href="http://msdn.microsoft.com/en-us/library/ms159736.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/ms159736.aspx</a> but this is showing answer only for SQL Server 2012 &amp; 2005 not for 2008.</p>