Cannot connect to SQL server from workstation - Microsoft SQL Server 2008 R2 (SP2)

limaechooscar

I face the following isuse on a Microsoft SQL Server 2008 R2 (SP2):

Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only.

My SQL server has mixed mode enabled (i verified and switch it on and off several times)
I am able to loging from a peer server which is a replica with the same windows accounts
I am unable to loging from a Windows workstation
The DSN configuration in Windows is succesful though

If mixed mode is enabled why would the server tell me it is not?

What could cause the server to believe it is Win authentication only although the setup is mixed mode?

limaechooscar

Wireshark did not help.

I traced back the changes on the server it appears that the main administrator user was renamed. A new sys admin user was created and I had to add this user in both Windows SQL Security groups.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-03-23

Comments

0 comments

After getting log backup from my database the VLF status remain 2 in sql server 2008 r2 SP2

Stored Procedure Parameter with FORMSOF and Thesaurus (SQL Server 2008 R2 SP2)

Microsoft SQL Server 2008 R2 removes carriage returns

Not able to connect sql server 2008 r2 with java

Create SQL Server 2008 Backup from 2008 R2

Cannot connect to SQL server from workstation - Microsoft SQL Server 2008 R2 (SP2)

Cannot connect to SQL server from workstation - Microsoft SQL Server 2008 R2 (SP2)

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

pump.io port in URL

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

How to import an asset in swift using Bundle.main.path() in a react-native native module

How to use HttpClient with ANY ssl cert, no matter how "bad" it is

Modbus Python Schneider PM5300

What is the exact difference between “ use_all_dns_ips” and "resolve_canonical_bootstrap_servers_only” in client.dns.lookup options?

Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

BigQuery - concatenate ignoring NULL

split column by delimiter and deleting expanded column

Unable to use switch toggle for dark mode in material-ui

Soundcloud API Authentication | NodeWebkit, redirect uri and local file system

Apache rewrite or susbstitute rule for bugzilla HTTP 301 redirect

Is there an option for a Simulink Scope to display the layout in single column?

UWP access denied

Center buttons and brand in Bootstrap

express js can't redirect user

Make a B+ Tree concurrent thread safe

Printing Int array and String array in one

Google Chrome Translate Page Does Not Work

Elasticsearch - How to match number range in string