Re: SQL Server auth requires OS auth?

From: Becker (ben_at_benbecker.net)
Date: 07/28/04 

Date: Wed, 28 Jul 2004 08:03:41 -0500

Kevin,

I think my confusion goes a little further. I have not loaded a sql client
on this machine, therefore isql won't work. I thought by default if I
didn't load a sql client it would use TCP/IP? It would appear that the
problem I'm getting is it using named pipes. How do I configure this
machine to use TCP IP? I don't want to authenticate to the OS.

Thanks,
Ben

"Kevin McDonnell [MSFT]" <kevmc@online.microsoft.com> wrote in message
news:lleNZBDdEHA.2972@cpmsftngxa10.phx.gbl...
> Hi Ben,
> Standard Security won't require NTLM auth as long as you can establish
a
> session with the box. For Named Pipes connections you'll need to be able
> to setup an IPC session which would require the ability to enumerate
shares
> on the machine.
>
> So the command "net view \\serverNameHere"
> should return a list of shares. Otherwise, Named Pipe connections will
> fail. You also need permission to "Access this computer from the
network".
>
> With TCP/IP you just need to be able to resolve the netbios or host name
> and establish a tcp session.
>
> Validate you can connect with TCP using the following syntax:
>
> ISQL -SserverNameHere -Uuserid -Ppasswordhere
>
> If it fails, it will return an OS error for the failure. Use this number
> to understand why it is failing.
>
>
> Thanks,
>
> Kevin McDonnell
> Microsoft Corporation
>
> This posting is provided AS IS with no warranties, and confers no rights.
>
>
>