Re: Cannot login SQL Server with 'sa'

Hi Kai,

This issue occurs because SQL Server Management Studio cannot correctly
report the error when the maximum number of concurrent connections has been
reached.

To work around this issue, you can use the sp_configure Transact-SQL
procedure to increase the maximum number of concurrent connections. You can
also manage the instance of SQL Server 2005 in other ways. For example, you
can use the sqlcmd utility.

To use sp_configure to increase the maximum number of concurrent
connections, follow these steps:
1. Click Start, click Run, type cmd, and then click OK.
2. At the command prompt, type the following command, and then press ENTER.
sqlcmd.exe -E -S servername
3. When you successfully connect to the instance of SQL Server 2005,
execute the following Transact-SQL statements at the SQL Server prompt.
sp_configure 'user connections', <NewNumber>
Go
Reconfigure
Go

4. Restart the SQL Server service for the change to take effect.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages

  • Re: simple collaboration enable ?
    ... throttling on more than 5 concurrent connections). ... I too like him would go for SQL Server 2K in a WSS production site, ... > I have WSS with WMSDE and create a site for Human Resources. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: SQL Server 2005
    ... procedure to increase the maximum number of concurrent connections. ... When you successfully connect to the instance of SQL Server 2005, ... I have an application that requires an database to be installed on the ...
    (microsoft.public.sqlserver.setup)
  • Re: Number of allowed connections for SQL Server 2005 Standard on
    ... XP just isn't geared for the types of work that SQL Server ... If you have 30 concurrent connections I would not call that ... I can put as much memory and storage space as I ... If that OS is XP Pro, how many concurrent connections can SQL Server ...
    (microsoft.public.sqlserver.connect)
  • Re: User License for sql Urgent!!!
    ... the command which u gave didnt work in SQL Server 7 ... for product Sql Server 7 ... does this 255 concurrent connections means 255 user ... >> How can we know as to how many user licenses we are ...
    (microsoft.public.sqlserver.server)
  • RE: 6.5: Kein Start nach falscher RAM-Größe für tempdb
    ... wirf mal einen Blick auf den KB Artikel 307487. ... and then start SQL Server by ... Stop SQL Server by pressing Ctrl-C at the command prompt window, ... | Server nicht mehr gestartet werden, ...
    (microsoft.public.de.sqlserver)