asked on

Login failed - LAPTOP\ASPNET

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

mb333

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

ASKER CERTIFIED SOLUTION

florencelee

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial