 WOT: ODBC Question, with SQL Server |
|
|
|
Porsche, and the Porsche crest are registered trademarks of Dr. Ing. h.c. F. Porsche AG.
This site is not affiliated with Porsche in any way. Its only purpose is to provide an online forum for car enthusiasts. All other trademarks are property of their respective owners. |
|
|
| richardL |
 Feb 6 2006, 06:07 PM
Post
#1
|
|
Senior Member  Group: Members Posts: 713 Joined: 27-January 03 From: San Diego, CA Member No.: 201 Region Association: None  |
I'm hoping someone here has an answer to this, its driving me crazy.
I have a client using an ODBC connection (on XP Pro), to connect to a SQL Server database. Its set to use NT authentication. You can create the ODBC Datasource, select the appropriate database on the appropriate server and test the connection - all is fine. However, when you check it is actually connected to the another database on that Server, apparently the one defined as the defualt for that server. For instance I created a connection pointing at the standard Northwind database, then I opened Access, linked to an ODBC datasource, selected my new datasource and instead of being offered a list of the tables in Northwind, I was offered a list of the tables in the other default database (not master). I eventually got it to work as I expected, by logging off of the domain account and doing a login as the adminstrator for the local machine. In that account, the DSN worked as expected. I have never seen a DSN with NT authentication simply provide access to another database - it should tell me I don't have access rights to the database selected or whatever. In this case the default database is the clients main live production system, so it appears to be a glaring security risk. Anybody know why this might happen, or even how to make it happen/stop? Thanks. |
   |
 
|
  |
Replies
| SirAndy |
Feb 6 2006, 11:39 PM
Post
#2
|
||
|
Resident German Group: Admin Posts: 41,688 Joined: 21-January 03 From: Oakland, Kalifornia Member No.: 179 Region Association: Northern California |
that actually has nothing to do with the DSN setup. if the user account they gave you has no restrictions, you'll be able to use it to access any database on the SQL server. if the account was only supposed to be used with one specific database but actually works with others as well, the account is set up incorrectly ... you specify which user can access what database devices (see pic 1) and you also set a "default" database for that user (see pic 2) ... so, maybe, the useraccount you are using is not configured correctly ... (IMG:http://www.914world.com/bbs2/html/emoticons/type.gif) Andy PIC 1 Attached image(s) 
|
||
 |
|
||
Posts in this topic
richardL WOT: ODBC Question Feb 6 2006, 06:07 PM
SirAndy well, you did specify the database to connect to i... Feb 6 2006, 06:40 PM richardL Thats the point - I am (of course) specifying the ... Feb 6 2006, 07:09 PM SirAndy <... Feb 6 2006, 10:17 PM jonwatts Our ODBC Admin at work says that testing the datab... Feb 6 2006, 10:38 PM SirAndy PIC 2 Feb 6 2006, 11:39 PM SirAndy hey richard, if the DB server is on a public netwo... Feb 6 2006, 11:43 PM Dr. Roger you are using a system DSN right? not a user?
us... Feb 7 2006, 12:11 AM Dr. Roger you've probably already setup a user on the SQ... Feb 7 2006, 12:18 AM richardL Its not a public site - its behind a firewall.
I... Feb 7 2006, 10:38 AM SirAndy <... Feb 7 2006, 12:07 PM richardL Feb 7 2006, 03:55 PM
Dr. Roger richard,
i don't know why you would want to u... Feb 7 2006, 06:11 PM |
2 User(s) are reading this topic (2 Guests and 0 Anonymous Users)
0 Members:
|
Lo-Fi Version | Time is now: 15th June 2024 - 06:34 PM |
Invision Power Board
v9.1.4 © 2024 IPS, Inc.