ASP Config with SQL2000

[FrankP]

I am trying to configure ASP.net configure on my server. I can pull up the ASP.Net Admin tool and see the application Configuration but when I hit the security TAB I cannot connect to the SQL database the message is Unbale to connect to the SQL Server Database. When I test the AspNetSqlprovider. This gives a message of could not establish a connection to the database. If you have not yet created the SQL Server database exit the tool and use aspnet_regsql to create and configure.

 

I have run aspnet_reg sql and can see the aspnetdb in sql. I have ensured that the machine adminisrator can use the procedures and tables etc.

 

I have sever 2000 sp 4

SQL server 2000

ASP net v2

 

Can anybody suggest what I am missing or point me somewhere when I can read more about it.

 

Thanks

 

Frank