I am in a situation where i need to create multiple connections to same SQL server database from different applications.
Example: I have a ASP.NET website hosted on a m/c 1 which is using this SQL server database and their is another desktop application on another m/c 2 on network and is trying to access the same SQL server database remotely.
Now what happens is whenever a client is browsing the website and i try to access the same database from m/c 2 from a different application, I get Login Failed exception.
When i checked the memory usage on taskmanager, i cld see that aspnet_wp allocates some memory whenever the website is open and even after closing the website[i.e. closing the browser window], it doesnot de-allocates the memory.
Please help me with your suggestions.