Solved

Getting error: Getting error: Cannot create a connection to data source Data source 1 SOME USERS

Posted on 2015-02-18
32
23 Views
Last Modified: 2015-03-04
My client is reporting an errror

Getting error: Cannot create a connection to data source Data source 1 when they try to view reports in report manager.

Interesting though this is only happening to SOME USERS. Other users can see reports without any issues.
0
Comment
Question by:vbnetcoder
  • 18
  • 14
32 Comments
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 40616524
Check their ODBC. Something must be different or missing in the complaining users machines.
0
 

Author Comment

by:vbnetcoder
ID: 40616535
A bit hard to do because it is a remote clients machine. Where would i go to check this?
0
 

Author Comment

by:vbnetcoder
ID: 40616542
Actually, i believe 2 users are getting this error and for one it is working
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 40616552
You need to have access to their machine. Or ask them to send you a print screen of their ODBC DSN configuration.
They can check it in Control Panel / Administrative Tools / Data Sources (ODBC) / System DSN.
0
 

Author Comment

by:vbnetcoder
ID: 40616555
What should they see .... when i look at the one on my local box i don't see anything
0
 

Author Comment

by:vbnetcoder
ID: 40616564
This is mine.  I am able to connect to reports on my local machine
0
 

Author Comment

by:vbnetcoder
ID: 40616566
0
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 40616578
By the error message I had the impression that they were using Data Source Names (DSN).
So, if they aren't using an ODBC connection means that they are connecting directly with SQL Server Native Client (SNAC) maybe.
I don't have any clues by now.
0
 

Author Comment

by:vbnetcoder
ID: 40616587
Let me know if you have any ideas of what i can check ....

the screenshot was from my computer but the same is on their server where i am able to run reports
0
 

Author Comment

by:vbnetcoder
ID: 40616592
is it possible that they don't have drivers installed under drivers in the Data Sources (ODBC)?
0
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 40616602
You check if they have the SNAC installed. That's a good idea.
0
 

Author Comment

by:vbnetcoder
ID: 40616610
How do i do that? sorry i am a complete newbie
0
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 40616614
You can check in ODBC for SQL Server drivers and also in the Add/Remove Programs for SQL Server Native Client (SNAC).
0
 

Author Comment

by:vbnetcoder
ID: 40616618
I assume we are talking about what i am pointing to in the screenshot.  Where should they go to download it if they don't?
Capture.JPG
0
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 40616633
You can download it from Microsoft download center. This is the full Feature Pack and you just need to download the ENU\x64\sqlncli.msi (for 64bit) or ENU\x86\sqlncli.msi (for 32bit). It's a msi file (windows installer) so just double-click on it to get it installed.
0
 

Author Comment

by:vbnetcoder
ID: 40616642
ok i should only do this if i don't see what i highlighted in the screen shot above correct?
0
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 40616652
I can't confirm that. I don't know how is configured the report connections.
0
 

Author Comment

by:vbnetcoder
ID: 40616661
if it's not on their computer it wouldn't hurt to download it though right?
0
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 40616666
No, not at all but you should check what the user that has no issues have different on his machine from the others.
0
 

Author Comment

by:vbnetcoder
ID: 40616670
True will do that first.
0
 

Author Comment

by:vbnetcoder
ID: 40616672
To do that should i go through all the tabs in the Data Sources (ODBC)?
0
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 40616681
I'm not talking only about ODBC. You should see everything. Applications, drivers, user permissions and anything do you remember.
0
 

Author Comment

by:vbnetcoder
ID: 40616683
hmmm not sure what i all need to check then
0
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 40616694
I would start to check if the users have access to the SQL Server database.
0
 

Author Comment

by:vbnetcoder
ID: 40616710
How would i do that?
0
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 40616716
You need to connect to the database and check if the users are created there.
I would also review the report connections.
0
 

Author Comment

by:vbnetcoder
ID: 40616829
I am looking at the error logs and the message is Login Failed for user (followed by the user)
0
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 40616837
Ok, that's a more clear error message. That user doesn't have access to SQL Server. Or if he have the password is wrong.
0
 

Author Comment

by:vbnetcoder
ID: 40616861
What would  i need to do to resolve it?  I don't see the user that work in SQL server either
0
 
LVL 47

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40616865
You need to create it. I think I already told you how yesterday in one of your SSRS questions.
0
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 40616872
Yes, I did. Check it here.
0
 

Author Closing Comment

by:vbnetcoder
ID: 40645139
ty
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server Question 5 36
How to connect Power BI Desktop to ssrs report server 2 23
MS SQL Server Modify insert/update update to use MERGE 13 45
MS SQL Delete Query 9 30
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now