Re: Why do I have to enable File and Printer sharing to connect through the XP firewall?

I was not aware of that. I am using mixed mode authentication.

That is a server-side setting. What matters is how the client tries to connect. IS the client connecting using a Windows account or using a SQL Server account?

For Windows authentication, SQL Server need to enumerate the SIDs for the account you pass with Windows (DC). The client should be able to connect using TCP/IP Sockets, assuming the client user has logged into the AD in the first place. If not, I assume that some AD validation is attempted when the login to SQL Server is performed. (But I admit that AD is far from my expertise...)

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Keith" <keith@xxxxxxx> wrote in message news:O782RHJ9HHA.2004@xxxxxxxxxxxxxxxxxxxxxxx

"Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx> wrote in message news:4F9AE0A4-4F1B-462E-AD9B-3C840072AC33@xxxxxxxxxxxxxxxx
Perhaps the connection is made using Named Pipes? I'd use cliconfg.exe on the client to verify that TCP/IP (sockets) is selected higher than Named Pipes. Sockets shouldn't require anything else but the TCP port. Unless you are trying a Windows logins, of course. Also, since you specify the port in your connection string, you shouldn't need the SQL Server browser service on the server (unless it is needed for other purposes, of course).


Tibor,

Thanks for the reply. Could you clarify what you mean when you said "Unless you are trying a Windows logins, of course." Are you saying that Windows Authentication/Mixed Mode uses Named Pipes to communicate with the domain controller? I was not aware of that. I am using mixed mode authentication.

Thanks!

Keith


.

Relevant Pages

  • Re: VS2005: SQL Debugging "T-SQL execution ended without debugging. You may not have sufficient
    ... > account also must be a member of the sysadmin role in the target SQL ... and the Windows firewall is disabled on both client & server. ... to the remote SQL Server 2005. ... But I'm still getting the "T-SQL execution ended without debugging. ...
    (microsoft.public.vsnet.debugging)
  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Utter madness!
    ... It is just Windows security stuff. ... You can get a trusted connection back to SQL server. ... ASP.NET account (either processModel or app pool identity depending on ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Passthrough authenication w/ SQL trusted connection
    ... separate connection will be used for each security context (each user ... account will have it's own pool). ... if you are using a Windows 2000 Domain, ... backend SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Search services not available
    ... Let me clarify that our SQL server uses Windows Authentication, ... account, even if it was just for now to get it working, that would be easier ... I have configured the Search service to use this ...
    (microsoft.public.sharepoint.windowsservices)