- For individual users
- Instant access to solutions
- Ask your tech questions
- Start your 30-day Free Trial
Main Topics
Browse All TopicsHi Experts,
I am setting database mirroring on SQL Server 2005 . I encountered the error :'The server network address "TCP://192.168.50.34:7022"
I have set database mirroring as belows:
--Principal server: nangdd-s02.ncs.com.vn
--Mirror server: ncs-e5ra7wreska.ncs.com.vn
1) Creat database AdventureWorks on principal server (nangdd-s02.ncs.com.vn)
2)Modify it to use the full recovery model:
USE master;
GO
ALTER DATABASE AdventureWorks
SET RECOVERY FULL;
GO
3)create a full backup of the principal database as follows:
BACKUP DATABASE AdventureWorks
TO DISK = 'C:\AdventureWorks.bak'
WITH FORMAT
GO
4)Copy the full backup to the mirror server (ncs-e5ra7wreska.ncs.com.v
RESTORE DATABASE AdventureWorks
FROM DISK = 'C:\AdventureWorks.bak'
WITH NORECOVERY
GO
5)create a log backup on the principal database.
BACKUP LOG AdventureWorks
TO DISK = 'C:\AdventureWorks_Log1.ba
GO
6)Copy the backup log file to the mirror server and restore log
RESTORE LOG AdventureWorks
FROM DISK = 'C:\AdventureWorks_Log1.ba
WITH FILE=1, NORECOVERY
GO
7)On the principal server instance create an endpoint that supports all roles using port 7022:
CREATE ENDPOINT Endpoint_Mirroring
STATE=STARTED
AS TCP (LISTENER_PORT=7022)
FOR DATABASE_MIRRORING (ROLE=ALL)
GO
8) On the principal server instance create Window Login to Pirror database from Principal server
USE master;
GO
CREATE LOGIN [BUILTIN\Administrators] FROM WINDOWS;
GO
GRANT CONNECT on ENDPOINT::Mirroring_Endpoi
GO
9)On the mirror server instance create an endpoint that supports all roles using port 7022:
CREATE ENDPOINT Endpoint_Mirroring
STATE=STARTED
AS TCP (LISTENER_PORT=7022)
FOR DATABASE_MIRRORING (ROLE=ALL)
GO
GRANT CONNECT on ENDPOINT::Endpoint_Mirrori
GO
10) On the mirror server create Window Login to Principal database from Mirror server
USE master;
GO
CREATE LOGIN [ncs\s02nangdd] FROM WINDOWS;
GO
GRANT CONNECT on ENDPOINT::Mirroring_Endpoi
GO
11) On the principal server instance, back up the database:
GO
BACKUP DATABASE AdventureWorks
TO DISK = 'C:\AdventureWorks_dbmirro
WITH FORMAT
GO
12)Copy backup file to the mirror server instance , restore the database:
RESTORE DATABASE AdventureWorks
FROM DISK = 'C:\AdventureWorks_dbmirro
WITH NORECOVERY
GO
13) Create a log backup on the principal database
BACKUP LOG AdventureWorks
TO DISK = 'C:\AdventureWorks_Log2.ba
GO
14)Copy log backup file to the mirror server instance and restore:
RESTORE LOG AdventureWorks
FROM DISK = 'C:\AdventureWorks_Log2.ba
WITH FILE=1, NORECOVERY
GO
15) On the mirror server instance, set the server instance on nangdd-s02.ncs.com.vn as the partner
ALTER DATABASE AdventureWorks
SET PARTNER =
'TCP://nangdd-s02.ncs.com.
GO
16)On the principal server instance, set the server instance on as the partner
ALTER DATABASE AdventureWorks
SET PARTNER = 'TCP://ncs-e5ra7wreska.ncs
GO
The first 15 steps well done!
But after step 16 I am receiving the following error:
'Msg 1418, Level 16, State 1, Line 1
The server network address "TCP://192.168.50.34:7022"
I have check network address, firewall, port availability but I still receive the same error
Anyone help me please!
Thanks,
NCS
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Business Accounts
Answer for Membership
by: rrjegan17Posted on 2009-11-04 at 02:16:26ID: 25737864
This should help you out with respect to the error encountered:
om/2007/04 /22/sql-se rver-fix-e rror- 1418- microsoft- sql-server -the-serve r-network- address-ca n-not- be-r eached-or- does-not-e xist-check -the-netwo rk-address -name- and- reissue-th e-command/
http://blog.sqlauthority.c