Create a SQL Server database on Samba share on Linux hostWhat are the implications of changing the SQL Server...
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?
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
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
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
edited 6 mins ago
Paul White♦
52.1k14278450
asked Feb 14 '18 at 7:20
unubarunubar
1
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
sql-server linux configuration
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
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
edited 6 mins ago
Paul White♦
52.1k14278450
52.1k14278450
asked Feb 14 '18 at 7:20
unubarunubar
1
asked Feb 14 '18 at 7:20
unubarunubar
1
asked Feb 14 '18 at 7:20
unubarunubar
1
1
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
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.
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
});
}
});
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
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
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
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.
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.
answered 10 mins ago
Comment ConverterComment Converter
1,2471325
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.
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
answered 10 mins ago
Comment ConverterComment Converter
1,2471325
1,2471325
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
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
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
