Tag Info

Hot answers tagged

5

"Client Tools Connectivity" is one of the available SQL Server shared install options you can choose locally without installing any of the server components. Run the SQL Server installer and ensure you deselect everything else (that you have not installed to provide connectivity). Should I install the SQL Server Management Studio on Server B? You ...


3

I think you must have installed Management Studio with only the Basic option selected. You need to install the "Complete" option in order to have support for Analysis Services. You should be able to just add the feature through the installer.


2

There are few things I would look at before redesigning your database. I'm pretty sure that reporting services doesn't need a star/snowflake to do its work so you might see what you can build with your nomalized database. Try building views that denormalize your OLTP data. It will get you thinking about the design aspects that you will need if you do ...


2

If the service access performs many requests, and each request has to be authenticated, this would be the expected behavior if an authentication cookie is not set. If every request has to perform a full authentication, performance will be noticeably degraded. If you are unable to set an auth cookie, and you can use Windows authentication, IIS has a ...


2

You can turn this behavior off with trace flag 830, for more information check this article on msdn dbcc traceon(830, -1) or as a start-up parameter if you want this turned on permanently: add /T830 as a service start-up parameter. Seeing as you have such cheap disks & your running sql server 2008, take a look at turning on page compression for the ...


1

Download Wireshark. Install. Run capture on both ends, filtering by SQL Server's TCP port (1433 if the default is used) on your client and by the client's IP on the server, until you hit this downtime. Once it happens, stop the capture and analyze. There's not guarantee you'll see something with this kind of capture - if there's noise on the network of any ...


1

All kinds of SQL services will not behave nicely when the disk gets full. The main problem is that SQL uses caching extensively and that usually means disk space. Sql Server loves it's disk space! Our fun with this is with SRS. It the disk gets full, the reports blow up with a web page error.


1

I would check the perfmon counters to confirm what is exactly using the memory - It is not clear if you are using task manager to identify the use. Analysis Service should peak out its memory at the total memory limit. Do the queries continue to run? - why do you have to reboot? is it to kill the ongoing queries? I would check the cleaner counters to see ...


1

From technet SQL Server 2005 Analysis Services (SSAS) Server Properties SSAS has a special memory “cleaner” background thread that constantly determines if it needs to clean up memory. The cleaner looks at the amount of memory used. The following basic processes are used by the cleaner to control amount of physical memory used by Analysis Server: If ...


1

found out that we had to remove all SPN's from Active Directory before this would work. setspn -D also, found that there were some SPN's set to a domain account, so had to remove those setspn -D and then it all worked after changing DNS. It came down to the SPN's being the issue. first had to change sql services (DB, SSAS) on SERVER_B to local ...


1

I ran into this problem as well. I unchecked the "Use single transaction when processing queries" checkbox in the Dataset's Data Source's Properties.


1

It pretty much is, unless you dump the whole SQL side and build the repository in a Cube - in which case you MAY get away with an OLTP schema underlying the data. The main problem is that a non-star-schema approach simply puts a lot of burden on the server for analysis. That said, the idea to sue analysis services is terrific - they shine in this area. Just ...


1

Maybe. The answer is impossible for anyone but you to say. Its completely dependent on the hardware involved and the load involved. Buy big enough hardware (either two separate machines or one even bigger machine) and I'm sure you can do it.


1

You can also move analysis services to its own hardware for maximum power. If you look at the page you link, it says that dual-server means "two or more" servers. Topology is more flexible than ever before in tfs2010.


1

Sounds like you need to do this: http://codesnob.wordpress.com/2009/06/03/remote-error-messages-iis/ The DLL will be sending an HTTP 500 error header to IIS hoping that it will return that to the client, however, IIS by default is set to only show errors to localhost requests so it replaces the SOAP error page with its own. Its a security feature, so I ...


1

Problem solved. I had anonymous authentication enabled, I've disabled it now.


1

"Proactive caching can only be deployed to a server running Microsoft SQL Server Enterpise Edition or Developer Edition." You've answered your own question there.


1

I don't believe that it will support this natively, but you could do some thing like the following 1) Add a trigger to the table that will set a last modified date value each time the a record is inserted or updated. 2) Create an SSIS package to reprocess your cubes. 3) Have the ssis package write a last run date time value to track the last time it ...


1

you can use sqlserver audit to log the sql statements, not the actual records. If you make sure that bind variables are not used, the actual sql including filter and join predicates will be logged. That is for the database For the cubes, you can enable tracing. Google it for better info on this part


1

Well, it seems that the reason for the problem is that the backup was of a SQL Server Analysis Services 2008 cube. I'd have preferred a nice simple "This backup is not compatible with this version." error message, but hopefully this question will help anyone else with this problem in the future! In case you're wondering, this backup was from a customer that ...


1

Fixed- the job step had to be "Run SSAS command" rather than "Run SSAS query"


1

To find out edition of SSRS, go to: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Log on the server which has SSRS Open the Summary.txt file. Look for the log file for Product : Microsoft SQL Server 2005 Reporting Services. In the SSRS log file, search for keyword "edition"


1

The first thing you need to do is establish why isn't the service starting. The SSAS service will log its problems into the system event log, and there is where you need to look. Start EventVwr.exe and check the application log for events reported by SSAS. The errors are also reported in the error log files, see Analysis Services Configuration - Data ...


1

Clean the system event log and then try to start the analysis service. This has worked for me. Nilesh



Only top voted, non community-wiki answers of a minimum length are eligible