Cannot connect to db using public user

  • Thread starter Thread starter Kin
  • Start date Start date
K

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?
 
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>
 
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>
Click to expand...
 
Back
Top