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 are the operating modes in which database mirroring runs?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
What is checkpoint in sql server?
What is the difference between set and select?
What is the function of sql server agent windows service?
What is sorting and what is the difference between sorting and clustered indexes?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
Write a SQL query to delete a table?
What samples and sample databases are provided by microsoft?
What are the advantages of having an index on the sql server?
Explain the working of sql privileges?
What is the difference between for auto and for nested?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)