Re: windows authentication from web servers

From: Don Grover (dgrover_at_assoft.com.au)
Date: 01/03/05 

Date: Mon, 3 Jan 2005 17:09:45 +1100

"Hassan" <fatima_ja@hotmail.com> wrote in message
news:e1qbYUV8EHA.1292@TK2MSFTNGP10.phx.gbl...
> If we use Windows authentication only for our SQL servers, how do we
> authenticate from the IIS Web Servers ? Do I need to logon to all the Web
> Servers with a particular domain account that has a account created in SQL
> ?
> Or are there other ways ?
>
>

If in same domain use prot: Named Pipes with Win Authentication
If across internet use prot: TCP/IP with sql username/password from each web
server.
Examples below.

  'Use Named pipes connection to database
  oConn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" &
sDBUserName & ";Password=" & sDBPassword & ";Initial Catalog=" & sDBCatalog
& ";Data Source=" & sDBServer & ";Network Library=DBNMPNTW;Use Procedure for
Prepare=2;Auto Translate=True;Packet Size=4096;Application
Name=CMDExecute;Workstation ID=" & sUserConnected & ";Use Encryption for
Data=False;Tag with column collation when possible=False"

  ' use Winsock as transport protocol
  'oConn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" &
sDBUserName & ";Password=" & sDBPassword & ";Initial Catalog=" & sDBCatalog
& ";Data Source=" & sDBServer & ";Network Library=DBMSSOCN;Use Procedure for
Prepare=2;Auto Translate=True;Packet Size=4096;Application
Name=CMDExecute;Workstation ID=" & sUserConnected & ";Use Encryption for
Data=False;Tag with column collation when possible=False"

  ' use Multi Protocol as transport
  'oConn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" &
sDBUserName & ";Password=" & sDBPassword & ";Initial Catalog=" & sDBCatalog
& ";Data Source=" & sDBServer & ";Network Library=DBMSRPCN;Use Procedure for
Prepare=2;Auto Translate=True;Packet Size=4096;Application
Name=CMDExecute;Workstation ID=" & sUserConnected & ";Use Encryption for
Data=False;Tag with column collation when possible=False"

Regards
Don Grover

Relevant Pages

  • An issue with SQL 2005 and Kerberos...
    ... I am having trouble getting SQL 2005 to authenticate using Kerberos. ... Regardless of what I try the authentication always goes through NTLM. ... We have a test domain setup with a substantial amount of servers. ... all the connections from these SharePoint servers to the SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: An issue with SQL 2005 and Kerberos...
    ... Regardless of what I try the authentication always goes through NTLM. ... We have a test domain setup with a substantial amount of servers. ... I tried removing IIS from the equation and tested connecting from one SQL ... I checked in the cluster administrator tool and Kerberos ...
    (microsoft.public.sqlserver.security)
  • Replication and Windows login
    ... Does the administrator windows login name and password of all servers ... participate in replication must be the same?, or may I use the SQL ...
    (microsoft.public.sqlserver.server)
  • Re: How can I avoid using SQL Authentication with the Office Web Parts?
    ... authenticate via another authentication protocol to the backend ... SQL server. ... We are using Office Web Parts on several Web Part pages to display data retrieved from a SQL Server ...
    (microsoft.public.office.developer.web.components)
  • Re: How can I avoid using SQL Authentication with the Office Web Parts?
    ... authenticate via another authentication protocol to the backend ... SQL server. ... We are using Office Web Parts on several Web Part pages to display data retrieved from a SQL Server ...
    (microsoft.public.inetserver.iis)
Quantcast