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
Which language is supported by sql server?
What is checkpoint in sql server?
explain different types of cursors? : Sql server database administration
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
How does Report Builder support Analysis Services cubes?
how to avoid cursors? : Sql server database administration
Where is my database stored on the hard disk in ms sql server?
Difference between Sql server reporting services and Crystal reports?
How many types of functions are there in sql server?
How to write a query with a full outer join in ms sql server?
How to delete existing triggers using "drop trigger"?
What are scheduled tasks in sql server?
What is the rdl file?
What's new in sql management studio for sql server? : sql server management studio
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?