Hi,
When I try to register a server in Analysis Services I get a error saying 'Automation error' and I also get a message saying Unable to open Registry Key 'SOFTWARE\MICROSOFT\OLAP Server\OLAP Manager'
Can someone please help.Install service pack 3 for SQL and Analysis Services.|||Thanks for the reply.
SP3 is already installed on the machine. I am not getting this message when I am logged on the machine as a user who belong to the Administrator group but if I log in the same machine as some other user (who is not a member of the Admin group), only then I get this message :confused:
Showing posts with label register. Show all posts
Showing posts with label register. Show all posts
Friday, March 23, 2012
Friday, February 24, 2012
error to register the msde2000 in enterprise manager
Hi all,
can anyone tell what can i do to register the msde in enterprise manager, it prompt me the 'sa' login fail. should the name pipe
protocol included or TCP/IP is already ok? thanks.
hi,
"CWeb@.office" <a@.b.com> ha scritto nel messaggio
news:%23AcFcAioEHA.4032@.TK2MSFTNGP15.phx.gbl
> Hi all,
> can anyone tell what can i do to register the msde in enterprise
> manager, it prompt me the 'sa' login fail. should the name pipe
> protocol included or TCP/IP is already ok? thanks.
MSDE installs by default allowing only trusted connections and not SQL
Server authenticated connections
in order to modify this behaviour at install time you have to pass the
additional parameter
SECURITYMODE = SQL
to the command line setup.exe boostrappert installer
you can have a look at
http://support.microsoft.com/default...b;en-us;285097 for
additional information about that, including further info on how to change
this setting after install hacking the windows registry
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
can anyone tell what can i do to register the msde in enterprise manager, it prompt me the 'sa' login fail. should the name pipe
protocol included or TCP/IP is already ok? thanks.
hi,
"CWeb@.office" <a@.b.com> ha scritto nel messaggio
news:%23AcFcAioEHA.4032@.TK2MSFTNGP15.phx.gbl
> Hi all,
> can anyone tell what can i do to register the msde in enterprise
> manager, it prompt me the 'sa' login fail. should the name pipe
> protocol included or TCP/IP is already ok? thanks.
MSDE installs by default allowing only trusted connections and not SQL
Server authenticated connections
in order to modify this behaviour at install time you have to pass the
additional parameter
SECURITYMODE = SQL
to the command line setup.exe boostrappert installer
you can have a look at
http://support.microsoft.com/default...b;en-us;285097 for
additional information about that, including further info on how to change
this setting after install hacking the windows registry
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Subscribe to:
Posts (Atom)