Thank you!
The issue was I was part of the administrator group on the server. I didn't
realize the window account mattered. I thought SQL security was only
controled thru SQL.
Re: SMS install ... As far as I remember you only need to add the site server machineaccount... >I am trying to install SMS and SQL on seperate servers in seperate domains. ... > account that is installing SMS. ... The account I use for SQL security has ... (microsoft.public.sms.setup)
Re: Brute Force ... This is exactly why Windows security is preferred over SQL security.... only thing you can really do about brute force attacks with SQL security is ... Or, if at all possible, switch to Windows security only and rely on Windows ... > What I mean by brute force is continually trying to connect to the server... (microsoft.public.sqlserver.security)
Re: Overall security of my MS based network ... > posts come through about SQL security,... The biggest step you can take to being secure is to always assume there is ... Treat every internal system as if ... it needs to be as secure as a server publicly available on the internet. ... (Focus-Microsoft)
Active Directory Group & SQL Server 2000 ... In the Active Directory we have created a specific group for users who have to using these servers. ... Please verify SQL Server is running and check your SQL Server registration properties and try again. ... I've replaced for test the AD group (in SQL Security) by the AD user of the user who couldn't connect to the server. ... (microsoft.public.sqlserver.security)
Linked Server Security Problem ... I moved a DB to another server in the same domain. ...app needs to connect both to new server and to a table ... could not get app to connect unless I used SQL security.... (microsoft.public.sqlserver.security)
