Gail - Just to be clear. This is what I'm trying.

C:\Program Files\Microsoft SQL Server\100\Tools\Binn>sqlcmd -E -S .\injest -A -Q"alter login [sys-admin] with name = sa"

Fix the database ownership (set the db owner to sa) then repair the installation or reinstall the patch.

How can I fix the DB ownership if I cannot log in to...

C:\Program Files\Microsoft SQL Server\100\Tools\Binn>sqlcmd -E -S .\injest -A

HResult 0x274D, Level 16, State 1

TCP Provider: No connection could be made because the target machine actively refused it.

Sqlcmd: Error: Microsoft SQL Server...

Yes but in order to fix the DB owner I need to utilize sqlcmd.

sqlcmd -E -S .\myinstance -A

This part is failing. With this failing I can not...

This is the named instance. I am running that from within the directory.

I attempted to use the following

sqlcmd -E -A -Q"alter login [sys-admin] with name = sa"

It not making the connection to the SQL instance.

I attempted to use the following

sqlcmd -E -A -Q"alter login [sys-admin] with name = sa"

It not making the connection to the SQL instance.

Yes. I also went into the directory of the instance and double clicked the sqlcmd icon. I get a black screen then just disappears. I really appreciate...

The net start command worked fine with the aforementioned switches but when I attempt to start sqlcmd it does not start. It acts like it doesn't exist.

C:\Program Files\Microsoft SQL...

sqlcmd does not start for the 2008 instance. starts fine for the 2005 instance. is there anywhere I should check to see why this is not starting?

Let me give it a shot. Thanks! I'll update in a few.

This is resloved. Thanks to @SirSQL 😀

The problem why I can't use the Pivot function requires the value to be an aggregate function..these are strings.

The issue is the code needs to be dynamic as it relates to column 2 (values 64, 65 in this example)

Thanks for all your help!

My apologies, I didn't have that information either. Thank you for the reply.