Unable to connect to server SQL SERVER 2000 SQL Authentication

Navigation
0

I need to perform a Hardening validation for a SQL Server 2000 database migration to SQL server 2008, trying to connect through some client (Microsoft SQL Server Management Studio) to SQL Server 2000 or from LocalHost with (SQL Query Analyzer ) with SQL authentication throws the following message

"Unable to connect to server: XXX.XXX.XXX.XXX"

The login with which I try to connect already exists with sysadmin role in SQL Server 2000, This login was created by entering Windows authentication in the connection (localhost), I attached the Log in Image only contains the login information of SQL server is the last one I have previously doing login tests in Localhost

    
asked by Cristian Zauco 21.07.2017 в 16:48
source

1 answer

0

The problem was solved, the solution was to activate the dual authentication mode SQL Server and Windows, Previously I only had the Windows Mode

    
answered by 21.07.2017 / 20:41
source
c # in console, nested While, exit questions yes / no in sub-menus and limits Problem with image - database - IF