August 11, 2010 at 10:55 am
I'm trying to set up mirroring on a test data base (for the first time). Netstat shows port 5022 listening on both servers:
Local Address Foreign Address State
TCP [::]:5022 [::]:0 LISTENING
I'll confess that I don't know if this is correct. Anyway, when I try to start mirroring I get the following:
The server network address "TCP://BHW-SPDW-1.domainname.com:5022" can not be reached or does not exist.
Windows firewall is off
Any help would be appreciated
August 11, 2010 at 12:00 pm
When I was setting DB Mirroring at my previous employer, I ran into the same problem. I had to grant CONNECT permissions to the service account running SQL Server to the Endpoint on each server involved in DB Mirroring.
August 11, 2010 at 2:21 pm
Lynn, where do you grant CONNECT permissions? I've been googling unsuccessfully for a while.
August 11, 2010 at 2:26 pm
I checked the sa account and it has connect permissions.
August 12, 2010 at 1:25 am
Here is a link for the step-by-step guide on How to Configure Database Mirroring?
Hope, this may help.
Thanks & Regards,
Sudeepta.
http://twitter.com/skganguly
August 12, 2010 at 1:14 pm
Execute ...
SELECT *
FROM sys.database_mirroring_endpoints;
Check to see if the state_desc is STARTED. If not then execute
ALTER ENDPOINT [EndPointName] STATE = STARTED
I haven't done Mirroring for a while, but you can refer to a small FAQ here, including links to some useful mirroring information sites. Also there are some scripts to help you setup Mirroring, however I have not had chance to test them on 2008.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 12, 2010 at 2:35 pm
I can start and stop the endpoints, but the connection still fails.
August 12, 2010 at 2:37 pm
I tried the code in the step by step guide but it didn't help. It looks like the endpoints are ok. The problem may be that I am using local accounts on the two servers.
August 12, 2010 at 2:46 pm
Start endpoints on both servers.
Go to first server, and open telnet connection to 2nd server using the endpoint port. If the connection establishes (aka the telnet window stays open); your computers can communicate.
Next what type of authentication type are you using?
Are these servers on a domain?
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 12, 2010 at 3:16 pm
Both endpoints show a state_desc = STARTED
Evidently I don't have telnet on the servers but I did try to telnet from my desktop (telnet 10.141.184.34 5022). I did not get a connect failure, but I didn't get a prompt either. If I hit enter a few times and the session returned to my server. If I change the port number to 5021 I do get the connect failure. I'm fairly confident that the ports are set up correctly.
I specify SQL authentication in the mirroring configuration wizard. Both servers have the same account (sa) and password
Both servers are on the same domain but I am not using domain accounts to configure mirroring.
August 12, 2010 at 3:25 pm
I never used SQL Authentication for Database Mirroring; how are you configuring that? Can you please show the SQL Statement you are executing?
Have you tried to create connection using IP instead of fully qualified named? For example:
ALTER DATABASE [DBName] SET PARTNER='TCP://10.141.184.34:5022'
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 12, 2010 at 3:29 pm
As I told you in another thread asking the same question, at a previous employer I had the grant CONNECT permissions to the service account running SQL Server to the Database Mirroring endpoint on each server. A little more detail.
I needed to create a login for the service account (domain\svcaccount). This account only needs public access.
Look up GRANT in BOL, I don't have access to that from my current employer.
August 12, 2010 at 3:35 pm
I am using the Wizard in MS SQL 2008 to create configure the security. I have the option of either Windows or SQL authentication. I chose SQL.
I tried
ALTER DATABASE [DBName] SET PARTNER='TCP://10.141.184.34:5022'
but I get the same error, unable to connect.
August 13, 2010 at 5:21 am
Thanks again.
August 13, 2010 at 5:37 am
You need to use certificates if you are using SQL Authentication, however, since you are in a domain environment, I suggest you to use Windows Authentication for database mirroring. I have already posted a link for a step-by-step guide earlier.
I have never configured Mirroring using certificates; however here is a link for a solution from Randall Neth; hope, this may help.
Thanks & Regards,
Sudeepta.
http://twitter.com/skganguly
Viewing 15 posts - 1 through 15 (of 28 total)
You must be logged in to reply to this topic. Login to reply