June 26, 2013 at 12:44 am
Hi...
when i am configuring Mirroring i am getting tcp\ip port problem..
my 1st server dafault Instance[MSSQLSERVER] run under Local system service account..
2nd server named Inst[pcname\shiva] run under \.shiva service account..
1st server backup and 2nd server restore completed...
but wen i am configuring mirroring i got problem like tcp\ip port problem, database space prob..
what is the solution for ths prob??
thanks...
June 26, 2013 at 1:12 am
What's the exact error message is in the SQL error log?
June 26, 2013 at 1:13 am
we always use a windows domain account as service account for our sqlserver instances.
Are there firewalls involved ? If yes, did you open the needed ports ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 26, 2013 at 2:03 am
HI Andrew..
wen im configuring mirroring i got this error..
The server network address "TCP://MOSSSQL-B.mycompany.com:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error:1418)
what is the prob? how to solve?/
Thankyou
shiva
June 26, 2013 at 5:28 pm
You need to test network connectivity to the endpoint.
Follow the troubleshooting steps under Endpoints heading here: http://msdn.microsoft.com/en-us/library/ms189127%28v=sql.105%29.aspx
If that's all fine, then use Telnet (it's a Windows 2008 feature, so install from Server Manager/Features).
Open a cmd prompt and run:
telnet MOSSSQL-B.mycompany.com 5022
If a blank screen appears, all good, you have a connection on port 5022, if you get an error then you know there is a network connectivity issue / firewall / antivirus etc.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply