I install sqlexpress 2005 on remote machine and I can connect to that with machinename\sqlexpress locally . but i cant connect to that engine remotely.
I did below action but problem still exist :
1- turn off firewall on both side
2- enable tcpip protocol and set tcp port(IPALL) to 1433 and disable 'Listen All'(because if tcp is enabled and 'Listen All' is enabled at the same time, sqlengine is going to stop and I have to disable Listen All in order to start engine )
3- server allow for remote connection box is checked 4- sqlbrowser is started
5- I use mix mode athentication
and also when i try to connect to engine I see packets in Wireshark with dst port=1434 that belong to sqlbrowser service.
at the end I cant connect to sqlengine locally with this servername : 127.0.0.1\SQLEXPRESS but machinename\sqlexpress or .\sqlexpress are OK thank you for your attention
Aucun commentaire:
Enregistrer un commentaire