Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
steelkilt
Constraint Violating Yak Guru
255 Posts |
 Posted - 2002-11-19 : 14:54:42
|
| I'm setting up a DSN on a client computer that accesses my SQL Server (7.0). I've had no trouble setting this up for the majority of users, however, on this particular WIN 2k machine, something mysterious happens:I step through the System DSN setup without a problem, then I actually test the DSN successfully without a problem. When I click OK to save and exit, the DSN is gone. It never gets written to the System DSN list.Any ideas?thx |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-11-19 : 16:08:32
|
| You probably don't have administrative privileges on that user's machine. You aren't able to write to the registry, so that's why it disappears. I'm not sure why MS let's you even go through the DSN screeens if you don't have the necessary privileges. |
 |
|
|
steelkilt
Constraint Violating Yak Guru
255 Posts |
Posted - 2002-11-20 : 09:57:36
|
| This is what I feared. If this becomes a trend, I'm in trouble due to admin overhead associated with finding a "licensed" admin to set up one silly DSN. Oddly, most of the machines I've set up thusfar have had no problems -- I just did the setup with user logged on as normal.All this will become moot in a few months once I have time to develop my web interface, which will hit the single system dsn on the server side.cheers, and thanks. |
|
|
|
|
|
|
DSN tests fine, then disappears!