We help IT Professionals succeed at work.

Login failed - LAPTOP\ASPNET

Geo123
Geo123 asked
on
581 Views
Last Modified: 2007-12-19
Hi all

Am trying to put data onto a datagrid using the datagrid example from 4guys from rolla and my ASP Starter kit Timetracker database(MSSQL).

I have copied connection string from working Tietracker example and now am getting Login failure for user LAPTOP\ASPNET..... I was connection string was using sa to get data.

Anyone any ideas? Am sure I had this problem when I first installed TimeTracker......like to know what underlying problem is

cheers

George
Comment
Watch Question

Commented:
It look like local ASPNET account don't have grant access for that database.

You can grant access to the local ASPNET account for that database using SQL
2000 Entreprise Manager or you can use that solution:

1) make sure the first line is the good path (the exact location of the file "osql.exe")
2) replace NetSDK by the name of your instance (if you are not sure, click
on your SQL server icon in the bottom right in your taskbar to find your SQL instance,
you will see something like => server: LAPTOP\YOURINSTANCE)
3) replace "DATABASE" by the name of your database
4) open notepad, cut and paste the code below (with the appropriate change)
and save it as whatever.bat
5) double-click on that whatever.bat


cd "C:\Program Files\Microsoft SQL Server\80\Tools\Binn"  
osql -E -S LAPTOP\NetSDK -Q "sp_grantlogin 'LAPTOP\ASPNET'"
osql -E -S LAPTOP\NetSDK -d DATABASE -Q "sp_grantdbaccess 'LAPTOP\ASPNET'"
osql -E -S LAPTOP\NetSDK -d DATABASE -Q "sp_addrolemember 'db_owner', 'LAPTOP\ASPNET'"
pause
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.