question

PaulBill-8748 avatar image
0 Votes"
PaulBill-8748 asked ·

Installing SQL Server 2014 express on a computer with no domain

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-general
· 1
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @PaulBill-8748,

We have not received a response from you. Did the replies could help you? If the response helped, do "Accept Answer". If it is not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered ·

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?



·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered ·

Hi @PaulBill-8748,

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.



·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.