| Thanas 2006-10-24, 6:30 pm |
| Still having trouble. Not really sure why anymore. here is the error
message that I got. Of course I have "x" out my server information for
obvious reason :)...
The witness is a SQL Server Express. It is up to date as far as
updates goes.
Thanks for your help and patience everyone.
-Thanas
TITLE: Database Properties
------------------------------
An error occurred while starting mirroring.
------------------------------
ADDITIONAL INFORMATION:
Alter failed for Database 'xxxxSQLServerDev'.
(Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink? Pro...>
&LinkId=20476
------------------------------
An exception occurred while executing a Transact-SQL statement or
batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The ALTER DATABASE command could not be sent to the remote server
instance 'TCP://xxx.xxx.org:5022'. The database mirroring configuration
was not changed. Verify that the server is connected, and try again.
(Microsoft SQL Server, Error: 1456)
For help, click:
http://go.microsoft.com/fwlink? Pro...56&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
jamie@encompassgroup
.ca wrote:
> Read step 2 in the section "Troubleshooting" in the following document.
>
> http://www.microsoft.com/technet/pr...5/dbmirror.mspx
>
> If your services are running as LocalSystem, it will not work. Try
> changing to an account with the appropriate privileges. I changed to a
> domian account and my problem went away.
>
> Good Luck
>
> Jamie
|