We're getting the following error:
A connection to SQL server is no longer usable. This could be caused by one of the following reasons:
* The server has been shut down manually or because of an error.
* The SQL server connection settings are not correct.
* A network failure has occurred.
* A hardware failure has occurred on the server or on your computer. Try to connect again later or contact your system administrator.
We tried doing the following:
You can do following
1. Open SQL Studio
2. Double clicked on the "NT AUTHORITY\NETWORK SERVICE" user under "Security / Logins"
3. Selected "User Mapping"
4. Check marked the database which neeed access to
5. Copy in "$ndo$navlistener" into "Default Schema" for selected database
6. check marked following
db_datareader
db_datawriter
db_ddadmin
We had to recreate the "NT AUTHORITY\NETWORK SERVICE" user under "Security / Logins" as it wasn't there. Inspite of doing the above steps, we're still getting the same error. How do we go about this?
