I would suggest that you get rid of ODBC and use OLEDB instead. Much more secure, much faster and by far more reliable.

ODBC died in the 1980's

Andrew SQLDBA

I worked for a company not long ago, and I was the only SQL DBA there. I had many servers with many databases on some, and only a few to...

It is. I have checked everything in every place that I know of, or can think of.

I have compared this one that does not work, with one that does work,...

What has been changed on your box?

I would probably just uninstall SQL and install it again on your box. That would be the less trouble some thing to do.

Andrew SQLDBA

Ok, that is a box name\instance name? Is your network cable plugged in? Have you authenticated on to the network?

Are you sure that the box has a named instance?

Can you...

Ok, you should be able to log into your own box. If the service is running and you have installed all the tools.

What are you using to log into your...

So what box are you on? The services that you just showed, are those from your box?

Who installed SQL on the box that you are using? That is what I...

Jeff

If you are changing the values often, I would suggest that you use a SQL Table, and build a simple web page to be able to view or modify the...

Are all the SQL Services running? Are you on a network that has other SQL Servers?

Andrew SQLDBA

sp_msforeachtable

Look at this system stored procedure in the SQL BOL

I would create a stored procedure that uses an input parameter to make this really flexible.

Andrew SQLDBA

I don't remember it, even from 4.2

You get the jest of how to configure the SQL Service accounts.

Andrew SQLDBA

Since it is NOT a SSIS Server, then why are you storing all those SSIS packages in the MSDB database?

Remove them, that will free up a few Gigs of...

Time to purchase more. Drives are cheap. How mush is this problem costing you?

with all the time wasted on here, you could have already paid for many drives by now,...

Have you thought about moving the MSDB database to a different drive?

That would solve all your problems. A drive with a lot more space.

Andrew SQLDBA

That does not even make sense. I think that you have been mis-guided about what the Transaction Log is and does.

Read the Books Online about the Transaction Log.

Andrew SQLDBA