Browse by Tags

• 2003
• access
• database
• enterprise manager
• error
• file search
• full-text
• indexes
• management
• Microsoft
• named pipes
• performance
• remote
• security
• services
• SQL Server
• SSMS
• tcp
• windows
• xp

• An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes ....)

  Error: An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes Provider,error:40-Could Read More... Posted Thursday, July 26, 2007 10:49 PM from SSQA.net | (Comments Off) Filed under: security, SQL Server, performance, SSMS, tcp, sql express, error, access, named pipes, remote, management

• Full Text Search is installed, but not enabled to see at table-level

  It was long time ago I have used FULL-TEXT within our environment, recently I have been given a task to manage a full text SQL instance. Well to refresh my tasks I have installed Full Text Search component on Windows 2003 Server for SQL server 2000 instance. Read More... Posted Thursday, July 26, 2007 7:38 PM from SSQA.net | (Comments Off) Filed under: SQL Server, SSMS, sql express, database, enterprise manager, full-text

• "Allow Indexing Service to index this disk for fast file searching"

  I believe since Windows 2000 server days you can take advantage of Indexing Service that creates indexes of the contents and properties of all files on local and network drives in order to increase file searching speed. It's quite similar to "Find Fast" Read More... Posted Wednesday, July 25, 2007 6:03 PM from SSQA.net | (Comments Off) Filed under: SQL Server, Microsoft, indexes, sql express, windows, services, xp, file search, 2003