?
Solved

Proxy settings

Posted on 2011-02-28
5
Medium Priority
?
348 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 2000 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

Currently, there is an issue with being able to copy values from an external application to a dropdown list in Project Web Access (PWA).  The standard copy and paste methods don't seem to work properly. Here is a way to accomplish this task to s…
With more and more companies allowing their employees to work remotely, it begs the question: What are some of the security risks involved with remote employees and what actions should we take to secure them?
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

850 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