sigs66
asked on
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
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
brejk
Try to enable Named Pipes and/or TCP/IP on the server. What's your client's protocols coniguration (use cliconfg.exe)?
ASKER
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....
Still no luck....
ASKER
I will try CLConfig.exe in a couple of hours.
Cheers & thanks
Cheers & thanks
ASKER
CLIConfig doesn;t come with SQL Express and there is no where obvious to download it from. Please help.
Instead of cliconfg use SQL Server Connection Manager. You can find client protocols there. Enable TCP/IP on the client's side.
ASKER
it is enabled already
ASKER
BMP
configMgr.bmp
configMgr.bmp
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
f..k it was that simple )))))))) thanks )))))))) much appreciated ))))))
ASKER
thanks
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?