Installing SQL Server 2014 express on a computer with no domain

MR BILL 256 Reputation points
2021-03-08T13:57:43.17+00:00

Normally when installing SQL Server 2014 express on a domain computer the service is normally NT Service. What is the best way to install SQL Server 2014 express on a computer with a workgroup. I'm running into issues where the logged in user or service does not have permissions to the server/database. Can anyone help or tell me what I need to do to install it without running into these permission issues? Also what Local Security Policies for the user may need to be granted.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,714 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,816 Reputation points
    2021-03-08T15:33:09.587+00:00

    the service is normally NT Service

    That has nothing to do with domain or workgroup, that's always the default services account and can be changed during installation or later.
    And that service account has nothing to do with the user (logins) accessing SQL Server.
    So I don't understand your worries here?

    0 comments
  2. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
    2021-03-09T03:45:32.82+00:00

    Hi @MR BILL ,

    > the service is normally NT Service

    This is default service account, we can change the service account from SQL server configure manager. Suggestion you read the MS document Configure Windows Service Accounts and Permissions to get more information about the default configuration of services of SQL Server, and configuration options for SQL Server services that you can set during and after SQL Server installation.

    > where the logged in user or service does not have permissions to the server/database.

    SQL server service account is different from SQL server login account.

    SQL server service account is that account that SQL service running under . You can change it to Local system that is a very high-privileged built-in account. Or change it to another account has the permission to SQL server service.

    SQL server login account is the identity of the person or process that is connecting to an instance of SQL Server. A login is a security principal, or an entity that can be authenticated by a secure system. Users need a login to connect to SQL Server. You can create a login based on a Windows principal (such as a domain user or a Windows domain group) or you can create a login that is not based on a Windows principal (such as an SQL Server login). Suggest you read MS document to better understand SQL login account.

    If the response is helpful, please click "Accept Answer" and upvote it, thank you.

    0 comments