I have a user who is trying to edit a Crystal report. She is getting ODBC errors. When I investigate, I first log using her credentials. When I open OBBC32ad.exe and examine the System datasource, the database tied to this Crystal report is not listed in the drop down of Databases. If I log into the same computer with my login, all the databases are present in the ODBC dialog. I have Domain Admin rights.
There is another Database, Data_02, which she does have access. So I looked for differences between the two but did not find any.
I think the issue is permissions. I know very, very little about this subject. I probably have had to address a security question twice in 20 years.
When I open the Security node of the Server tree in SSMS, I can find her NT username (SW) under the Login branch. When I examine the Properties I cannot find a clue as to why she does not have access to Data_101 But does have access to Data_02. I cannot see differences between the two.
When I examine first Data_02 and then Data_101 in the Databases node, the SW login is not listed under Security>> Users for either database.
I have attached screen shots of all the screens I described above.
I would really appreciate your assistance in giving this user access to Data_101. And an explanation of how is Data_02 set up differently.