To echo what others have said - you have two different databases with two different functions. I would keep them that way.

Ray K (9/13/2011)

---

Finish this sentence:

Old...

Now we know where Steve will be sleeping when in the dog house.

Jack Corbett (9/12/2011)

---

SQLRNNR (9/12/2011)

---

Chad Crawford (9/12/2011)

---

Woohoo. Attended my first SQL Saturday and spoke there as well. Was as nervous as <fill in your favorite joke here>, since...

Chad Crawford (9/12/2011)

---

SQLRNNR (9/12/2011)

---

Chad Crawford (9/12/2011)

---

Woohoo. Attended my first SQL Saturday and spoke there as well. Was as nervous as <fill in your favorite joke here>,...

Chad Crawford (9/12/2011)

---

Woohoo. Attended my first SQL Saturday and spoke there as well. Was as nervous as <fill in your favorite joke here>, since the topic they...

Is FACILITY\mtester defined as the user in your datasource?

If that user is defined in the datasource - you have to grant it access to the db.

And that user has proc execute perms or datareader perms on the database that you are trying to connect to?

Assuming the report doesn't require writing data to the database.

What is the error message you are receiving?

Thomas Abraham (9/12/2011)

---

If he's...

Welsh Corgi (9/12/2011)

---

My observation is that there are lot of people posting their Homework Assignments.

It is so obvious that they are not real world problems. They are not even good...

I don't mind building hardware at work, for clients, or for a new machine for home. I hate re-building...

GilaMonster (9/11/2011)

---

SQLRNNR (9/11/2011)

---

GilaMonster (9/11/2011)

---

I think the hard drive failure's worse. Cost me most of last night and a good part of this morning and I'm working on my laptop until...

flame

Nothing like an easy question to start the week.