This is an old post folks sorry but this has been long solved I havent gottena chance to get back to you ...but thanks.

webdaddy13

Thanks Randy, It is simple. I will change it tonight.

webdaddy

I really dont know but the db was accessed directly

webdaddy

will try but I am almost sure it should work...UIf it doesnt do you have a suspision????

webdaddy13

Thanks everyone

I am not following you please send screens if possible or detailed info I am running SQL svr 2000 In the security screen I see only logins server roles and...

thanks ritterd where can I make this change in enterprise manager to recognize both I see a radio button that looks like it picks one or the other

webdaddy13

thanks sa24

you are on to something how do make the new admin whomever I choose the service account for SQL SVR? That is exactly my problem b/c even when...

thanks Jim not a domain a workgroup and a stand alone server but I setup all the admins to have permissions both on the iis machine and the SQL svr...

I have solved this issue for my win 2000/SQL SVR 7.0 installation. It is a permissions problem involving win 2K OS on that particular server.

"Event ID: 7000" or...

Jason you are so right!!!!

 I finally found out what my problem was and I hope this solution helps others. I had to go to my machines that have SQL SVR...

Hi Ramesh this is webdaddy13

How would I go about creating another account for SQL SVR. I actually went in and created a new user called SQLSVR gave it admins...

Thank you guys I will try both.

thank you guys this forum has really helped me...I will try it out you guys a great

I hope some day soon I can help you guys

webdaddy13

I appreciate the conversion statement but I really need to know how to autoatically populate that field date_entered without supplying the date from client side or server side programming