{"id":1105,"date":"2010-09-16T22:59:09","date_gmt":"2010-09-16T17:29:09","guid":{"rendered":"http:\/\/JitendraZaa.com\/blog\/?p=1105"},"modified":"2010-09-16T22:59:09","modified_gmt":"2010-09-16T17:29:09","slug":"install-sql-server-2005-in-windows-xp","status":"publish","type":"post","link":"https:\/\/www.jitendrazaa.com\/blog\/sql\/sqlserver\/install-sql-server-2005-in-windows-xp\/","title":{"rendered":"Install SQL Server 2005 in Windows XP"},"content":{"rendered":"

This article will describe that how to install the SQL server 2005 on Windows XP. Normally a wrong step in installation for beginners results in non working SQL Server instance on his windows XP. To install the SQL Server 2005 on Windows XP follow below steps:<\/p>\n

The firts screen will be the license agreement screen, accept the terms and proceed.<\/p>\n

\"SQL<\/a>
SQL Server 2005 Accept License<\/figcaption><\/figure>\n

The next screen will check the prerequisites for SQL Server 2005.<\/p>\n

\"SQL<\/a>
SQL Server 2005 Prerequisites<\/figcaption><\/figure>\n

<\/p>\n

After prerequisites, System configuration will be checked.<\/p>\n

\"SQL<\/a>
SQL Server 2005 System Configuration Check<\/figcaption><\/figure>\n

If everything goes fine, then license key, name and company will be asked. Provide the required information and click on next button.<\/p>\n

\"SQL<\/a>
SQL Server 2005 Registration Screen<\/figcaption><\/figure>\n

Then select SQL Server Database Services <\/strong>and Workstation components, Books Online and\u00a0development tools to install.<\/span> <\/strong><\/p>\n

\"SQL<\/a>
SQL Server 2005 Components to Install<\/figcaption><\/figure>\n

In Instance Name screen, provide any instance name, <\/strong>here PORTFOLIOCENTER name is used.<\/p>\n

\"SQl<\/a>
SQl Server 2005 Named Instance<\/figcaption><\/figure>\n

then select use the built-in System account <\/strong>as shown in below screen.<\/p>\n

\"SQL<\/a>
SQL Server 2005 Service Account<\/figcaption><\/figure>\n

Select Windows Authentication mode <\/strong>in next screen.<\/p>\n

\"SQL<\/a>
SQL Server 2005 Authentication mode<\/figcaption><\/figure>\n

For collation Settings <\/strong>leave the next screen as it is.<\/p>\n

\"SQL<\/a>
SQL Server 2005 Collation Settings<\/figcaption><\/figure>\n

Error and usage report depends on your\u00a0interest.<\/p>\n

\"SQL<\/a>
SQL Server 2005 Error and Usage Report Settings<\/figcaption><\/figure>\n

click on next button.<\/p>\n

\"SQL<\/a>
SQL Server 2005 Ready to Install Screen<\/figcaption><\/figure>\n

Setup Progress screen will come, depending on your CPU speed it may take 10 minutes to 30 minutes to install.<\/p>\n

\"SQL<\/a>
SQL Server 2005 Setup Progress<\/figcaption><\/figure>\n

After installation, restart the windows and you have completed the setup.<\/p>\n

\"SQL<\/a>
SQL Server 2005 Completing SQL Server Setup Wizard Screen<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"

Steps to Install SQL Server 2005 – Standard edition in Windows XP<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"jz_research_post":"","_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[14],"tags":[292],"class_list":["post-1105","post","type-post","status-publish","format-standard","hentry","category-sqlserver","tag-sql-server"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":1121,"url":"https:\/\/www.jitendrazaa.com\/blog\/sql\/sqlserver\/create-new-user-in-sql-server-2005\/","url_meta":{"origin":1105,"position":0},"title":"Create new User in SQL Server 2005","author":"Jitendra","date":"September 18, 2010","format":false,"excerpt":"Create new User in SQL Server 2005","rel":"","context":"In "SQL Server"","block_context":{"text":"SQL Server","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/sql\/sqlserver\/"},"img":{"alt_text":"SQL Server Security folder","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/09\/SQL-Server-Security-folder.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":665,"url":"https:\/\/www.jitendrazaa.com\/blog\/sql\/execute-dynamic-query-in-sql-server\/","url_meta":{"origin":1105,"position":1},"title":"Execute dynamic Query in SQL Server","author":"Jitendra","date":"July 16, 2010","format":false,"excerpt":"How to execute the dynamic query in microsoft SQL Server 2005.","rel":"","context":"In "SQL"","block_context":{"text":"SQL","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/sql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1184,"url":"https:\/\/www.jitendrazaa.com\/blog\/sql\/sqlserver\/manually-attach-database-in-sql-server\/","url_meta":{"origin":1105,"position":2},"title":"Manually attach database in SQL Server","author":"Jitendra","date":"October 6, 2010","format":false,"excerpt":"Download sample database of SQL server and Manually attach database in SQL Server - AdventureWorksDB","rel":"","context":"In "SQL Server"","block_context":{"text":"SQL Server","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/sql\/sqlserver\/"},"img":{"alt_text":"Select Existing mdb file on system to attach","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/10\/Select-Existing-mdb-file-on-system-to-attach-300x258.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":504,"url":"https:\/\/www.jitendrazaa.com\/blog\/sql\/drop-function-if-exist-sql-server\/","url_meta":{"origin":1105,"position":3},"title":"Drop Function if exist – SQL Server","author":"Jitendra","date":"July 2, 2010","format":false,"excerpt":"Drop the user define function from database if it exists.","rel":"","context":"In "SQL"","block_context":{"text":"SQL","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/sql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":448,"url":"https:\/\/www.jitendrazaa.com\/blog\/sql\/search-for-table-in-sql-server\/","url_meta":{"origin":1105,"position":4},"title":"Search for Table in SQL Server","author":"Jitendra","date":"June 30, 2010","format":false,"excerpt":"In\u00a0organization, where huge number of tables present in database. its very hard to search the particular table. Here few SQL queries to search the table name by pattern. Search For Table whose name starts with A Clustered Index speeds up performance of the query ran on that table. Clustered Index\u2026","rel":"","context":"In "SQL"","block_context":{"text":"SQL","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/sql\/"},"img":{"alt_text":"List of Non clustered Tables in SQL Server 2005","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/06\/Non-clustered-Tables.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1359,"url":"https:\/\/www.jitendrazaa.com\/blog\/sql\/sqlserverintegrationservices\/etl-dts-and-ssis-introduction\/","url_meta":{"origin":1105,"position":5},"title":"ETL , DTS and SSIS Introduction","author":"Jitendra","date":"December 4, 2010","format":false,"excerpt":"Introduction to ETL Services, Data transformation services, SQL Server Integration Services, Advantages of SSIS over DTS, New features of SSIS 2008","rel":"","context":"In "SSIS"","block_context":{"text":"SSIS","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/sql\/sqlserverintegrationservices\/"},"img":{"alt_text":"What is ETL Extraction Transformation Loading","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/12\/What-is-ETL-Extraction-Transformation-Loading.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/1105","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/comments?post=1105"}],"version-history":[{"count":0,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/1105\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/media?parent=1105"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/categories?post=1105"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/tags?post=1105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}