Xp_cmdshell Executing 32bit Exe On SQL X64
Jan 11, 2008Here is a post to the MSDN forums that I have not been able to resolve:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2663783&SiteID=1
Anyone here have any ideas?
ADVERTISEMENT
SQL Agent Executing 32bit Code
Jan 10, 2008There is no SQL Agent forum so if this isn't the correct place please move this post.
Windows 2003 R2 x64 with SQL Server x64.
One of the steps in a SQL job I have setup requires me to run an exe. I can run this exe from the command line or by double-clicking it on this same server but when running it from a SQL job it does not run, the job just has the status 'executing' but does not do anything. I have enabled xp_cmdshell. I have also tried calling a bat file which then runs the exe and I have tried calling the bat file with SysWOW64cmd.exe. Same problem.
It seems to me the the operating system recognises the 32bit exe and runs it in that context but the SQL Agent thread keeps trying to run it as a 64bit exe and hence never gets anywhere. (My best guess)
Is there a way to force SQL job/steps to run an exe or bat file in a 32bit thread? Any other ideas.
Thanks
Scott
FYI - Executing SSIS Jobs On IA64 With 32bit Drivers
Jul 14, 2006Just an FYI for those scheduling SSIS packages on 64bit Itaniums.
This came to light when using a 32 bit OLEDB driver on a 64bit Itanium.
When manually executing the package on the server through SQL Management
Studio, we got the expected results. However, when we scheduled the
package as a job, it failed every time. The error was:
"The AcquireConnection method call to the connection manager 'ConnectionName' failed with error code 0xC0202009€?.
We tried everything to fix this, but nothing worked. Finally we found
that when manually running the package, SQL Management Studio was calling the
32bit version of dtexec.exe, while the Agent calls the 64bit version of
dtexec.exe. The fix is to not use the "SQL Server Integration
Services Package" type in the job step, but use "Operating system
(CmdExec)" type. Then in the command box, call the 32bit (x86)
version of dtexec.exe.
Example:
C:Program Files (x86)Microsoft SQL Server90DTSBinnDTExec.exe /DTS
"File SystemSSIS Packages[PackageName]" /SERVER [SQLSERVERNAME]
/DECRYPT [password] /MAXCONCURRENT " -1 " /CHECKPOINTING OFF
/REPORTING V
Executing Xp_cmdshell
Oct 14, 2004Hi ,
I want to execute xp_cmdshell from normal sql server account not sysadmin member in SQL Server 2000. I had give execute privileges on xp_cmdshell to normal account... but its not working...
Is it possible to execute xp_cmdshell from non sysadmin member account in SQL Server2000...
Thanks in advance...
-Mohit.
Error Executing Xp_cmdshell
Oct 1, 2007I'm trying execute DTSX-package
Code Block
exec master..xp_cmdshell '"C:Program Files (x86)Microsoft SQL Server90DTSBinndtexec.exe" /FILE ...'
But have got error
Code Block
'C:Program' is not recognized as an internal or external command,
for some reason it doesn't work!
Or xp_cmdshell doesn't work with long filenames?
Executing An SSIS Package From TSQL Without Using Xp_cmdshell?
Oct 22, 2007How can I execute an SSIS package from TSQL without using xp_cmdshell?
I have a web-app which calls some SQL which executes my SSIS package (a DTSX file, but stored in the server). But the security policy for my application won't permit me use to xp_cmdshell.
I want to do this:-
DECLARE @returncode int
EXEC @returncode = xp_cmdshell 'dtexec /sq pkgOne"'
Is there another way for executing a Package without going to the command line (e.g. is there some other system stored proc)?
Thanks
Error Executing Xp_cmdshell From Within A SQL Task In A DTS Package...
Jul 20, 2005HelloI am trying to execute ‘xp_cmdshell' from within a DTS package thatwas created by another person. When I try to execute that ‘SQL Task'selectively from within the package, I get the following errormessage:Error Title: Package ErrorError Details:Error Source: Microsoft OLE DB Provider for SQL ServerError Description: xpsql.cpp: Error 87 from GetProxyAccount on line604Why is this error message popping up? When I create a new package(myself) and create an exact same SQL task as above and run it, theSQL task runs fine.Appreciate any help / feedback.Thanks in AdvanceJagannathan Santhanam
View 1 Replies View RelatedExecuting An SSIS Package From TSQL Without Using Xp_cmdshell?
Oct 22, 2007How can I execute an SSIS package from TSQL without using xp_cmdshell?
I have a web-app which calls some SQL which executes my SSIS package (a DTSX file, but stored in the server). But the security policy for my application won't permit me use to xp_cmdshell.
I want to do this:-
DECLARE @returncode int
EXEC @returncode = xp_cmdshell 'dtexec /sq pkgOne"'
Is there another way for executing a Package without going to the command line (e.g. is there some other system stored proc)?
Thanks
Path Not Found When Executing Package Using Xp_cmdshell Dtexec
Feb 10, 2006I have a package that executes fine in BIDS. However, when calling it using xp_cmdshell it cannot find the path to the source flat file. Anyone have any suggestions?
Here is the statement:
xp_cmdshell 'dtexec /SQ NatlAcctsImport /SER CR1-SQL-01 /CONN SourceConnectionFlatFile;Q:BINATNLACCTS'
Here is the result:
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
NULL
Started: 9:50:56 AM
Progress: 2006-02-10 09:50:57.40
Source: Data Flow Task
Validating: 0% complete
End Progress
Progress: 2006-02-10 09:50:57.40
Source: Data Flow Task
Validating: 50% complete
End Progress
Progress: 2006-02-10 09:50:57.42
Source: Data Flow Task
Validating: 100% complete
End Progress
Progress: 2006-02-10 09:50:57.43
Source: Data Flow Task
Validating: 0% complete
End Progress
Progress: 2006-02-10 09:50:57.43
Source: Data Flow Task
Validating: 50% complete
End Progress
Progress: 2006-02-10 09:50:57.43
Source: Data Flow Task
Validating: 100% complete
End Progress
Progress: 2006-02-10 09:50:57.43
Source: Data Flow Task
Prepare for Execute: 0% complete
End Progress
Progress: 2006-02-10 09:50:57.43
Source: Data Flow Task
Prepare for Execute: 50% complete
End Progress
Progress: 2006-02-10 09:50:57.43
Source: Data Flow Task
Prepare for Execute: 100% complete
End Progress
Progress: 2006-02-10 09:50:57.43
Source: Data Flow Task
Pre-Execute: 0% complete
End Progress
Warning: 2006-02-10 09:50:57.43
Code: 0x80070003
Source: Data Flow Task Source - NATNLACCTS [1]
Description: The system cannot find the path specified.
End Warning
Error: 2006-02-10 09:50:57.43
Code: 0xC020200E
Source: Data Flow Task Source - NATNLACCTS [1]
Description: Cannot open the datafile "Q:BINATNLACCTS".
End Error
Error: 2006-02-10 09:50:57.43
Code: 0xC004701A
Source: Data Flow Task DTS.Pipeline
Description: component "Source - NATNLACCTS" (1) failed the pre-execute phase and returned error code 0xC020200E.
End Error
Progress: 2006-02-10 09:50:57.43
Source: Data Flow Task
Pre-Execute: 50% complete
End Progress
Progress: 2006-02-10 09:50:57.43
Source: Data Flow Task
Cleanup: 0% complete
End Progress
Progress: 2006-02-10 09:50:57.43
Source: Data Flow Task
Cleanup: 50% complete
End Progress
Progress: 2006-02-10 09:50:57.43
Source: Data Flow Task
Cleanup: 100% complete
End Progress
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 9:50:56 AM
Finished: 9:50:57 AM
Elapsed: 0.985 seconds
NULL
Problem In Executing Xp_cmdshell With Least Privileged SQL Login Account In SQL 2005
Jan 26, 2007Hi,
I have a least privileged SQL Login €œClient€? and have granted execute rights on XP_Cmdshell SP at master db. When I execute master.. XP_Cmdshell €˜dir€™ I€™m getting the below error.
Msg 15153, Level 16, State 1, Procedure xp_cmdshell, Line 1
The xp_cmdshell proxy account information cannot be retrieved or is invalid. Verify that the '##xp_cmdshell_proxy_account##' credential exists and contains valid information.
Please note it is SQL Login account and not windows account. I have checked everywhere for similar problem and no luck.
Thanks for you help in advance
With regards
GK
Stored Procedure Executing Durations Are Different Between Executing From Application(web) And SQl Server Management Studio - Qu
Jan 24, 2008
Hi,
I have a web application using Stored Procedure (SP). I see that there's a SP taking long time to execute. I try to capture it by Profiler Tool, and find out that with the same SP on the same db with the same parameter. The duration of executing by my web app is far bigger than the duration of executing on SQl server management studio - query window
Please see the image through this url http://kyxao.net/127/ExecutionProblem.png
Any ideas for this issue?
Thanks a lot
Stored Procedure Executing Durations Are Different Between Executing From Application(web) And SQl Server Management Studio - Query Window
Jan 23, 2008Hi,I have a web application using Stored Procedure (SP). I see that there's a SP taking long time to execute. I try to capture it by Profiler Tool, and find out that with the same SP on the same db with the same parameter. The duration of executing by my web app is far bigger than the duration of executing on SQl server management studio - query windowPlease see the image attached http://kyxao.net/127/ExecutionProblem.png Any ideas for this issue?Thanks a lot Jalijack
View 2 Replies View RelatedDifferent Results When Executing From .NET Component Compare To Executing From SQL Management Studio
Oct 10, 2006Hi all,I am facing an unusual issue here. I have a stored procedure, that return different set of result when I execute it from .NET component compare to when I execute it from SQL Management Studio. But as soon as I recompile the stored procedure, both will return the same results.This started to really annoying me, any thoughts or solution? Thanks very much guys
View 2 Replies View RelatedAll 32bit Connections Freeze...
Mar 2, 1999I'm very new to SQL servers. We're running SQL 6.5-SP4 and have three applications using different databases on the server (NT4-SP3).
App 1. Written in PowerBuilder using 32bit DB_LIB, NWLink IPX/SPX.
App 2. Written in VFP 5.0a using ODBC32, NWLink IPX/SPX
App 3. Written in VB using ODBC16, NWLink IPX/SPX
Something happens, which freezes all 32bit connections and prevents any other 32bit connects. Which means I can't get Enterprise Manager to connect! This does not affect the ODBC16 clients?!?!
So far the only way, I have found, to clear and fix is to get all 32bit users out of their apps and the server becomes available again. There's got to be something to prevent this, any ideas? Is there a way to trace this to find the culprit?
Thank you for any and all help,
Jim
<jpeppercorn@jhcb.com>
SQL 32bit DB To A SQL X64bit DB Server
Nov 16, 2007I am going to test the migration of a 32bit SQL 2005 database to a SQL 2005 x64bit database server. Has anyone tried this? What can I expect? Will it work? Is there anythi I need to do?
I was just going to detach the 32bit DB, copy yhe files to the 64 bit server and reattach it.
Thanks
SQL 2k5 Failover From 64bit To 32bit
Aug 30, 2007I'm sure this has been discussed in the forums before, but I'll ask anyways. I'm replacing our GP server next year to one that will run SQL2k5 64-bit. The current server is only capable of 32bit SQL. I know with some databases changing from x64 to x32 is a bad idea...will SQL Server support it?
Thanks
How Do You Find Out Whether PC Is 32bit Or 64bit
Dec 24, 2005I would like to install MS SQL Management Express, and I would like to make sure I am downloading the right files.
Could you tell me how I can find out whether my PC is 32bit or 64bit?
Many thanks
W aka Gauguin
4gigs RAM, 32bit, /PAE And AWE In SQL Question
Mar 4, 2008
Same server:
Windows 2003 R2 SP2 (32bit)
SQL 2005 SP2
4gigs of Hot-Add RAM
WSUS 3.0 SP1
SCCM 2007
I've had nothing but issues on this server until I came across the articles about using /PAE in the boot.ini to correct the 4gig RAM issues, then read that /PAE can corrupt your database.
I then enabled AWE on the SQL 2005 server using the RAM range of 1gig-4gigs.
Since this, I am seeing errors in the Application Event log on the server that states SQL is not ready to accept client connections.
So, before I go any further with this build, it this something I should be concerned about ?
Thx !
MarcusDOI.gov
Log Shipping 64bit --&&> 32bit
Sep 18, 2007
Hi All
Can I use Log shipping From 64bit to 32bit in SQL Server2000?
Thanks~
SSIS 32Bit Or 64Bit
Dec 28, 2007Having looked at the complexities of transforming data from Oracle in a 64Bit Environment to SQL 2005, will SSIS 2008 run nativley in 64Bit. I understand that SSIS 2005 ran in 32Bit, even when in a 64Bit environment, causing great issues in accessing Oracle. Oracle released an update to compensate for this, however can someone please clarify whether SQL 2008 will have the same issues, or will SSIS 2008 be able to speak with Oracle on a 64Bit level.
Regards
32bit Sql2005 And 64bit2005 ..[urgent]
May 14, 2008Hi all:
advance thanks for ur help..
i need to know what could be the differnet , when use BIGint datatype at 32bit sql2005 and 64bitsql2005??
can i know benefits of bigint if i use at 32bit and 64bit sql2005??
waiting for your valuable reply..
thanks!
Mk..
How To Change 32bit To 64bit Using SqlServer2005
May 26, 2008I m swagatika and working on a s/w company.I am facing some problem in MS SqlServer2005.
my problem is:-
My project is running on SqlServer2005 which is 32 bit support.
But i want to change my project on SqlServer2005 which will be support to 64 bit .
What are the steps i follow to change 32 bit to 64 bit.
can anybody help me?
SQL Server 2005 32bit-vs-64bit
Apr 24, 2007This may seem like a completely foolish question, but is there any issue in using the 32bit workstation components (on XP) to connect to the 64bit server-side components? New to SQL2K5 and never had any issues using the 2K workstation/server components together.
Thank you!
SQL 2005 32bit Upgrade To 64bit Possible?
Nov 7, 2007Just curious if it's possible, and supported, to upgrade SQL 2005 from32bit to 64bit. This is on top of Windows 2003 64bit. Trying to getthe proper supported config for OM2k7 without blowing everything away.Thanks,JDP
View 1 Replies View Related32bit Admin Tools When The Only Media You Have Is 64 Bit
Jun 13, 2006We have jumped straight to 64 bit SQL 2005 with no 32 bit 2005 inbetween.
However this means the tools we have cannot be installed on windows XP/2000 32 bit.
Is there some way to get the 32 bit tools as it appears strange that 32 bit tools were not provided for remote access.
Cheers
Julian
Principal 64Bit- Member On 32Bit
Dec 14, 2006Hi all,
I've got two VLDBs on 64bit hardware platform + 64Bit-W2003K Std R2 + 64Bit SQL2005 Std Edition.
If I set this guy up as the Principal, can I have the standby/member on 32Bit HW + 32Bit W2003 Std + 32Bit SQL2005?
Will this actually work?
Regards,
Uday Shivamurthy
Connecting 32bit ASP To 64 Bit SQL Server 2005
Mar 17, 2007issue:
i have an ASP-Application running fine with both SQL Server 2000 and SQL 2005 (both 32 bit)
Now i have to attach a 64bit SQL-Server.
I have a problem with the connection:
This one runs fine with sql 2005 32bit
<%set myConn = Server.CreateObject("ADODB.Connection")
myConn.open "driver={SQL Native Client};server=<servername>;database=<dbname>;uid=<uid>;pwd=<pwd>" %>
but not with the 64-bit server:
ADODB.COnnection error "800a0ea9". Provider is not specified and there is no standard provider.
ok, i did some research and came up with the following:
<%set myConn = Server.CreateObject("ADODB.Connection")
myConn.open "PROVIDER=SQLOLEDB;DATA SOURCE=<serverip>,<serverport>;database=<dbname>;uid=<uid>;pwd=<pwd>" %>
thats fine, now i get a connect.
Unfortunately, this provider seems to behave different to the one i use in 32bit :
Lets say i have a stored procedure"
create spName as
select * from mytable
when i execute the following
<%sqlstr = "exec spname"
set myRecSet = CreateObject("ADODB.Recordset")
myRecSet.open SQLStr, myConn
response.write(myRecSet(0)) %>
it gives the first value of the first row with the Connection to a 32bit SQL-Server
but myRecSet seems to be empty on my 64bit SQL Server the response.write leads to an error message.
As far as i understand this, the provider used when connecting to a 32bit Server returns the records selected by the last row of the stored procedure into the recordset, but the provider when connecting to a 64bit server does not return these results.
What can i do, if i dont want to rewrite my asp-programming. I hope somebody has the correct naming / syntax for an connection string which allows me to connect my asp-application to the 64bit SQLServer which behaves like the "old" one for 32bit.
I hope my comments are clear enough - english is obviously not my mother-tongue - and somebody can give me a hint.
Thanks,
Heinrich
64bit Server 32bit Client
Apr 19, 2006I installed SQL 2005 on a 64bit server. Can I still use enterprise studio on a 32bit client machine?
The install CD's are 64bit and when I try to find the enterprise studio to install on my 32bit machine i get an error. Is there a place to download the 32bit enterprise studio? What are my options here?
Thanks in advance.
Mike
Service Broker B/w 64bit And 32bit
Apr 25, 2006Hi:
I wanted to make sure some things clear before setting up service broker. I have enterprise server as 64 bit and local client servers as 32 bit. I would like to know what steps do I need to take care when I am setting up service broker b/w sql server enterprise editon 2005(64 bit) and sql server express 2005 client server(32 bit)...any special considerations ...?
Thanks,
Pramod
64bit OS 32bit SQL Install With Reporting Services?
Mar 10, 2008
Hi All,
Probably a dumb question but our network guy has installed 64 bit Win2003 on one of the servers onto which I'm tasked with running our 32bit SQL Server 2005 server.
The installation goes through without a hitch and I'm able to get the SP2 installed over the top with no problem. I am, however, having trouble when trying to browse into the Reporting Services pages. I simply get a std "Page Not Found" web page. I've gone through the Report Server Configuration to see if I can get things to come up properly and everything appears to be initializing properly but still "no go"...
Can one of you MVP's give me a direction? I know it's relatively few details to get started but I'll provide whatever's necessary to get me pointed in the right direction.
Thanks
REM7600
"Jack of All Trades, Master of SQL (NOT)"
32bit SQL Server On 64bit Inter Hardware
Jun 26, 2007Hello,
Are there any issues with running the 32 bit version of Windows 2003 server and SQL Server Standard edition on a 64 bit Intel hardware Platform? I don't see why there would be if the OS is 32bit but just thought I'd ask.
Thanks.
Eval Between SQL 2000 32bit And SQL 2005 64bit
Oct 9, 2006Hi
I just started a new job and one of my first assignments was to determine and prove the improvement between SQL Server 2000 32 bit and SQL Server 2005 64bit extension. (Itanium may come later but for now we will live with x64)
I have used SQL 2005 before but only with a fresh install and a new application built from the ground up. Now we want to upgrade our present databases to 2k5. In a previous test by another DBA, he found the SQL 2005 ran slower. However, he realized that he was using SQL 2005 32bit on Windows 2003 64bit. Now we have everything in place, here are the steps I have accomplished so far.
Loaded Windows 2003 64 and SQL 2005 64.
Made a copy of an existing database from a SQL 2000 32 bit
Attached this database to the new SQL 2005 server. However, I keep the compatibility at 8.0.
Updated the statistics and backed the db up.
Had another DBA run a Profiler trace on the production server.
Replayed the trace on the new server.
My problem is this doesn€™t seem to give the information I am looking for. First, we were only looking at queries over 5 minutes and only looking at things from a duration standpoint. We are going to change this. Second, even though I created a template that looks like the one used on the production server, it is not using it.
So how do I compare performance on this 64bit server verses the 32bit SQL 2000. Any and all help is greatly appreciated.
64bit Mirrored SQL Server Std With 32bit Witness?
Mar 30, 2007
I have two 64bit SQL Server Std servers that will be principal and mirror. I also need to stand up a witness. I already understand that the witness can be any version of SQL Server, but can the witness server be 32bit given the principal and mirror are 64bit?