Cannot Execute Xp_cmdshell. Access Is Denied While Copying Data Over The Network

Aug 7, 2006

Hi,

I am having
some trouble copying data over my workgroup network from my Windows
2003 Server Machine (machineA with SQL SERVER 2005) to one of my
network Machine's drive(MachineB).
Here is the T-SQL code that I am trying to execute:

EXEC xp_cmdshell 'copy D:Datafile.txt  \MachineBDocuments'

Whenever
I tried to execute the above piece of code, I get the error message
"Access is denied", but if I try to copy the file from the Command
Prompt (cmd.exe) with the copy command, the file copies fine over the
network.

I have already searched over the internet and I found
out that loads of people have the same issue, and they were suggested
something like this:
"Check in Services and make sure that the MSSQLServer service is run as
a domain user and that domain user has rights to these network
resources."

Well
it sounds plausible, but I don't know what are the exact steps to do
this. How do I know which user is running the MSSQL Server service? Are
they referring to the user which I use to connect to my SQL Server
Database engine throuhg the SQL Server Management Studio?
Also they are suggesting 'domain user', and as I said before I do not have domain network just regular simple workgroup network.

Here
are some details of the user that I use to login. I generally login
into my Windows 2003 Server machine with user called 'User1' and I use
the same 'User1' to connect to SQL Server through the Management Studio
Screen.
Should I create a user called 'User1' on my MachineB(Destination Machine)?

I would really appreciate, if someone can give me detailed steps explaning how to solve this problem.

Thank you very much once again.

View 11 Replies


ADVERTISEMENT

Cannot Execute Xp_cmdshell. Access Is Denied While Copying Data Over The Network

Aug 7, 2006

Hi,

I am having some trouble copying data over my workgroup network from my Windows 2003 Server Machine (machineA with SQL SERVER 2005) to one of my network Machine's drive(MachineB).
Here is the T-SQL code that I am trying to execute:

EXEC xp_cmdshell 'copy D:Datafile.txt \MachineBDocuments'

Whenever I tried to execute the above piece of code, I get the error message "Access is denied", but if I try to copy the file from the Command Prompt (cmd.exe) with the copy command, the file copies fine over the network.

I have already searched over the internet and I found out that loads of people have the same issue, and they were suggested something like this:
"Check in Services and make sure that the MSSQLServer service is run as
a domain user and that domain user has rights to these network
resources."

Well it sounds plausible, but I don't know what are the exact steps to do this. How do I know which user is running the MSSQL Server service? Are they referring to the user which I use to connect to my SQL Server Database engine throuhg the SQL Server Management Studio?
Also they are suggesting 'domain user', and as I said before I do not have domain network just regular simple workgroup network.

Here are some details of the user that I use to login. I generally login into my Windows 2003 Server machine with user called 'User1' and I use the same 'User1' to connect to SQL Server through the Management Studio Screen.
Should I create a user called 'User1' on my MachineB(Destination Machine)?

I would really appreciate, if someone can give me detailed steps explaning how to solve this problem.

Thank you very much once again.

View 18 Replies View Related

Xp_cmdshell Access Is Denied On Network Resource

Jun 27, 2007

I start receiving error 'Access is denied' executing following command:
exec xp_cmdshell 'dir \IP-ADDRESSSHARE_NAME*.*'

The configuration is following:
Two computers CO1 and CO2
Both computers are not in domain,
Both computers use the same local windows account to run their instances of SQL server 2005 and passwords for those accounts are the same
Both local accounts are in their local administrative groups
Both servers do not have configured proxy account. I execute sql commands under ther sysadmin account

If I execute this command from CO1 to CO2, everything works.
exec xp_cmdshell 'dir \CO2_IPSHARE_NAME*.*'
If I execute from CO2 to CO1 I receive access denied.
exec xp_cmdshell 'dir \CO1_IPSHARE_NAME*.*'

If I will log in to the computer CO2 under account of SQL server and execute the dir command from it, it works.
dir \CO1_IPSHARE_NAME*.*

Could you point me where to look?

View 12 Replies View Related

Access Denied Error Message Using Xp_cmdshell To Access Network Share

Jan 14, 2007

When running the following statement in SQL 2005, I get the error message "Access is denied":

exec master.dbo.xp_cmdshell 'TYPE \SERVER-BSHAREFILE.TXT'



The following are true about the network:

The SQL Server is installed on SERVER-A.
SERVER-A and SERVER-B are Windows 2003 servers on the same Windows 2003 domain.
The SQL Server and SQL Server Agent services are running under the domain account SQLSERVICE.
SQLSERVICE is a member of the Domain Admins group.
The Domain Admins group is part of the local Administrators group on SERVER-B.
The SQLSERVICE account has also explicitly been given Full Control to the folder referenced by \SERVER-BSHARE
xp_cmdshell use has been enabled on the SQL Server.


If I run the following command in SQL:

exec master.dbo.xp_cmdshell 'whoami'the following is returned: DOMAINSQLSERVICE
If I change the command to access the c: drive instead of a network drive, it executes successfully.

Can anyone shed some light on why I still cannot access any of the files in this folder using xp_cmdshell?

Tim

View 5 Replies View Related

Xp_cmdshell - Access Is Denied Problem

Feb 25, 2008

Good afternoon all,

I am trying to run the following but I get "Access is Denied".

declare
@SPsysname,
@Instancesysname,
@SQLvarchar(2000),
@theDate datetime

-- Initialise variables

set @SP= object_name(@@procid)
set @Instance = @@servername
set @theDate = getdate()

set @SQL = 'sqlcmd -E -S DEREKPREPRODUCTION -h-1 -d Staging -Q " set nocount on select ''""'' + cast(PersonId as varchar) + ''-'' +
cast(DatabaseId as varchar) + ''""'' from Staging.dbo.EmailRemovalTest where DTS > dateadd(dd, -7, getdate()) set nocount off "
> C: estoutput' + convert(varchar, @theDate, 112) + '.txt'

exec xp_cmdshell @SQL

There is a sproc on the same server that uses xp_cmdshell. When I run that sproc it works fine. I wonder, does having execute permission on the sproc grants me permission to use xp_cmdshell? Anyway, how do I enable this setting?

Thanks for your help ni advance.

View 6 Replies View Related

Xp_cmdshell Resulted In Access Is Denied

Jul 20, 2005

Scenario:----------SQL server: 192.168.1.3Server 2: 192.168.1.2, a folder named ABC is shared out.Both servers have the same password for the account named"Administrator"----------i tried to execute the following command in SQL server (192.168.1.3):exec master..xp_cmdshell 'move /Y "D: est.txt""\192.168.1.2ABC est.txt"'and got the error "access is denied"However, when i execute the move command in the command prompt of theSQL server, there was no problem. i'm able to connect to\192.168.1.2ABC without any problem too.What could be the problem?

View 1 Replies View Related

XP_CMDSHELL- Access Denied Accessing Remote Server

Jun 20, 2007

I am using XP_CMDSHELL to run 2 Windows commands (from a SQL 2005 SP2 server) that access files on a remote server (called webserver). The two commands are:

1. cscript.exe \webserverwwwrootEur_SaveProductImages.vbs
2. dir \webserverwwwroot
Up until very recently this worked fine. Now I am getting Access Is Denied errors:

For #1:
Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.
CScript Error: Loading script "\webserverwwwrootEur_SaveProductImages.vbs" failed (Access is denied. ).

For #2:
Access is denied.

This happens if the above commands are run through a job, or directly with Query Analyzer as SA.

I understand that XP_CMDSHELL commands are run in the security context of the SQL Server startup account. The SQL Server startup account is called SQLServer and this account exists on both webserver and the database server. On both servers the username & password are identical and the user is in the local Administrators group. The two servers are in a workgroup.

Things I have tried (with no effect):

1. Restarted the servers
2. Deleted and recreated the SQLServer login on both servers
3. Changed the startup account for SQL Server through the SQL Server Configuration Manager to another account and back to SQLServer.

The most revealing tests are these:

1. If I log into the database server myself using the SQLServer account I can run the above commands in a Command Prompt with no problem

2. I installed SQL 2005 Express SP2 on webserver using the same startup account (SQLServer). If I run the same XP_CMDSHELL commands as above but accessing files on the database server, the commands work!
So, an XP_CMDSHELL command run under SQL Express using the local SQLServer account to access a remote server works, but an XP_CMDSHELL command run under SQL Server using a local SQLServer account (that is supposedly identical to the same named account on the other server) does not work !!?!?!?

It is almost as if XP_CMDSHELL commands run under SQL Server are NOT using the SQLServer startup account, but using some other weaker account. How can I tell if this is true?

How can I get this back working (as it was a week ago). The only thing I can think that happened on the servers to cause this is the installation of Windows Updates.

Thanks

View 7 Replies View Related

ACCESS DENIED ERROR COPYING TO DOS

May 5, 1999

I have created a stored procedure that dumps the database from
server 'A' and copies the dump file to server 'B'. I get 'ACCESS'
DENIED' error in the following portion when it shells out to DOS:

SELECT @CmdStr = 'COPY ' + RTrim(@PrimaryCopyDev) + RTrim(@DBDevice) + '.dat ' + RTrim(@SecondaryCopyDev) + RTrim(@DBDevice) + '.dat'
EXEC@result = Master..xp_cmdshell @CmdStr

Can anyone tell me what is wrong? Thanks in advance.

View 1 Replies View Related

Access Denied For Network Drive

Oct 4, 2006



Sql server prompts "access denied"

while firing the following query

EXEC master..xp_cmdshell 'dir \servernamesharedfolder*.* '

how to access the folders and files existing in network drive.

View 3 Replies View Related

Access Denied When Trying To Execute A Ssis Task

Mar 22, 2006

Hi,

I sometimes come accross this error when I attempt to execute an isolated task in the control flow. What is funny is that I am still able to debug the package.

It eventually resolves after a while. What could it be?

Thanks

Philippe

TITLE: Microsoft Visual Studio
------------------------------

Access Denied. (Exception from HRESULT: 0x80030005(STG_E_ACCESSDENIED))

------------------------------
BUTTONS:

OK
------------------------------

View 7 Replies View Related

Execute Package Task Fail With Access Denied

Jul 12, 2007

Hi all,



I have an error when a package is trying to execute a SubPackage using the "Execute Package Task". I have this problem for all packages that are running sub packages.



The packages are stored in the DTSPackages folder of the SQL Server installation folder.

The master package is called from an Event Handler on a document library in MOSS 2007.

The account from the Sharepoint Application Pool has Full Control on the DTSPackages folder.



What am I missing ?

View 2 Replies View Related

Getting Access Denied To FileName Error When Using The Execute Sql Task (With File Connection) Into A Foreach Loop Container.

Jan 18, 2007

Hi ALL,

Getting Access Denied To FileName Error When Using the Execute Sql Task (With File Connection) into a Foreach Loop Container.

Please Note :

I have a folder containing .sql files. I have to dynamically loop through the files and send them as a File connection Folder to the Execute Sql Task.

When I run this Package I am getting the follwoing error :

[Execute SQL Task] Error: An error occurred with the following error message: "Access to the path 'C:ProjectsFuzzy Lookup DataFlow ExampleScripts' is denied.".

Also I have logged in to the machine as Administrator and to Sql Server with sa.

Please help.



Thanks.

Regards,

Salil

View 1 Replies View Related

Data Access :: Server Rejected The Connection - Access To Selected Database Has Been Denied

Jun 10, 2015

I have recently upgraded to SQL2014 on Win2012. The Access front end program works fine.

But, previously created Excel reports with built in MS Queries now fail with the above error for users with MS 2013.  The queries still work for users still using MS 2007. 

I also cannot create any new queries and get the same error message. If I log on as myself on the domain to another PC with 2007 installed it works fine, so I don't think it is anything to do with AD groups or permissions.

View 6 Replies View Related

Data Access :: Server Does Not Exist Or Access Denied

Apr 22, 2015

When i am trying to start our hospital software based on SQL server 2000, it shows Following Error.Search Condition is not valid, (DBNETLIB) Connection Open (connect()).  SQL server does not exist or excess denied. Due to Fetch data.I run our software in Windows 8.1, while it smothly runs in previous version of Windows XP and 7.

View 2 Replies View Related

Execute Package Task: Error 0x80070005 While Preparing To Load The Package. Access Is Denied.

Jun 8, 2007

I am having problems executing a child package from a parent package using the Execute Package Task. I am attempting to run the master package through a SQL Server Agent job.

The SQL Server Agent job is owned by sa. The step that runs the parent package is configured to load the package from the SSIS Package Store on the same server that the job is running.

I have the Execute Package Task configured as follows:

Location: SQL Server
ExecuteOutOfProcess: True
Connecting as a SQL Server login (let's say TestEtl)

I have added the db_dtsoperator database role to both the TestEtl login and the login that SQL Server Agent connects through. I have also configured the child package's reader role to include db_dtsoperator. Per http://msdn2.microsoft.com/en-US/library/ms141053.aspx, this should allow these logins to run the child package.

I have enabled logging of all events in both the parent and child packages. I see the following in the logs when the Execute Package Task executes (omitted portions unrelated to the execution of the child package task):

450939 OnPreExecute ChildPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 450940 OnPreValidate ChildPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 450941 OnPostValidate ChildPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 450942 User: Diagnostic ETL 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 ExternalRequest_pre: The object is ready to make the following external request: 'IDataInitialize::GetDataSource'.450943 User: Diagnostic ETL 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 ExternalRequest_post: 'IDataInitialize::GetDataSource succeeded'. The external request has completed.450944 User: Diagnostic ETL 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 ExternalRequest_pre: The object is ready to make the following external request: 'IDBInitialize::Initialize'.450945 User: Diagnostic ETL 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 ExternalRequest_post: 'IDBInitialize::Initialize succeeded'. The external request has completed.450946 User: Diagnostic ETL 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 ExternalRequest_pre: The object is ready to make the following external request: 'IDBCreateSession::CreateSession'.450947 User: Diagnostic ETL 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 ExternalRequest_post: 'IDBCreateSession::CreateSession succeeded'. The external request has completed.450948 OnError ChildPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 Error 0x80070005 while preparing to load the package. Access is denied. . 450949 OnError ParentPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 Error 0x80070005 while preparing to load the package. Access is denied. . 450950 OnTaskFailed ChildPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 450951 OnPostExecute ChildPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 450952 OnWarning ParentPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. 450953 OnPostExecute ParentPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 450954 PackageEnd ParentPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 End of package execution.

I am sure that what I am doing is quite common, and I obviously have something misconfigured somewhere - but I'm not sure what my misconfiguration is. Can anyone enlighten me?

View 6 Replies View Related

Data Not Copying To MS Access Table

Aug 27, 2007

Hello,
I have a Data Flow Source that uses a SQL Command to pull data. In the SQL statement, I used CAST to change all varchar types to Nvarvchar to suit MS Access. I can preview the data from the source. In testing, the SQL statement only pulls about ten records.

I have a Microsoft 2000 Access database table as a destination. Data in each column in the table is required, and all columns have defaults.

I also have a grid data viewer set up. I have the DefaultBufferMaxRows set to 2 so that I can see data going across. When I execute this dataflow, no data is transfered to the Access database table. No data shows up in the dataviewer. There are no errors. The 'Execution Results' tab does not show errors, but indicates that zero rows were transfered. There are no warnings.

How do I begin to isolate the problem? The following is the SQL Statement in the Data Flow Source. Thank you for your help! - cdun2

DECLARE @CategoryTable TABLE
(ColID Int,
ColCategory varchar(60),
ColValue varchar(500)
)
--and fill it
INSERT INTO @CategoryTable
(ColID, ColCategory, ColValue)
SELECT
0,
LEFT(RawCollectionData,CHARINDEX(':',RawCollectionData)),
LTRIM(SUBSTRING(RawCollectionData,CHARINDEX(':',RawCollectionData)+1,255))
FROM Collections_Staging
--Assign an ID to each block of data for each occurance of 'Reason:'
DECLARE @ID int
SET @ID = 1
UPDATE @CategoryTable
SET [ColID] = CASE WHEN ColCategory = 'Reason:' THEN @ID - 1 ELSE @ID END,
@ID = CASE WHEN ColCategory = 'Reason:' THEN @ID + 1 ELSE @ID END
--Then put the data together
SELECT --cast to Nvarchar for MSAccess
a.ColID,
CAST(a.ColValue as Nvarchar(30)) AS OrderID,
COALESCE(CAST(b.ColValue as Nvarchar(30)),'') AS SellerUserID,
COALESCE(CAST(c.ColValue as Nvarchar(100)),'') AS BusinessName,
COALESCE(CAST(d.ColValue as Nvarchar(15)),'') AS BankID,
COALESCE(CAST(e.ColValue as Nvarchar(15)),'') AS AccountID,
COALESCE(CAST(SUBSTRING(f.ColValue,CHARINDEX('$',f.ColValue)+1,500)AS DECIMAL(18,2)),0) AS CollectionAmount,
COALESCE(CAST(g.ColValue as Nvarchar(10)),'') AS TransactionType,
CASE
WHEN h.ColValue LIKE '%Matching Disbursement%' THEN NULL
ELSE CAST(h.ColValue AS SmallDateTime)
END AS DisbursementDate,
--COALESCE(h.ColValue,'') AS DisbursementDate,
CASE
WHEN i.ColValue LIKE '%Matching Disbursements%' THEN NULL
WHEN CAST(LEFT(REVERSE(i.ColValue),4)AS INT) > 1000 THEN CAST(i.ColValue AS SmallDateTime)
WHEN LEFT(REVERSE(i.ColValue),4) = '1000' THEN NULL
END AS ReturnDate,
--COALESCE(i.ColValue,'') AS ReturnDate,
COALESCE(CAST(j.ColValue as Nvarchar(4)),'') AS Code,
COALESCE(CAST(k.ColValue as Nvarchar(255)),'') AS CollectionReason

FROM @CategoryTable a
LEFT JOIN @CategoryTable b ON b.ColID = a.ColID AND b.ColCategory = 'Seller UserId:'
LEFT JOIN @CategoryTable c ON c.ColID = a.ColID AND c.ColCategory = 'Business Name:'
LEFT JOIN @CategoryTable d ON d.ColID = a.ColID AND d.ColCategory = 'Bank ID:'
LEFT JOIN @CategoryTable e ON e.ColID = a.ColID AND e.ColCategory = 'Account ID:'
LEFT JOIN @CategoryTable f ON f.ColID = a.ColID AND f.ColCategory = 'Amount:'
LEFT JOIN @CategoryTable g ON g.ColID = a.ColID AND g.ColCategory = 'Transaction Type:'
LEFT JOIN @CategoryTable h ON h.ColID = a.ColID AND h.ColCategory = 'Disbursement Date:'
LEFT JOIN @CategoryTable i ON i.ColID = a.ColID AND i.ColCategory = 'Return Date:'
LEFT JOIN @CategoryTable j ON j.ColID = a.ColID AND j.ColCategory = 'Code:'
LEFT JOIN @CategoryTable k ON k.ColID = a.ColID AND k.ColCategory = 'Reason:'
WHERE a.ColCategory = 'Order ID:'

View 7 Replies View Related

Copying Data From Microsoft Access To SQL Server

Oct 16, 2006

Hello I am developing a web application that will allow users to upload a .mdb file and from that file I need to populate an SQL database. I know the table name of the .mdb file, but I am unclear how to structure my data access layer correctly. How do I pull data from the .mdb file and once I have it how do i populate the SQL database?Any advice would be greatly appreciated.thanks! 

View 1 Replies View Related

Problem With Xp_cmdshell ,BCP And Network Drives

Sep 27, 1999

Basically what I am trying to do is run bcp from within a stored procedure in SQL 6.5.
It allows me to dynamically assign the destination filename (the legacy application expects to see a file for each picking slip) I want to store the file on another server/shared directory on the LAN

Here is the code
DECLARE @ship_no varchar(16)
SELECT @ship_no = '1234567'
DECLARE @SQL_SYNT varchar(255)
SELECT @SQL_SYNT = "master.dbo.xp_cmdshell " + '"BCP AUSTCHAR..armaster out servernameBECpsqlout'+@ship_no+'.cba /c /t , /r /Sservername /Uuser /Ppassword"'
EXEC( @SQL_SYNT)

However I get the following output:

(1 row(s) affected)


(1 row(s) affected)

output
---------------------------------------------------------------------------------------------------------------------------------------------
DB-LIBRARY error:
Bcp: Unable to open host data-file.

The destination file is not created.
I have tried:
making the path the local HDD that works:
Using a mapped drive, that does not work
Running the same bcp command from the command line. That works.
Using UNC's (as above) You can see the result.
I have also checked security and made SQLexecutive ran as the domain admin. Did not work.


Can Anyone help?

Thanking you in advance

View 1 Replies View Related

SQL 2012 :: Master Data Service Access Denied

Apr 25, 2014

I removed MDS web UI which is working before and recreated. I enabled Window Authentication and Disabled Anonymous Authentication in IIS Authentication. I am getting Access denied when I view MDS web Site.

View 1 Replies View Related

Master Data Services :: Access Denied For All Accounts

May 5, 2015

I can use and access MDS using Excel, but when I try to open the web page, the get an error as Access restricted. MDS has been working fine till now and suddenly this error message appears

View 4 Replies View Related

Access Denied To Data Source Reporting Services 2000

Dec 19, 2006

I have data on server A and the report server on server B.

I have created reports that I can run through report manager (on server B).

I have depolyed the reports but when I try to run the reports on client computers I get the following error:



An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Cannot create a connection to data source 'ABCD'. (rsErrorOpeningConnection) Get Online Help

SQL Server does not exist or access denied.

I have tried setting different credentials ... windows security, specified username and password to credentials not required ...

All give above error.

TIA



View 4 Replies View Related

Master Data Services :: Access Is Denied When Connecting To MDS Web Interface

Aug 5, 2015

The application pool is running under my account.

Authentication for web site: Windows Authentication is enabled, everything else is disabled.

Authentication for the server: Windows Authentication is enabled, everything else is disabled.

I am an admin on both the server and the SQL instance.

SQL Server version = Microsoft SQL Server 2012 - 11.0.5343.0 (X64)

I am the only record in [mdm].[tblUser]

View 2 Replies View Related

Master Data Services :: Access Denied In MDS Home Page

Aug 30, 2015

I have installed MDS while installing SQL Server 2014 on my local machine ( windows 10). However when I try accessing the home page of Master Data Manager, it is giving access denied error. I am unable to access the Master Data Manager itself. MDS Database and Web Application are using same user account which is Administrator on the system.

View 2 Replies View Related

Data Access In Local Network Ms Sqlserver 2000

Aug 24, 2005

Hi, i need some help, i have a problem trying to access data in my local network.

I have a PC with ms windows server 2003 and ms sql server 2000, and i want that the others PC in the network can access the data. I installed the client sql server in the others PC, but i can't make it work. What i have to do?

Thanks

View 5 Replies View Related

'microsoft.ace.oledb.12.0' Access Denied When Exporting Data To Excel 2007

May 10, 2008

I have a stored proc that runs and produces an Excel 2007 file. I can run it fine within SQL Server Management Studio.
Basically, this is a partial code in the stored proc:


-- export sql server table data to excel 2007

insert into OPENROWSET('microsoft.ace.oledb.12.0',

'Excel 12.0;Database=D: emp est2007.xlsx;',

'SELECT * FROM LicensesrRegion') select * from Licenses

BUT when I have an execute SQL task to run that stored proc in an SSIS package, I received the following error:
Ad hoc access to OLE DB provider 'microsoft.ace.oledb.12.0' has been denied. You must access this provider through a linked server.

Please advise.

PS: I have to run that stored proc in an SSIS package because the SSIS package does some prereq stuff ( create folder, copy template to new Excel output file) then finally calls the aforementioned stored proc.

Thank you in advance.

Thanks!

View 6 Replies View Related

System.Data.SqlClient.SqlException: SQL Server Does Not Exist Or Access Denied.

Jan 8, 2007

Hi all

Please help me.

I have an asp.net 1.1 (vb.net) application which accesses data from a sql server 2000. I published this application on http://test.autenmas.co.za and the database I access is on 196.23.156.196. I am getting this error message when I run the application from this site:

System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.

But it's working fine on my local, development machine. I am using the following connection string in my connections:

"Data source=196.23.56.193; Initial Catalog=Autenmas; User Id=xxxx; password=yyyy"

Is there anything wrong with my code, is there anything that must be done on the web/database server or any other configurations for that matter, what really is the problem??????

Thanks in advance.

View 1 Replies View Related

Data Access :: Login Failed For User When Run Application In Network

Jun 9, 2015

When i wanna run Application in other computers in network. The following error occurs.

error : System.Data.SqlClient.SqlException: Login failed for user 'Suren-PCGuest'.ConnectionStr = "Data Source=SUREN-PCMSSQLSERVER,1433;Initial Catalog=WorkFlow;Integrated Security=True";

View 5 Replies View Related

Copying Detached Databases Over The Network With T-SQL

Jul 25, 2006

I have a T-SQL script which deataches and attaches the database. Now here is what I want to do:
I
want to create a SQL Server Job and schedule it to run at a particular
time of the month to Detach all the databases on my local machine and
*Copy all the deatched databases over a network machine* and then
Attach those Database.

All this should be done in T-SQL. I
already have the T-SQLs for Attaching and Detaching. All I need is to
know the T-SQL (example) which will copy the *Detached Databases* from
mu local computer to my Network Computer. How do I achieve that?

Thanks

View 7 Replies View Related

Unable To Create A New File Data Source: SQL Server Does Not Exist Or Access Denied

Jun 22, 2004

Hi ,

I have just downloaded an evaluation version of SQL server from the microsoft website and installed it in my PC.

Now I want to create file data source.

I followed these steps:
-From the control panel, ODBC datasource admin
-click the DSN tab
-click the add button
-select the sql server driver, enter the data source file name
-enter "local" in the server text box as I installed the sql server in my standalone PC.
-click next
After that I had this error.
"Connection failed. SQL server does not exist or access denied."

But The sql server service is running.

Can anyone help me where did my configuration go wrong??
Thanks...

Nov

View 2 Replies View Related

Reporting Services :: Access Denied Error When Testing Data Source Connection In SSRS 2008

Aug 16, 2011

We are running Reporting Services 2008 R2 on a Windows Server 2008 Standard 64-Bit server.  I have a user that has full access to Reporting Services at all folder levels but IS NOT a local administrator on the 2008 server.

This user can create data source connections but when he tries to test the connection by clicking on the 'Test Connection' button, he gets the following error "The permissions granted to user <username> are insufficient for performing this operation.A user that has administrator priveleges on the server can test the connection fine. 

I don't want to make this user an administrator on the server. 

This is an extract from the log file:

ibrary!ReportServer_0-24!3478!08/16/2011-13:45:37:: Call to TestConnectForDataSourceDefinitionAction().
library!ReportServer_0-24!3478!08/16/2011-13:45:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: , Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user <username>
are insufficient for performing this operation.;

[code]....

View 10 Replies View Related

How To Grant Execute On Xp_cmdshell??

Apr 2, 2002

Can anyone help me please.
Healp please.
Does anybody know how to make xp cmdshell runnable for users other than Admin. It should be possible to grant execute to others, but i can't figure out how.

This is what i found:

Be aware that when you grant execute permission for xp_cmdshell to users, the users will be able to execute any operating-system command at the Windows NT command shell that the account running SQL Server (typically local system) has privilege to execute.

To restrict xp_cmdshell access to users who have administrator permission on the Windows NT-based computer where SQL Server is running, use SQL Setup or SQL Enterprise Manager to set the server options, selecting the "xp_cmdshell - Impersonates Client" option. With this option selected, only users who have connected to SQL Server via a trusted connection and are members of the local Administrators group on that computer are allowed to use xp_cmdshell. The commands run by xp_cmdshell continue to execute in the server's security context.

View 1 Replies View Related

Execute Xp_cmdshell And Other SA Storedproc

Mar 8, 2004

Hi all,

I have to execute stored procedures containing
xp_cmdshell and certain system storedprocedures in msdb and master
with a user who is not SA.
(i.e iam able to execute stored procedures when i log as sa,
but any other user cannot run them)

Pls tell how to do this, it is quite urgent.

View 1 Replies View Related

SQL Server 2005 Agent - Error Copying A File Onto The Network...

Jan 10, 2008

Hi,

I have an SSIS package designed to copy across a file from local machine to a location on the network.

The SSIS package works fine when I run it directly run it in the Designer, ie, it copies over the file to the network.

But when I run the package through the Job server agent, it fails giving me a validation error on the network path..

Does it have to do with the permissions of the User account used here? Could anyone please provide any information on this....


Thanks

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved