SQL is licensed per Physical CPU. How many physical CPU's do you have?

Also, in order to be able to REALLY take advantage of virtualization, you might want to purchase Windows...

For what it's worth, here's the reportserver.config security segment...

<Authentication>

<AuthenticationTypes>

<RSWindowsNegotiate/>

<RSWindowsNTLM/>

</AuthenticationTypes>

<RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>

<RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>

<EnableAuthPersistence>true</EnableAuthPersistence>

</Authentication>

Does the order of these make a difference?

<RSWindowsNegotiate/>

<RSWindowsNTLM/>

Unchecking the IE setting "Enable Integrated Windows......" works but most of the reports we have...

Post your connection string. Just change the server name, IP address, db name and credentials.

From the PC you are trying to connect with, can you connect using a UDL or...

Try changing your connection string to use SQLNCLI (SQL Native Client).

Post your connection string.

Also check to see what the users default DB is. Some people set a default DB...

GilaMonster (7/21/2011)

And that's the gamble.

In the pleasant scenario you give there's a chance (it happened more than once) that the one, or many, TX log...

GilaMonster (7/21/2011)

If you want to keep the log managable, back the log up regularly and make sure there are no other problems that cause the log to grow (failed replication,...

GilaMonster (7/21/2011)

That's still a very bad thing to do, as it means that if a full backup is not restorable you have no options for restoring to point of failure....

Yes, backup log with truncate only is logged. I see it. There's actually a job that does this just prior to the FULL db backup.

At least the job logs...

I hope not!

I did notice a trend that it fails at a specific time. At least the past 2 days it did. There is only one job that runs at...

I use the WinZip commandline tool and use the Windows Scheduler to kick it off.

Like the others said, use only one compression tool. I zip a 90GB .bak file to...

It looks like your backing up to a UNC path. Can you try backing up to a local drive?

If no space try a USB drive. I found that backing up...

THAT WAS IT!!!!

I knew I was forgetting something simple...... :hehe:

Thanks a bunch!

Nevermind. I figured it out.

I told you it was a senior moment.

The problem was the account I creaed was missing the letter "s". So the creds SQL was passing...

True.

Then I recomend the OP package this script and do as Grasshopper sez.....

Try this on the DB *AFTER* they restore it. It's not "Auto_Fix" so it might work.....

DECLARE @username...