Re: AS2005: Can't access named instance / sqlbrowser issue...

Which problem exactly (below there are 2 problems mentioned)

1. You cannot start SQL Server Browser service?
2. SQL Server Browser service is started, but you cannot connect to the
named instance?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights



"Hugo" <Hugo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E35529E3-ACD1-4837-8EF2-687DEA2FFD17@xxxxxxxxxxxxxxxx
I have the same problem but It doesn't work with me.

Do you have any additional information?

Thanks a lot!

Hugo

"Jéjé" wrote:

thanks a lot!

security on the folder solves the issue!! :-)))


"Edward Melomed [MSFT]" <edwardm@xxxxxxxxxxxxxxxxxxx> wrote in message
news:uUzjQaDKGHA.3352@xxxxxxxxxxxxxxxxxxxxxxx
Several things to check:
1. File share permissions:
C:\Program Files\Microsoft SQL Server\90\Shared
C:\Program Files\Microsoft SQL Server\90\Shared\ASConfig

2. Reg Key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\SQL
Browser
Should have AnalysisServiceListener value set to 1

3. Try deleting msmdredir.ini and .bak files
C:\Program Files\Microsoft SQL Server\90\Shared\ASConfig
Restart SQLBrowser and then your named instance.

Edward.

--
This posting is provided "AS IS" with no warranties, and confers no
rights



"Jéjé" <willgart_A_@xxxxxxxxxxxxxx> wrote in message
news:ujYp3HDKGHA.1728@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

starting the sqlbrowser cause this error (event log):
The SQLBrowser service was unable to establish Analysis Services
discovery.

I can't access my named instance of Analysis services.

the "default" instance is an SQL2000 version, not 2005.



I can access my AS server if I specify the port in the connection
(like
<server>:PORT) but this port change everytime I restart the service.

Can I use a fixed value for this port?



I have uninstalled / reinstall AS but this change nothing.



any idea?



thanks.



Jerome.











.

Relevant Pages

  • Re: SQL Management Studio will not connect to x64 bit SP2 server
    ... Management studio communicates over the port that SQL is listening on. ... Management Studio on the x64 bit server with named instance. ...
    (microsoft.public.sqlserver.connect)
  • Re: Remote connection to SQL Server 2005
    ... Only the default instance listens on port 1433. ... named instance or are running SQL Express, which is a named instance named ... Microsoft, SQL Server Books Online ... on a Windows 2003 Server machine behind a router. ...
    (microsoft.public.sqlserver.connect)
  • sql browser and named instance connection issue
    ... Checking file permisisons on:\Program Files\Microsoft SQL ... Restart SQLBrowser and then your named instance. ... The suggestions in the blog post include setting the Port property in SSAS ...
    (microsoft.public.sqlserver.olap)
  • Re: connect to named instance in a cluster
    ... SQL will decide on a port when the service restarts unless it is a default instance or you have locked SQL to a specific port number. ... I had problem connecting to the named instance. ...
    (microsoft.public.sqlserver.clustering)
  • Re: AS2005: Cant access named instance / sqlbrowser issue...
    ... C:\Program Files\Microsoft SQL Server\90\Shared ... The SQLBrowser service was unable to establish Analysis Services ... I can't access my named instance of Analysis services. ... I can access my AS server if I specify the port in the connection (like ...
    (microsoft.public.sqlserver.olap)