I SQL2008 database as the data source to develop a commodity enters sells saves the software, but recently in a software use units often appear in the configuration manager is SQL2008 SQL SERVER (MSSQLSERVER) and SQL SERVER (MSSQLSERVER) agent in the computer after the interruption, the user cannot use software,
I have set the two startup mode in advance to automatically, but also a dropped after the computer connection,
Check SQL Server error log, locating the exception occurs before, during and after the point in time to see detailed information display abnormal:

The Server is listening on [' any '& lt; ipv6 & gt; 1433].
Server is A self - generated certificate was successfully the loaded for encryption.
. .

Respect to computer expert advice, what is the reason? How to solve? Be very grateful!

CodePudding user response:

Look at the computer log, what is the error message

CodePudding user response:

As February moderator say, see the Windows event viewer inside relevant error log,
In addition, the port from 1433 to the other (such as: 8888) and have a look

CodePudding user response:

How to change the port from 1433 to other "(such as: 8888)"? Please inform us the operation steps, please guide, be obliged!

CodePudding user response:

Change the port, or every time you and see if it is not running after the restart