Solved

Proxy settings

Posted on 2011-02-28
5
329 Views
Last Modified: 2012-05-11
Does anyone know how to check for proxy server settings in sybase. Let''s say my current Sybase server is A. And I want to know if the settings on this server are enabled to allow reference/updates/deletes to remote Sybase server B.

What are the commands or functions?

Pls note: I am NOT asking for how to add a proxy server, only to know if my current one has the settings enabled.

Thanks,
0
Comment
Question by:4Learning
  • 3
  • 2
5 Comments
 
LVL 13

Expert Comment

by:alpmoon
ID: 35002726
Unfortunately, it is not very straightforward as each table needs to be defined against remote server.

You can check serverwide configuration by sp_helpserver. It shows remote server definition. But, then you need to check individual tables by sp_help <table name> on the database proxy table definitions are located. That is the database you access to remote tables on server B.
0
 

Author Comment

by:4Learning
ID: 35007718
Thankyou Alpmoon.

What I get by sp_helpserver is the following columns:
name, network_name, class, status, id, cost

So if the name of my Sybase server is S1, then against S1, in the status column, I only see the word "local".
If S1 did have proxy server settings, what would be status column value?

Thankyou.
0
 
LVL 13

Accepted Solution

by:
alpmoon earned 500 total points
ID: 35009187
If you don't see the other server in that list, it means that server is not configured to access from S1. You should see the other server with its name on S1, its actual network name (the name in interfaces file) and other options like below:

 name                                     network_name                                             class                              
         status                                                                                                                                                                                                                                                          id       cost            
 ---------------------------------------- -------------------------------------------------------- ------------------------------------
         --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ----------------
 XXXXXXX                                 XXXXXXX                                                 local                              
                                                                                                                                                                                                                                                                          0          0            
 SYB_BACKUP                               XXXXXXX_BS                                              NULL                                
         timeouts, no net password encryption, writable , rpc security model A                                                                                                                                                                                            1       NULL            
 SYB_REMOTE                               SYB_REMOTE                                                 ASE_server                          
         timeouts, no net password encryption, writable , rpc security model A                                                                                                                                                                                            2       NULL
0
 

Author Comment

by:4Learning
ID: 35009582
I do see the remote server S2, that I would like to access. And it does have value for status column as -
timeouts, net password encryption, writable , rpc security model A.

I also tried running a stored procedure on S2 from S1 as-
S2...sp_myproc

and it does give me the result from that server.

So looks like it is configured to remotely connect. But if I run the following from S1

connect to S2
go
use db2
go

I get connect permission denied.
0
 
LVL 13

Expert Comment

by:alpmoon
ID: 35009903
It depends on which user is trying to do it and how remote users are mapped. I think you should go through "Managing Remote Servers" chapter in Admin guide to set it up.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

This article was originally published on Monitis Blog, you can check it  here . If you have responsibility for software in production, I bet you’d like to know more about it. I don’t mean that you’d like an extra peek into the bowels of the sour…
Always backup Domain, SYSVOL etc.using processes according to Microsoft Best Practices. This is meant as a disaster recovery process for small environments that did not implement backup processes and did not run a secondary domain controller that ne…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

733 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