Very Computer

--
Neil Boyle
--
www.impetus-sql.co.uk - Free SQL Server online handbook

Quote:> I am trying to submit data from an ASP web Page to SQL Server.
> I have IIS 4 and SQL 7 running on 2 different machines. I have read a few
> articles but not gotten it. I suspect it has to do with authentication on
> the IIS machine. If anyone knows about this please help me out and thanx
in
> advance.
> Terry

Quote:>I am trying to submit data from an ASP web Page to SQL Server.
>I have IIS 4 and SQL 7 running on 2 different machines. I have read a few
>articles but not gotten it. I suspect it has to do with authentication on
>the IIS machine. If anyone knows about this please help me out and thanx in
>advance.

1) Use the SQL Server Client Network Utility to set the default network
library to TCP/IP and ...

2) You use SQL Server authentication instead of NT authentication. To do
this, you need to set the connection string of the ADO Connection object
to something like ...

driver=sql server;server=NNN;database=DDD;uid=XXX;pwd=YYY;

Where NNN is the IP address of the machine running the SQL server, DDD
is the database you want to use and XXX and YYY are the SQL Server uid
and password.

Hope this helps.

--
Alan Silver
Please remove the "*ferret" if replying by e-mail