Solved

remote logins for proxy table in sybase

Posted on 2016-10-11
5
69 Views
Last Modified: 2016-10-11
Dears, kindly note I have created an external login and a remote login as following: sp_addremotelogin remoteserver,locallogin1, remotelogin1 sp_addexternallogin remoteserver,locallogin1, remotelogin1

and I log in by user locallogin1 to the localserver to the database localdb and try to create proxy table from remotedb1 on remoteserver but still get the login failed error, any body know why??

kindly note there is localuser1 aliased to locallogin1 , i.e there is no user 'locallogin1' (direct mapping) on the database localdb where I try to create proxy table, rather there is a user localuser1 is alias to locallogin1, is this related to the problem??

please advice
0
Comment
Question by:suzn cas
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 41839499
Have you added remoteserver using sp_addserver?

Does the server name you used in sp_addserver exactly the same as its name in your local interfaces file?

Is the password for locallogin1 on localserver the same as the password for remotelogin1 on remoteserver?

Can you log in directly to remoteserver using remotelogin1 and that password?

I don't believe the alias will matter because if your error is a login error, you haven't gotten as far as databases, users or aliases yet. Can you share the exact error message?
0
 

Author Comment

by:suzn cas
ID: 41839542
Dear Joe, Thanks alot,
Is the password for locallogin1 on localserver the same as the password for remotelogin1 on remoteserver?
NO, it is not.they are different logins name with different passwords.

for example: the locallogin1 = suzn with password = 123 , and the remotelogin1 = rami with password 'rami',
is this the case?? so what can I do, create a local login at remote server with = (login name = suzn with password = 123), then may locallogin at local server (uzn with password = 123) with him ??????
0
 
LVL 24

Accepted Solution

by:
Joe Woodhouse earned 500 total points
ID: 41839545
Passwords are your problem. When you use sp_addremotelogin and sp_addexternlogin, you can specify what the remote password is. It looks like you haven't done that. It's simple, add it as one more parameter:

exec sp_addexternlogin [remoteserver], [locallogin], [remotelogin], [remotepassword]
go

Open in new window

1
 

Author Comment

by:suzn cas
ID: 41839566
Dear Joe, Thanks in advance.
I add remote password to the sp_addexternallogin and every thing is well.
Thank you
0
 

Author Closing Comment

by:suzn cas
ID: 41839572
when the passwords for local login and remote login are not tha same , we should add remotepassword as:

exec sp_addexternlogin [remoteserver], [locallogin], [remotelogin], [remotepassword]

Thanks  Joe Woodhouse
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Dynamically Growing Sybase Database 3 459
Cannot create ODBC connection over the network 3 1,255
SyBase SQL Querry Syntax 1 275
connect to sybase then query 1 790
Unified and professional email signatures help maintain a consistent company brand image to the outside world. This article shows how to create an email signature in Exchange Server 2010 using a transport rule and how to overcome native limitations …
Deploying our service is a grudge match between customer benefits and customer pain. In one corner, rolling out fixes (yay!) and delivering new features (double yay!). In the other corner, training on new features (boo – sounds like work), and chan…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question