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 |
|
Ger
Starting Member
11 Posts |
 Posted - 2003-03-11 : 10:10:16
|
| In my network we use SQL Server authentication. I developed a few applications that connect to the database, some in C++ Builder and some in Visual C++ (these run in DOS windows). All C++ Builder applications that try to use the database pop up a login dialog. But the VC++ programs, in certain computers, don't stop for logging in, and carry on doing whatever they have to do with the database. When I check a log to see which database user did the task, it's "dbo". How come there are programs that login automatically as dbo, not requesting ever a password? What can I do to make sure that NO COMPUTER has access to the tables without a password?Thanks |
|
|
Peter Dutch
Posting Yak Master
127 Posts |
Posted - 2003-03-11 : 10:19:39
|
| There's no way you could access the db without some sort of connectionstring. What connection info do you use to connect to the db? What are the differences between the two? |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-03-11 : 10:47:34
|
| Maybe the VC++ apps are using integrated security and are connecting as domain administrators - via a remote DB component? - which will end up as dbo.Otherwise maybe have sa password hard coded somewhere.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Ger
Starting Member
11 Posts |
Posted - 2003-03-12 : 09:48:51
|
quote:
There's no way you could access the db without some sort of connectionstring. What connection info do you use to connect to the db? What are the differences between the two?
Right, there is a connection string, which is simply "DSN=<name>" where <name> is the ODBC id. All computers connect through that id.I haven't found differences in the ODBC entry options for different computers. Thanks... |
|
|
|
Ger
Starting Member
11 Posts |
Posted - 2003-03-12 : 09:57:00
|
quote:
Maybe the VC++ apps are using integrated security and are connecting as domain administrators - via a remote DB component? - which will end up as dbo.Otherwise maybe have sa password hard coded somewhere.
The password is not hardcoded.In VC++ I use the CDatabase and CRecordset classes. And it is the same EXE that behaves differently on different computers.I'm not sure what you mean by using integrated security, how do you do that? Thanks. |
|
|
|
|
|
|
no login!