Ok.. here is something interesting.

I check my sql logs and when I tried to make a connection using : UID and PWD in my connection string. The log says that...

I added Network Service account to SQL Server. Still no result.

Any other suggestions..

Thanks.

yes,  I can map to any folder on the sql server from another server. I can run SQL Management Studio using SQL Authentication from my web server.

What I am...

I tried that as well.

 I can successfully connect to the sql box using sql tools and also able to access the folder. The only thing is that when I tried...