Microsoft describes process of enabling or disabling a Server Network Protocol for MSSQL server as follows: Using SQL Server Configuration Manager To enable a server network protocol In SQL Server Configuration Manager, in the console pane, expand SQL Server Network Configuration. In the console pane, click Protocols for <instance name>. In the details pane, right-click the protocol you… Read More »
Today’s task is to backup database in one MSSQL server and restore database on another server. There is no direct connection between this setup, so backup can be transferred only via ftp. First, create a blank target database. Then, in “SQL Server Management Studio” restore wizard, look for the option to overwrite target database. It… Read More »
Recently I came across with issue where migrating website from one hosting to another resulted on text encoding issues. Site was very old and lot of time had passed, so on new server all texts coming from database had cryptic signs instead of Nordic characters. All you can find below is from article on page https://confluence.atlassian.com/kb/how-to-fix-the-collation-and-character-set-of-a-mysql-database-744326173.html… Read More »