Viewing 15 posts - 1,426 through 1,440 (of 1,448 total)
Kerberos is used to authenticate using the windows credentials. It is used to hop between servers. We have the web application on a separate server from SSAS, and SQL on...
September 30, 2007 at 10:18 am
I agree that security should start back at the Cube. Secure Data at the source whenever possible. It's your first chance to implement security.
Be aware that granting access to Everyone...
September 20, 2007 at 8:41 am
I'm almost looking forward to the day they cancel me. For 3 months running, they've messed up my bill. Every month, they assure me that they've fixed the problem. Maybe...
September 5, 2007 at 8:28 am
Similar to what Michael is explaining, we build a Fact table for certain things we wish to measure. When we invoice a Sales order, we capture several key pieces...
August 8, 2007 at 6:55 am
The main reason I use Kerberos is to make the hops between our web servers and the sql and analysis services. NTLM cannot make the hop.
July 31, 2007 at 8:03 am
Usually a Domain Administrator Account would not be trusted for delegation. This would be a very bad account to use. The SQL / SSAS machine also has to be...
July 30, 2007 at 9:47 am
Make sure you register a SPN. Local System does not register one for SQL Server2005 as in previous versions.
Running as Local System is also a security risk. Please use...
July 27, 2007 at 2:24 pm
I'd assume your XP SP2 is 32 bit. x64 bit OS can run either 32 bit or x64 bit versions.
I agree with Sugesh - read the compare versions details....
July 27, 2007 at 11:57 am
From my understanding, Kerberos is tried first, then if it fails, fallback is to NTLM.
You need to set up SPN's to register the services, which are slightly different on SQL...
July 27, 2007 at 11:32 am
For x64 bit machines, you can install a 32 bit version. I don't think they have done any 64 bit versions yet.This was on our disk for x64 bit.
July 12, 2007 at 6:45 am
Windows Update identifies only Windows Patches. If they use Microsoft Update, you should see other patches i.e. Office, SQL Server (or Express), etc.
You might want to check this out.
July 12, 2007 at 6:36 am
The stored pocedure gives all the info you may need. I assume you would be interested that SQL Server is 64 bit if running on x64 bit platform. Someone could...
June 13, 2007 at 7:29 am
I don't know how many records are involved, but NOT EXISTS might offer some advantages.
FROM V_RPT_TRANS2 WHERE INTNL_PF_NUM NOT IN (SELECT INTNL_PF_NUM FROM V_RPT_TRANS1)
Gail is right - looking at the...
June 13, 2007 at 7:06 am
Try saving to MSDB letting it use server security. Default (I think) package is saved with sensitive information encrypted with user key.
How you are scheduling / launching the package...
May 15, 2007 at 1:43 pm
Just create a data source on your machine to the SQL Express instance, then go to File, Get External Data, Link Tables. You should be able to use this...
December 18, 2006 at 6:51 am