Database Mirroring Monitor - Registered Databases Question
-
Hi,
I was wondering if there was a way to register databases that are using a different port (1434). When I enter in sqldb,1434 in the server name, I get a message stating that it requires the actual server name. So when I enter in sqldb, I get a network-related or instance-specific error occurred while establishing a connection to SQL Server error.
Could someone please help me resolve this issue?
Thank you!
-
1433 is the default port, do you havce TCP\IP enabled?
Have you installed a default or named instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Perry Whittle (12/29/2014)
1433 is the default port, do you havce TCP\IP enabled?Have you installed a default or named instance?
Yes, I have TCP/IP enabled (TCP Port set to 1434) and it is a named instance.
-
..Hope you are entering "server name\instance, 1434".
..Working with IP by any chance ?
-
Joy Smith San (12/29/2014)
..Hope you are entering "server name\instance, 1434"...Working with IP by any chance ?
Yes, I have tried entering "sqldb,1434" and I got the "must be server name only" message. Oh, by server name, I'm assuming you're talking about SQL server name instead of the physical server name.
The message also states: "Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name"
-
Oh, by server name, I'm assuming you're talking about SQL server name instead of the physical server name.
SQL Server name is nothing but your instance name is it ?
Tried with "[physical server name]/[SQL Instance name], 1434" ?
-
Joy Smith San (12/30/2014)
Oh, by server name, I'm assuming you're talking about SQL server name instead of the physical server name.
SQL Server name is nothing but your instance name is it ?
Tried with "[physical server name]/[SQL Instance name], 1434" ?
Yes, it should be just the instance name, but since I'm using a different port I'm not sure how to enter that for database mirroring monitor.
I have just tried entering "[physical server name]/[SQL Instance name], 1434", but that didn't work either...
-
why have you configured the instance to use 1434, best practice would be to set a static high range port for the instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Perry Whittle (12/31/2014)
why have you configured the instance to use 1434, best practice would be to set a static high range port for the instanceThat's what it was originally (before me). Either way, is there no way to register the database mirror on database mirroring monitor to track databases using a different port other than 1433?
-
you add the primary, the est should be taken care of
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Try using an alias and then pointing the monitor at the alias.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARantMinion Maintenance is FREE:
-
KenpoDBA (1/5/2015)
Try using an alias and then pointing the monitor at the alias.Can you please explain how best to do that?
-
Yeah, google how to setup a sql alias.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARantMinion Maintenance is FREE:
-
KenpoDBA (1/7/2015)
Yeah, google how to setup a sql alias.Got it to work, but when I add it to the Mirroring Monitor, I get the error message:
SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name.
-
Y I know it doesn't work for repl, but I've never tried before with the mirroring mon...
well then, you may be putting together your own monitor in code.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARantMinion Maintenance is FREE:
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply