Viewing 15 posts - 3,886 through 3,900 (of 6,105 total)
That error means a RECONFIGURE needs to be executed to "install" what configuration change you made. This shouldn't be related to changing the audit settings, because that's kept in a...
November 27, 2003 at 5:53 am
Did anyone remove the guest user or change its permissions in any way for this database?
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
November 27, 2003 at 5:48 am
The uesr account you're using to log in to the server with... someone needs to change the default database What probably has happened is you were pointed at a database...
November 26, 2003 at 1:57 pm
GSEC stands for GIAC Security Essentials Certification and it's a vendor-independent security certification. GIAC stands for Global Information Assurance Certification and there are several tracks. GSEC is the generic security...
November 23, 2003 at 2:32 pm
Two other ways...
xp_cmdshell using echo >> (the double greater than sign appends). For instance:
xp_cmdshell 'echo Write to a text file >> c:\temp\test.txt'
Second, is using Jet and a linked server connection....
November 21, 2003 at 3:01 pm
Did your network folks block UDP/1434 per chance?
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
November 21, 2003 at 2:40 pm
Agreed on this one... when I dealt with vendors in the Air Force we documented everything for this very reason. I mean everything... you would be surprised at how often...
November 21, 2003 at 2:36 pm
Problem with OpenHack 4 is it is an unsupported config, so far as Microsoft is concerned. The list from SQL Security is probably the best bet. OpenHack 4's config breaks...
November 21, 2003 at 2:19 pm
Whenever possible, it is considered a best practice to use Windows authentication. The reasons are pretty simple: the SQL Server password doesn't go across the network in plaintext and you...
November 21, 2003 at 2:18 pm
Are you failing on a particular query or is it for all queries?
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
November 21, 2003 at 2:12 pm
Are you having to use SQL Server logins? If not, use Windows groups. The security can then manage permissions by managing the Windows group. Saves a bunch of cleanup for...
November 21, 2003 at 2:09 pm
Don't forget to restart the SQL Server service after you make the logon auditing change.
As for passwords... you'll have to build some sort of auditing methodolgy around traces or the...
November 21, 2003 at 2:05 pm
Given the NDA in place on Yukon, you're probably going to want to ask this question in the Beta Newsgroups for Microsoft. The information on how to connect to the...
November 21, 2003 at 2:00 pm
Agreed. If you follow the Principle of Least Privilege, only the appropriate DBAs would have sysadmin rights. This would also involve removing the BUILTIN\Administrators group (once the appropriate DBA group...
November 13, 2003 at 1:38 pm
Heh. That's funny. Great Plains is now owned by Microsoft. Let's hope they get it fixed. They fixed BizTalk Server so it can use Windows authentication, so I don't see...
November 13, 2003 at 12:06 pm
Viewing 15 posts - 3,886 through 3,900 (of 6,105 total)