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 |
How to verify a login name with sqlcmd tool?
how can ur insert the emp table
How can change procedure in sql server?
What is a NOLOCK?
What types of Joins are possible with Sql Server?
How many partitions a clustered index has by default in sql server 2012?
Explain nested join?
Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?
Tell me the phases a transaction has to undergo?
What are the differences between union, intersect, and minus operators?
How to enable tcp/ip protocol on a sql server?
Can you explain various data region available in ssrs with their use?
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)