Recent content by Solo4357

Figured it out. In the powershell console: did a get-mailboxdatabase | fl *rpc* which told me that it was still the CAS server for the database even though it shouldn't be, the new CAS server should've been. Then I ran Set-MailboxDatabase –Identity “Database name” –RPCClientAccessServer “FQDN...

I am working through a lab scenario in preparation for an upgrade. I set up two exchange 2003 servers and then added a Exchange 2010 server with all three roles. Everything worked fine, mail flowed between the two organizations, etc. I then installed a new exchange 2010 with CAS/HUB only and...

I don't think they exported the IIS itself, just copied the websites over. I'm just not sure why one would put up a windows login and the other wouldn't.

Yeah I did, but no dice. It appeared to be the same on both.

I have some programmers that copied a site over for testing purposes from one server to another. There's a virtual directory that when accessed from a link pops up a windows login. This doesn't work on the new server, just says the page can't be found. I've checked all the settings on both the...

We have a user that cannot access some public folders she has client permissions on. Other user's have been set up the same way with no issues. I can't seem to find a reason for it, is there any tips anyone has?

I have been plunged into a situation that hopefully you guys can answer this question on.. 2 domains. New domain contains all the users. Old domain contains the exchange servers. The users all still exist on the old domain, however disabled. New domain users were assigned to the old exchange...

That's my problem, I can't the way the it's set up in the cube. Doesn't come across as a measurement.

I have a report that looks like this: Fullname OHCOSTS Customer Billed John 5000 Cutco 500 BigCorp 400 SubTotal 10000 900 Bill 4000 MickeyD 4000 JimBob's 500 Subtotal 8000...

I have created a report that has two row groups and one column group. Year | Total Full Name | Code | Sum(Amount) | Sum(Amount) So you can expand "full name" and get the codes under that and corresponding amounts. By default they are all collapsed. The year is the...

I have created a time dimension but not in the data source (i'm a little confused on where the data lies or if it just builds it on the fly based on the properties.) I needed a new one that wasn't in the database because it's easier with it to expand the years as time goes on. However in the...

I'm trying to query a cube and filter out by dimension. What I want is to select jobs where the Job status is not 'C' OR the Completion Date is this year. (Some of those would have a 'C' in the status.) Any quick help on that?

True enough. Since I only need it to do a one time data dump, 6 to one-half dozen to the other. Either way, it's getting the job done. Many thanks.

Oo that almost did it. Here's my changes: SELECT * FROM (SELECT jobcode, NULL as phase, jobphasename FROM my_table UNION ALL SELECT jobcode, phase, jobphasename FROM my_table) Group By Jobcode, Phase,JobPhasename ORDER BY jobcode, phase; Otherwise I got a name record for each phase record...

I have to get some records out of the database for a text file for import. The fields are Jobcode, jobphase, and jobname, jobphasename. However the format needs to be: for the first record of the job: Jobcode Blank jobname and subsequent records jobcode jobphase jobphasename so for the...