Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

55 views
Skip to first unread message

Jéjé

unread,
Feb 2, 2006, 2:50:47 PM2/2/06
to
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.


Edward Melomed [MSFT]

unread,
Feb 2, 2006, 3:23:42 PM2/2/06
to
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_@hotmail_A_.com> wrote in message
news:ujYp3HDK...@TK2MSFTNGP14.phx.gbl...

Jéjé

unread,
Feb 2, 2006, 4:47:34 PM2/2/06
to
thanks a lot!

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


"Edward Melomed [MSFT]" <edw...@norely.micrsoft.com> wrote in message
news:uUzjQaDK...@TK2MSFTNGP12.phx.gbl...

Hugo

unread,
Apr 21, 2006, 4:31:02 AM4/21/06
to

Hugo

unread,
Apr 21, 2006, 4:36:02 AM4/21/06
to
I have the same problem but It doesn't work with me.

Do you have any additional information?

Thanks a lot!

Hugo

Edward Melomed [MSFT]

unread,
Apr 21, 2006, 2:32:14 PM4/21/06
to
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" <Hu...@discussions.microsoft.com> wrote in message
news:E35529E3-ACD1-4837...@microsoft.com...

Hugo

unread,
Apr 28, 2006, 8:53:02 AM4/28/06
to
Thank you for your response. I can start SQL Server Browser Service but
cannot connect to the named instance. I have checked all security on folders.
It still doesn't work.

Oliver

Edward Melomed [MSFT]

unread,
Apr 28, 2006, 7:30:00 PM4/28/06
to
You might be having different problem . Try installing SQL Server 2005 SP1
Go to MSDN forum for more information about troubleshooting connectivity
problems
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=314855&SiteID=1

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


"Hugo" <Hu...@discussions.microsoft.com> wrote in message

news:62887C72-AEAD-4FA2...@microsoft.com...

0 new messages