Hi Lynn,

He was expecting about the log full error.

Thanks 🙂

Hi Lynn,

He was expecting about the log full error.

Thanks 🙂

Hi Lynn,

He was expecting about the log full error.

Thanks 🙂

Hi Lynn,

He was expecting about the log full error.

Thanks 🙂

Sure Gail!

Thanks once again.

Hi Gail,

The Article was simply awesome. Thanks so much man!

Abhay, thanks once again my friend!

Hi Paul,

Am new to SQL Server Adminsitration. I was trying to know how to dismantle things and how to construct things when something happens.

It was just my personal interest!!!!!:-)

Thanks Guys!...

Yaah! u r right!!!

We should know the what error msg sql server is giving.

Thanks!

Finally, we won the battle 🙂

sorry that was my bad.

Thanks for figuring it out.

Thanks Bud:-)

Kalyani,

Pl find the attached screen shots which show my network configuration.

Is there anything which need to change the order. If so, pl suggest.

Still the error persists!!!

steps : enable local and Remote connections

using TCP/IP and Named Pipeds

2. Restarted my SQL Server

3. tried to connect using Sqlcmd but failed.

C:\>

C:\>sqlcmd -SMAHESH$SQL_02 -E

HResult...

Here is my machine details:

But how would these help me in fixing the above error??????????

select @@servername

-- output : MAHESH\SQL_01

select serverproperty('instancename')

-- output : SQL_01

I am having only one instance i.e one named instance running on my machine.

Hi, That's just my curiosity!

I am new to SQL Server 2005 and Administration.

The Question was struck in my mind and that's how!!!