Geekly Articles each Day
📜 ⬆️ ⬇️

Installing MSSQL Express with full-text search, connecting an existing database and working on TCP / IP

I remembered jumping with a tambourine around a computer, so I decided to trace the actions once and for all. And I always forget something ...

  1. Download SQL Server 2005 Express Edition with Advanced Services SP2 (I really already have an English version, without service packs, so I’ll focus on it)
  2. Installation:
    1. On the “Registration Information” page, uncheck “Hide advanced configuration options”
    2. On the “Feature Selection” page I need the following additional options:
      • Replication
      • Full-text search
      • Connectivity Components
      • Management Studio Express
    3. On the "Instance Name" page, select "Default instance"
    4. On the “Service Account” page, we also launch the “SQL Browser” service
    5. On the “Authentication Mode” page, select “Mixed mode” and set a password for the sa user.
  3. Setup:
    Start SQL Server 2005 Surface Area Configuration, point "Surface Area Configuration for Services and Connections" branch "MSSQLSERVER \ Database Engine \ Remote Connections" - Set "Local and remote connections \ Using TCP / IP only", restart the server.
  4. Import DB:
    • Run the command line
    • osql -S 127.0.0.1 -U sa -P 2.5
    • USE [master]
      GO
      CREATE DATABASE [] on
      ( filename = N' :\ \ \ \ \ \ .MDF' ),
      ( filename = N' :\ \ \ \ \ \ .LDF' )
      FOR ATTACH ;
      GO

    It turned out that I had a full-text search catalog. The process of repairing stretched from various sources, therefore at first glance it may seem like a messy jumble of tangle. This is probably not too far from the truth.
    exec sp_fulltext_catalog ' ', 'drop'
    exec sp_fulltext_database 'enable'
    CREATE FULLTEXT CATALOG AS DEFAULT;
    CREATE FULLTEXT INDEX ON ( ) KEY INDEX PK_ ;
    GO

    All this was carried out in one run, there is no desire to risk and try to understand the technique of the search. It’s not a little while :) However, I have earned a full-text search after these frauds properly.

    And it works.
    You can, for example, open a file in Notepad
    %windir%\system32\drivers\etc\hosts
    And add
    127.0.0.1 mysampledomain.net
    Then you can log in to your server as to mysampledomain.net

')

Source: https://habr.com/ru/post/9174/

More articles:


All Articles