SQLkiwi (7/5/2011)

---

Just so we're all clear on this, I'm interested in how you justify things like attending the summit to the person paying. I have heard of some people...

did you change service accounts passwords ?

You may also want to start a sqlprofiler trace on your sqlinstance capturing all login info an all oledb errors to get more detail on what's going wrong.

( keep it...

1) Is your production server sql2008 ?

2) is your production DB dblevel 100 ?

DMV may not work when running the db in a lower compatibility mode.

btw avoid usage of the...

SQLkiwi (7/4/2011)

---

ALZDBA (7/4/2011)

---

One of the arguments I always like to use is: What would it cost to absorbe the same knowledge when following the regular courses, on that many topics,...

Since it states user '' IMO that means someone didn't provide a SQLUser !

Check that applications parameters to configure the connection string.

Sumanta Roy (7/4/2011)

---

Hi,

Please see the result below.

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard...

I don't think it is logged in th errorlog by default -...

In that case double check there aren't any sql client aliasses defined that revert the connection ...

- Can you post @@version info of the instance ?

- On your instance, can...

Is this the only instance on that server ?

Double check you and your user are connecting to the same server\instance !

Maybe this failed connection tracker helper can help you sort...

GilaMonster (7/4/2011)

---

A little under $2000 USD here...

Jeffrey Williams-493691 (7/3/2011)

---

Check with the team that manages the SMTP server - see if they are using any filtering to allow only defined servers to send mail. Also, validate...

It's great to see many of SSC addicts have been granted MVP once more.

Congratulations to you all.

Chad Crawford (6/29/2011)

---

ALZDBA (6/29/2011)

---

This won't hurt either.

Actually it...

Jeff Moden (6/29/2011)

---

As a side bar, I don't backup to tape. I backup to disk and then back that up. It makes life a little more convenient for...