Busca pela tag "sql server"

JDBC connection failed, error: TCP/IP connection to host failed

I want to connect Java class file with SQL server 2012. I have logged in with SQL server authentication. But i am receiving error in connectivity. ERROR: The TCP/IP connection to the host 127.0.0.1, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties.

MS SQL Server 2008 full text search problem

I have a J2EE application that was developed using JTDS on MS SQL SErver 2005 and it is deployed on JBoss. Recently a customer tried to use MS SQL Server 2008 and there are problems. When executing a full text search I get the following exception from the server.

How to enable remote connections in SQL Server 2008?

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

SQL Functions – ROW_NUMBER()

ROW_NUMBER() can be used to generate a sequential number for each row in the result set. Unlike RANK() and DENSE_RANK(), ROW_NUMBER() in case of ties it does not generate same number, it simply ignores the tie and generates sequential numbers for each of the tied rows.

Understanding SQL Server Full-Text Indexing

Microsoft SQL Server supports T-SQL, an implementation of ANSI standard SQL. T-SQL is designed to (among other things) search for matches in your data. For example, if you've created a table with a column named Notes you could construct these queries:

Understanding Full-Text Indexing in SQL Server

Full-text indexing in SQL Server has been quietly improving as Microsoft have worked on it over the last few years, making this a good time to look at what it offers. Who better to give us that look than Robert Sheldon, in the first of a series.

SQL Server 2012 – Introduction to pagination

Microsoft SQL Server distinguishes between paging and pagination. Paging refers to handling of memory bottlenecks whereas pagination, the focus of this article, refers to dividing T-SQL query result set into discrete parts.

Pesquisa de texto completo

O índice de texto completo inclui uma ou mais colunas baseadas em caractere da tabela. Essas colunas podem ter qualquer um dos seguintes tipos de dados: char, varchar, nchar, nvarchar, text, ntext, image, xml, varbinary ou varbinary(max).

Habilitando a conexão remota no SQL Server 2008

E ai pessoas, como tenho recebido alguns e-mails pedindo para mostrar “como fazer para que outros computadores acessem o meu banco de dados” e “habilitar o acesso remoto do SQL Server 2008”, então vamos à demonstração! Em seguida, habilitamos o Firewall do Windows (permitindo exceçõ

Enable remote connections for SQL Server Express 2012

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

Páginas