Re: Sql Server login



One method is to login to you laptop using a local Windows account. By
default, members of the member of the local Administrators group are
sysadmin role members.

You could also configure SQL Server to allow both Windows and SQL Server
authentication from Enterprise Manager under the security tab of server
properties. Then create a standard SQL security login.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Aamir" <aamir.majeed@xxxxxxxxx> wrote in message
news:1142334398.538640.216970@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I installed SQL server on my Laptop at office domain with windows
authentication and now when I am trying to use that SqlServer in home
when I logged in with System Account I could not able to log in Sql
Server Is there anyway that I could sign in Sql Server without being
log in the system with domain account.



.



Relevant Pages

  • Re: Rid AD of Circular Group Membership
    ... and have use on members if it is used there. ... Administrators group is still intact), nor do they have empowerments over ... Admins is being used for by the 30+ can be delegated I(ex. ... The quess is each has an account and uses it, ...
    (microsoft.public.windows.group_policy)
  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: adminDSholder being over zealous!
    ... I have experienced the same problems, where users in members of groups ... without the account ACLs reverting to match AdminSDHolder. ... account operators can manage their own accounts or the ... >>A supported fix is now available from Microsoft, ...
    (microsoft.public.win2000.security)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)