Solved

Proxy settings

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

In 2017, ransomware will become so virulent and widespread that if you aren’t a victim yourself, you will know someone who is.
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

911 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

22 Experts available now in Live!

Get 1:1 Help Now