Lets say due to N/W or Security issues client is not able to
connect to server or vice versa. How do you troubleshoot?



Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How d..

Answer / guest

First I will look to ensure that port settings are proper on
server and client Network utility for connections. ODBC is
properly configured at client end for connection ??Makepipe
& readpipe are utilities to check for connection. Makepipe
is run on Server and readpipe on client to check for any
connection issues.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is the sql case statement used for?

0 Answers  


can a database be shrunk to 0 bytes, if not, why? : Sql server administration

0 Answers  


Explain some stored procedure creating best practices or guidelines?

0 Answers  


What are various limitations of the views?

0 Answers  


which table keeps the locking information? : Sql server administration

0 Answers  






What should we do to copy the tables, schema and views from one SQL Server to another?

3 Answers  


How to make a remote connection in a database?

0 Answers  


What is the data type of time?

0 Answers  


what are defaults? : Sql server database administration

0 Answers  


What is attribute hierarchy? : sql server analysis services, ssas

0 Answers  


Explain subquery and state its properties?

0 Answers  


Why the trigger fires multiple times in single login?

0 Answers  


Categories