Hey,

It was just proffered if it could be moved off to save on licensing and service desk having to install applications.. Instead link it to Sharepoint for authentication etc....

Well,

strangely and slightly more annoyingly.. I tried it again today and its worked....

Ill look into why as im not really happy with that. I know it was a...

Hi

yeah, thats what i thought, but the servers that are already in there. Are just servers, no AD accoutns run any services on them and theres no AD user...

Think ill make a few dummy projects to design databases to work from.

Thank you

Hi

thank you for the reply!

Keeps it simple! I had already writed out the objectives and starting to go though them pretty much as you had suggested (keeping links...

thanks to you both..

im bookmarked both you sites they look good 🙂

Hi,

Very nice article.

So am i right in saying this form of auditing only answers the "when" and not the "who", I saw session Id but unless your constantly...

maybe im looking wrong then.

If i look in security at instance level. It only shows the default users

If i look insecurity at db level. It shows all the users...

hey all,

thanks for the replies!

all the accounts are windows auth.

i admit i only do accounts via the GUI. So i have to add them to the instance to...

Hi Steve,

So i only used the config manger.

I think i got confused by the fact that I can put in a account with say a 22 char length...

Fixed:

Right.. so fixing it has come up with a few queries for me.

The fix and things to note:

1: Dont create service accounts with more than 20 chars...

Thanks guys!

yes i installed the SSMS tools!

Cheers

Hey all,

Thanks for the advice.. Sadly never had a server with that many disks to seperate windows from applications, But I try to put Logs and Data files on...

This is a good starting point

http://www.dbaroadmap.com/[/url]

Hey all

Thanks for all the replies..

I think your right for a starting point Eric. Ill do a restore onto my pc of some data and start seeing how its...