MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
If SQL Server does start but cannot be accessed, the problem is likely to relate to what issue.
A
Network
B
CPU
C
DISK
D
None of the above
Explanation: 

Detailed explanation-1: -This issue occurs when at least one of the following problems exists: The name of the computer hosting SQL Server is incorrect. The instance doesn’t resolve the correct IP. The TCP port number isn’t specified correctly.

Detailed explanation-2: -Make sure that Allow Remote Connections is enabled on sql server properties. Check if TCP/IP is enabled. Configure to allow SQL Server in Firewall Settings. Check for working fine SQL Server Browser.

Detailed explanation-3: -Go to the SQL Server Enterprise Manager. Right click on the SQL Server instance and select Properties. In the General tab and Network Configuration window, make sure TCP/IP and Named Pipes are enabled. Restart the SQL Server service if you need to make these changes.

Detailed explanation-4: -SQL Server Error 26 occurs when users trying to connect to a SQL Server named instance. The reason of the SQL Server Error 26 is the client stack could not receive SSRP response UPD packet from SQL Browser.

There is 1 question to complete.
Previous
Next