populate these two fields with a user creds who is part of the SQL sysDBA and then try a backup again. Working bcp is'bcp Monitor.testing out E:\Martin.Christiansen\FirewallRegler.csv -c -t, -T -S' + course i needed to specify the db to connect toĮxcellent. Go to the client NMC -> properties for this client -> Globals 1 0f 2 -> user and password. I must have slept when i read the many tutorials around the web. But now i get this error instead, which i really dont understand as testing is a functioning permanent table in my db?SQLState = S0002, NativeError = 208Error = Invalid object name 'testing'.NULLEDIT: fixed it. Try this:SET = 'bcp testing out E:\Martin.Christiansen\FirewallRegler.csv -c -t, -T -S ' + Lumbago My blog->
You are specifying the server name in the -T switch so there is no need for this to be in the database name (unless it's a linked server? is SC2835128 a linked server name?).
The login failed.SQLState = 28000, NativeError = 18456Error = Login failed for user 'NT AUTHORITY\SYSTEM'.NULLWhat is wrong? HiI'm trying to export a sql file to a csv file using following code:DECLARE varchar(8000)SET = 'bcp SC2835128.testing out E:\Martin.Christiansen\FirewallRegler.csv -c -t, -T -S' + master.xp_cmdshell i try to execute this with inside ssms it gives me following error:SQLState = 37000, NativeError = 4060Error = Cannot open database "SC2835128" requested by the login. When we have multiple open connections we receive the following error: MicrosoftSQL Native ClientSQL ServerLogin failed for user 'user'. 4 ETW000 dev trc ,00000 (18456) 28000 MicrosoftSQL Server Native Client 10.0SQL ServerLogin failed for user SMAPORTAslmadm.
We've got lots of great SQL ServerĮxperts to answer whatever question you can come up with.