 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Security / May 2006SQL 2005 user not having permissions to write a file in a folder
Hi , We have a product that is currently working with dotnet 1.1 and SQL 2000 & MSDE , now we are upgrading it for SQL2005 and SQL Express and framework 2.0, we use a stored procedure that reads a binary data from the database and writes it into a file on the file system, this was working perfect in sql 2000 but in 2005 it is bombing saying access denied.The sql user is of type sysadmin, there seems to be some permission we need to provide or something.Please help.It especially seems to give issues in SQL express please guide as to why this problem is happening and how do we fix it, the stored procedure works perfectly for MSDE and SQL SERVER 2000 Best Regards, Niketa > Hi , > We have a product that is currently working with dotnet 1.1 and SQL 2000 & [quoted text clipped - 10 lines] > Best Regards, > Niketa Check the account that the SQL Server service is running under. The file operations will occur under those credentials. David You can check CREDENTIAL clause in CREATE LOGIN statement. "Vaibhav Goel"님이 작성한 내용: > Hi , > We have a product that is currently working with dotnet 1.1 and SQL 2000 & [quoted text clipped - 8 lines] > Best Regards, > Niketa How are you writing to the file? Is the app or the stored procedure doing this? I don't suppose you're using xp_cmdshell (you shouldn't be for this). :) If you are, you have to go into the surface area configuration tool and enable xp_cmdshell. Otherwise, you'll fail regardless of what permissions your login has.  SignatureMeanOldDBA derrickleggett@hotmail.com http://weblogs.sqlteam.com/derrickl When life gives you a lemon, fire the DBA. > You can check CREDENTIAL clause in CREATE LOGIN statement. > [quoted text clipped - 12 lines] > > Best Regards, > > Niketa HI , WHat credential must we specify in the create login statement, also i believe we can alter credentials too right? Either way please tell me what credential we must specify to allow SQL server to use stored procedure to write a file on the server machine folder.The sql server is running under a user account who is an administrator > You can check CREDENTIAL clause in CREATE LOGIN statement. > [quoted text clipped - 12 lines] > > Best Regards, > > Niketa HI , WHat credential must we specify in the create login statement, also i believe we can alter credentials too right? Either way please tell me what credential we must specify to allow SQL server to use stored procedure to write a file on the server machine folder.The sql server is running under a user account who is an administrator > You can check CREDENTIAL clause in CREATE LOGIN statement. > [quoted text clipped - 12 lines] > > Best Regards, > > Niketa You can ignore the CREDENTIAL clause in CREATE LOGIN. That is currently unused. Thanks SignatureLaurentiu Cristofor [MSFT] Software Design Engineer SQL Server Engine http://blogs.msdn.com/lcris/ This posting is provided "AS IS" with no warranties, and confers no rights. > HI , > WHat credential must we specify in the create login statement, also i [quoted text clipped - 26 lines] >> > Best Regards, >> > Niketa Hi, Yes that was the problem i changed the account through the SCM utility and it worked perfectly please tell me how do we ensure that when sqlserver/e > You can check CREDENTIAL clause in CREATE LOGIN statement. > [quoted text clipped - 12 lines] > > Best Regards, > > Niketa Hi, Yes that was the problem i changed the account through the SCM utility and it worked perfectly please tell me how do we ensure that when sqlserver/express is launched it runs under the account of the administrator is there any paramter that can be influenced while launching it.The product installs the sqlserver/express yet it shows that it is running under the network service account , how do we make sure that when we launch sql server / express it runs under the local user account? Please help. > You can check CREDENTIAL clause in CREATE LOGIN statement. > [quoted text clipped - 12 lines] > > Best Regards, > > Niketa |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.