September 15, 2004 at 10:46 pm
Hi
I have got a typical situation . My IIS is running on BDC say sqlserver2 while the data base in PDC sql server1. Both are NT boxes and SQL version is 2000. Sql uses windows authentication .Will it be possible for me to connect from an asp page on sqlserver2(BDC) to sqlserver1(PDC).I prefer WinNT challenge bar response site authentication
Regards
john
September 16, 2004 at 4:31 am
for using the trusted connection, just leave the user id and password from the connectionstring parameter (not even mentioning it). It will automatically uses trusted connection to connect to the sql server. make sure that both IIS and SQL Server are in the same domain and IIS user name (IUSR_) is authenticated in your sql server.
September 17, 2004 at 9:22 pm
I agree .
I have few doubts regarding this
First of all if my domain is DOM1 then how shall I do this in sqlserver1 running in PDC ,
sp_grantdbaccess ‘DOM1/iusr_sqlserver2’ will work .But in my case its not working and
with sp_grantdbaccess ‘iusr_sqlserver2’ it fails to connect to db.
One more ,
If I am doing like this means I have to give other privileges (SELECT,…)also to iusr_sqlserver2 correct ?
john
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply