Also look a the advanced options.

Make sure windows integrated security is enabled.

Thanks, Greg E

If it is a Kerberos issue -

Check and see if on the client, in IE, the server is in trusted sites.

Then check the setting under Trusted sites and Intranet to...

Be sure to also consider how you plan on using Analysis Services, and the additional resources it may require. Not all products play too well on the same machine. If...

Looking at the number of hits generated, this was a good teaser. 😀

Guess we just have to settle for our reality game we have today.

Greg E

Hopefully someone will verify this - having run both SQL 2005 and SSAS on the same machine, we see it's looking at the total memory that the OS sees.

Also be...

More details giving some examples might get some other responses.

Scripting tools come to mind first, although I am only a user on the domain.

And sometimes combined with Excel.

For example...

Software Assurance takes on a whole new meaning if you are expected to upgrade as soon as the next version is released.

Seems Visual Studio also suffers from a similar fate...

review where you set max active requests.

0 ( no limit ) will allow you to possibly overload the server.

Default was 20 - try 40 as suggested

GE

We have our project on the server file system, but run our packages from MSDB.

File system has it's own backup, and so does SQL server.

This also allows different access levels...

You might want to read this.

http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx

If you have access to AD console.msc to view some of the setup, you should be able to start reviewing the computers and accounts involved....

ProClarity 6.3 has been working good for us. We use Web Pro as the interface is a bit cleaner. It does understand named sets in the cube. It also has...

It's the same source table but using the dimension twice, etc, etc...

Simple way to solve for SQL would be self join. Similar in concept in a cube.

We use...

Also - I seem to recall on our SMTP server, we had to allow the server IP access. Most SMTP servers should have some level of security so they are...

Might be a dumb question - but did you use rsconfig to configure email for Reporting Services?

I use an SMTP server for this, not Database mail.

Check your settings in rsconfig

Greg...

OK.

There are a number of pieces to having Kerberos set up properly. And it also requires a Domain Admin to setup the endpoints.

Have some other bookmarks and tips that may...