Thanks everyone for responding to my question.

I will try to be as honest as possible here . As always I was on and off my goal. Few days I...

THANKS FOR TRYING TO HELP. i GREATLY APPRECITE IT. i COULD RESOLVE THIS PROBLEM.

I was not refereing the named instance server properly.

Instead of refering it as 123.XXX.XXX.XXX\MachineC, I was refering...

Machine C is a named instance. However the default instance does not exists any more on the machine.

The configuration manager has info only for the named instnace and not for...

I am good in sql server 2005. Conisdering the new version , I thought If I can update my knowledge on sql server 2008 , I stand a better chance...

No one wants to sahre their opinion...???;)

Winston Smith,

I wont be able to comment on other suggestions of yours as i have not taken exam yet. However of your following suggestion

"6. Designate yourself a timeframe. If you...

Thanks everyone for tips and links.

I did go through the links ...they appear very easy...either my preparation is good or easy questions could have been posted online.

One interview can change...

Yup i do know sql server..!!!:P

I am preety confident on the DBA concepts...but considering the company that is interviewing i am kind of anxious to know what could be asked...!!!!

Can...

Thanks a ton for responses and i apologize for being so late in responding.

Here comes a brief introduction about my job...

I am the only developer and i maintain web(asp.net and...

You response "I could be looking in different datatabse is soo funny".

However, i have made all kind of checking..to make sure i am not making any mistake in copieing/checking right...

Thanks for the response...here is the error message..

"Timeout expired. The time out expired prior to optaining connection frm the pool.All pooled connections were in use and max pool size was...

Thanks everyone for all the suggestion. May be i was looking problem at a wrong place.

I have an ASP.net application which sues SQL server 2005. After some time of its...

You are right...motivation is purley personal.I am trying my level best.

I work in an envirnment where in i am the only deveoper while non in my offcie know abcd of...

"Designate yourself a timeframe. If you dont, you will keep putting it off and you will have forgotten stuff you learned in the beginning ( if your not using it...

Thanks everyone for suggestion...here is what had happend..

I did update/checked security.etc..but din't help...

I have 2 instance of sql server running(2000 and 2005). Accidently while making some changes i had defined...