Permission Problem

Windows 2000 server, service pack 4, RAID 5 array, 2Gb RAM, SQL server 2000.





.Net framework 1.1 installed and runs happily UNTIL you try to access anything to do with data.





I've got a c# page, imported all relevent namespaces etc. This runs fine on other servers and my XP Pro machine. However, when put on this server, all I get is





Exception Details: System.UnauthorizedAccessException: Access is denied.





I've tried explictly setting permissions on the file, directory etc, but nothing I've found can get the file to work, yet other c# pages which don't use SQL connections work fine !





The offending line:





Line 31: SqlCommand sqlCmd = new SqlCommand(sql,sqlCon);


Line 32: sqlCon.Open();


Line 33: SqlDataReader datareader = sqlCmd.ExecuteReader();


Line 34: while (datareader.Read()





is line 32.





STACK TRACE:








[UnauthorizedAccessException: Access is denied.]


System.EnterpriseServices.Platform.Initialize() +497


System.EnterpriseServices.ResourcePool..ctor(TransactionEndDelegate cb) +11


System.Data.SqlClient.ConnectionPool..ctor(DefaultPoolControl ctrl) +797


System.Data.SqlClient.PoolManager.FindOrCreatePool(DefaultPoolControl ctrl) +170


System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +356


System.Data.SqlClient.SqlConnection.Open() +384


ASP.test_aspx.Page_Load(Object sender, EventArgs e) in C:Inetpubwwwrootfishfood est.aspx:32


System.Web.UI.Control.OnLoad(EventArgs e) +67


System.Web.UI.Control.LoadRecursive() +35


System.Web.UI.Page.ProcessRequestMain() +731








I've copied this directory and set up another application on another server and it works fine!





Anyone got any ideas?