I was wondering about the performance impact of using Windows Authentication to connect to a SQL server in a Winforms application versus using SQL Authentication. In our current model, everyone uses the same username and password in the connection string stored in the application. Everyone using the application is always on the same domain, either in the physical office, or connected through VPN. At any one time, about fifty people could be using the application.
I was told there could be problems with connection pooling since connections are separated into pools by connection string and Windows identity.