The port change has to be made on the SQL Server itself not on the client side. Then the clients have to set up the ODBC connection to that port....

You've looked at the job logs, but have you checked the Windows Event Logs? Sometimes they give additional error information, especially if the problem is caused by the OS and...

Also, instead of the Administration forum, scroll down and check out the Certification forum.

-SQLBill

I don't believe you can get the data back. Transaction log backups (and differential backups) must be applied to the FULL BACKUP made prior to them. Had someone made a...

I don't know about other readers, but I'm kinda confused.

I get these two:

1. You have SQL Server Personnal Edition on your home computer.

2. You have Enterprise Manager on your...

By data modification, I mean ANY type of change. For example, let's say you have a column that has DATE LAST VIEWED. This column could be updated many times in...

Is there a lot of data modification going on in the morning?

-SQLBill

Let's start at the beginning...

check these out:

Is MSSQLSERVERAGENT service started?

Is the job ENABLED?

-SQLBill

I like the look of it. However, I don't always read the SQL newsletters I get now. Most of the time I get the information from the site itself. I...

Which database(s) is/are failing and what type of backup are you attempting to do?

-SQLBill

Allen,

I talked to my sysadmin guru.

C$ is created by NTFS automatically. You were correct - it's an administrative share. However, the root (in this case C) can be shared...

Allen,

I'll ask him and let you know what he says.

He explained it to me in depth and in the time between that and posting my response, I lost a lot...

Brian,

This page could not be found (23 May 1000 EST): http://www.sqlservercentral.com/testcenter

And I'm curious to see how I did against others.

-SQLBill

gfahrlander,

Are your services running under LocalSystem? If so, according to my sysadmin guru, LocalSystem DOES NOT have network access privileges.

Allen,

Just want to pass this on to you,

Just finished talking to...

Not completely true. I have a 2-node active/passive cluster with a virtual SQL Server. I have stopped services several times and never experienced a failover FROM stopping the services MANUALLY....