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-16 : 07:18:51
|
Hello ALLi have a scenario, where i am hosting a ASP.NET website which is using SQL 2005 DB, additionally i have made a .udl link file which is linking the same DB.Now, Website is open on localhost and accessing Database contents and if subsequently we try to test connection using my .udl link file it shows one of the 2 errors below: 1. Login Failed......... 2. Test Connection failed because of an error in initializing provider. Unable to open the physical file "...." .OS error 32(process cannot access the file as it is being used by another process.)Please help me resolve this problem. |
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-07-16 : 07:28:21
|
Sql Server is unable to access the database files at startup....could you pls once again check the permissions and provide modify privilege to the folder containing database files to the startup account.....also ensure that antivirus is not accessing these files -------------------------R.. |
 |
|
niting85
Starting Member
3 Posts |
Posted - 2009-07-16 : 22:23:25
|
i have already given the permission to startup account as well as ASPnet account but i will chk on with the antivirus stuff may be that can be a possibility. |
 |
|
|
|
|