FBA - A network-related or instance-specific error occurred while establishing a connection to SQL

[npatel]

Hello,

I'm getting below error while trying to login for FBA site.

Error text:

Authentication With Server Failed : The user name or password is incorrect
Authentication With Server Failed : 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. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

------------------------------------------------------------------

- I'm passing correct username and password.

Architecture:

- Primary SF site (non-DMZ) for windows auth.

- Secondary SmartForm site (in DMZ) for FBA only - another IIS site.

How did I setup the site:

- Had setup the site referring K2 documentation

Am I missing sql conn string in any config file?

Thanks,

Nirav

[npatel · Accepted solution]

Solved the issue.

'A single comma/slash can give developer a hard time.'

There was an additional slash '' in host server config file for DB. Corrected it & now it's working.

I and my collegue have spent days for chasing this error. & in the end it's just a slash. 😕

My db server name is like "VT-XYZ-ABCK2DBServer". I had copy pasted like "VT-XYZ-ABC\K2DBServer".

I had checked several times, but since C# lang. syntax in mind, this was always overlooked.

Anyway, was able to identify the error & now FBA site is working.

//Nirav

[npatel]

Original text:

My db server name is like "VT-XYZ-ABC\K2DBServer". I had copy pasted like "VT-XYZ-ABC\\K2DBServer".

K2 Community site upgrade removed slash. I guess the same issue which I faced. 😉