Need your help: SQL Authentication Setup

[Michelle_Laveri]

Hi,

I'm putting the final finishing touches to my SRM 4.0 book. And I'm having moment of doubt. I've documented setting up MS SQL2K5 with SQL Authentication for SRM, but I'm lacking confidence in the steps, because I'm not sure if they are 100% as a proper SQL admin would do them.

Does anyone here (or could anyone here) give me a step-by-step approach to the configuration that they have used in production - that meets corporate standards?

If I can't be 100% I'm doing it the right way, I don't want to take the risk of including instructions that might not be 100% up to the mark...

Regards

Mike Laverick

RTFM Education

http://www.rtfm-ed.co.uk

Author of the SRM Book:http://stores.lulu.com/rtfm

Free PDF or at-cost Hard Copy

[Poort443 · Accepted solution]

Hi Mike,

You've probably seen this document on VIOPS: http://communities.vmware.com/docs/DOC-11547 called "Install and Configure SQL Express 2005 for use with Site Recovery Manager V4". But in case you missed it, it's a great document, and what I've used to do this. As the title states it's aimed at SQL Express, but I doubt if it should be any different on the full SQL Server.

Regards,

-Poort

[Michelle_Laveri]

NOW. That is BRILLANT! Just what I was looking for - as non SQL admin I need step-by-step idiot proof instructions...

Great Find! 😄

Regards

Mike Laverick

RTFM Education

http://www.rtfm-ed.co.uk

Author of the SRM Book:http://stores.lulu.com/rtfm

Free PDF or at-cost Hard Copy

[Poort443]

Glad it's helpful. I'm looking forward to your book, I could use a good book on SRM. There isn't enough information on SRM available. I actually used your SRM 1.0 book to find out how to do the SQL databases

-Poort