Re: SQL 2005 user not having permissions to write a file in a fold

You can ignore the CREDENTIAL clause in CREATE LOGIN. That is currently
unused.

Thanks

--
Laurentiu 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.

"Vaibhav Goel" <VaibhavGoel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DD54435C-3129-4C8A-8C51-70F5ECCECF5B@xxxxxxxxxxxxxxxx
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



"hongju" wrote:

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 &
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


.

Relevant Pages

  • Re: SQL server -- prevent application end users from loggin to sql ser
    ... Those client tools will access SQL ... Server and any databases allowed to their credentials. ... 4.If they get their own laptops which has sql client tools, ... access) to that sql server box directly. ...
    (microsoft.public.sqlserver.security)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)
  • Re: Probably a simple question
    ... passing user's credentials to the SQL Server. ... applications just keep a separate SQL login ID for database operations (all ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: SQL Connectivity by Web App
    ... > The most common approach to this common problem is to specify SQL ... > credentials in the connection string. ... > protect the connection string at storage, which is a challenge, but unless ... > you want to propagate user's credentials to SQL server, ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)