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

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

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.

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 4

What do you mean by:

quote:
(they are secured out of master and model, might be msdb)

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

K. Brian Kelley
@kbriankelley

kknudson SSCarpal Tunnel Points: 4986 More actions · Answer 5

Allen, well I was in some classes so I didn't have time to check the MDAC level, both are 2.70.7713.4

Brian, I just meant that I don't give security to Master, Model to general users. The little note was I can't remember if it was Model or MSDB.

I do find it strange that the ODBS setup shows these DBs, and not the one's it is supposed to ???