Sfrgttk

Why did Shae (falsely) implicate Sansa?

Can a planet be tidally unlocked?

Complicated square root problem.

How to play song that contains one guitar when we have two guitarists (or more)?

Why is it a problem for Freddie if the guys from Munich did what he wanted?

Does an increasing sequence of reals converge if the difference of consecutive terms approaches zero?

How to know if I am a 'Real Developer'

How to assess the susceptibility of a U.S. company to go bankrupt?

Is there a technology capable of disabling the whole of Earth's satellitle network?

Bitcoin automatically diverted to bech32 address

Was Opportunity's last message to Earth "My battery is low and it's getting dark"?

Is it possible to detect 100% of SQLi with a simple regex?

Buying a "Used" Router

Ethernet cable only works in certain positions

Suggestions on how to improve logo

How can a kingdom keep the secret of a missing monarchy from the public?

Why does calling Python's 'magic method' not do type conversion like it would for the corresponding operator?

How can guns be countered by melee combat without raw-ability or exceptional explanations?

Taking an academic pseudonym?

A dragon's soul trapped in a ring of mind shielding wants a new body; what magic could enable her to do so?

Is 'bad luck' with former employees a red flag?

Headless horseman claims new head

How to draw these kind of adjacent ovals with arrows in latex?

Substitute ./ and ../ directories by actual names

Create a SQL Server database on Samba share on Linux host

What are the implications of changing the SQL Server Service Logon Account?Once more about SQL Server virtual accountsChanging the SQL Server service account - any additional considerations?Scenario/Method (idea) for transfering database from one server to anotherCreate Linked Server using Active Directory accountWhat are points to consider when replacing the SQL Server service account?LDAP Authentication - SQL Server 2017 on LinuxSQL Server service permissions on network share depending on IntegratedSecurity=true/falseSQL Server 2017 Failover Cluster on RHEL LinuxHow do I use a different domain and username in a SQL Server BACKUP LOG command?

-2

I want to create a SQL Server database on a Samba share on a Linux host.

The Samba share is accessible from the Windows machine where SQL Server is installed. It connects to the Samba share using a username on the Linux host. Since SQL Server uses its own service account, how can I make the service account logon to the Linux host with the username that has access to the Samba share?

I have looked at this:

Configure File System Permissions for Database Engine Access

But it only shows how to give permissions to the SQL Server account. I want the SQL Server account to actually use another account to logon to the Samba share.

sql-server linux configuration

share|improve this question

edited 6 mins ago

Paul White♦

52.1k14278450

asked Feb 14 '18 at 7:20

unubarunubar

1

add a comment | 

-2

I want to create a SQL Server database on a Samba share on a Linux host.

The Samba share is accessible from the Windows machine where SQL Server is installed. It connects to the Samba share using a username on the Linux host. Since SQL Server uses its own service account, how can I make the service account logon to the Linux host with the username that has access to the Samba share?

I have looked at this:

Configure File System Permissions for Database Engine Access

But it only shows how to give permissions to the SQL Server account. I want the SQL Server account to actually use another account to logon to the Samba share.

sql-server linux configuration

share|improve this question

edited 6 mins ago

Paul White♦

52.1k14278450

asked Feb 14 '18 at 7:20

unubarunubar

1

add a comment | 

I want to create a SQL Server database on a Samba share on a Linux host.

The Samba share is accessible from the Windows machine where SQL Server is installed. It connects to the Samba share using a username on the Linux host. Since SQL Server uses its own service account, how can I make the service account logon to the Linux host with the username that has access to the Samba share?

I have looked at this:

Configure File System Permissions for Database Engine Access

But it only shows how to give permissions to the SQL Server account. I want the SQL Server account to actually use another account to logon to the Samba share.

sql-server linux configuration

share|improve this question

edited 6 mins ago

Paul White♦

52.1k14278450

asked Feb 14 '18 at 7:20

unubarunubar

1

share|improve this question

edited 6 mins ago

Paul White♦

52.1k14278450

asked Feb 14 '18 at 7:20

unubarunubar

1

share|improve this question

edited 6 mins ago

Paul White♦

52.1k14278450

asked Feb 14 '18 at 7:20

unubarunubar

1

edited 6 mins ago

Paul White♦

52.1k14278450

edited 6 mins ago

Paul White♦

52.1k14278450

asked Feb 14 '18 at 7:20

unubarunubar

1

asked Feb 14 '18 at 7:20

unubarunubar

1

1 Answer
1

active

oldest

votes

0

_{Answer left in a comment by kirchner}

You can change the service account to one that has access to your share.

SQL Server will not impersonate when opening database files, and there is no way to change it.

share|improve this answer

answered 10 mins ago

Comment ConverterComment Converter

1,2471325

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f197874%2fcreate-a-sql-server-database-on-samba-share-on-linux-host%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

_{Answer left in a comment by kirchner}

You can change the service account to one that has access to your share.

SQL Server will not impersonate when opening database files, and there is no way to change it.

share|improve this answer

answered 10 mins ago

Comment ConverterComment Converter

1,2471325

add a comment | 

0

_{Answer left in a comment by kirchner}

You can change the service account to one that has access to your share.

SQL Server will not impersonate when opening database files, and there is no way to change it.

share|improve this answer

answered 10 mins ago

Comment ConverterComment Converter

1,2471325

add a comment | 

_{Answer left in a comment by kirchner}

You can change the service account to one that has access to your share.

SQL Server will not impersonate when opening database files, and there is no way to change it.

share|improve this answer

answered 10 mins ago

Comment ConverterComment Converter

1,2471325

share|improve this answer

answered 10 mins ago

Comment ConverterComment Converter

1,2471325

answered 10 mins ago

Comment ConverterComment Converter

1,2471325

answered 10 mins ago

Comment ConverterComment Converter

1,2471325