tag:blogger.com,1999:blog-8950887269244304313.post1584892300900993714..comments2024-03-15T02:17:39.656-05:00Comments on Adventures in Database Administration: Setting up aliases on a SQL Server with multiple instancesKevinhttp://www.blogger.com/profile/09120001050238915178noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-8950887269244304313.post-296097696774098032019-02-28T05:03:22.772-06:002019-02-28T05:03:22.772-06:00I found so many interesting stuff in your blog esp...I found so many interesting stuff in your blog especially its discussion. Really it's great article. Keep it up.<b><a href="http://supportcontactnumber.uk/avg-customer-service.html" rel="nofollow">Avg UK</a></b> | <b><a href="http://supportcontactnumber.uk/avg-customer-service.html" rel="nofollow">Avg Phone Number</a></b>David Martinhttps://www.blogger.com/profile/14877695206913251118noreply@blogger.comtag:blogger.com,1999:blog-8950887269244304313.post-38386897077787246892018-07-06T07:49:34.481-05:002018-07-06T07:49:34.481-05:00Great post thanks for sharing for more update at
...Great post thanks for sharing for more update at <br /><a href="https://onlineitguru.com/sql-server-dba-online-training-placement.html" rel="nofollow">Sql server DBA Online Training Bangalore</a><br />rmouniakhttps://www.blogger.com/profile/06622438005105687926noreply@blogger.comtag:blogger.com,1999:blog-8950887269244304313.post-2595505664032097042018-05-11T02:29:48.643-05:002018-05-11T02:29:48.643-05:00Get SQL Server Instance Recovery through Cognegic&...Get SQL Server Instance Recovery through Cognegic's Exchange Database Recovery <br />Get enormous database Backup Recovery bolster with Cognegic's DB Recovery Support or DB Recovery Services example has smashed in MS SQL Server. Ensure, you can physically take care of this issue by utilizing move forward strategy or roll in reverse technique. Yet, in the event that as yet confronting same concern then with no dithering contact to Cognegic's Database Configuration Support and get the best help.<br />For More Info: https://cognegicsystems.com/ <br />Contact Number: 1-800-450-8670 <br />Email Address- info@cognegicsystems.com<br /> Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801<br />Anonymoushttps://www.blogger.com/profile/14983103606458397268noreply@blogger.comtag:blogger.com,1999:blog-8950887269244304313.post-53032284607668269642016-08-11T03:33:28.269-05:002016-08-11T03:33:28.269-05:00Hi Kevin - one question, why do you Uncheck Regist...Hi Kevin - one question, why do you Uncheck Register this connection's addresses in DNS?<br /><br />We tested aliases creation with your tutorial, and the only thing that didn't work for us is the first alias that points to the default instance.<br />In addition, suddenly the DNS entry of the WinServer(the physical machine) vanished from the DNS admin tool.<br /><br />Once we checked back that option gister this connection's addresses in DNS, all the 3 aliases worked, along with their original instance names.<br /><br /><br />Thanks,<br />ROni.RoniVeredhttps://www.blogger.com/profile/03899508013625746563noreply@blogger.comtag:blogger.com,1999:blog-8950887269244304313.post-43049713761612298752016-05-31T07:44:27.714-05:002016-05-31T07:44:27.714-05:00Beautiful post.
3 years later and it's still r...Beautiful post.<br />3 years later and it's still relevant.<br />We had some issues with the implementations of aliases and your post helped to clear it out.<br />Thanks !RoniVeredhttps://www.blogger.com/profile/03899508013625746563noreply@blogger.comtag:blogger.com,1999:blog-8950887269244304313.post-86441600187153043092016-04-27T11:30:31.519-05:002016-04-27T11:30:31.519-05:00What query I use to find the alias for the server ...What query I use to find the alias for the server name. something equivalent to @@SERVERNAMEAnonymoushttps://www.blogger.com/profile/03123661768869687216noreply@blogger.comtag:blogger.com,1999:blog-8950887269244304313.post-11221343873279625422015-06-04T04:35:44.956-05:002015-06-04T04:35:44.956-05:00Hi Kevin,
I followed the setup mentioned above an...Hi Kevin,<br /><br />I followed the setup mentioned above and it works perfect for SQL2008 & SQL2008R2 but it fail for SQL2012, do you have any idea? It will prompt below error.<br /><br />TITLE: New Server Registration<br />------------------------------<br /><br />Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again.<br /><br />------------------------------<br />ADDITIONAL INFORMATION:<br /><br />Instance failure. (System.Data)<br /><br />------------------------------<br />BUTTONS:<br /><br />OK<br />------------------------------<br />Anonymoushttps://www.blogger.com/profile/02153430188884830534noreply@blogger.comtag:blogger.com,1999:blog-8950887269244304313.post-55913737474828487822015-02-03T11:16:34.095-06:002015-02-03T11:16:34.095-06:00Do you have similar steps for Fail over SQL cluste...Do you have similar steps for Fail over SQL cluster Instances ? In this case SQL server Instance can reside on either of cluster nodesAnonymoushttps://www.blogger.com/profile/09579159391873582748noreply@blogger.comtag:blogger.com,1999:blog-8950887269244304313.post-52161389315578582932015-01-26T18:36:24.665-06:002015-01-26T18:36:24.665-06:00Hi Kevin,
SQL Alias Name are perfectly working. I...Hi Kevin,<br /><br />SQL Alias Name are perfectly working. I can able to connect to correct instances either by using SQL Alias Names or Static Ips. However, I am facing little issue while adding a member to AVG group. The remote DR SQL Server (Stand Alone Installations) has 3 SQL Instances (1 default, 2 named) listening on 1433 ports with SQL Aliases & Static Ip's set up correctly. I need to add these 3 SQL instances to 3 separate AVG groups. Though I am generating the scripts for adding remote DR node to AVG group, ALTER AVAILABILITY GROUP statement is still taking SQL Instance Name (Windows Server\Instance) instead of using SQL Alias Name. Hence, even though the member able to join, it is not coming online to add remote databases to AVG group. Do we have any work around to solve this issue?<br /><br />:Connect avg-primary-server<br /><br />ALTER AVAILABILITY GROUP [AVG-NAME]<br />ADD REPLICA ON N'server-name\instance-name' WITH (ENDPOINT_URL = N'TCP://server-name.domain.com:5022', FAILOVER_MODE = MANUAL, AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, BACKUP_PRIORITY = 50, SECONDARY_ROLE(ALLOW_CONNECTIONS = ALL));<br /><br />GO<br /><br />:Connect Remote-DR-Standby<br /><br />ALTER AVAILABILITY GROUP [Avg-Name] JOIN;<br /><br />GOVenkathttps://www.blogger.com/profile/03377941458755381339noreply@blogger.comtag:blogger.com,1999:blog-8950887269244304313.post-36034805536718415822015-01-26T18:25:06.606-06:002015-01-26T18:25:06.606-06:00This comment has been removed by the author.Venkathttps://www.blogger.com/profile/03377941458755381339noreply@blogger.comtag:blogger.com,1999:blog-8950887269244304313.post-46920933658414701982014-05-07T09:40:09.628-05:002014-05-07T09:40:09.628-05:00Hi Kevin, thanks for the information you provided ...Hi Kevin, thanks for the information you provided in this article - it's very helpful!<br />Are you aware if the steps to accomplish something like this has changed much between SQL Server 2008 and SQL Server 2012 or even the new 2014? <br />Also, once these alias are setup, how much work do you think it would be to migrate them to the new version of SQL? I'm just curious about maintanability.<br />Thanks,<br />MonekaAnonymoushttps://www.blogger.com/profile/00982773538427451753noreply@blogger.comtag:blogger.com,1999:blog-8950887269244304313.post-17577584148466641362014-04-30T14:23:24.820-05:002014-04-30T14:23:24.820-05:00Hi Ashok --
The DNS records should look the same...Hi Ashok --<br /> The DNS records should look the same as if the SQL instances were listening on port 1433. You cannot specify ports inside DNS. If you've setup the TCP ports for the instance correctly to listen on 29355 or 39576 and added the correct number of IP's to your server, then you will reference the instances with a DNS alias to those IP's, which are mapped to instance.Kevinhttps://www.blogger.com/profile/09120001050238915178noreply@blogger.comtag:blogger.com,1999:blog-8950887269244304313.post-76670488969924071132014-04-30T13:06:19.903-05:002014-04-30T13:06:19.903-05:00Very good and detailed article!
Have you tried usi...Very good and detailed article!<br />Have you tried using non-default ports on all these instances? How would the corresponding DNS records look (say for instance you want WinServer\Instance2 to listen on port 29355 and WinServer\Instance3 to listen on 39576 - bascally random ports). <br />Thank you for your post.Ashokhttps://www.blogger.com/profile/13079545890959660027noreply@blogger.com