Cannot connect with the Administator account

Hi.
I installed Sql Server 2005 with NetworkService user and now
I can't connect with Management Studio with the Administrator account.
How can I do?
Thx! ;-)
Matteo Migliore
Blog - http://blogs.ugidotnet.org/matteomiglioreError message?
Kevin Hill
IC3 North Texas
www.ChristianCycling.com
Please support me in the 2008 MS150:
http://www.ms150.org/dallas/donate/donate.cfm?id=208000
"Matteo Migliore" <matteo.migliore.cut@.gmail.com> wrote in message
news:e4Ateg$RIHA.4752@.TK2MSFTNGP05.phx.gbl...
> Hi.
> I installed Sql Server 2005 with NetworkService user and now
> I can't connect with Management Studio with the Administrator account.
> How can I do?
> Thx! ;-)
> --
> Matteo Migliore
> Blog - http://blogs.ugidotnet.org/matteomigliore
>|||> Error message?
There aren't errors. The problem is that only NetworkService user can
connect,
but not the Administrator account. I suppose that I've to add Administrator
to users.
Mmmm... while I was writing, I tried to run Management Studio with "Run As
Administrator" in Vista,
and I solved the problem.
Thx again!
Matteo Migliore
Blog - http://blogs.ugidotnet.org/matteomigliore|||That's because Windows Vista' s UAC. Another user experienced the very same
problem some days ago in the NG if I'm remembering correctly...
Ekrem nsoy
"Matteo Migliore" <matteo.migliore.cut@.gmail.com> wrote in message
news:%23B9PGHASIHA.2000@.TK2MSFTNGP05.phx.gbl...
> There aren't errors. The problem is that only NetworkService user can
> connect,
> but not the Administrator account. I suppose that I've to add
> Administrator to users.
> Mmmm... while I was writing, I tried to run Management Studio with "Run As
> Administrator" in Vista,
> and I solved the problem.
> Thx again!
> --
> Matteo Migliore
> Blog - http://blogs.ugidotnet.org/matteomigliore
>|||> Mmmm... while I was writing, I tried to run Management Studio with "Run As
> Administrator" in Vista,
> and I solved the problem.
Alternatively, you can add the specific user Windows account as a login and
to the sysadmin server role. This is basically what is done by the the user
provisioning tool that can be launched at the end of the SQL 2005 SP2
installation.
Hope this helps.
Dan Guzman
SQL Server MVP
"Matteo Migliore" <matteo.migliore.cut@.gmail.com> wrote in message
news:%23B9PGHASIHA.2000@.TK2MSFTNGP05.phx.gbl...
> There aren't errors. The problem is that only NetworkService user can
> connect,
> but not the Administrator account. I suppose that I've to add
> Administrator to users.
> Mmmm... while I was writing, I tried to run Management Studio with "Run As
> Administrator" in Vista,
> and I solved the problem.
> Thx again!
> --
> Matteo Migliore
> Blog - http://blogs.ugidotnet.org/matteomigliore
>

Cannot Connect to Analysis Server-not a member of OLAP Admin

I have set up the the Analysis Service to log on as DOMAIN\administrator.
I have added DOMAIN\administrator as a member of OLAP Adminitration
I initially logged in as DOMAIN\administrator.
Upon trying to connect in Analysis Server, I get the error messge Cannot
connect to SERVER registry or you are not a member of the OLAP
AdministratorGroup
What gives? How do I resolve this?
Are you running the latest service pack for Analysis Services?
Kevin E.
"Diane" <Diane@.discussions.microsoft.com> wrote in message
news:B2888652-78F9-4F32-88B2-F21C03A48A65@.microsoft.com...
>I have set up the the Analysis Service to log on as DOMAIN\administrator.
> I have added DOMAIN\administrator as a member of OLAP Adminitration
> I initially logged in as DOMAIN\administrator.
> Upon trying to connect in Analysis Server, I get the error messge Cannot
> connect to SERVER registry or you are not a member of the OLAP
> AdministratorGroup
> What gives? How do I resolve this?
|||Yes, I am.
"Diane" wrote:

> I have set up the the Analysis Service to log on as DOMAIN\administrator.
> I have added DOMAIN\administrator as a member of OLAP Adminitration
> I initially logged in as DOMAIN\administrator.
> Upon trying to connect in Analysis Server, I get the error messge Cannot
> connect to SERVER registry or you are not a member of the OLAP
> AdministratorGroup
> What gives? How do I resolve this?
|||We had the same problem on some of our installations. Seems like after we
rebooted and then tried to connect it worked fine. Might of had something to
do with MSSQLServerOLAPService not being started until after reboot. Just a
thought.
Kevin
"Diane" <Diane@.discussions.microsoft.com> wrote in message
news:904C6394-D5AE-4BC4-8A45-39B58AA742BD@.microsoft.com...[vbcol=seagreen]
> Yes, I am.
> "Diane" wrote:

Cannot connect to admin:ServerName

Hi All,

When I try to connect to SQL Server 2005 by using Dedicated administrator connections by admin:ServerName.

I encounter this error:
Cannot connect to admin:ServerName
Dedicated administrator connections are not supported. (ObjectExplorer)

N.B.:
I use SQL authentication to connect.
SQL authentication is working without the "admin:" prefix.

Thank you.
Bishoy

Hi Bishoy,

Make sure you have enabled DAC in the SQL Surface Area Configuration under features. It is disabled by default.

Cheers,

Rob

|||DAC for sqlexpress is disabled by default. Add trace 7806 as part of the startup trace for sqlserver. Restart the service to the effect. Don't forget to enable/start sqlbrowser service too.

See the following kb for more info:
http://msdn2.microsoft.com/en-us/library/ms189595.aspx|||

Robert Varga wrote:

Hi Bishoy,

Make sure you have enabled DAC in the SQL Surface Area Configuration under features. It is disabled by default.

Cheers,

Rob

Thanks for the pointer, no wonder it didn't work when I tried.

Question is, I have enabled DAC on 3 SQL servers, but still cannot connect into them with ADMIN:SERVERNAME

Error is "Dedicated administrator connections are not supported."

Do I need to restart the SQL Server?

Cannot connect to admin:ServerName

Hi All,
When I try to connect to SQL Server 2005 by using Dedicated administrator
connections by admin:ServerName.
I encounter this error:
Cannot connect to admin:ServerName
Dedicated administrator connections are not supported. (ObjectExplorer)
N.B.:
I use SQL authentication to connect.
SQL authentication is working without the "admin:" prefix.
Thank you.
BishoyMaybe a stupid question, but do you have DAC enabled on this server (it
is disabled by default)?
Bishoy wrote:
> Hi All,
> When I try to connect to SQL Server 2005 by using Dedicated administrator
> connections by admin:ServerName.
> I encounter this error:
> Cannot connect to admin:ServerName
> Dedicated administrator connections are not supported. (ObjectExplorer)
> N.B.:
> I use SQL authentication to connect.
> SQL authentication is working without the "admin:" prefix.
> Thank you.
> Bishoy|||May be an unrespectable answer.
DAC is enabled and still the problem persists.
Thank you.
"Theo Verweij" wrote:
> Maybe a stupid question, but do you have DAC enabled on this server (it
> is disabled by default)?
> Bishoy wrote:
> > Hi All,
> >
> > When I try to connect to SQL Server 2005 by using Dedicated administrator
> > connections by admin:ServerName.
> >
> > I encounter this error:
> > Cannot connect to admin:ServerName
> > Dedicated administrator connections are not supported. (ObjectExplorer)
> >
> > N.B.:
> > I use SQL authentication to connect.
> > SQL authentication is working without the "admin:" prefix.
> >
> > Thank you.
> > Bishoy
>|||> Dedicated administrator connections are not supported. (ObjectExplorer)
Are you trying to open a query window or Object Explorer through the DAC? You can only have one
connection using the DAC, and Object Explorer can not use the DAC.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bishoy" <Bishoy@.discussions.microsoft.com> wrote in message
news:2D5006C5-5836-4B83-B680-8D51B378104D@.microsoft.com...
> Hi All,
> When I try to connect to SQL Server 2005 by using Dedicated administrator
> connections by admin:ServerName.
> I encounter this error:
> Cannot connect to admin:ServerName
> Dedicated administrator connections are not supported. (ObjectExplorer)
> N.B.:
> I use SQL authentication to connect.
> SQL authentication is working without the "admin:" prefix.
> Thank you.
> Bishoy|||If this is remote, you need to make sure to enable remote
admin connections with sp_configure.
But the error indicates you're running into something else.
The DAC is only supported for a query window, it's not
supported with Object Explorer. If trying to connect with a
DAC in SSMS, try opening a regular connection first and then
open a query window with a DAC.
-Sue
On Sun, 5 Nov 2006 10:44:01 -0800, Bishoy
<Bishoy@.discussions.microsoft.com> wrote:
>Hi All,
>When I try to connect to SQL Server 2005 by using Dedicated administrator
>connections by admin:ServerName.
>I encounter this error:
>Cannot connect to admin:ServerName
>Dedicated administrator connections are not supported. (ObjectExplorer)
>N.B.:
>I use SQL authentication to connect.
>SQL authentication is working without the "admin:" prefix.
>Thank you.
>Bishoy|||Dear Tibor and Sue,
You are just correct.
Actually it works with new query only.
Thank you alot.
Bishoy|||I apologize.
Bishoy wrote:
> May be an unrespectable answer.
> DAC is enabled and still the problem persists.
> Thank you.
> "Theo Verweij" wrote:
>> Maybe a stupid question, but do you have DAC enabled on this server (it
>> is disabled by default)?
>> Bishoy wrote:
>> Hi All,
>> When I try to connect to SQL Server 2005 by using Dedicated administrator
>> connections by admin:ServerName.
>> I encounter this error:
>> Cannot connect to admin:ServerName
>> Dedicated administrator connections are not supported. (ObjectExplorer)
>> N.B.:
>> I use SQL authentication to connect.
>> SQL authentication is working without the "admin:" prefix.
>> Thank you.
>> Bishoy|||Hi Bishoy
The error message is very specific. It says you cannot open a DAC connection
to Object Explorer. That is the default when you try to open Management
Studio.
You need to open Management Studio, and then you can open a query window
with the DAC.
Alternatively, you can configure Management Studio to open a Query Window
instead of explorer on startup.
--
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Bishoy" <Bishoy@.discussions.microsoft.com> wrote in message
news:2D5006C5-5836-4B83-B680-8D51B378104D@.microsoft.com...
> Hi All,
> When I try to connect to SQL Server 2005 by using Dedicated administrator
> connections by admin:ServerName.
> I encounter this error:
> Cannot connect to admin:ServerName
> Dedicated administrator connections are not supported. (ObjectExplorer)
> N.B.:
> I use SQL authentication to connect.
> SQL authentication is working without the "admin:" prefix.
> Thank you.
> Bishoy