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 |
|
kbdrand
Starting Member
14 Posts |
 Posted - 2002-07-11 : 08:18:09
|
| We have a MS SQL 7.0 server setup as a call tracking system. I need to perform some reports from a Unix box (Linux Redhat 7.3 to be exact) and when I try to login to the server it gives my a 'login failed' message.My signo-on works fine from a Windows machine so I'm assuming it's because the server is using only Windows authentication. On SQL Server 2000 you have mixed mode authentication for non-Windows clients. Does 7.0 have the same feature? And if so, what do I need to do to turn it on and what are the security problems of setting this up?If I can't use mixed mode, or if there is a better way to do this, please let me know.Thanks! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-11 : 08:28:45
|
| Sure, it's pretty easy to do. Open the SQL 7.0 machine using Enterprise Manager, right-click on the server and choose Properties. Go to the Security and choose the SQL Server and Windows option (mixed mode). Stop and restart the SQL Server, and you're all set. You'll need to create SQL logins for the Unix people too, you can also do that in Enterprise Manager (expand the server tree, look under Security/Logins) |
 |
|
|
|
|
|
SQL login via Unix/PHP