[Solved]: SQL mirroring error 1488, 1499

Dear All,

While configuring Mirroring on SQL server I was getting a message “Alter Database failed ….” Error no 1488

As below

SQLerror1488

So searched a lot on internet, but didn’t got success as all blogs were point that the database is in single user mode in reality it was wrong as my database was in multi_user mode

So I dug and got the solution, it  is very simple.

On Mirrored (secondary) server the database files were not having permissions for the user from which the SQL service was running and the same user I was using to configure mirroring too.

Steps followed

  • Stopped SQL service on Mirrored (secondary) server
  • Given full control to the user from which the SQL service is running
  • Started SQL service

On principal server now clicked on start mirroring and the mirroring is configured successfully

Thanks

Prashant Deshpande

Advertisements

Leave a comment

Filed under Uncategorized

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s