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
>