Thanks for the reply. I actually realized the problem was that I didn't
allow the remote user to access any dbs. I gave it roles, but no access
to any of the dbs. One click solved the problem. Thanks.
And yes it was in mixed authentication mode.
At 08:15 AM 10/7/2003 -0400, you wrote:
>Won,
>
>
>IS the SQL Server configured for Mixed Authentication or for Windows
>Authentication? If the SQL Server is configured to only use Windows
>Authentication, you will not be able to use a SQL Server login,until you
>reconfigure it.
>
>
>Dave
>
>-----Original Message-----
>From: Won Lee [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, October 07, 2003 7:50 AM
>To: CF-Talk
>Subject: sql server + cf 5.0
>
>
>Hello,
>
>I have CF 5.0 installed on a Linux box.
>I have SQL server 2000 installed on my workstation.
>
>I need the linux box to be ablet o access the SQL server on my
>local machine.
>I can't seem to login to the SQL server via remote connection.
>I found
>this out because I tried to create a USER and SYSTEM DNS on the
>SQL Server
>box and it didn't connect using SQL permissions.. I was however
>able to
>create a USER and SYSTEM DNS when using Windows Authentication.
>
>Any help?
>
>
> _____
>
>
>----------
>[
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
