Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Pooh99
Starting Member
14 Posts |
 Posted - 2010-03-12 : 09:14:18
|
| I am failly new to SQL DBA functionality. Can anyone help? I am getting this error at the point of clicking on 'Start Mirroring' on the Database Properties.The Mirror database has been restored with NO Recovery, so this isn;t the problem. The transaction log was also restored with no recovery . All ports are ok on both systems using 5022 and TCP is enabled, checked with telnet for ports. Firewall on local machine has 5022 in exceptions under TCP/IPAny ideas would be much appreciated.markg |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-12 : 12:48:10
|
| can u connect remotely to it with SSMS? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-12 : 18:19:26
|
I think 1418 is always a connection error...could be wrong...but you're right, the error message would be quite helpful  |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jet1337
Starting Member
11 Posts |
Posted - 2010-03-16 : 03:05:49
|
| thanks for sharing tkizer |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cpender
Starting Member
11 Posts |
Posted - 2010-04-09 : 06:55:09
|
quote:
Originally posted by Pooh99
I have sorted it all thank you.It was just the services were not set for the domain login but set to local system account!Confusing error given though!markg
can someone explain in more detail how he fixed this?I am getting the same error as this no matter what I try. I have the principal and the Mirror on different subnets. There is no DOMAIN. I can ping each server from the other, in fact I can connect to both servers from the SQL Server Management Studio.When I try the following from the Mirror database it works:ALTER DATABASE UMACS set partner = N'TCP://EXFINAP01:5022'But when I try the following from the Principal Database I get the 1418 error:ALTER DATABASE UMACS set partner = N'TCP://EXFINAP02:5022'I have followed all the step by step guides on line, backing up DB and log and restoring with NORECOVERY etc. I have TCP and Named Pipes enabled and TCP port is 1433 etc.can anyone point me in the right direction? I think it may be something to do with permissions but I don't know how to confirm this.Thanks in advance. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Error 1418 SQL 2005 Mirroring