At this point, I'm scratching my head. The system is handling authentication just fine... this would seem to indicate that there's a potential problem with SQL Server, one I've not...

The SQL Server computer account is what may be fried. This is just a stab. When I say administrator, I mean the Windows administrator account.

You know, before going down that...

Query Analyzer connects to a server and you specify a database. A data source is in ODBC. Are the databases the same?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL...

It might be possible with other vendors.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

We typically say Microsoft Sequel Server but on the other side it is My Ess Que El. Both ways are considered valid.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to...

That's adaptive format and Microsoft varies on whether or not a test is in adaptive format. Check at http://www.cramsession.com/ to see what the most recent version of the test are.

K....

Within T-SQL, I would get a sev 16 error and that would be all she wrote. I ended up putting ADO code in a DTS package. That's one option.

Another option...

Removing a node only handles the physical node. The cluster is still intact in that case, just running on a single physical node (I think some refer to this as...

Have you run a DBCC CHECKDB() on JDE_Production?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

You always have the option attacking this via other methods:

1) In Windows 2000, you can set the service to restart itself (services.msc). This is the easiest approach.

2) You can have...

Yup, sure have. And I've been in this position as a systems administrator with responsibility over the enterprise no authority. That's just as bad.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish...

1) Check to make sure users are logging into the domain, not using an account on their local system. The problems you describe (so far as user logins) happen when...

Triggers on system tables are unsupported, so that's really not an option. Scheduling a job that checks for the existence of the role and adds it if it's missing is...

Undocumented DBCC commands are in an article by Alex Chigrik:

http://www.mssqlcity.com/Articles/Undoc/SQL2000UndocDBCC.htm

It includes the -1 flag for DBCC LOG() but doesn't detail anything more than what you've already seen here.

K. Brian Kelley

http://www.truthsolutions.com/

Author:...

What database does the DSN point to? Is it the same as the one you are pointing to in Query Analyzer?

Either the data source has to be configured to...