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 |
|
cshong
Starting Member
8 Posts |
 Posted - 2010-03-17 : 05:06:41
|
| I want to make connection to the database through ODBC. But, I want to set SQL server's administrator account 'sa' can only login through the installed Microsoft SQL Server Management Studio Express but cannot login through the application that connect to the database through ODBC or other types of connection. But, make the other users still can login to the database through the application that use ODBC / other types of connections. Is this possible? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-03-17 : 05:28:48
|
The easy way is to not give them the SA-Password isn't it?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-17 : 10:05:46
|
I have inherited systems where everyone in the company was using the sa password. It is often a LOT of work to be done before you can change it. We want to protect the data, but users also need to get their work done...you can't take away their access until you provide an alternative. Plus there may be compiled apps running with the password embedded (sigh).One of the things I did was create a job that queries sysprocesses every couple of minutes emailing me the hostname and programname of any remote connections using sa.Another thing that can be done is to create a logon trigger.anyway, I agree with ya Fred, but sometimes it's not as simple as it appears  |
|
|
|
|
|
|
Disable 'sa' login through ODBC/other connections.