December 14, 2009 at 7:05 am
SQL Linked Server Query failed with “Login failed for user , I try every thing, but still no luck.
I try different user still logon failed.
I can get the data from B to A server but not from A to B server
December 14, 2009 at 7:08 am
B to A is a linked server also ? Same account & permissions ?
December 14, 2009 at 7:10 am
yes, the only different is A server has Enterprize and B hase Standard edition
December 14, 2009 at 7:20 am
That should not have any issue, you must be able to have Linked Server between different editions.
Check the Login you are using exists on the destination with the same password.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 14, 2009 at 7:22 am
yse both logon are same ps
December 14, 2009 at 7:26 am
Can you confirm that login is working with the pwd you are using in Linked Server, try using that login/pwd from another Server using SQL Server Authentication.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 14, 2009 at 7:28 am
yes they are, do you know how to create a ODBC connection
December 14, 2009 at 7:39 am
I am not an expert in that, I only create it only when necessary.
Instead, let me ask this, are you trying to create the Linked Server using the GUI? If so what is that you are selecting, are you selecting SQL Native Client as Other data source?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 14, 2009 at 7:41 am
ODBC connecting file.
i used GUI and sp_addlinkserver both still have a same issue
December 14, 2009 at 9:02 am
Is that a Named Instance and ar you suing the Servername\Instance name or the Servername\Port # where SQL is listening.
More info would only would be better to troubleshoot.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 14, 2009 at 9:05 am
I logon as a sysadm
companyname\sysadmin id
December 14, 2009 at 9:07 am
What abt server details you are using when creating Linked Server.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 14, 2009 at 9:13 am
server type : SQL Server
security: be made using the login's current security context
server option: Data access -True
Rpc - true
Rpc out -true
use remorte collation -true
December 14, 2009 at 9:17 am
MAK-1128556 (12/14/2009)
server type : SQL Serversecurity: be made using the login's current security context
server option: Data access -True
Rpc - true
Rpc out -true
use remorte collation -true
When you use that security setting, the Linked Server is created using the admin log who is currently trying to create the Linked Server (that is you) rather than that use the last option and give the credentials manually and try.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 14, 2009 at 9:20 am
I try the last option too, but still my admin id is not working
Viewing 15 posts - 1 through 15 (of 19 total)
You must be logged in to reply to this topic. Login to reply