dbTalk Databases Forums  

SQL 2005 Managment Studio - Start Stop SQL Services on Win 2008

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss SQL 2005 Managment Studio - Start Stop SQL Services on Win 2008 in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
James Buist
 
Posts: n/a

Default SQL 2005 Managment Studio - Start Stop SQL Services on Win 2008 - 11-03-2008 , 08:15 AM






I have just installed SQL2005 on my new 2008 server. I have added the admin
user accounts to SQL2005 so I can login using Windows Authentication.
I'm running Win2K8 as a DC with all updates and SQL 2005 with SP2 and all
subsequent updates.
I can't stop and start services from within SQL Management Studio. I get the
error the object can't be accessed and I think it is to do with the UAC in
Win2K8 but I've turned it off in the user account section. I have changed the
Group Policy settings that seem relevent i.e there is no warning on accessing
high level objects from the UI when logged in as admin. Are there other GP
settings to modify?

Any ideas what to check next?

Reply With Quote
  #2  
Old   
James Buist
 
Posts: n/a

Default Re: SQL 2005 Managment Studio - Start Stop SQL Services on Win 200 - 11-03-2008 , 06:21 PM






Perfect. Many thanks for that. I'm still not used to that option being
required in 2008 and never thought to look. I figured I needed to do that to
modify Printer settings. Forgot about it here. I wish it could be turned off!
Do you know a group policy setting to disable that option so admins can just
operate everything as normal - I do not share my admin account with my user
account!

Regards

James

"Ekrem Önsoy" wrote:

Quote:
Will you try right clicking on the SSMS icon and Run as Administrator? A
customer was complaining about this and UAC was enabled at his side and this
worked for him.

--
Ekrem Önsoy



"James Buist" <JamesBuist (AT) discussions (DOT) microsoft.com> wrote in message
newsC41FD6E-7B96-49AC-91DE-B1EA7A07CCCD (AT) microsoft (DOT) com...
I have just installed SQL2005 on my new 2008 server. I have added the admin
user accounts to SQL2005 so I can login using Windows Authentication.
I'm running Win2K8 as a DC with all updates and SQL 2005 with SP2 and all
subsequent updates.
I can't stop and start services from within SQL Management Studio. I get
the
error the object can't be accessed and I think it is to do with the UAC in
Win2K8 but I've turned it off in the user account section. I have changed
the
Group Policy settings that seem relevent i.e there is no warning on
accessing
high level objects from the UI when logged in as admin. Are there other
GP
settings to modify?

Any ideas what to check next?


Reply With Quote
  #3  
Old   
James Buist
 
Posts: n/a

Default Re: SQL 2005 Managment Studio - Start Stop SQL Services on Win 200 - 11-03-2008 , 06:21 PM



Perfect. Many thanks for that. I'm still not used to that option being
required in 2008 and never thought to look. I figured I needed to do that to
modify Printer settings. Forgot about it here. I wish it could be turned off!
Do you know a group policy setting to disable that option so admins can just
operate everything as normal - I do not share my admin account with my user
account!

Regards

James

"Ekrem Önsoy" wrote:

Quote:
Will you try right clicking on the SSMS icon and Run as Administrator? A
customer was complaining about this and UAC was enabled at his side and this
worked for him.

--
Ekrem Önsoy



"James Buist" <JamesBuist (AT) discussions (DOT) microsoft.com> wrote in message
newsC41FD6E-7B96-49AC-91DE-B1EA7A07CCCD (AT) microsoft (DOT) com...
I have just installed SQL2005 on my new 2008 server. I have added the admin
user accounts to SQL2005 so I can login using Windows Authentication.
I'm running Win2K8 as a DC with all updates and SQL 2005 with SP2 and all
subsequent updates.
I can't stop and start services from within SQL Management Studio. I get
the
error the object can't be accessed and I think it is to do with the UAC in
Win2K8 but I've turned it off in the user account section. I have changed
the
Group Policy settings that seem relevent i.e there is no warning on
accessing
high level objects from the UI when logged in as admin. Are there other
GP
settings to modify?

Any ideas what to check next?


Reply With Quote
  #4  
Old   
James Buist
 
Posts: n/a

Default Re: SQL 2005 Managment Studio - Start Stop SQL Services on Win 200 - 11-03-2008 , 06:21 PM



Perfect. Many thanks for that. I'm still not used to that option being
required in 2008 and never thought to look. I figured I needed to do that to
modify Printer settings. Forgot about it here. I wish it could be turned off!
Do you know a group policy setting to disable that option so admins can just
operate everything as normal - I do not share my admin account with my user
account!

Regards

James

"Ekrem Önsoy" wrote:

Quote:
Will you try right clicking on the SSMS icon and Run as Administrator? A
customer was complaining about this and UAC was enabled at his side and this
worked for him.

--
Ekrem Önsoy



"James Buist" <JamesBuist (AT) discussions (DOT) microsoft.com> wrote in message
newsC41FD6E-7B96-49AC-91DE-B1EA7A07CCCD (AT) microsoft (DOT) com...
I have just installed SQL2005 on my new 2008 server. I have added the admin
user accounts to SQL2005 so I can login using Windows Authentication.
I'm running Win2K8 as a DC with all updates and SQL 2005 with SP2 and all
subsequent updates.
I can't stop and start services from within SQL Management Studio. I get
the
error the object can't be accessed and I think it is to do with the UAC in
Win2K8 but I've turned it off in the user account section. I have changed
the
Group Policy settings that seem relevent i.e there is no warning on
accessing
high level objects from the UI when logged in as admin. Are there other
GP
settings to modify?

Any ideas what to check next?


Reply With Quote
  #5  
Old   
James Buist
 
Posts: n/a

Default Re: SQL 2005 Managment Studio - Start Stop SQL Services on Win 200 - 11-03-2008 , 06:21 PM



Perfect. Many thanks for that. I'm still not used to that option being
required in 2008 and never thought to look. I figured I needed to do that to
modify Printer settings. Forgot about it here. I wish it could be turned off!
Do you know a group policy setting to disable that option so admins can just
operate everything as normal - I do not share my admin account with my user
account!

Regards

James

"Ekrem Önsoy" wrote:

Quote:
Will you try right clicking on the SSMS icon and Run as Administrator? A
customer was complaining about this and UAC was enabled at his side and this
worked for him.

--
Ekrem Önsoy



"James Buist" <JamesBuist (AT) discussions (DOT) microsoft.com> wrote in message
newsC41FD6E-7B96-49AC-91DE-B1EA7A07CCCD (AT) microsoft (DOT) com...
I have just installed SQL2005 on my new 2008 server. I have added the admin
user accounts to SQL2005 so I can login using Windows Authentication.
I'm running Win2K8 as a DC with all updates and SQL 2005 with SP2 and all
subsequent updates.
I can't stop and start services from within SQL Management Studio. I get
the
error the object can't be accessed and I think it is to do with the UAC in
Win2K8 but I've turned it off in the user account section. I have changed
the
Group Policy settings that seem relevent i.e there is no warning on
accessing
high level objects from the UI when logged in as admin. Are there other
GP
settings to modify?

Any ideas what to check next?


Reply With Quote
  #6  
Old   
James Buist
 
Posts: n/a

Default Re: SQL 2005 Managment Studio - Start Stop SQL Services on Win 200 - 11-03-2008 , 06:21 PM



Perfect. Many thanks for that. I'm still not used to that option being
required in 2008 and never thought to look. I figured I needed to do that to
modify Printer settings. Forgot about it here. I wish it could be turned off!
Do you know a group policy setting to disable that option so admins can just
operate everything as normal - I do not share my admin account with my user
account!

Regards

James

"Ekrem Önsoy" wrote:

Quote:
Will you try right clicking on the SSMS icon and Run as Administrator? A
customer was complaining about this and UAC was enabled at his side and this
worked for him.

--
Ekrem Önsoy



"James Buist" <JamesBuist (AT) discussions (DOT) microsoft.com> wrote in message
newsC41FD6E-7B96-49AC-91DE-B1EA7A07CCCD (AT) microsoft (DOT) com...
I have just installed SQL2005 on my new 2008 server. I have added the admin
user accounts to SQL2005 so I can login using Windows Authentication.
I'm running Win2K8 as a DC with all updates and SQL 2005 with SP2 and all
subsequent updates.
I can't stop and start services from within SQL Management Studio. I get
the
error the object can't be accessed and I think it is to do with the UAC in
Win2K8 but I've turned it off in the user account section. I have changed
the
Group Policy settings that seem relevent i.e there is no warning on
accessing
high level objects from the UI when logged in as admin. Are there other
GP
settings to modify?

Any ideas what to check next?


Reply With Quote
  #7  
Old   
James Buist
 
Posts: n/a

Default Re: SQL 2005 Managment Studio - Start Stop SQL Services on Win 200 - 11-03-2008 , 06:21 PM



Perfect. Many thanks for that. I'm still not used to that option being
required in 2008 and never thought to look. I figured I needed to do that to
modify Printer settings. Forgot about it here. I wish it could be turned off!
Do you know a group policy setting to disable that option so admins can just
operate everything as normal - I do not share my admin account with my user
account!

Regards

James

"Ekrem Önsoy" wrote:

Quote:
Will you try right clicking on the SSMS icon and Run as Administrator? A
customer was complaining about this and UAC was enabled at his side and this
worked for him.

--
Ekrem Önsoy



"James Buist" <JamesBuist (AT) discussions (DOT) microsoft.com> wrote in message
newsC41FD6E-7B96-49AC-91DE-B1EA7A07CCCD (AT) microsoft (DOT) com...
I have just installed SQL2005 on my new 2008 server. I have added the admin
user accounts to SQL2005 so I can login using Windows Authentication.
I'm running Win2K8 as a DC with all updates and SQL 2005 with SP2 and all
subsequent updates.
I can't stop and start services from within SQL Management Studio. I get
the
error the object can't be accessed and I think it is to do with the UAC in
Win2K8 but I've turned it off in the user account section. I have changed
the
Group Policy settings that seem relevent i.e there is no warning on
accessing
high level objects from the UI when logged in as admin. Are there other
GP
settings to modify?

Any ideas what to check next?


Reply With Quote
  #8  
Old   
James Buist
 
Posts: n/a

Default Re: SQL 2005 Managment Studio - Start Stop SQL Services on Win 200 - 11-03-2008 , 06:21 PM



Perfect. Many thanks for that. I'm still not used to that option being
required in 2008 and never thought to look. I figured I needed to do that to
modify Printer settings. Forgot about it here. I wish it could be turned off!
Do you know a group policy setting to disable that option so admins can just
operate everything as normal - I do not share my admin account with my user
account!

Regards

James

"Ekrem Önsoy" wrote:

Quote:
Will you try right clicking on the SSMS icon and Run as Administrator? A
customer was complaining about this and UAC was enabled at his side and this
worked for him.

--
Ekrem Önsoy



"James Buist" <JamesBuist (AT) discussions (DOT) microsoft.com> wrote in message
newsC41FD6E-7B96-49AC-91DE-B1EA7A07CCCD (AT) microsoft (DOT) com...
I have just installed SQL2005 on my new 2008 server. I have added the admin
user accounts to SQL2005 so I can login using Windows Authentication.
I'm running Win2K8 as a DC with all updates and SQL 2005 with SP2 and all
subsequent updates.
I can't stop and start services from within SQL Management Studio. I get
the
error the object can't be accessed and I think it is to do with the UAC in
Win2K8 but I've turned it off in the user account section. I have changed
the
Group Policy settings that seem relevent i.e there is no warning on
accessing
high level objects from the UI when logged in as admin. Are there other
GP
settings to modify?

Any ideas what to check next?


Reply With Quote
  #9  
Old   
James Buist
 
Posts: n/a

Default Re: SQL 2005 Managment Studio - Start Stop SQL Services on Win 200 - 11-03-2008 , 06:21 PM



Perfect. Many thanks for that. I'm still not used to that option being
required in 2008 and never thought to look. I figured I needed to do that to
modify Printer settings. Forgot about it here. I wish it could be turned off!
Do you know a group policy setting to disable that option so admins can just
operate everything as normal - I do not share my admin account with my user
account!

Regards

James

"Ekrem Önsoy" wrote:

Quote:
Will you try right clicking on the SSMS icon and Run as Administrator? A
customer was complaining about this and UAC was enabled at his side and this
worked for him.

--
Ekrem Önsoy



"James Buist" <JamesBuist (AT) discussions (DOT) microsoft.com> wrote in message
newsC41FD6E-7B96-49AC-91DE-B1EA7A07CCCD (AT) microsoft (DOT) com...
I have just installed SQL2005 on my new 2008 server. I have added the admin
user accounts to SQL2005 so I can login using Windows Authentication.
I'm running Win2K8 as a DC with all updates and SQL 2005 with SP2 and all
subsequent updates.
I can't stop and start services from within SQL Management Studio. I get
the
error the object can't be accessed and I think it is to do with the UAC in
Win2K8 but I've turned it off in the user account section. I have changed
the
Group Policy settings that seem relevent i.e there is no warning on
accessing
high level objects from the UI when logged in as admin. Are there other
GP
settings to modify?

Any ideas what to check next?


Reply With Quote
  #10  
Old   
James Buist
 
Posts: n/a

Default Re: SQL 2005 Managment Studio - Start Stop SQL Services on Win 200 - 11-03-2008 , 06:21 PM



Perfect. Many thanks for that. I'm still not used to that option being
required in 2008 and never thought to look. I figured I needed to do that to
modify Printer settings. Forgot about it here. I wish it could be turned off!
Do you know a group policy setting to disable that option so admins can just
operate everything as normal - I do not share my admin account with my user
account!

Regards

James

"Ekrem Önsoy" wrote:

Quote:
Will you try right clicking on the SSMS icon and Run as Administrator? A
customer was complaining about this and UAC was enabled at his side and this
worked for him.

--
Ekrem Önsoy



"James Buist" <JamesBuist (AT) discussions (DOT) microsoft.com> wrote in message
newsC41FD6E-7B96-49AC-91DE-B1EA7A07CCCD (AT) microsoft (DOT) com...
I have just installed SQL2005 on my new 2008 server. I have added the admin
user accounts to SQL2005 so I can login using Windows Authentication.
I'm running Win2K8 as a DC with all updates and SQL 2005 with SP2 and all
subsequent updates.
I can't stop and start services from within SQL Management Studio. I get
the
error the object can't be accessed and I think it is to do with the UAC in
Win2K8 but I've turned it off in the user account section. I have changed
the
Group Policy settings that seem relevent i.e there is no warning on
accessing
high level objects from the UI when logged in as admin. Are there other
GP
settings to modify?

Any ideas what to check next?


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.