SQL Server 2012 Express connection error

connection database-connection windows-authentication sql-server-2012-express
Vipul picture Vipul · Jul 20, 2012 · Viewed 11.9k times · Source

I installed SQL Server 2012 but not able to connection to express instance getting below error:

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) (Microsoft SQL Server, Error: -1)

SQL Server is attempting to register a Service Principal Name (SPN) for the SQL Server service. Kerberos authentication will not be possible until a SPN is registered for the SQL Server service. This is an informational message. No user action is required. 2012-07-20 11:37:08.72 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/VIPUL-MEHTA.XXXX.com ] for the SQL Server service. Windows return code: 0x2098, state: 15. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.

Here is my SQL Server Configuration settings

Here is my SQL Server Configuration settings

enter image description here

In management studio I am providing below information to connect:

Server: .\MSSQLSERVER Authentication: Windows Authentication

In SQL Server 2012 how can I change the settings of Surface Area Configuration. I forgot the password for SA, so I cannot connect using SQL Server authentication.

Here is TCP IP Settings:

enter image description here

Answer

Maxim Yefremov picture Maxim Yefremov · Jul 26, 2012

Just open incoming port 1433 in the Windows firewall for TCP access:

http://blogs.technet.com/b/danstolts/archive/2011/06/08/how-to-open-firewall-port-1433-for-sql-server-database-engine-for-use-with-scom-or-anything-else.aspx

Related questions

postgresql "keepalives" parameter

According to https://www.postgresql.org/docs/current/static/libpq-connect.html there is parameter keepalives and further parameters keepalives_idle, keepalives_interval and keepalives_count which are relevant only if keepalives=1. But it is not clear to me what does …

Read More
java.net.SocketException: Connection reset

I am getting the following error trying to read from a socket. I'm doing a readInt() on that InputStream, and I am getting this error. Perusing the documentation this suggests that the client part of the connection closed the connection. …

Read More
Setting up connection string in ASP.NET to SQL SERVER

I'm trying to set up a connecting string in my web.config file (Visual Studio 2008/ASP.NET 3.5) to a local server (SQL server 2008). In my web.config, how and where do I place the connection string? Here's what web.config …

Read More