Re: SMS reinstall ... the SQL is running on the same ... >choose modify or reset the current installation.... From there make sure all SMS_Service accounts... >> We are having an issue with SMS 2.0. ... (microsoft.public.sms.setup)
RE: local admin account password ... Subject: local admin account password... > 4) Only use domain accounts so delete the local ones. ... > The DB file would be encrypted with EFS so only the limited user SQL... > backup user can make a zip backup of the DB whenever it gets changed ... (Focus-Microsoft)
RE: local admin account password ... Say you have more then 1000 systems, how do you handle the local admin... Only use domain accounts so delete the local ones. ... The DB file would be encrypted with EFS so only the limited user SQL... There would be basically two stored procs,... (Focus-Microsoft)
RE: "login failed for user ..." appears in event viewer repeatedly ... OK, did I hear you right, you've determined that the attacks are coming from ... holes to that segment and/or box to just the SQL ports.... I looked closer at the SQL accounts.... I used SQL profiler to audit logins and login failures. ... (microsoft.public.sqlserver.security)
Re: Server or Service Accounts complete lockdown? ...SQL Enterprise Manager?... I wonder if I need to somehow create accounts in each SQL DB to allow ... Heres the strange bit - I have full access but dev team are prompted to ... used by the web application for SQL database access.... (microsoft.public.security)
