shepherdweb.com

Archive for the 'MS SQL' Category

Error While Installing Microsoft SQL Server 2005 on Windows XP

Tuesday, November 7th, 2006

I’m setting up a new PC with all the tools a Web Developer might need. While installing Microsoft SQL Server 2005, I encountered the following error during setup:
SQL Server Setup failed to obtain system account information for the ASPNET account. To proceed, reinstall the .NET Framework, and then run SQL Server Setup again.
This is [...]

How to Query Active Directory Using Enterprise Manager

Thursday, July 20th, 2006

Step 1
Open Security and find Linked Servers (Figure 1). This is where your linked server will show up after you add it.
Open Tools -> SQL Query Analyzer and paste in the following code:
exec sp_addlinkedserver ‘ADSI’, ‘Active Directory Services 2.5′, ‘ADsDSOObject’, ‘adsdatasource’
You should now be able to expand Linked Servers and see a server called [...]

Bad Behavior has blocked 679 access attempts in the last 7 days.