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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

522


What do you mean by acid?

580


What do you understand by triggers and mention the different types of it?

488


What are information schema views?

559


what happens on checkpoint? : Sql server database administration

511






What is a database table?

527


Why I am getting this error when dropping a database in ms sql server?

596


Write a SQL query to delete a table?

657


Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

522


What are the rendering extensions of ssrs?

105


What are the dmvs?

575


What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

577


where can you add custom error messages to sql server? : Sql server administration

585


Mention the command used to rename the database.

536


What is the usage of sign function?

598