Re: Domain or Local User Account for Laptop SQL 2008 Services

Hi cpnet,
Thank you for your detailed response.

I noticed that you said:
for explicit permissions, "myDomain\MyUser" is only granted "Connect SQL", and this is granted by "sa".

However you also said:
2008: "myDomain\MyUser" is also in the "sysadmin" server role;

May you let me know why you granted "CONNECT SQL" here since you had asigned the fixed server role sysadmin to your domain user?

In my former test, I simply added my domain user account as a sysadmin in both SQL Server 2005 and 2008 instance, and they all worked fine when they were disconnected from the domain.
Also the domain name listed in my SQL Server 2008 Management Studio was in upper case like "MYDOMAIN\myuser". Could you please let me know you SQL Server 2008 version, CTP or RTM?
My SQL Server 2008 was Enterprise Edition RTM with the version 10.0.1600.


Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================











.

Relevant Pages

  • The Company Who cheated me Fake client/server application
    ... Manager begin to Complain From yearly inventory Report the Process takes ... I write My Recommendation to manager Ask Him Purchasing Brand new server ... After Install Process Finish I Attach the Databases and Run Sql Agent ... Inside Fake client/server application: ...
    (microsoft.public.sqlserver.server)
  • Re: 64 bit analysis server
    ... Remote adminstration is how SQL Server 2000 is configured for 64-bit servers ... Program Manager ... SQL BI Product Unit ... >>require other SP3 machines to administer them. ...
    (microsoft.public.sqlserver.olap)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... Manager nusance has been around, and yet they somehow could never find time ... counter Total Server Mmeory shows 18GB. ... due to how the large memory allocation APIs work. ... Swap files for SQL do not need to be more than about 2-4 GB ...
    (microsoft.public.sqlserver.clustering)
  • Re: sql server service manager
    ... aber im sql server service manager kann ich doch den server und ... den service starten und auch den autostart einstellen. ... >> manager nicht gestartet. ... > Der SQL Server ist ein Dienst, ...
    (microsoft.public.de.sqlserver)
  • Re: SQL Server Express Manager
    ... Lead Program Manager - SQL Server ... Windows Server System UX Global Engineering Group ... Microsoft kann für die Richtigkeit und Vollständigkeit der Inhalte in dieser ...
    (microsoft.public.de.sqlserver)