SQL Server account and login permissions for NAS?Tool to test a user account and password (test login)How to connect to local instance of SQL Server 2008 ExpressC#/SQL Server: Login failed when connecting from remote machineSQL Server 2005: Move account from one server to another while maintaining unknown passwordConstant Errors on SQL server, Event ID 28005 and 4625sql server trusted connection with windows 8 microsoft accountCoverting MySQL SQL statements to SQL ServerUnable to backup SQL database due to insufficient permissionsMS SQL replication run only with system accountIs it possible for a group policy to interfere with a Sql Server Express installation?
Why aren't (poly-)cotton tents more popular?
Proof of (weak) consistency for an unbiased estimator
In the Marvel universe, can a human have a baby with any non-human?
What is this particular type of chord progression, common in classical music, called?
Why does the numerical solution of an ODE move away from an unstable equilibrium?
Is my Rep in Stack-Exchange Form?
Inverse-quotes-quine
Does anycast addressing add additional latency in any way?
First-year PhD giving a talk among well-established researchers in the field
How to determine what is the correct level of detail when modelling?
How should I behave to assure my friends that I am not after their money?
How come I was asked by a CBP officer why I was in the US?
Fedora boot screen shows both Fedora logo and Lenovo logo. Why and How?
Does squid ink pasta bleed?
Why is Madam Hooch not a professor?
Alternatives to arc
STM32 crashes when FreeRTOS project is converted to C++
Use color ramp to mix materials
Is there a short way to compare many values mutually at same time without using multiple 'and's?
How many satellites can stay in a Lagrange point?
Fitting a mixture of two normal distributions for a data set?
How often can a PC check with passive perception during a combat turn?
What determines the "strength of impact" of a falling object on the ground, momentum or energy?
Challenging plot in "3D"
SQL Server account and login permissions for NAS?
Tool to test a user account and password (test login)How to connect to local instance of SQL Server 2008 ExpressC#/SQL Server: Login failed when connecting from remote machineSQL Server 2005: Move account from one server to another while maintaining unknown passwordConstant Errors on SQL server, Event ID 28005 and 4625sql server trusted connection with windows 8 microsoft accountCoverting MySQL SQL statements to SQL ServerUnable to backup SQL database due to insufficient permissionsMS SQL replication run only with system accountIs it possible for a group policy to interfere with a Sql Server Express installation?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
We use MS SQL server express 2008 R2 to store data for our application. Recently, we've started storing the databases on a shared NAS drive. Previously, we had the sql server "log in as" built in account: local system - because our database were stored locally. To make it work with the NAS we had to change this to "this account" and have the installer enter a username and password. This makes install more complicated, as they have to know a suitable account and pw.
A customer recently tried this with a computer which had a local windows (Win7) username and password that wasn't recognised by the NAS. Even though the NAS had write permissions enabled for everyone - so the user could create files on the NAS - when SQL server was given that username and password, the server couldn't write to the NAS. Error thrown was 1317 "The specified account does not exist."
My question is why can a user who is logged in on a paticular username write to a NAS, but, SQL, using the same username can't? Is there a workaround? (this would be useful when we want to do quick demos)
windows sql
asked Mar 22 '13 at 20:06
SugrueSugrue
1409 bronze badges
add a comment |
We use MS SQL server express 2008 R2 to store data for our application. Recently, we've started storing the databases on a shared NAS drive. Previously, we had the sql server "log in as" built in account: local system - because our database were stored locally. To make it work with the NAS we had to change this to "this account" and have the installer enter a username and password. This makes install more complicated, as they have to know a suitable account and pw.
A customer recently tried this with a computer which had a local windows (Win7) username and password that wasn't recognised by the NAS. Even though the NAS had write permissions enabled for everyone - so the user could create files on the NAS - when SQL server was given that username and password, the server couldn't write to the NAS. Error thrown was 1317 "The specified account does not exist."
My question is why can a user who is logged in on a paticular username write to a NAS, but, SQL, using the same username can't? Is there a workaround? (this would be useful when we want to do quick demos)
windows sql
asked Mar 22 '13 at 20:06
SugrueSugrue
1409 bronze badges
add a comment |
We use MS SQL server express 2008 R2 to store data for our application. Recently, we've started storing the databases on a shared NAS drive. Previously, we had the sql server "log in as" built in account: local system - because our database were stored locally. To make it work with the NAS we had to change this to "this account" and have the installer enter a username and password. This makes install more complicated, as they have to know a suitable account and pw.
A customer recently tried this with a computer which had a local windows (Win7) username and password that wasn't recognised by the NAS. Even though the NAS had write permissions enabled for everyone - so the user could create files on the NAS - when SQL server was given that username and password, the server couldn't write to the NAS. Error thrown was 1317 "The specified account does not exist."
My question is why can a user who is logged in on a paticular username write to a NAS, but, SQL, using the same username can't? Is there a workaround? (this would be useful when we want to do quick demos)
windows sql
asked Mar 22 '13 at 20:06
SugrueSugrue
1409 bronze badges
We use MS SQL server express 2008 R2 to store data for our application. Recently, we've started storing the databases on a shared NAS drive. Previously, we had the sql server "log in as" built in account: local system - because our database were stored locally. To make it work with the NAS we had to change this to "this account" and have the installer enter a username and password. This makes install more complicated, as they have to know a suitable account and pw.
A customer recently tried this with a computer which had a local windows (Win7) username and password that wasn't recognised by the NAS. Even though the NAS had write permissions enabled for everyone - so the user could create files on the NAS - when SQL server was given that username and password, the server couldn't write to the NAS. Error thrown was 1317 "The specified account does not exist."
My question is why can a user who is logged in on a paticular username write to a NAS, but, SQL, using the same username can't? Is there a workaround? (this would be useful when we want to do quick demos)
windows sql
windows sql
asked Mar 22 '13 at 20:06
SugrueSugrue
1409 bronze badges
asked Mar 22 '13 at 20:06
SugrueSugrue
1409 bronze badges
asked Mar 22 '13 at 20:06
SugrueSugrue
1409 bronze badges
asked Mar 22 '13 at 20:06
SugrueSugrue
1409 bronze badges
asked Mar 22 '13 at 20:06
SugrueSugrue
1409 bronze badges
1409 bronze badges
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
Given that SQL Server Express can only hold a very small amount of data, 4 Gigs I think, using a shared NAS is probably overkill for storage. As to why it would work for a person and not for an account when using the same credentials, no idea. You'd have to talk to the NAS vendor (or at least identify them) to figure that out as it's the NAS which is rejecting the connection.
answered Mar 22 '13 at 20:28
mrdennymrdenny
26.4k4 gold badges36 silver badges66 bronze badges
SQL Server 2008 R2 Express has a 10GB limit for the DB, but the db can link to external files (eg videos) of any size.
– Sugrue
Mar 22 '13 at 21:44
This is the device in question: synology.com/products/product.php?product_name=DS2411%2B
– Sugrue
Mar 22 '13 at 22:00
Those videos would be outside the database then, and the application would simply point to files in a folder which the database has a reference to. The database and the video files don't need to exist in the same location.
– mrdenny
Mar 23 '13 at 0:35
There are other reasons why the DB has to be on the NAS. I don't want to redesign the application just to solve a SQL login bug.
– Sugrue
Mar 23 '13 at 8:48
That's going to be an issue with the NAS and how it's handling authentication tokens from Windows. SQL doesn't know anything about Windows authentication other than to hand authentication requests to the server or the domain. There's no application redesign. Just tell SQL Server to store the database on local disk. The application doesn't care where the actual database sits.
– mrdenny
Mar 25 '13 at 20:51
|
show 2 more comments
Try to execute command before backup to connect to your shared folder at NAS:
net use \<NAS><shared-folder> <password> /user:<domain><user>
...and execute after backup to disconnect:
net use \<NAS><shared-folder> /delete
edited Jun 2 '13 at 19:51
Bryan
6,38510 gold badges59 silver badges89 bronze badges
answered Jun 2 '13 at 19:28
AlexeyAlexey
1012 bronze badges
Thanks. What does this do?
– Sugrue
Jun 3 '13 at 8:25
...mounting ("mapping" in Microsoft terminology) drive shares in a network environment... en.wikipedia.org/wiki/Net_use
– Alexey
Jun 3 '13 at 10:12
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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%2fserverfault.com%2fquestions%2f490610%2fsql-server-account-and-login-permissions-for-nas%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Given that SQL Server Express can only hold a very small amount of data, 4 Gigs I think, using a shared NAS is probably overkill for storage. As to why it would work for a person and not for an account when using the same credentials, no idea. You'd have to talk to the NAS vendor (or at least identify them) to figure that out as it's the NAS which is rejecting the connection.
answered Mar 22 '13 at 20:28
mrdennymrdenny
26.4k4 gold badges36 silver badges66 bronze badges
SQL Server 2008 R2 Express has a 10GB limit for the DB, but the db can link to external files (eg videos) of any size.
– Sugrue
Mar 22 '13 at 21:44
This is the device in question: synology.com/products/product.php?product_name=DS2411%2B
– Sugrue
Mar 22 '13 at 22:00
Those videos would be outside the database then, and the application would simply point to files in a folder which the database has a reference to. The database and the video files don't need to exist in the same location.
– mrdenny
Mar 23 '13 at 0:35
There are other reasons why the DB has to be on the NAS. I don't want to redesign the application just to solve a SQL login bug.
– Sugrue
Mar 23 '13 at 8:48
That's going to be an issue with the NAS and how it's handling authentication tokens from Windows. SQL doesn't know anything about Windows authentication other than to hand authentication requests to the server or the domain. There's no application redesign. Just tell SQL Server to store the database on local disk. The application doesn't care where the actual database sits.
– mrdenny
Mar 25 '13 at 20:51
|
show 2 more comments
Given that SQL Server Express can only hold a very small amount of data, 4 Gigs I think, using a shared NAS is probably overkill for storage. As to why it would work for a person and not for an account when using the same credentials, no idea. You'd have to talk to the NAS vendor (or at least identify them) to figure that out as it's the NAS which is rejecting the connection.
answered Mar 22 '13 at 20:28
mrdennymrdenny
26.4k4 gold badges36 silver badges66 bronze badges
SQL Server 2008 R2 Express has a 10GB limit for the DB, but the db can link to external files (eg videos) of any size.
– Sugrue
Mar 22 '13 at 21:44
This is the device in question: synology.com/products/product.php?product_name=DS2411%2B
– Sugrue
Mar 22 '13 at 22:00
Those videos would be outside the database then, and the application would simply point to files in a folder which the database has a reference to. The database and the video files don't need to exist in the same location.
– mrdenny
Mar 23 '13 at 0:35
There are other reasons why the DB has to be on the NAS. I don't want to redesign the application just to solve a SQL login bug.
– Sugrue
Mar 23 '13 at 8:48
That's going to be an issue with the NAS and how it's handling authentication tokens from Windows. SQL doesn't know anything about Windows authentication other than to hand authentication requests to the server or the domain. There's no application redesign. Just tell SQL Server to store the database on local disk. The application doesn't care where the actual database sits.
– mrdenny
Mar 25 '13 at 20:51
|
show 2 more comments
Given that SQL Server Express can only hold a very small amount of data, 4 Gigs I think, using a shared NAS is probably overkill for storage. As to why it would work for a person and not for an account when using the same credentials, no idea. You'd have to talk to the NAS vendor (or at least identify them) to figure that out as it's the NAS which is rejecting the connection.
answered Mar 22 '13 at 20:28
mrdennymrdenny
26.4k4 gold badges36 silver badges66 bronze badges
Given that SQL Server Express can only hold a very small amount of data, 4 Gigs I think, using a shared NAS is probably overkill for storage. As to why it would work for a person and not for an account when using the same credentials, no idea. You'd have to talk to the NAS vendor (or at least identify them) to figure that out as it's the NAS which is rejecting the connection.
answered Mar 22 '13 at 20:28
mrdennymrdenny
26.4k4 gold badges36 silver badges66 bronze badges
answered Mar 22 '13 at 20:28
mrdennymrdenny
26.4k4 gold badges36 silver badges66 bronze badges
answered Mar 22 '13 at 20:28
mrdennymrdenny
26.4k4 gold badges36 silver badges66 bronze badges
answered Mar 22 '13 at 20:28
mrdennymrdenny
26.4k4 gold badges36 silver badges66 bronze badges
26.4k4 gold badges36 silver badges66 bronze badges
SQL Server 2008 R2 Express has a 10GB limit for the DB, but the db can link to external files (eg videos) of any size.
– Sugrue
Mar 22 '13 at 21:44
This is the device in question: synology.com/products/product.php?product_name=DS2411%2B
– Sugrue
Mar 22 '13 at 22:00
Those videos would be outside the database then, and the application would simply point to files in a folder which the database has a reference to. The database and the video files don't need to exist in the same location.
– mrdenny
Mar 23 '13 at 0:35
There are other reasons why the DB has to be on the NAS. I don't want to redesign the application just to solve a SQL login bug.
– Sugrue
Mar 23 '13 at 8:48
That's going to be an issue with the NAS and how it's handling authentication tokens from Windows. SQL doesn't know anything about Windows authentication other than to hand authentication requests to the server or the domain. There's no application redesign. Just tell SQL Server to store the database on local disk. The application doesn't care where the actual database sits.
– mrdenny
Mar 25 '13 at 20:51
|
show 2 more comments
SQL Server 2008 R2 Express has a 10GB limit for the DB, but the db can link to external files (eg videos) of any size.
– Sugrue
Mar 22 '13 at 21:44
This is the device in question: synology.com/products/product.php?product_name=DS2411%2B
– Sugrue
Mar 22 '13 at 22:00
Those videos would be outside the database then, and the application would simply point to files in a folder which the database has a reference to. The database and the video files don't need to exist in the same location.
– mrdenny
Mar 23 '13 at 0:35
There are other reasons why the DB has to be on the NAS. I don't want to redesign the application just to solve a SQL login bug.
– Sugrue
Mar 23 '13 at 8:48
That's going to be an issue with the NAS and how it's handling authentication tokens from Windows. SQL doesn't know anything about Windows authentication other than to hand authentication requests to the server or the domain. There's no application redesign. Just tell SQL Server to store the database on local disk. The application doesn't care where the actual database sits.
– mrdenny
Mar 25 '13 at 20:51
SQL Server 2008 R2 Express has a 10GB limit for the DB, but the db can link to external files (eg videos) of any size.
– Sugrue
Mar 22 '13 at 21:44
SQL Server 2008 R2 Express has a 10GB limit for the DB, but the db can link to external files (eg videos) of any size.
– Sugrue
Mar 22 '13 at 21:44
This is the device in question: synology.com/products/product.php?product_name=DS2411%2B
– Sugrue
Mar 22 '13 at 22:00
This is the device in question: synology.com/products/product.php?product_name=DS2411%2B
– Sugrue
Mar 22 '13 at 22:00
Those videos would be outside the database then, and the application would simply point to files in a folder which the database has a reference to. The database and the video files don't need to exist in the same location.
– mrdenny
Mar 23 '13 at 0:35
Those videos would be outside the database then, and the application would simply point to files in a folder which the database has a reference to. The database and the video files don't need to exist in the same location.
– mrdenny
Mar 23 '13 at 0:35
There are other reasons why the DB has to be on the NAS. I don't want to redesign the application just to solve a SQL login bug.
– Sugrue
Mar 23 '13 at 8:48
There are other reasons why the DB has to be on the NAS. I don't want to redesign the application just to solve a SQL login bug.
– Sugrue
Mar 23 '13 at 8:48
That's going to be an issue with the NAS and how it's handling authentication tokens from Windows. SQL doesn't know anything about Windows authentication other than to hand authentication requests to the server or the domain. There's no application redesign. Just tell SQL Server to store the database on local disk. The application doesn't care where the actual database sits.
– mrdenny
Mar 25 '13 at 20:51
That's going to be an issue with the NAS and how it's handling authentication tokens from Windows. SQL doesn't know anything about Windows authentication other than to hand authentication requests to the server or the domain. There's no application redesign. Just tell SQL Server to store the database on local disk. The application doesn't care where the actual database sits.
– mrdenny
Mar 25 '13 at 20:51
|
show 2 more comments
Try to execute command before backup to connect to your shared folder at NAS:
net use \<NAS><shared-folder> <password> /user:<domain><user>
...and execute after backup to disconnect:
net use \<NAS><shared-folder> /delete
edited Jun 2 '13 at 19:51
Bryan
6,38510 gold badges59 silver badges89 bronze badges
answered Jun 2 '13 at 19:28
AlexeyAlexey
1012 bronze badges
Thanks. What does this do?
– Sugrue
Jun 3 '13 at 8:25
...mounting ("mapping" in Microsoft terminology) drive shares in a network environment... en.wikipedia.org/wiki/Net_use
– Alexey
Jun 3 '13 at 10:12
add a comment |
Try to execute command before backup to connect to your shared folder at NAS:
net use \<NAS><shared-folder> <password> /user:<domain><user>
...and execute after backup to disconnect:
net use \<NAS><shared-folder> /delete
edited Jun 2 '13 at 19:51
Bryan
6,38510 gold badges59 silver badges89 bronze badges
answered Jun 2 '13 at 19:28
AlexeyAlexey
1012 bronze badges
Thanks. What does this do?
– Sugrue
Jun 3 '13 at 8:25
...mounting ("mapping" in Microsoft terminology) drive shares in a network environment... en.wikipedia.org/wiki/Net_use
– Alexey
Jun 3 '13 at 10:12
add a comment |
Try to execute command before backup to connect to your shared folder at NAS:
net use \<NAS><shared-folder> <password> /user:<domain><user>
...and execute after backup to disconnect:
net use \<NAS><shared-folder> /delete
edited Jun 2 '13 at 19:51
Bryan
6,38510 gold badges59 silver badges89 bronze badges
answered Jun 2 '13 at 19:28
AlexeyAlexey
1012 bronze badges
Try to execute command before backup to connect to your shared folder at NAS:
net use \<NAS><shared-folder> <password> /user:<domain><user>
...and execute after backup to disconnect:
net use \<NAS><shared-folder> /delete
edited Jun 2 '13 at 19:51
Bryan
6,38510 gold badges59 silver badges89 bronze badges
answered Jun 2 '13 at 19:28
AlexeyAlexey
1012 bronze badges
edited Jun 2 '13 at 19:51
Bryan
6,38510 gold badges59 silver badges89 bronze badges
edited Jun 2 '13 at 19:51
Bryan
6,38510 gold badges59 silver badges89 bronze badges
edited Jun 2 '13 at 19:51
Bryan
6,38510 gold badges59 silver badges89 bronze badges
6,38510 gold badges59 silver badges89 bronze badges
answered Jun 2 '13 at 19:28
AlexeyAlexey
1012 bronze badges
answered Jun 2 '13 at 19:28
AlexeyAlexey
1012 bronze badges
answered Jun 2 '13 at 19:28
AlexeyAlexey
1012 bronze badges
1012 bronze badges
Thanks. What does this do?
– Sugrue
Jun 3 '13 at 8:25
...mounting ("mapping" in Microsoft terminology) drive shares in a network environment... en.wikipedia.org/wiki/Net_use
– Alexey
Jun 3 '13 at 10:12
add a comment |
Thanks. What does this do?
– Sugrue
Jun 3 '13 at 8:25
...mounting ("mapping" in Microsoft terminology) drive shares in a network environment... en.wikipedia.org/wiki/Net_use
– Alexey
Jun 3 '13 at 10:12
Thanks. What does this do?
– Sugrue
Jun 3 '13 at 8:25
Thanks. What does this do?
– Sugrue
Jun 3 '13 at 8:25
...mounting ("mapping" in Microsoft terminology) drive shares in a network environment... en.wikipedia.org/wiki/Net_use
– Alexey
Jun 3 '13 at 10:12
...mounting ("mapping" in Microsoft terminology) drive shares in a network environment... en.wikipedia.org/wiki/Net_use
– Alexey
Jun 3 '13 at 10:12
add a comment |
Thanks for contributing an answer to Server Fault!
- 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%2fserverfault.com%2fquestions%2f490610%2fsql-server-account-and-login-permissions-for-nas%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
