Question about Computer Associates Unicenter SQL-Station 7.0 Debugger Option for PC

1 Answer

SQL Station 4.1 and 7.0

I had the agent for 4.1 installed on one of our database servers, and then tried to update it to 7.0. After that, began getting "looping chain of synonym" errors. Tried uniunstalling one, then the other, then installing one or the other, etc, but I am hosed with the looping chain whatever I do. Struggling through the srv_msg.log, but unsure what to do.

Posted by on

  • 1 more comment 
  • bomber17 Feb 14, 2008

    No I didn't. Is that really needed? These are busy servers, and shutdowns are a big deal.

  • bomber17 Feb 14, 2008

    Yes we have redundancy, but it still takes and act of God to initiate a deliberate shutdown/failover here. And I am one of very few users here who uses SQL Station, so my reasons to push for the shutdown won't carry much weight. Still, thanks for the advice!!

  • bomber17 Feb 18, 2008

    After wandering through the maze of CA support, I was finally able to get a full resolution of this one. There is a patch for Sql Station 7.0 (7.0.4). I applied the patch, unistalled and reinstalled the agent, and now it works fine! No cycle of the server power was needed.

×

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Sergeant:

    An expert that hasĀ over 500 points.

    Champion:

    An expert who has answered 200 questions.

  • Expert
  • 326 Answers

I hate to ask this question, but did you cycle power after unistalling both agents and then reinstalling either agent?

Posted on Feb 14, 2008

  • Rory Biggs
    Rory Biggs Feb 14, 2008

    Unless you like playing in the register, (with the possibility of system crash), recycling power is a much better option. The system will remove what ever DLL's are not being used. You may try looking in the config to disable the DLL, but you will still have to restart to enact.

    You don't have reduntant server?

×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

3 Answers

Repair database without being attached SQL 2005


Use SQL Server Repair Kit. A convenient, reliable and ultimately efficient MS SQL database repair tool for system administrators, developers and database experts. Best in class performance and outstanding usability for users with and without experience.

Read more: http://www.mssqlserver.repair/

May 13, 2015 | Microsoft SQL Server 2005 Enterprise...

Tip

Tricks for Keeping SQL Server Safely


Some simple ways to protect your SQL Server database

1. Using the Microsoft Baseline Security Analyzer (MBSA) to assess the server's security
MBSA is one of a variety of Microsoft products, which can scan unsafe configuration tools. It can be run locally; you can also run through the network.

2. Isolate your server and regularly back up
Physical and logical isolation would form the basis of SQL Server security. Database should be installed within the enterprise network security area, but not directly connected to the Internet. Back up all data regularly and store copies in a safe location outside the site.

3. Assign a strong SA password for a SA account
SA account should always have a strong password, even if Windows is configured to require authentication of the server. This will ensure that the server has been reconfigured in the future as Mixed Mode authentication; it will not appear blank or weak SA.

4. Restrict the permissions SQL Server service
SQL Server 2000 and SQL Server Agent is running as a Windows service. Each service must be associated with a Windows account, and derive from this account security context. SA log in SQL Server allows the user (sometimes including other users) to access the operating system features.

About reset SA password in SQL 2008/2005/2000

To secure our database we would like to choose create an intricate password. But even our selves would forget the SA password in SQL Server 2005/2008 sometimes. So here is a way for you to reset SQL Server 2005 password -- MS SQL Server Password Unlocker, which is a highly A Highly Technical and Safe SQL password 2005 Recovery tool. And following is a few features of the tool.

Features:

* Support SQL Server password recovery for MS SQL Server and MS SQL Server Express 2008/2005/2000

* No need to install MS SQL Server on your PC or lose data, the file master.mdf format is necessary

* Stop and resume MS SQL service automatically if the MS SQL Server on your PC is running

* Reset SQL password with ease no matter how long and complicated the SQL password is

* Easy to use

Feedback:

The most of people who encountered with SQL 2005 password losing problems are getting back to their SQL account now. We can also feel that ease and the hilarious mood when a hard nut has been cracked. Hope this MS SQL Server Password Unlocker would help more people and get their trouble erased.

on Nov 12, 2010 | Computers & Internet

2 Answers

SQL 2008 R2 - MASTER.LDF corrupted without backup


Try this one solution...

1. First Shutdown SQL Server
2. Then move the current database file/rename (do not touch the .ldf)
3. After rename/move db, restart SQL Server
4. Create a new database with same name and log file and location also same
5. Stop SQL Server

Make use of some interesting links which might help you....
http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/1465-table-in-sql-server-2008-is-corrupted - a lot of guides and tips for corrupted sql server databases
https://repairsql.recoverytoolbox.com/ Recovery Toolbox for SQL Server - free demo version of this tool, if any variant doesn't seem effective

Apr 26, 2015 | Microsoft SQL Server 2008 Enterprise Full...

3 Answers

What is SQL?


It is a special purpose programing language. Computer language you will never use, unless you are into servers or programing type software

Jan 27, 2015 | Oracle 10g Database Standard (ODBSEONUPP0)

2 Answers

How to convert SQl server 2005 to SQL server 2008


upgrade it or
take backup of your database
install sql server 2008
Restore backup in sql server 2008

Feb 05, 2011 | Office Equipment & Supplies

5 Answers

SQL 401: cannot open database


SQL database Recovery Software remove errors from SQL server database and allow recover your all database of SQL Server 2012 or below versions. The software support with all over version of SQL server. Try at here:-
SQL Database Recovery

Jun 06, 2008 | Computers & Internet

Not finding what you are looking for?

Open Questions:

See all Computer Associates Unicenter SQL-Station 7.0 Questions

Computers & Internet Logo

80 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computer Associates Computers & Internet Experts

Barbat Nae
Barbat Nae

Level 3 Expert

508 Answers

k24674

Level 3 Expert

7993 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18343 Answers

Are you a Computer Associates Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...