Problem to login

I'm using Sql server 2012 express within Win 7 machine.

Sorry, I get this
C:\Users\zcwm>telnet 1433
Connecting To 1433...Could not open connection to the host, on port 23: Connect
failed

you need to enable both shared memory, pipe and tcp/ip protocols.

Can I have more details to this?

Even after I've already enabled TCP/IP, and have put 1433 as TCP port (then have rebooted the machine), I now still get this

Cannot connect to PC326VM01\SSEXPR12.

------------------------------
ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

you need to enable both shared memory, pipe and tcp/ip protocols

Did you enabled all these protocols? Not only TCP/IP but all.

This looks like an authentication problem rather than a connection problem.  How do you connect AD or SQL login ?

@arnold

Perhaps.  I have never seen this message before.

But this does not surprise me either. This connectivity protocol resolution is always SQL Server culprit.

@HuaMinChen
You need to do some testing to confirm some information:

1>Please make sure the client does use TCIPIP only to connect.  Connect remotely using the IP followed by the IP address as follows (replace the example IP by the IP of the server)       235.36.36.376, 1433
2> Please answer the previous question.  Do you use an Activedirectory, Local admin or SQL Login to connect to the server  to authenticate ?

Waiting for answer to above questions to go further.  Hope this helps.

Thanks. Can you please advise, what to further adjust within the machine now? I did encounter the problem, while I tried to logon that using Management studio, within the same machine.

Under start, programs, you should have ms sql that includes a configuration tool. Under the server look at the enabled protocols to make sure all three are enabled.  The change requires the restart of the sql server instance.  Within the same interface, all three should be enabled under the client options.

Within ssms, double check the options prior to attempting the connection to see which option it is trying to use. Named pipes, shared memory, tcp/ip and which port

Etc.

I can see all the relevant protocols have been enabled below. why did I encounter the problem?
t898.png

Note the 1433 port is on ip2 supposedly on all interfaces, run netstat -an | find /I ":1433" and look at whether you have a LIstening line.


Note while active is set, enabled is set to no on IP 2.

@HuaMinChen

Have you tried doing what I suggested in my last post ?  Please connect only remotely using TCPIP after disabling the other protocols.  Can you do that?  From SSMS, enter the IP in management studio followed by the port number.  I gave you an example and I am waiting for the results.  Unless you do that I can hardly help you further.

@arnold
<<Within ssms, double check the options prior to attempting the connection to see which option it is trying to use. Named pipes, shared memory, tcp/ip and which port>>
The client is one thing but the server resolution of the client request is another thing.  I found the hard way the only reliable way to make sure Non-TPC IP protocols are not involved is to have them disabled on the server (with SQL Browser Service turned off) than troubleshoot from there.

Racimo,
I disabled these 2 protocols

Shared memory
Named pipes

and then tried to connect to it, from one other machine, using the IP and did get these

Cannot connect to 10.202.6.31,1433.

------------------------------
ADDITIONAL INFORMATION:

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: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)

Select allOpen in new window

I have all three enabled, make sure the firewall rules on the server allow the inbound traffic. Enabling/disabling protocols requires the restart if the service.

Another issue I've seen deal with an incorrect version of the CLI.

.......
Your error points to sql 2005, while the image reflects sql client version as 11 suggesting it is sql server 2012. In this case the sql client library is the issue for the mismatch.

OK.  So know you can be positive that TCPIP access is invisible from your client box and the previous error message was related to non TCP IP resolution.  Looking at your screenshot please make sure the IPAll TCP IP is enabled.  All your IP seem to be disabled.

Under IPAll please change the port from 1433 to some other value to confirm and select enabled under IPAll.  Try reconnect usin other port than 1433 (Ex:5022)

<<No connection could be made because the target machine actively refused it>>
Please temporarily disable your firewall if any and retry.  Thanks

As arnold mentionned, please restart your service with each modification

It can also be a SPN problem.
Can you run the following commands in DOS prompt and post here the results?

setspn -L PC326VM01\SSEXPR12

Select allOpen in new window

setspn -L MSSQLAccount

Select allOpen in new window

Substitute MSSQLAccount by the account that is being used to run the SQL Server service.

<<It can also be a SPN problem>>
True.  

But first, let's eliminating the server configuration and firewall issues.

I have also created the Inbound rule on TCP port 1433, but I still get the same problem. Here are what I get

C:\Program Files\Microsoft SQL Server\MSSQL11.SSEXPR12\MSSQL\DATA>setspn -L PC326VM01\SSEXPR12
FindDomainForAccount: Call to DsGetDcNameWithAccountW failed with return value 0
x0000054B
Could not find account SSEXPR12

C:\Program Files\Microsoft SQL Server\MSSQL11.SSEXPR12\MSSQL\DATA>setspn -L sa
FindDomainForAccount: Call to DsGetDcNameWithAccountW failed with return value 0
x0000054B
Could not find account sa

Select allOpen in new window

The SQL Server service account isn't sa for sure. Check in services which account it's being used for the service.
For the first SPN try to run with the server name only: setspn -L PC326VM01

So, what was the issue and how you solved it?

Please use a the service domain account for SPN registration.

<< how you solved it?>>
I am interested as well :)