ODBC / Security Issue

Question

Post reply

ODBC / Security Issue

kknudson

SSCarpal Tunnel

Points: 4986
More actions
July 10, 2003 at 11:44 am

#59287

I have 2 servers one works right one doesn't.

Userid has access to 2 DBs, when they configure ODBC at the client pointing to the Dev Server the DB list is Default, Master, model and Temp (they are secured out of master and model, might be msdb).

When the configure pointing to Prod they get DB1, DB2, master ....

Why is the Dev server not showing them the actual names of the DBs they are allowed to access ??

Any ideas.

Any ideas

KlK, MCSE

KlK

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 1

Allen Cui-55137

SSC Guru

Points: 51650

July 10, 2003 at 12:12 pm

#464952

I would suspect the user does not have access to these two dbs. Is MDAC version same in these two servers?

kknudson SSCarpal Tunnel Points: 4986 More actions · Answer 2

Sorry Allen, I can use Query analyzer to select from either DB, and the ODBC connection will allow access to the 'default' DB. As far as MDACs, I don't have the exact levels, but I built both machines at roughly the same time to SQL2k SP2 + a couple of patches.

I know the Dev box has been abuse a little, but it shouldn't be too far off.

I figure some security setting is whacked.

Note the users in question are NT Auth'd, but I recreated the exact same condition with a SQL Server ID.

KlK, MCSE

KlK

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 3

Allen Cui-55137

SSC Guru

Points: 51650

July 11, 2003 at 9:34 am

#465110

You can download MDAC component checker from Microsoft to verify the version of MDAC in both server. I would suggest to reinstall the MDAC to your Dev server.