How to install sql server 2005?

-
Steps to install sql server 2005 can be found at:

http://articles.techrepublic.com.com/5100-10878_11-6102265.html

You need to install the following,
1. Windows installer
Note: No need of installing windows installer for server 2003 sp1,sp2
2. SQLEXPR.EXE
3. SQLServer2005_SSMSEE.msi

Download links
SQLEXPR.EXE
SQLServer2005_SSMSEE.msi

If you get client systems error 'doesn't allow remote connections' then
follow these steps,
start -> programmers -> microsoft sql server 2005 -> configuration tools ->
sql server surface area configuration

#1 enable sql browser services
#2 set the appropriate type for remote connections
#3 Stop and start modified services.

Happy Installation.

Comments

Post a Comment

Popular posts from this blog

SharePoint 2019 New Features

-
  SharePoint 2019 Majorly brought modern experience available in Online Communication sites: Communication sites are a place to share news, showcase a story, or broadcast a message to other people Create fast sites Fast site creation in SharePoint Server 2019 allows users create new sites in a few seconds ·        OneDrive personal site [SPSPERS#10] ·        Team site (modern only) [STS#3] ·        Communication site [SITEPAGEPUBLISHING#0] Modern Experience SharePoint Server 2019 contains the modern experiences for lists and libraries in Team sites. 1.      Lists and Libraries 2.      Modern WebPart 3.      Site Page 4.      Modern Search Experience 5.      Team Sites Integration with Power Apps, Power BI and Power Automate From the SharePoint home page, you can cre...
Read more

Comparing Windows Kerberos and NTLM Authentication Protocols

-
1. Kerberos is faster than NTLM: Pass through is not applicable to Kerberos. 2. In Kerberos authentication both client and server are authenticated mutually. In NTLM one client is validated, which allows intruders can get the client response.s 3. Kerberos is a open standard NTLM is  proprietary  to Microsoft. 4. Kerberos allows delegation, NTLM(double hop problem because of this) do not. 5. Kerberos supports Smart Card logon, NTLM do not. These are beautifully explained in below article. Ref: http://windowsitpro.com/security/comparing-windows-kerberos-and-ntlm-authentication-protocols
Read more

Move the list items from one list to another list using PowerShell - SharePoint 2010

-
Using below script one can move items from one list to another(including CreatedBy/ModifiedBy which are configured in a list(source,target,item age). #*************************************************************************** # Moves list/library items from one location to another location for archiving. Remove-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue Add-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue $srcListSiteUrl = http://testsite $ConfigListName = "ArchivalConfiguration" $IDFieldName = "OldItemID"  $date = Get-Date -format y $ldate = Get-Date $LogDate = $date -replace " ", "_" $path = "C:\Jobs\ArchivalLog\" If(!(test-path $path)) {     New-Item -ItemType Directory -Force -Path $path } $Logfile = "$($path)\$($LogDate).log" Add-content $Logfile -value "******************************************************************************" Add-cont...
Read more