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
What is equi join with example?
What are the acid properties?
What is deploy, process and build? : sql server analysis services, ssas
What is 3nf normalization form?
What is your recommendation for a query running very slow? : sql server database administration
Do you have any idea about the tcl commands?
Define candidate key, alternate key, and composite key.
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What is a synonym for manipulation?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
Tell me about the approaches which you used to counter the DI problems.
What is data block and how to define data block size?
What is the use of for clause?
Is truncate autocommit?
How to create an identity column?