tutaro.blogg.se

Keping CMD open, open a new CMD as an administrator and navigate to your SQL server instance folder (mine is: C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn) and run the following command to increase instance memory to 4GB:ĮXEC sys.sp_configure 'show advanced options', 1 ĮXEC sys.sp_configure 'min server memory', 1024 ĮXEC sys.sp_configure 'max server memory', 4096.

Check if TCP/IP is enabled, and s ahead of the Named Pipes in the settings Check if Named Pipes protocol is enabled 3. Check if Shared Memory protocol is enabled 2. Typically, to troubleshoot this, you go to SQL Server Configuration Manager (SSCM) and: 1. I hope this will work for others as well. Only one user was able to connect with the SQL server. You can got this error for the reason that the user connections was reset to 1. Open MSSMS and run the command below: sp_configure 'show advanced options', 1 If your default database other than master, You need to revert to master. More commonly this issues seen when the default database will be offline or not exists.