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

I assume Windows account since I'm not passing any user/pw information in the connection string.

Then I assume you say something like "Integrated security = true", or "trusted connection".


The user(s) are already members of the domain. In this particular instance, the user is me and I'm a domain/olap admin.

If you have logged on to the domain, then ti sould work fine over the TCP/IP netlib.


BTW I looked for "cliconfig.exe" so I could check the client-side configuration and didn't find it anywhere on my machines. What package/app installs it?

It is cliconfg.exe, not cliconfig.exe. It is part of Windows.
--
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:e7Bo6gM9HHA.4784@xxxxxxxxxxxxxxxxxxxxxxx

"Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx> wrote in message news:E402B142-E357-4124-A897-43E4D1747848@xxxxxxxxxxxxxxxx
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?

I assume Windows account since I'm not passing any user/pw information in the connection string.

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...)

The user(s) are already members of the domain. In this particular instance, the user is me and I'm a domain/olap admin.

BTW I looked for "cliconfig.exe" so I could check the client-side configuration and didn't find it anywhere on my machines. What package/app installs it?

--
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: Connecting using Windows Authentication
    ... You would use the following to authenticate using Windows NT integrated ... > Dirk - the connection string looks like this: ... > the SQL Server provider is expecting something to let it know how to log ...
    (microsoft.public.access.modulesdaovba)
  • Re: SQL open error
    ... I wish to use Windows authentication rather than supplying ... in Enterprise Manager reads as. ... Source=localhost in my connection string I get the error ... "SQL server does not exist or access denied". ...
    (microsoft.public.dotnet.general)
  • Deployment issue - Error 26
    ... The target environment is a dedicated server running SQL Server 2005 Standard ... and client machines running the VS2005-developed code on Windows XP. ... testing looked OK after changing the connection string in the app config file. ... It built a connection string and stored it in the Project settings for the data ...
    (microsoft.public.dotnet.framework.adonet)
  • SQL Server does not exists... Yada, yada, yada
    ... Machine running ASP.Net is either a Window 2000 Pro or Windows XP Pro ... running SQL Server 2000. ... The DLL knows how to find it's own connection string from ... domain users account, and whilst running under the local system ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: One Connection String for Multiple Users (SQL)
    ... Hitchhiker’s Guide to Visual Studio and SQL Server ... "William Vaughn" wrote: ... This uses the> same connection string for all instances of the application. ...
    (microsoft.public.sqlserver.connect)