SQL Server replication requires the actual server name to make a connection to the server

Symptom:

Error Msg: “SQL Server replication requires the actual server name to make a connection to the server”

 

When attempting to create a new replication publication the following error is produced:

New Publication Wizard

SQL Server is unable to connect to server ‘SSSS’.

Additional information:
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 alternative name are not supported. Specify the actual server name, ‘OOOO’. (Replication.Utilities)

Where “SSSS” is the name of the current server, and (in my case) “OOOO” was the previous name of the same server.

Steps to reproduce this problem:

Microsoft SQL Server Management Studio
Expand the server
Expand Replication
Right click “Local Publications” and select “New Publication …”
Cause:

This error has been observed on a server that had been renamed after the original installation of SQL Server, and where the SQL Server configuration function ‘@@SERVERNAME’ still returned the original name of the server. This can be confirmed by:

select @@SERVERNAME
go

This should return the name of the server. If it does not then follow the procedure below to correct it.

Remedy:

To resolve the problem the server name needs to be updated. Use the following:

sp_addserver ‘real-server-name’, LOCAL

if this gives an error complaining that the name already exists then use the following sequence:

sp_dropserver ‘real-server-name’
go
sp_addserver ‘real-server-name’, LOCAL
go

If instead the error reported is ‘There is already a local server.’ then use the following sequence:

sp_dropserver old-server-name
go
sp_addserver real-server-name, LOCAL
go

Where the “old-server-name” is the name contained in the body of the original error.

Stop and restart SQL Server.

 

 

Reff: http://www.cryer.co.uk/brian/sqlserver/replication_requires_actual_server_name.htm 

Advertisements

sql drop stored procedure if exists

Drop and re-create procedure if it exists in T-SQL not working

 

IF EXISTS(SELECT 1

          FROM   INFORMATION_SCHEMA.ROUTINES

          WHERE  ROUTINE_NAME = 'YOUR_STORED_PROCEDURE_NAME'

                 AND SPECIFIC_SCHEMA = 'dbo')

  BEGIN

      DROP PROCEDURE YOUR_STORED_PROCEDURE_NAME

  END

GO




CREATE PROCEDURE dbo.YOUR_STORED_PROCEDURE_NAME

AS-- Logic Comes Here

GO

Open Cart Add bulk menu to bulk product

SELECT * FROM ocw8_product_to_category WHERE product_id IN

(SELECT product_id FROM `ocw8_product` WHERE model = ‘Sloppy Plate’)

INSERT INTO ocw8_product_to_category (product_id,category_id)
VALUES (75,68)

INSERT INTO ocw8_product_to_category (product_id,category_id)
VALUES (76,68)
GO
INSERT INTO ocw8_product_to_category (product_id,category_id)
VALUES (78,68)
Go
INSERT INTO ocw8_product_to_category (product_id,category_id)
VALUES (79,68)
GO
INSERT INTO ocw8_product_to_category (product_id,category_id)
VALUES (80,68)
GO
INSERT INTO ocw8_product_to_category (product_id,category_id)
VALUES (81,68)
Go

OpenCart Install VQMOD to install all extensions

Lots of extention in Opencart is developed in VQMOD. To install VQMOD:

STEP 1 : Download vQmod

  1. Download VqMOD: From Here
  2. Unzip it.
  3. Upload vQmod to root directory vqmod

STEP 2 : Install vQmod

  1. After upload run the installation by running install file through :http://www.yourdomain.com/vQmod/install.

You will see vQmod INSTALLED message

 

Extension Installation

(Collected from this site: https://www.transpacific-software.com/guide_install_opencart_extensions.html )

Your vQmod is installed and you are ready to install a vQmod based extension.

STEP 3 : Download the extension

STEP 4 : Extract the file and upload the content in your root directory.

STEP 5 : Go to your admin Extensions>Modules you will see the module in the list.

  • All vQmod based extensions will have vQmod folder. This folder will add new extension files within vQmod folder already present on the server. You have to simply dump the extension files on FTP.

STEP 6 :

  • Within admin go to Extensions.
  • You will find the extension listed. You will also find Install link. Click install link to install the module.

STEP 7 :

  • After installation, click on the edit link and set the setting for a module.

STEP 8 :

  • Go to frontend to see the module working.