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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Unable to connect Database - Login Failed

Author  Topic 

niting85
Starting Member

3 Posts

Posted - 2009-07-16 : 07:18:51
Hello ALL

i 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..
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -