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 [...]

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 [...]