If you encounter this kind of an error message,

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

If you encounter this kind of an error message, what you need to look into to solve this problem?

[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL Server not found.
1. Check if MS SQL Server service is running on the computer you are trying to log into
2. Check on Client Configuration utility. Client and Server have to in sync.

(Continued on next question...)

Other Job Interview Questions

• As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
• What are constraints? Explain different types of constraints.
• How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
• When you create a database how is it stored?
• What is bit datatype and what’s the information that can be stored inside a bit column?
• What are statistics, under what circumstances they go out of date, how do you update them?
• Explain different isolation levels
• When you create a database how is it stored?
• What is an index? What are the types of indexes? How many clustered indexes can be created on a table? I create a separate index on each column of a table. What are the advantages and disadvantages of this approach?
• How many bits IP Address consist of?
• More...