A couple more resources with step by steps:

http://wiki.cdyne.com/wiki/index.php?title=Mirroring_SQL_Server_2005

Servers not in a domain (workgroup model as an example)

http://alan328.com/SQL2005_Database_Mirroring_Tutorial.aspx

Can you telnet to the Fully Qualified Domain Name of the Mirror partner on...

jez.lisle (12/2/2009)

---

I have done that and this is what it said afterwards

Event Type:Error

Event Source:MSSQLSERVER

Event Category:(2)

Event ID:1474

Date:02/12/2009

Time:21:24:21

User:N/A

Computer:MyServerName

Description:

Database mirroring connection error 4 'An error occurred while receiving data: '10054(An existing connection was...

jez.lisle (12/2/2009)

---

They are internal VM machines no internet connections apart from internal ones, would that still need a firewall? if so then I'll check with my IT dept and find...

just came across this ad:

http://www.sqlservercentral.com/Forums/Topic716821-360-3.aspx

Last post in the thread

double post

answered the primary post at http://www.sqlservercentral.com/Forums/Topic827726-360-1.aspx

It looks like a key would be the wait type you are seeing.

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/e2ddf26f-f86c-4368-b4a7-17b2b7c64aa5/

You are experiencing SOS_SCHEDULER_YIELD waits. This is an indicator of cpu pressure and happens when a process...

I have run into this in the past as well (multiple instances on a server but not all produce this error). The SPN Fix described in that KB article...

First result from google shows:

download.microsoft.com/download/6/9/d/69d1fea7-5b42-437a-b3ba-a4ad13e34ef6/OracleSSIS.docx

A couple more questions:

Are you setting up via GUI? Or are you setting up via TSQL Script?

http://weblogs.sqlteam.com/tarad/archive/2007/02/13/60091.aspx

Do you have a firewall (windows or otherwise) between the two preventing communications on 5022 or 5023?

What version SQL server are both principal and mirror server?

When you ping the servers,...

Licensing information available on the system:

http://blogs.msdn.com/sqlblog/archive/2006/11/10/tracking-license-information-in-sql-2005.aspx

Since SQL 2005 does not automatically track licensing information anymore, your best bet to find licensing information is to contact your rep or find your...

RUN

http://www.freevbcode.com/ShowCode.asp?ID=5081

RBarryYoung (11/25/2009)

---

Jeff Moden (11/3/2009)

---

malli.chitturi (11/2/2009)

---

Its not about memorizing the Q&A. Its about SQL is easy to Learn but hard to master. So Its just helping what part of SQL they...

This is a much simpler task in some other medium than TSQL as Barry suggested. From within tsql, you would end up making calls to another medium to accomplish...