quote:

---

We want to use windows authentication for the application trusted id, but are unable to connect to SQL Server when the trusted...

Compare the number of physical processors in the server versus the number the OS sees. If the number is the same, no hyperthreading. If the number is 2x, hyperthreading.

K. Brian...

What happens when you run the same update query from Query Analyzer?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

quote:

---

Sometimes I spent my lunch break with the girls from the HR department (only because they sit next to us!).

They told...

Yes, the restart is required.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

If the active node is dropping are there any errors in the logs?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

If he used a SQL Server login, then unfortunately you'll not be able to verify if he logged in or not. If he used Windows authentication and logging is on...

Using Microsoft Query with Excel, you can tie a query to a spreadsheet, and this gets around having to use ADO. Is this not an option?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start...

Other than Profiler, is your SQL Server configured to audit successful logins? If so, the info is in the application log of the server of who logged on to the...

One of the foremost authors in this field is Ralph Kimball. You can also find more info at his site, including some articles:

http://www.rkimball.com/

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide...

Do a profiler trace and try to to access the web pages in question through the web app. Make sure you add Audit Login Failure to the events you're trapping...

quote:

---

I'm looking forward to playing with the 'Validate SP's and UDF's with checksum' over the next couple of weeks and I was...

quote:

---

There's no such word as "virii". It's "viruses".

---

In scientific and medical arenas, virii tend to...

Thanks, mmortensen, this is a feature WinXP has Win2K doesn't. Guess it's time to see about upgrading the home systems. I'm also going to have to...

I'll have to see. As it is I owe you guys an a security article. But the kiddos are with the grandparents. Perhaps!

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author:...