1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / guest


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

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

Post New Answer

More SQL Server Interview Questions

What is model database? : SQL Server Architecture

0 Answers  

How do you connect 100 files as a flat file sources in one package of SSIS?

2 Answers  

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

0 Answers  

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

1 Answers   Logitech, Mphasis,

When would you use sql joins?

0 Answers  




What is scalar user-defined function?

0 Answers  

What is Trigger?

3 Answers   Misys,

How to get @@error and @@rowcount at the same time?

0 Answers  

How to divide query output into multiple groups with the group by clause in ms sql server?

0 Answers  

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

0 Answers  

What are indexes? When do you need to create Indexes?

4 Answers   CarrizalSoft Technologies, HP,

How to get the number of affected rows?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories