SQL Server Management Studio Express not connecting

Hi All

I trying to connect to my SQL Server Manager Studio Express to my SQL Server and it isn't connecting. The error is attached. The server and the studio are both on the same PC. The SQL Service Manager says both the SQL service and the SQL browser are running. When I use SSEUtil.exe it connects and -l lists the databases.

SSMSE used to work and then stopped (no idea what I did) I tried uninstalled and re-installing it but no luck.

Any ideas? Thanks in advance
Cheers

Steve the SQL Novice

error.bmp
LVL 2
sigs66Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
brejkConnect With a Mentor Commented:
Try to connect to your instance using

tcp:YourServerIP,port

(i.e.: tcp:192.168.0.1,1433) instead of providing instance name. You can read port from TCP/IP options under Server Network Configuration.
0
 
brejkCommented:
Try to enable Named Pipes and/or TCP/IP on the server. What's your client's protocols coniguration (use cliconfg.exe)?
0
 
sigs66Author Commented:
in SQL Server Configuration Manager under Protocols fir SQLEXPRESS Shared memory, Named Pipes, & TCP/IP are enabled. Under the SQL Native Client / client protocols Shared Memory and Named Pipes are enabled.

Still no luck....
0
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
sigs66Author Commented:
I will try CLConfig.exe in a couple of hours.  

Cheers & thanks
0
 
sigs66Author Commented:
CLIConfig doesn;t come with SQL Express and there is no where obvious to download it from. Please help.
0
 
brejkCommented:
Instead of cliconfg use SQL Server Connection Manager. You can find client protocols there. Enable TCP/IP on the client's side.
0
 
sigs66Author Commented:
it is enabled already
0
 
sigs66Author Commented:
0
 
sigs66Author Commented:
f..k it was that simple )))))))) thanks )))))))) much appreciated ))))))
0
 
sigs66Author Commented:
thanks
0
 
devMckAPSCommented:
Where can I find SQL Server Connection manager? Is it supposed to be installed be default? I don't see it anywhere on the machine. Should SQL be reinstalled or something?
0
All Courses

From novice to tech pro — start learning today.