Cannot connect to db using public user

[Kin]

Pls Help

I open a connection to remote sql server

Connection String:
Provider=SQLOLEDB.1;User Id='user';Password='pwd';Initial
Catalog='database';Data Source='remoteServer,port'

when user is public user, the iis always return error, with script timeout
but when user is 'sa' or 'dbo', iis return the right result to me


can anyone explain what problem i have?

 

[Michael Nemtsev, MVP]

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>

 

[dogkin via DotNetMonster.com]

Dear Michael,

Sure.
I have test the user right from Query Analyzer.
the public use can access the DB and select / update tables that allow.

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>