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 |
|
danyeung
Posting Yak Master
102 Posts |
 Posted - 2008-01-21 : 11:23:25
|
| I created a login in SQL Server 2005 for SQL Server Reporting Service training purpose. It seemed the login exceed the connection limit. There were 9 people in the training and some people got the connection errors. Sometimes the connection error went away after the user re-established the connection. Is there a default limit per login? If so, what is the default? Can I change it to unlimited? And how?Thanks.DanYeung |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-01-21 : 13:01:27
|
| Put 0 in Connection ( Server properties for default) |
 |
|
|
danyeung
Posting Yak Master
102 Posts |
Posted - 2008-01-21 : 13:18:57
|
| Where do I put 0 in Connection? May I have some instruction?Thanks.DanYeung |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-01-21 : 13:24:56
|
| Go to Server Properties--ConnectionsMaximum number:0 |
|
|
|
danyeung
Posting Yak Master
102 Posts |
Posted - 2008-01-21 : 14:04:53
|
| It is 0 in Server Properties Connection tab. Do I have to set the maximum connection to 0 for the login I created for the training that I mentioned above? And how?Thanks.DanYeung |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-21 : 15:36:00
|
| What kind of connection error did you get? |
|
|
|
danyeung
Posting Yak Master
102 Posts |
Posted - 2008-01-21 : 18:25:02
|
| The error message was Login failed for user 'user1'. Error: 18456, Severity 14, State 5.Thanks.DanYeung |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-21 : 20:17:18
|
| It's bug and fixed in sql2k sp2. |
|
|
|
|
|
|
Limited connections per login?