X64 Problems installing SSAS named instance
-
My setup passed successfully (afaik
 
, but ...1) The SQLBrowser service was unable to establish Analysis Services discovery.
Solved
that by having it run with LocalSystem2) SSMS instance discovery does not show this SSAS instance (actualy none at all, but there are no others at this domain)
3) When I connect using ssms and specify the named instance, it connects, but there is no sample db ??
This is my install parameterset :
[Options]
USERNAME="Its Me"
COMPANYNAME="Its Mine"
INSTALLSQLDIR="C:\Program Files\Microsoft SQL Server\"
INSTALLSQLSHAREDDIR="C:\Program Files\Microsoft SQL Server\"
INSTALLASDATADIR="Y:\"
ADDLOCAL=Analysis_Server,AnalysisDataFiles,Client_Components,SQL_AdventureWorksDWSamples,SQL_AdventureWorksASSamples
;--------------------------------------------------------------------
INSTANCENAME=UABE0DV76
;--------------------------------------------------------------------
; there already was a sqlbrowser installed (Databaseinstance active)
;SQLBROWSERACCOUNT=
;SQLBROWSERPASSWORD=
ASACCOUNT="mydomain\SSASDev"
ASPASSWORD="mypwd"
SQLBROWSERAUTOSTART=0
SQLAUTOSTART=0
AGTAUTOSTART=0
ASAUTOSTART=0
RSAUTOSTART=0
SECURITYMODE=SQL
SAPWD="mypassword"
SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS
DISABLENETWORKPROTOCOLS=2
ERRORREPORTING=0
SQMREPORTING=0
ENABLERANU=0
ADMINPASSWORD=mywindowspassword
VS=UABE0DV76
INSTALLVS=Analysis_Server
IP="myInstanceIP,Public Team Cluster Connection"
GROUP="Group_1"
ADDNODE="UABE0DV02,UABE0DV01"
ASCLUSTERGROUP="mydomain\mygroupDevelopmentAdministrators"
Any hints ?
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
This was removed by the editor as SPAM
-
I have this same problem, and this post is the only bit of information I have found about it so far.
I'm using SQL 2005 Evaluation Edition x64, with SP1, installed as a named instance (SQL 2000 and Analysis Services 2000 is the default instance). It's running on an HP DL385 with dual Opterons and 8GB RAM, with Windows Server 2003, Standard x64 Edition, with SP1.
I found this in the Application event log:
Source: SQLBrowser, Event ID: 9
The SQLBrowser service was unable to establish Analysis Services discovery.
That's my contribution to this discussion; hopefully someone else will have more useful information.
-
After further searching, I found my answer here:
Check that the service account has write permission on these directories:
C:\Program Files (x86)\Microsoft SQL Server\90\Shared
C:\Program Files (x86)\Microsoft SQL Server\90\Shared\ASConfig
That's what did it for me. The post I linked to has more info.
-
Thank you Jeff for this reference.
- I've contacted MS and they confermed in x64-sqlbrowser, it does not pulish, but only supplies connection-routing. That's why I couldn't see the instance but was able to connect when I supplied the full name.
- as for the sample db, that had to be installed seperatly, as mentioned in BOL ! I'd hoped it would have been installed when supplying the inputparameters for samples, but that was not the case.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply