Hello Kin,

Does you public user have access to DB for reading?

---
WBR,
Michael  Nemtsev [.NET/C# MVP] :: blog: http://spaces.live.com/laflour 

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo

K> Pls Help
K>
K> I open a connection to remote sql server
K>
K> Connection String:
K> Provider=SQLOLEDB.1;User Id='user';Password='pwd';Initial
K> Catalog='database';Data Source='remoteServer,port'
K> when user is public user, the iis always return error, with script
K> timeout but when user is 'sa' or 'dbo', iis return the right result
K> to me
K>
K> can anyone explain what problem i have?
K>