Solved

Proxy settings

Posted on 2011-02-28
5
313 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In this article, you will read about the trends across the human resources departments for the upcoming year. Some of them include improving employee experience, adopting new technologies, using HR software to its full extent, and integrating artifi…
In this article, I show you step by step with screenshots to assist you - HOW TO: Deploy and Install the VMware vCenter Server Appliance 6.5 (VCSA 6.5), with some helpful tips along the way.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

706 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now