SQL Server subscriptions on non standard port

When setting up replication using publications and subscriptions, it's not easy to do if your publishing server is running on a different port number than the standard port number (1433).

If you try to enter the server name as SERVERNAME,port number you get an error stating that you cannot use ip addresses, aliases or other strange names.

So the only option you are left with is to use the REAL name of the SQL server.

So lets say your server's SQL name is: COMPANYSQL01 you need to use that server name, but if you are running on a different port number or even with multiple instances on the server, each running on a different port, you are in BIG trouble.

Lets take the following configuration.

You have a SQL server 2005, configured with the name COMPANYSQL01.

You have two instances on that server, INSTANCE1 and INSTANCE2

INSTANCE1 runs on the standard port 1433, and you have configured the next instance INSTANCE2 to run on 1434.

So normally you would connect to the server instance2, by entering COMPANYSQL01\INSTANCE2,1434

But that's not possible in Subscription configuration, since you are not allowed to enter a port number.

So what you need to do, is the following:
1. Connect to the instance you want to create a subscription from:

2. Open a query window and enter the following: SELECT @@SERVERNAME (Should yield COMPANYSQL01\INSTANCE2) with the example above

3. Open the Sql Server Configuration Manager on the server that wants to be a subscriber.

3. Expand the SQL Native client configuration (32bit)

4. Expand Aliases, and create a new alias:

4.1 For alias name enter COMPANYSQL01\INSTANCE2
4.2 In port number you enter the non standard port number, i.e. 1434 in this example
4.3 Protocol leave at TCP/IP
4.4 Enter COMPANYSQL01\INSTANCE2 as server name.
4.5 If server is a 64bit machine repeat steps 4 - 4.4 in the SQL Native client configuration in Sql Server Configuration Manager

If you do not have name resolution in place on your subscriber server, i.e. you cannot ping COMPANYSQL01, then you need to fix that, either by updating your DNS or by adding a host entry in your hosts file (C:\Windows\System32\Drivers\etc\hosts ). The name resolution issues can be because your SQL server is on another network than your subscriber, i.e. your subscriber is on your local LAN, and the server that you want subscriptions from is in your DMZ.

Even though the subscription configuration explicitly tells you that aliases does not work with subscriptions, it does if you use the same name for the alias as the real name.
Its strange I know, but it works, it really does.

LIVE messenger on windows xp x64 or windows server 2003

Strangely enough microsoft decided that windows xp x64 and windows server 2003 shouldn't support LIVE messenger, even though the program runs just fine.

When you try to install LIVE messenger 8.5 you get the message that your operating system is not supported.

Do not despair.

Just download an old version of LIVE messenger from e.g. oldapps.com, and install that version.

When you sign on the first time, messenger says that there is a new version availablem, and ask if you want to upgrade to that version.

Just click yes, and it will download the new version, install it without complaning a bit.

Thats how you get LIVE messenger 8.5 on xp x64 and server 2003.

Disable the shutdown event tracker of windows 2003

Some of use are using windows 2003 as a desktop OS because its more near to the real use when developing applications, websites etc.

So when faced with the inevitable box that asks for a reason as to how we want to shut down or restart our computer, a man just have to act.

Luckily there is help to be had. There is a Group policy that controls wether or not the pesky question should be asked or not.

Simply start the Group Policy editor, by Clicking on the Start button, selecting Run, entering gpedit.msc and press enter.

This will yield the UI for the Group poilicy editor.

Navigate to Computer Configuration > Administrative Templates > System and in the right hand pane, select the “Display Shutdown Event Tracker” setting.

Right click on the setting and select properties, and set the radio button as shown below to Disabled.

When you have done this and waited a few moments, your Shut down windows dialog box should look much nicer :)