Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
niting85
Starting Member
3 Posts |
 Posted - 2009-07-19 : 05:20:23
|
| Hello 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. |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-07-20 : 16:55:15
|
| you probably arent closing the connection in your .net code.If you are using c# you should add this to the end of your codecon.Open();.....con.Close(); |
 |
|
|
|
|
|
Multiple connections to SQL Server?