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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-04 : 07:11:10
|
| LUIS writes "Hi there !!!, I have a very large, ERP like aplication developed with Clarion for windows 5.5 Enterprise Edition.It runs with Sql-Server 2000 as the RDBMS.We have it installed and runnig in aprox. 10 clients.Since we started with it years ago we decide to use Sql-Server authentication, not trusted conections.But... One of our clients needs and want to use trusted connection, Ok, I am using an api, to access obtain the user that is logged in and detect with the connection string if he is ussing Trusted connection or not.If he is not, things are the same, if he is using TC, then I use the API to obtain the logged windows user to use it with my aplication security, and the Sql-Server validate the user ok.All this using Windows XP or 2000 as client.But, this isn't working in windows 98, It looks like although I am logged in the Windows WorkGroup (not a domain) and have an administrator account, I can´t access the sql-server, it is assuming I am a guest.The question is, is there any way to obtain a the username from the Windows 98 (e.g. Administrator) and send it via the Clarion MSSQL driver to be validated as a user ?Thank you for your help." |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-11-04 : 22:53:50
|
| As far as I know, Windows 98 is not able to access SQL Server using Windows Authentication.You can not use Windows Authentication when running the server on 98 as it doesn't support it, I can only assume the reverse is true.Damian |
 |
|
|
|
|
|
|
|
Trusted connection in Sql-Server