Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chih
Posting Yak Master
154 Posts |
 Posted - 2007-08-14 : 02:46:59
|
| Hi everyone,Is there any limitation in number of accesses for a sql login account?For example, I use one sql login account to connect between the website and db. Since I changed web server to window 2003. I got error message saying SQL Server does not exist or access denied.I then created another sql account instead of only one login account. now the website is running fine and faster than before. I really don't understand it. Can anyone please explain it?Thanks in advance! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-14 : 22:30:19
|
| There is no such limlt. |
 |
|
|
chih
Posting Yak Master
154 Posts |
Posted - 2007-08-15 : 00:09:45
|
| We use odbc to access ms sql2005. the connection string in ASP is like Set Conn = Server.CreateObject("ADODB.Connection")Is there any limitation in number of connection? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-15 : 22:31:11
|
| Did you set limit in connection pool? |
|
|
|
chih
Posting Yak Master
154 Posts |
Posted - 2007-08-15 : 22:43:20
|
We use ASP not ASP.Net.I am not a programmer. Do we also use pool in ASP? What is the limit?quote:
Originally posted by rmiao
Did you set limit in connection pool?
|
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-15 : 23:02:15
|
| I'm not programmer either, so don't know details. |
|
|
|
askben
Starting Member
8 Posts |
Posted - 2007-08-17 : 23:27:15
|
| Connection pools are based on the connection string, so it is possible that you ran out of connections in the pool, but it would not be very likely since you got an access denied.Not sure what you ran into, but there no limit to how many times a login can access SQL Server.------------Ben Miller |
|
|
|
|
|
|
Sql login account accessing limitation