SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 Analysis Services failing to Start . File system
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

s1234
Starting Member

5 Posts

Posted - 07/03/2014 :  19:21:42  Show Profile  Reply with Quote
Hello All,

Posting this problem here and hoping for a solution from the experts in this forum.

When i have restarted the Analysis Services , i see that it has been stopped but never started back. It fails with an error

"The SQL Server Analysis Services (MSSQLSERVER) service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs."

When Checked the Event Viewer i see the following error -

The service cannot be started: The following system error occurred: The filename, directory name, or volume label syntax is incorrect. File system error: Error occurred during the creation of directory: '\\?\E:\OLAP\MSSOLAPFactory\OlapData;M:\Test Backup'.

I remember changing the BackupDir value of Analysis Services few days back, and i think it could have impacted. Can you please help me how can i change back the BackupDir value and have the server back?

Let me know if you need any more details

sunder.bugatha
Starting Member

India
22 Posts

Posted - 07/04/2014 :  05:22:58  Show Profile  Click to see sunder.bugatha's MSN Messenger address  Send sunder.bugatha a Yahoo! Message  Reply with Quote
check the backup location in the config file.

e.g.
C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Config



Hema Sunder
Go to Top of Page

sunder.bugatha
Starting Member

India
22 Posts

Posted - 07/04/2014 :  05:23:33  Show Profile  Click to see sunder.bugatha's MSN Messenger address  Send sunder.bugatha a Yahoo! Message  Reply with Quote
msmdsrv.config

Hema Sunder
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000