Bcp Sqlstate = 28000 Native Error = 18452
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About sqlstate 28000 sql server error 18452 Us Learn more about Stack Overflow the company Business Learn more about hiring
Connection Failed Sqlstate 28000 Sql Server Error 18452
developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the sqlstate 28000 native error 18456 login failed for user Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SQL 2012 bcp call returns SQLState bcp unable to open bcp host data-file = 28000. NativeError = 18456 Login failed for user up vote 2 down vote favorite I’m working with a SQL stored procedure that makes a call to xp_cmdshell. xp_cmdshell has been enabled, and has a proxy account set to ‘vpexporter’. This sproc was designed to write out a data file to disk. This sproc had been working when it was on a SQL 2005 server. The
Native Error 18456 Crystal Reports
environment has been upgraded to SQL 2012 and the sproc no longer runs. The line making the call is: set @sql1 = 'bcp "SELECT * FROM dbo.udPayrollOutput" queryout "D:\Repository\Exports\' + @fileunique -Uvpexporter -Ppassword -c -t,' exec master..xp_cmdshell @sql1 Running this in SSMS gives me the following: SQLState = 28000. NativeError = 18456 Error = [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user ‘vpexporter’. I have tried this with both a SQL login and with a domain account. Both return the same error. The ‘vpexporter’ has been added as a login, and has been set up as a user of the master db with execute permissions on xp_cmdshell. I feel something must have changed in how xp_cmdshell is called with SQL version 2012, but I haven’t found anything when googling that. I tried running "exec xp_cmdshell 'whoami.exe'" which returned 'nt authority\network service' which is the account SQL Server is running under. My understanding was that by specifying a command shell proxy account with 'sp_xp_cmdshell_proxy_account' it would use that instead. I do not want to grant xp_cmdshell execute access to the Network Service. I've made some progress but am still getting stuck. The original error was due t
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » error = [microsoft][odbc driver 11 for sql server]unable to open bcp host data-file SQL Server 2005 » Administering » error using bcp error using bcp error = [microsoft][sql server native client 10.0]unable to open bcp host data-file Rate Topic Display Mode Topic Options Author Message pavan kumar posanipavan kumar posani Posted Monday, June 18, 2007 7:11 PM Grasshopper Group: General Forum Members Last Login: Thursday, October 29, 2009 2:35 PM Points: 18, Visits: 22 Hi iam getting the following error when iam using bcpC:\>bcp scp2.dbo.Inventory_Target_Level http://stackoverflow.com/questions/29611600/sql-2012-bcp-call-returns-sqlstate-28000-nativeerror-18456-login-failed-for out \\kzo-sqlclup1\adexa\quantum_inv_tgt_lvl.dat -f \\kzo-sqlclup1\adexa\quantum_inv_tgt_lvl.fmt -S kzo-sqlclup1wt214-U quantumuser -P g00fySQLState = S1000, NativeError = 0Error = [Microsoft][ODBC SQL Server Driver]Unable to open BCP host data-file
please help me to resolve this issueIts really urgentthankyoupavan posani Post #374804 Sugesh KumarSugesh Kumar Posted Monday, June 18, 2007 10:31 PM Hall of Fame Group: General Forum Members Last Login: Thursday, July 9, 2015 9:38 AM http://www.sqlservercentral.com/Forums/Topic374804-146-1.aspx Points: 3,461, Visits: 358 http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=120&messageid=237238The link above will solve the issue. Try and let us know.Pavan,My kind advice. You have posted your query as such and it has your user name and password in it. See to that you dont reveal such inform to others than the concerned persons. It will surely harm the security of your system. Cheers,Sugeshkumar Rajendran SQL Server MVPhttp://sugeshkr.blogspot.com Post #374822 Aboobucker SidiqueAboobucker Sidique Posted Monday, April 7, 2008 11:25 PM Forum Newbie Group: General Forum Members Last Login: Monday, April 14, 2008 12:07 AM Points: 6, Visits: 24 I am getting this error while using bcp in 2005SQLState = 28000, NativeError = 18456Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'SA'.THe bcp command worked fine when we used SQL server 2000.THe sql server 2005 connects with SQL authentication mode+windows authentication mode Post #481300 vidhya sagarvidhya sagar Posted Tuesday, April 8, 2008 4:20 AM SSC-Addicted Group: General Forum Members Last Login: Monday, April 25, 2016 1:53 AM Points: 416, Visits: 620 Hi Aboobucker,Can you check the password for SA used in BCP is cofailed by Muthukkumaran kaliyamoorthy Published on: June 18, 2012 Comments: 1 Comment Tags: Error 18456, SQL job failed 18456, SQLSTATE 28000 Categories:DBA Login failed for [SQLSTATE 28000] (Error 18456) the step failed http://www.sqlserverblogforum.com/2012/06/login-failed-for-sqlstate-28000-error-18456-the-step-failed/ When you query the data from another SQL server (Linked server) and SQL server & agent service is run as a domain user. You may get the error following error message in http://www.yqcomputer.com/931_4577_1.htm your job history. Error: Executed as user: Domain\XXX.Service. Login failed for user ‘ SSBF\SQL.Service ‘. [SQLSTATE 28000] (Error 18456). The step failed. Solution: Step 1: Check the source SQL server agent logon service account sql server name All programs -> SQL server 2008 -> Configuration Tools -> SQL server configuration manager. Go to the SQL server agent -> properties -> Check the logon tab and find the account name. Step 2: Check the same is available in the target SQL server. Under the security tab ->logins. If it’s not available add the domain user with necessary permission on your target machine. I hope unable to open this will help someone. Muthukkumaran kaliyamoorthyI’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server And I’m specialized in Administration and Performance tuning. I’m an active member of SQL server Central and MSDN forum. I also write articles in SQL server Central. For more Click hereMore Posts - Website Share this 1 Comment - Leave a comment nasha says: June 17, 2013 at 4:34 pm hello tank u for useful post i have another problem .i cant connect with sql user when i write it in instaletiob time. i chose mix mode .and i recive this error login failed for user msn\sqldb . microsoft sql server ,error 18456.state1 in my sql server configuration in logon tab i see sqldb user . but in sql -> database-> security -> user i dont see sqlbd what can i do?? please help me Reply Leave a comment Cancel reply Your email address will not be published. Required fields are marked * Name * Email * Website You may use these HTML tags and attributes: to a file. My command looks like the following: master..xp_cmdshell 'bcp "exec master..sp_who2" queryout "H:\Temp\SQLTestOutput.txt" -c -U "Freddy" -P "Stuff" -S "\Fred\NetSDK" ' I am getting an error back "Server does not exists or access is denied". When I look at the Sql Server Icon on my XP machine (running locally) - it says my server name is "\\Fred\NetSDK", I have tried it as "\Fred\NetSDK" as wll as "\\Fred\NetSDK" and "Fred\NetSSDK" each fails (the last format give a diffenent error message which lead me to believe it is definitely not the right format. I and using Integrated security - meaning my login ID on XP is used to get me into SQL server. I have configured SQL server to use my login ID when starting. Any ideas as to what I might be doing wrong here? *** Sent via Developersdex http://www.yqcomputer.com/ *** Don't just participate in USENET...get rewarded for it! Top BCP - First Time by Brian Mora » Sat, 08 Nov 2003 08:02:50 I never noticed, but you're right the server applet in the task bar does use a format like \\Fred\NetSDK however for BCP the name should be referenced as Fred\NetSDK what error does that give you? Also, you don't need quotes. That makes it simpler to type... -- Brian Moran Principal Mentor Solid Quality Learning SQL Server MVP http://www.yqcomputer.com/ Top BCP - First Time by Jim Heave » Sat, 08 Nov 2003 14:28:30 Ok, that seemed to help some, now I get the following error: Login failed for user 'Dad'. Reason: Not associated with a trusted SQL Server connection. Why doesn't it trust me...I think I'm trustworthy!!! *** Sent via Developersdex http://www.yqcomputer.com/ *** Don't just participate in USENET...get rewarded for it! Top BCP - First Time by Jim Heave » Sun, 09 Nov 2003 03:07:30 When I run the way you suggested, it then give me an