- Community Home
- >
- Storage
- >
- Legacy
- >
- Storage Software
- >
- Re: SQL 2000 IA Browser fails
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-08-2010 11:49 AM
тАО06-08-2010 11:49 AM
SQL 2000 IA Browser fails
- Tags:
- SQL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-11-2010 06:19 AM
тАО10-11-2010 06:19 AM
Re: SQL 2000 IA Browser fails
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-13-2010 07:26 AM
тАО10-13-2010 07:26 AM
Re: SQL 2000 IA Browser fails
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-12-2011 06:00 AM
тАО12-12-2011 06:00 AM
Re: SQL 2000 IA Browser fails
I went a long time without this occurring. We just did some network work this weekend on one of the nodes and the issue is back with a vengence. IA service is failing and aliases not working every 6 hrs-12 hrs. To "fix" which is painful, I have to fail over all instances (only have one backup server) and then reboot the problem node to "release" the alias. It happens on either node - it does not matter.
ia.log shows:
2011-Dec-12 06:42:07 [4056] IA service: Event was signalled, might need to exit
2011-Dec-12 06:42:07 [4056] IA service: Event was signalled, might need to exit
2011-Dec-12 07:12:46 [6576] IA service: Reading settings from the registry
2011-Dec-12 07:12:46 [6576] Router: Removing legacy ips from the node
2011-Dec-12 07:12:46 [10664] Router: Starting Sql Alias Manager...
2011-Dec-12 07:12:46 [6576] Router: Removing..10.77.44.44:1433
2011-Dec-12 07:12:46 [6576] Router: Removing..10.77.45.18:1433
2011-Dec-12 07:12:46 [6576] Router: Removing..10.77.45.232:1433
2011-Dec-12 07:12:46 [6576] Router: Removing..10.77.46.22:1433
2011-Dec-12 07:12:51 [8448] IA service: Reading settings from the registry
2011-Dec-12 07:12:51 [8448] Router: Removing legacy ips from the node
2011-Dec-12 07:12:51 [7272] Router: Starting Sql Alias Manager...
2011-Dec-12 07:12:51 [8448] Router: Removing..10.77.44.44:1433
2011-Dec-12 07:12:51 [8448] Router: Removing..10.77.46.22:1433
2011-Dec-12 07:12:53 [10456] IA service: Reading settings from the registry
2011-Dec-12 07:12:53 [10456] Router: Removing legacy ips from the node
2011-Dec-12 07:12:53 [11132] Router: Starting Sql Alias Manager...
2011-Dec-12 07:12:53 [10456] Router: Removing..10.77.44.44:1433
2011-Dec-12 07:12:53 [10456] Router: Removing..10.77.46.22:1433
2011-Dec-12 07:13:01 [3240] IA service: Reading settings from the registry
2011-Dec-12 07:13:01 [3240] Router: Removing legacy ips from the node
2011-Dec-12 07:13:01 [3336] Router: Starting Sql Alias Manager...
2011-Dec-12 07:13:01 [3240] Router: Removing..10.77.44.44:1433
2011-Dec-12 07:13:01 [3240] Router: Removing..10.77.46.22:1433
2011-Dec-12 07:13:06 [1392] IA service: Reading settings from the registry
2011-Dec-12 07:13:06 [1392] Router: Removing legacy ips from the node
2011-Dec-12 07:13:06 [7896] Router: Starting Sql Alias Manager...
2011-Dec-12 07:13:06 [1392] Router: Removing..10.77.44.44:1433
2011-Dec-12 07:13:06 [1392] Router: Removing..10.77.46.22:1433
2011-Dec-12 07:13:21 [9640] IA service: Reading settings from the registry
2011-Dec-12 07:13:21 [9640] Router: Removing legacy ips from the node
2011-Dec-12 07:13:21 [10808] Router: Starting Sql Alias Manager...
2011-Dec-12 07:13:21 [9640] Router: Removing..10.77.44.44:1433
2011-Dec-12 07:13:21 [9640] Router: Removing..10.77.46.22:1433
2011-Dec-12 07:13:51 [3260] IA service: Reading settings from the registry
2011-Dec-12 07:13:51 [3260] Router: Removing legacy ips from the node
2011-Dec-12 07:13:51 [3292] Router: Starting Sql Alias Manager...
2011-Dec-12 07:13:52 [3260] Router: Removing..10.77.44.44:1433
2011-Dec-12 07:13:52 [3260] Router: Removing..10.77.46.22:1433
2011-Dec-12 07:14:22 [11224] IA service: Reading settings from the registry
2011-Dec-12 07:14:22 [11224] Router: Removing legacy ips from the node
2011-Dec-12 07:14:22 [7044] Router: Starting Sql Alias Manager...
2011-Dec-12 07:14:22 [11224] Router: Removing..10.77.44.44:1433
2011-Dec-12 07:14:22 [11224] Router: Removing..10.77.46.22:1433
2011-Dec-12 07:14:52 [11156] IA service: Reading settings from the registry
2011-Dec-12 07:14:52 [11156] Router: Removing legacy ips from the node
2011-Dec-12 07:14:52 [10640] Router: Starting Sql Alias Manager...
2011-Dec-12 07:14:52 [11156] Router: Removing..10.77.46.22:1433
As before, this only happens on the SQL 2000 nodes. I know on SQL 2005 the SQL Browser has to be disabled but I have no idea with 2000.