Re: Cannot login SQL Server with 'sa'

Michael,
Thank you very much for your help.
When I installed SQL Server 2005 initially, I use Wondows Authentication
mode. After the installation, I changed to Mixed mode. Then I setup the new
password for 'sa' and other SQL Server logins, I cannot login with any SQL
logins.

I just found out the Login properties (status) for those SQL logins ware
setup to "Disable" by default, after I change them to "Enaled", I can login
with SQL logins.

Thank you so much !!!

Kai


"Michael Cheng [MSFT]" <v-mingqc@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:g8q%235hfCGHA.3992@xxxxxxxxxxxxxxxxxxxxxxxx
> 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: System Administrator Implied Permissions
    ... >> Hi Dan, ... >> Now, given this, why does SQL Server ... However, these logins were not ... Other sysadmin role members have the ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2005 Login Problem
    ... There are two authentication method in SQL Server. ... 1- Windows Authentication ... Only creating Logins is not the complete solution of course, then you'll need to map those users to the appropriate databases and assign them roles and grant them permissons. ...
    (microsoft.public.sqlserver.clients)
  • No Application Logins Allowed - SOX
    ... I'm trying to work through an issue regarding our MS SQL Server logins. ... "Customer" application uses a login to SQL Server called "Customer" and the ... Grant our users Windows Authentication access to SQL Server. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows permissions to run Jet OLEDB 4.0
    ... in SQL Server or not when you have to go outside of the server to the ... Actually I was talking about Windows logins. ... There is no security whatsoever implemented on the mdb ...
    (microsoft.public.data.oledb)
  • Re: End User Security Administrator for a Intranet Application
    ... If you are on SQL Server 2000, ... server role can change passwords and add logins. ... >role 'sysadmin' inorder to create logins, ...
    (microsoft.public.sqlserver.security)