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 / 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 |
What is the sql case statement used for?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
Explain some stored procedure creating best practices or guidelines?
What are various limitations of the views?
which table keeps the locking information? : Sql server administration
What should we do to copy the tables, schema and views from one SQL Server to another?
How to make a remote connection in a database?
What is the data type of time?
what are defaults? : Sql server database administration
What is attribute hierarchy? : sql server analysis services, ssas
Explain subquery and state its properties?
Why the trigger fires multiple times in single login?