Access SQL server from diffrent domains.

[amardesai2005]

If anyone knows the answer to this I will really appreciate.

I am on domain Name A
I have SQL Server sitting on domain A
I have IIS Server sitting on domain A

I have intranet application running fine. All our intranet application users are from domain A.

Now we have two new users from diffent domain name B and they can visit the website but they are not able to connect with sql server from ASPX code.


Cnn=Server=SQLD2V;database=Test; user id=yyy passorr=zzz
SqlConnection objConnection = new SqlConnection(Cnn);

objConnection.Open(); ---- when it try to open connection from Domain B it get stuck. No Error message display. This code work fine if any user come from domain A.


I am using SQL aunthatication in my code, Authantication mode in IIS has Anonymous access,

Is anyone please advise me what should i do.

Thanks
AD

 

[dvannoy]

instead of the server name use the ip address.

http://www.connectionstrings.com