Welcome to ISAserver.org

Sql Windows Authentification

Users viewing this topic: none

Logged in as: Guest

Printable Version

All Forums >> [ISA Server 2000 General] >> Server Publishing >> Sql Windows Authentification

Page: [1]

Message

<< Older Topic Newer Topic >>

Sql Windows Authentification - 8.Oct.2003 3:48:00 PM

0911cwaddell

Posts: 7
Joined: 26.Aug.2003
From: Frankfurt Germany
Status: offline

Hi all
I am aware that it is possible to use intigrated windows authentication when publishing a internal webserver so that the user must be a valid Windows 2000 DOMAIN account to log onto the web resources. The situation I am faced with is similar but a little bit more complex.I have a IIS DotNet web app running on a public IP webserver (IIS 5.0) which uses a SQL2000 datasource which is behind an ISA FW. The connection is made to the Data source through a ADO DotNet connection object. It is recommended by Microsoft not to use the old SQL authentification but to use a Domain user account for the connect to the DB. This works fine on a trusted internal network. My question basically is there a similar publishing process for SQL2000 which allows external clients or in this case applications to authenticate using Windows Intigrated Authentifation through the ISA FW

Thanks in advance

Chris

Post #: 1

Featured Links*

RE: Sql Windows Authentification - 8.Oct.2003 4:22:00 PM

aselicean

Posts: 260
Joined: 7.Dec.2002
From: Romania
Status: offline

Hi Chris

I am facing the same dilemma as I need to publish a SQL Server for replication with mobile devices. The SQL documentation I have (SQL Books Online) states that Integrated Authentication is not passing thru firewalls.

I am not so experienced with .net, but I remember seeing something that might help.

In the connection string you have to put something like:
--- taken from MSDN April 2002 -------
Provider=SQLOLEDB.1;Data Source=MySQLServer;Initial Catalog=NORTHWIND;Integrated Security=SSPI
--- end ------------------------------

If you have MSDN Apr2002 edition, look for
ms-help://MS.MSDNQTR.2002APR.1033/vbcon/html/vburfIntroductionToADOConnectionDesignTools.htm

Hope this will put you on the right track.

Maybe your programmers might help you further with this.

HTH,

[ October 08, 2003, 04:23 PM: Message edited by: Alin Selicean ]

(in reply to 0911cwaddell)

Post #: 2

RE: Sql Windows Authentification - 8.Oct.2003 6:25:00 PM

andre@freaking.info

Posts: 68
Joined: 23.Sep.2003
From: New York
Status: offline

You should use either an SQL Server authentication, or make a trusted connection between your web server and SQL Server. In either case you should open additional ports on the ISA (1433 in the first case, and Netbios in the second case). I don't think it would be a secure config in both ways.

Andre.

(in reply to 0911cwaddell)

Post #: 3