You cannot delete other topics. Once we have mapped the user to the database, we will need to grant them permissions on the mapped databases as well. Userid and password do not resolve the error issue. The first thing you will have to do is to create the windows login or group within SQL management studio. Source

After deploying the report to the server, I checked properties of the DataSource and again no 'Save Password' check box. I did not state but probably should have, that I am using stored credentials with the store credentials securely in report server radio button checked and the use "Use as Windows The good news though is that you will not need to duplicate your efforts in order to grant security to Dynamics GP Excel reports. You cannot edit other events.

For example, a report server administrator might update the connection string or credentials. This is a common error in SQL Server Reporting Services reports which is caused by incorrect security setup. Cannot create connection to data source ‘XXXXXXXX’ For more information about this error navigate to the reporter server on the local machine or enable remote errors. The issue here is report server and sql db is on server 1 while the web site is on server 2.

So I think my reply should solve Steve Ho’s issue, if not he is also welcomed to give some feedback and unmark it, and I will do more research and give If I receive written permission to use content from a paper without citing, is it plagiarism? Looks like that datasets blocked each other and generated such error. Cannot Create A Connection To Data Source Ssrs 2012 In your case the test server may have access to run against the test SSRS or live SSRS server which is why it is working.

Was there no tax before 1913 in the United States? Cannot Create A Connection To Data Source ' Data Source For Shared Dataset' The report server retrieves and uses the credentials when report processing is scheduled or triggered by an event rather than a user request. So why is security such a big issue? tks Reply b471code3 Star 9197 Points 2579 Posts Re: Getting error: Cannot create a connection to data source Feb 14, 2012 09:18 PM|b471code3|LINK Thats fine, go to server 2 and it

share|improve this answer edited Mar 30 at 12:25 Necreaux 3,16851440 answered Mar 30 at 12:19 jamal ahmad 111 add a comment| up vote 0 down vote if you use null values http://scenelink.org/cannot-create/cannot-create-a-connection-to-data-source-rserroropeningconnection-sql-server.php You cannot post JavaScript. Tuesday, March 01, 2011 8:42 PM Reply | Quote 0 Sign in to vote Yes. The roles on the company databases look a bit different, although they should look familiar: We will again need the public role, though from there, what is required will depend on An Error Has Occurred During Report Processing. Cannot Create A Connection To Data Source

The user accounts are in the database with proper permissions to database, tables, etc. A data connection includes a name and connection properties that are dependent on the connection type. On the Reporting Server Configuration Manager, the Unattended Execution Account is not selected and is blank. have a peek here You cannot edit your own posts.

Microsoft Dynamics GP Get help on your Microsoft Dynamics GP solution from qualified experts in the forums, read blogs and how-to articles, and watch videos. Cannot Create A Connection To Data Source 'datasource1'. Pinging is currently not allowed. You cannot vote within polls.

For more information, see Specifying Credentials in Report Builder 3.0 and Data Connections, Data Sources, and Connection Strings (SSRS).

If you need a shared data source, ask your system administrator to create one for you.In Report Builder, you cannot create a shared data source. Does every interesting photograph have a story to tell? Password Reminder Password Register Register | FAQ | Members List | Calendar | Today's Posts | Search BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 This is the forum to discuss http://scenelink.org/cannot-create/cannot-create-connection-data-source-sql-server-2005.php You are dealing with 2 different accounts (and you need both): User account to access the database via the SSRS report (dataset)which you should have defined in the SSRS report User

It will grant the required security on database objects, but nothing more. Be careful when granting these permissions, anything you grant to the windows users can be used in SSRS, Excel, Access or any other program which can connect using an ODBC connection. I am able to run the reports on BI application. An error has occurred during report processing.

The report server retrieves and uses the credentials when report processing is scheduled or triggered by an event rather than a user request. Subscribe for updates: Products Contacts License Management Company Products Resources Veeam University Partners Success Stories Contact Veeam sales Buy Veeam products Renewals Online shop License Management Support Technical Documentation Knowledge Base Users will need access to the system database (usually called DYNAMICS), as well as any company databases on which they want to run reports. Privacy Policy & Cookies SQL Server Developer Center Sign in United States (English) Brasil (Português)Česká republika (Čeština)Deutschland (Deutsch)España (Español)France (Français)Indonesia (Bahasa)Italia (Italiano)România (Română)Türkiye (Türkçe)Россия (Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国

tks Reply b471code3 Star 9197 Points 2579 Posts Re: Getting error: Cannot create a connection to data source Feb 14, 2012 04:06 PM|b471code3|LINK Then do as the error states and enable They make reports and report access easier to manage, and help to keep reports and the data sources they access more secure. Joell MCSD MCDBA Tuesday, March 08, 2011 6:31 PM Reply | Quote 0 Sign in to vote Hi, If you want to access external data for a report.