You are in a seriously difficult situation. As the DBA, you're held accountable for the condition of the company's databases and yet any employee can do anything to the data....

When I worked there, all indexes on all databases were rebuilt every night.

Thank you both for your responses.

LC

Thanks for your response. I'm not sure why what you suggested will work but I'll do it.

And thanks for the reminder about fragmented indexes. I intend to rebuild all of...

I have the same problem. Everything is so running so smoothly that I may have worked my way out of a job. So, I've been thinking of valuable projects to...

I have to agree that in recent memory, the questions posted have become too fundamental and/or too inane. My observation is that, probably, in hard economic times, some very senior...

Gift,

There is no AV on the server.

An associate and I have shut down firewalls on my computer and the server to attempt to connect. This did not work, either....

No, Gift, that is not the problem. The "sa" account is enabled and mixed authentication was selected during installation. It is still selected.

LC

Craig,

I am using port 1433 on both instances, addressing them by name (they are the default instances on their respective machines), and attempting to use SSMS to connect. The machines...

Gift,

Thank you for your suggestions. I installed IIS and verified MS Server 2003 SP2 but to no avail.

I still cannot connect the servers even though both SQL Browsers can...

Thank you for all of your additional comments. I'll file them in my DBA memory banks for future use.

Sincerely,

LC

Thanks, guys.

LC

Tony,

I am starting to see a lot of job requirements listings like this for DBAs, system admins, and software developers.

We know, and some managers know, that no one has all...

Steve,

The Atkins diet changed my life, my relationship with and need for food, my health, my metabolism, my blood pressure, and my weight, all for the better.

I've been...

As a 24 year software developer moving into the DBA role, I was impressed with your solution, and your understanding of the problems.

I couldn't agree more about the need to...

This seems so fundamental that I almost think I shouldn't mention it but I will anyway.

When designing a database, its indexes, and the queries that access it, do everything you...