bobrikalexin
New Member
I just got visualstudio.net and am all excited, so i put together my first project. After building and running it i got an error message that says " login failed JAGAI/ASPNET " and it refered to the line of code where SQL tried to access the database. I am running Win/2000, my computer name is JAGAI and I understand that SQL is using the user account name ASPNET, but why cant it login? Please help i am new and confused.Hi Derek , <BR>do you have a query analyser or any kind of SQL client . try to connect to the same server , same database with the same name and password as your page does , this is the first step.<BR>if you can't connect then your using then wrong user & password<BR>If you haven't already, you need to go into SQL server and then into Security and grant the user ASPNET access to the database in question. <BR><BR>Hth, <BR><BR>])ryThanks for the reply. I think this is the problem. Yet i am so new to SQL outside of the language that i am asking you to please tell me exactly how to set this permission for the ASPNET user. Thank you very muchThank you for your reply. I think Dry Water is giving me the solutionGreat thanks and appreciation goes to you and your technical expertise in this issue. Soon i will read up on SQL server so i may not burden the .NET community with silly questions, but as for now you rock.Ok no problem Derek. <BR><BR>1. Open up SQL server<BR>2. Click on the database you want to use. There should be a directory called Security <BR>3. Open Security and there will be an item called Logins<BR>4. Double click Logins and then right click on the logins area and choose "New Login..."<BR>5. This will result in the login properties screen. At this point there will be several fields on the general tab. Click the little browse button next to the Name field and find the ASPNET user. <BR>6. Once you've done this, check the grant access button, choose the default database and click ok. This assumes a DSNless connection using Windows authentication, if you need a SQL login you can do it here as well. <BR><BR>That should be all you need. <BR><BR>])ry