where can i find Sybase Interface file in windows system ?

I'm getting the following error 7235 while starting backup service when discovering the solutions, find the KB for Error 7234/7235

Error: 7235, Severity: 17, State: 0  No other query entry found for the remote server SYBASESRV_BS - site SYB_BACKUP. Aborting this site handler, as no remote server responded. Please make sure the remote server is accepting connections.   

Open in new window


after issuing the following dump command line to Check that the remote server is up and running. I got the below error :

1> exec SYB_BACKUP...sp_who
2> go

If Backup Server is running, will get a meaningful response to this query. Unfourantly, we got the below error

Msg 7205, Level 17, State 2:
Line 1:
Can't open a connection to site 'SYB_BACKUP'.  See the error log file in the SQL

Server boot directory.
Msg 7205, Level 18, State 3:
Line 1:
Can't open a connection to site 'SYB_BACKUP'.  See the error log file in the SQL

Open in new window


as per the Action plan, we should check the interface file and I am not able to find the interface file yet. I would appreciate if anyone can share thoughts on this, please.
MansourIT ManagerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Joe WoodhousePrincipal ConsultantCommented:
The Sybase interfaces file in Windows is called SQL.INI, and it lives in %SYBASE%/ini.

It does not look the same as a UNIX/Linux interfaces file so I strongly recommend you don't edit it directly. It's best to use the Sybase client to look at it, so under Windows I suggest running "dsedit" which will open the "Directory Services Editor" (or a GUI tool for viewing and editing the interfaces file.)

Dsedit has a "ping" utility built in (a little lightning bolt in the menu bar) which you can use to test if everything is working, although you say you get this error when trying to start the Backup Server service so you aren't getting that far yet.

Another thing to try - can you start the Backup Server manually? Sybase on Windows still creates a RUN_SERVER file in the usual location, it just isn't used or maintained after creation. If you open a CMD prompt and navigate to %SYBASE%/install and manually launch the Backup Server, what happens?
MansourIT ManagerAuthor Commented:
when starting the Backup Server Manually for services get the below error, Moreover, for manually launch the Backup Server and need your advise

Captures.PNG
Joe WoodhousePrincipal ConsultantCommented:
We may be overthinking this. I suggest you simply recreate the Backup Server. It does not store any data and usually under Windows all settings are at their default values. You will lose nothing by removing it and recreating it.

Depending on your version of ASE it is probably a tool called "asecfg" or sometimes "Server Config" that will let you both drop and create a new Backup Server.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.