Having said that, I still don't understand why, without the browser service, I could connect to "localhost\SQLEXPRESS" and not "127.0.0.1\SQLEXPRESS"... :blush:

OOPsss :crying:

What I did not understand was why did I need the browser service since i was using port 1433 but I suppose the answer is that it is a...

OMG!!!

I started the SQL Server Browser Service and can now connect to 127.0.0.1...

I can even access my server from another machine! 😀

Could someone try to explain this to me?

What exactly...

I have attached two images.

The second one being the bottom half when scrolling down.

I just tried on my prod server but I can't even logon to my SQL server from the server itself if I only enable TCP-IP.

What could I get wrong?

I "may"...

We already use TFS for our developments but it's another story to make end users use TFS...

It might be "phase 2"...

The exciting bit wins I think 😉

From what I have read so far, it seems to tick all the boxes...

It seems both exciting (capabilities) and disappointing (too easy!)

That was a quick answer!

Thanks, I'll have a look.

I also just came across Filetables which might help...

Perry,

This fixed the problem on my test machine.

I did not have to create an outbound rule on the client windows firewall, though.

However, there are so many rules that there might...

Ah..... :unsure:

I only set it for a specific IP address.

Do I leave the other entries as...

I was indeed using 2012 and your suggestion did the trick

Thanks for teaching me something very interesting 🙂

I like the idea behind this article but I get an error when I try to setup the extended event...

"Msg 25706, Level 16, State 8, Line 1

The event attribute or...

Phil,

Sorry for the delay in replying but I got burried under "emergencies".

If that interests anyone, here is a way to reproduce my problem and the solution brought by Phil.

With this...

I have not installed it myself on my current machine.

I'll have a look onto a machine I installed myself...

Thanks