Hello,
I have a computer running Windows XP. I have recently installed SQL Server 2000 and Visual Studio.Net. I started building a database enabled application. I can run and debug the app locally from my machine no problem. However, if I am in a remote location and try to access one of the aspx pages I get an error that I don't have permission to use a resourse used to serve this request.
I know that the permissions in the folder are all ok, because I can access a simple HTML page in the same directory as the aspx pages. So I'm pretty sure that the problem is with the user accounts on the DB. My SQLConnection object is set up using Windows Integrated security. Since both the DB and application are on the same machine I thought that would work.
Does anyone know what settings I need to have to be able to see the pages from outside? (If you feel this is a Visual Studio problem, please let me know and I can post it in there instead.)
Also, I changed a bunch of settings on SQL server and ended up messing myself up. Now when I select "Properties" when right-clicking on the SQL Server Group "(LOCAL)(Windows NT)" it says "Only members of the sysadmin role can access this feature". I know I used to be able to see what was in there but I guess I somehow locked myself out of it. Ooops.
Any help would be appreciated.
Thanks.
I have a computer running Windows XP. I have recently installed SQL Server 2000 and Visual Studio.Net. I started building a database enabled application. I can run and debug the app locally from my machine no problem. However, if I am in a remote location and try to access one of the aspx pages I get an error that I don't have permission to use a resourse used to serve this request.
I know that the permissions in the folder are all ok, because I can access a simple HTML page in the same directory as the aspx pages. So I'm pretty sure that the problem is with the user accounts on the DB. My SQLConnection object is set up using Windows Integrated security. Since both the DB and application are on the same machine I thought that would work.
Does anyone know what settings I need to have to be able to see the pages from outside? (If you feel this is a Visual Studio problem, please let me know and I can post it in there instead.)
Also, I changed a bunch of settings on SQL server and ended up messing myself up. Now when I select "Properties" when right-clicking on the SQL Server Group "(LOCAL)(Windows NT)" it says "Only members of the sysadmin role can access this feature". I know I used to be able to see what was in there but I guess I somehow locked myself out of it. Ooops.
Any help would be appreciated.
Thanks.
