After asking this question, I realized that the real slowness comes from the SQL Server Engine, and I used tons of things and I still didn't succeed.
However, I created a
connection.udl on the desktop and I tried to connect to my local host through different providers and through different combinations of connection strings.
I realized that when I use
localhost instead of
. and use
Microsoft OLE DB Provider for SQL Server, the connection is almost instantaneous and really fast.
Now I want to be able to connect to SQL Server through SSMS using that provider. But I do not know how. Could you help me please.
How can I log in to SSMS, using the & # 39; Microsoft OLE DB Provider for SQL Server & # 39 ;?