Use this invitation code: 1707212015293285
Use this invitation code: 1707212015293285
This page is not finished, for now it is only a bunch of notes.
How it started?
(meetup Andrew Gray)
Meetup group title: “FREE – LIFE CHANGING EVENTS & SEMINARS IN LONDON”
Title of the meetup: Learn how to make a min of $5k p/m passive income! Exclusive opp ENDS 11th 7pm!!
The meetup post contains only a link. The link get you to a registration form.
Place, revealed by email 1 day before.
Plaza River bank
forced to be there soon
5 emails with a stupid video (I’m exciting, pre-launh, like Facebook) before the event.
water (no beer, orange joice or something to eat)
yuhuuu, gimme five and big smile, and videos and photos all the time.
high volume music
Singer, horrible pop music, promotion of her album
A women was the speaker and then present Eric Ho.
It is like in the videos on youtube.
Good speaker, bla bla bla and trickes to get attention.
Bla bla bla. Some photos
At 24 years old he was financial independent.
Some images with cars (some out of the shop winmdow!)
Some in SPA or yatch (clearly not his, because he was not manouvering”).
A lot os self-videos, some embarassing for the stupidity.
He present Mister Wong. An idiot that has 20 million like for a video on youtube, So? How can this makew ME rich?
All the time generic questions to the crowd and “raise your and if/who”…
All the links in the email before the event are tracked with funnel.
– IDK: I don’t know
– Y: yes
– N: no
Which version is your SQL Server ?
– I don’t know
Are you using an IP in the conenction string?
Is the application that need to conenct on the same machine of SQL Server ?
Are you using a Trusted conenction?
Are you using “localhost” as server name?
Do you know which connection string are you using?
Are the TCP inbound/outboundport allowed for port 1433?
The Login user in SQL Server is allowed to connect and login?
+ A001: use “(local)” instead of “localhost”
+ A002: check this: https://support.microsoft.com/en-us/help/328306/potential-causes-of-the-sql-server-does-not-exist-or-access-denied-err
+ A003: use “(local)” or instead of the IP address
+ A004: check this settings in Server/Security/Logins/User/(right click)/Properties/(Status section)
Restore SQL Server database X.
Try to conenct using the usual connection string. Conenction fail.
Delete the user in “Security” of SQL Server.
Delete the user from the “Users” of the database.
Create a new user in Server/Securit6y/Logins:
– User name: seelct a user that exists in the machine, ex.: \user
– leave everything unchaged
Create a user in the database in database/Security/Users:
– Login namne: seelct <achine\
– User name: select \
< Do you use an IP address in the connection string?
in the database:
– User name: select / using hhe selector
– Login name:
– Default schema:
Check the user defined in the Application Pool of the current web site
Scenario: integration tests against ASP.Net MVC API.
MVC version 5.2
Create a base class test to manage the repetitive API GET/POST calls like:
protected HttpResponseMessage Execute(HttpMethod method, string url, T data)
url = BASE_URL + url;
HttpRequestMessage request = new HttpRequestMessage(method, url);
JsonMediaTypeFormatter formatter = new JsonMediaTypeFormatter();
formatter.SerializerSettings.ContractResolver = new CamelCasePropertyNamesContractResolver();
if (method == HttpMethod.Post && data != null)
request.Content = new ObjectContent(data, formatter);
using (var server = new HttpServer(GetConfiguration()))
using (var client = new HttpClient(server))
var response = client.SendAsync(request).Result;
500. Internal server Error.
The server is set like this:
private HttpConfiguration GetConfiguration()
HttpConfiguration configuration = new HttpConfiguration();
//var dependencyResolver = new WindsorDependencyResolver(container);
//configuration.DependencyResolver = dependencyResolver;
// remove all HostAuthenticationFilter due to the error “no OWIN Authentication manager…”
foreach (var filter in configuration.Filters.Where(f => f.Instance is HostAuthenticationFilter).ToList())
mmhh… try to debug:
It enter in the ApiController, get the data from the REpository and it exit from the class with a nice colelction of data… what is wrong ???
Routing is ok, it is actually passing the request to the right controller.
Injection of repositories is ok, it is fetching and returning data.
Log4Net is ok, I’m not calling the “log4net.Config.XmlConfigurator.Configure();” without a proper configuration in app.config.
Adding “configuration.IncludeErrorDetailPolicy = IncludeErrorDetailPolicy.Always;”
is absolutely useless for this problem.
What to do now?
I’ll check one of 2 or 3 previous project where I’ve already done this a where I spent 1,2 or 7 days to figure out this ALL THE TIMES fucking problem !