Hello.
I'm using Visual Web Developer, .NET Framework 2.0, ASP.NET 20., IIS 5.1. on Windows XP Pro SP2.
I have assigned every possible user i can think of full permissions to the web folder, all of the subfolders, and the database files. This includes Administrator, Administrator Groups, ASPNET user, IUSR_Machine, Interner guest account, Network Group, Network Service Group, Power Users Group, Users.
I'm logged on as administrator.
When i run the web service from within VWD, i get this error.
Cannot open database "eBayTrader" requested by the login. The login failed.
Login failed for user 'DHJC2R91\ASPNET'.
Does anybody know how to resolve this problem
I have been working on it for days. I will gladly pay someone to work this out with me over the phone/email. I'll send you a check before we start.
Thanks,
Tony
Cannot open database "eBayTrader" requested by the login. The login failed.
Roachy
Hello Jens.
Thanks for your help.
I have no idea of how to do any of this. I tried to do it thru SQL Server Managment Express and it did not work.
I'm not sre of where to give access to a database.
What is "BOL under statement CREATE LOGIN"
Thanks,
Tony
Quint
this error message has nothing to do with file permissions etc. thats just apure SQL Server error stating that the Service Accoutn you are using for the WebServer is not priviledged to gain access to the database. You can give him the appropiate acces with either using SQL Server Managment Express or using (as already said) the appropiate SQL statement on the commandlines. If you don’t know how, just have a look in the BOL under statement CREATE LOGIN. If you have furhter problems, come back here.
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
Quantum_x
Hi T,
actually I just saw your post. Sometimes I don’t get time to monitor all my post in the different groups, therefore if you have any problems, I posted my mail adress in here that everybody can contact me if they want to (either this or my website). (BTW: Its now 1:30 at night as I found some time to keep up the posting)
Now to your question, here we go:
So here is an example to give the user SomeMachine\ASPNET access to the SQL Server:
CREATE LOGIN SomeMachine\ASPNET FROM Windows; --Creats the user at server level
Here are the actual queries:
CREATE USER WebUser FROM LOGIN [SomeMAchine\ASPNET]
GO
EXEC
sp_addrolemember N'db_datareader', N'WebUser'GO
Now the User should habe datareader access right, you can use furtherone the predefined roles (like db_datareader) or grant the actual specific permissions on your own to the user (Look for GRANT if you don’t know how to give him granular permissions)
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
Angelms
Jens.
I guess your offer of "If you have furhter problems, come back here" is not in affect
Thanks,
Tony
ofireps
Have you checked the database permissions on the actual database objects and systems, you can use the command line tools to do this or try the management studio express for a GUI Version.