December 30, 2008 at 12:29 am
hi,
My server name is =TFSRTM08\SQLEXPRESS
when I tried to login in windows its working fine....but
when I used sql server authentication when I gave login =sa and
password=123 .here I configured sa properties and password ..it shows errro:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (.Net SqlClient Data Provider)
Thanks
Dastagiri.D
December 30, 2008 at 3:37 am
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.
Please refer this link for more info, http://www.ureader.com/message/2671598.aspx
[font="Verdana"]- Deepak[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply