GOT IT!

OK so I emailed my boss last night to gain some insight if there was a method to the maddness that is selecting the correct collation from the menu...

I was told to make it mimic production so I would like to attempt to figure out how to get that done.

I am still sitting at the COllation Settings menu...I am remoted in from work and was hoping to get this finished before work tomorrow...it is not a priority but once...

WHen I am on the Collation Settings menu I am not seeing an option under SQL Collations that ='s Dictionary Order, accent-sensitive ONLY.

Am I looking in the wrong place? ...

That is where I am at...I am at the selection portion where you can pick the collation but the selection names don't seem to match up...

example

Dictionary order, case-sensitive,accent sensitive....

I will give that a try tomorrow or later tonight when I have a moment and report back.

Thanks for the info.

leeland

Thanks for the replies guys...I will attempt to answer all messages.

The service account DOES have rights on the application server, it is in the local Admin group.

I believe the PSEXEC...

Is there a reason that you cannot go to SP4?  Do you have any Servers that are SP4 SQL 2000 that have this issue?

That sounds like you have tried everything I could think of...last thing I could think of is what SP level are the SQL boxes and what Version?  Sorry I am...

To state the obvious here....

So you stated that you can go into services and manually start the service...but when you go into EM, and attempt to start the service it...

What is the domain\account that is used to log into the server ? (Is it the same account that is used to start both services ?)

Under SQL Server Agent -->Properties-->Connection

What...

OK thanks for the answers...

Next question, what type of account are you using to start SQL Server Agent?  Is it the same account that is used to start the SQL...

Did you recently change the password on the account that you are using to start the SQL Server Agent?

When you say "start the service manually" do you mean within Services?...

Thanks for the information it helped a lot...So with a little free time I decided to run a few tests…

I got it to work by testing it. Here...

This is EXACTLY what I needed as an explination...I see how it releates now and what I need to study to make the connections.  I haven't used binary for a long...