Samuaijack

hey guys,
i am now working on a small asp.net website where clients come and enter their comment and it is inserted to a database then at the end of the day the manager or administrator sees all those comment but i am facing a problem,it's not in the syntax,here is the error message:


i guess it's something in sqlserver but i don't have alot of experience in it.

DaWei

My guess (and it's only a guess) would be that your application hasn't been accorded the requisite access permissions.

__________________
Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code.
Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

Infinite Recursion

Yep. Maybe you need to grant SELECT permissions to dbo for the StudentControl object on the Northwind database.

__________________
http://jasonpowers.net

"There are a thousand hacking at the branches of evil to one who is striking at the root."

Iftikhar

Hi,

First read this file of configuring SQl and then perform following steps. This error is configuration error.

http://web.lemoyne.edu/courseinforma...SDE_ReadMe.doc

1. CONFIGURING THE PATH VARIABLE for
C:\Program Files\Microsoft SQL Server\80\Tools\Binn

2. CONFIGURING THE ASPNET USER ACCOUNT - at the command prompt do this

osql -E -S (local)\NetSDK -Q "sp_grantlogin 'MACHINENAME\ASPNET'"

3. CONFIGURING INDIVIDUAL DATABASES - at the command prompt do this

osql -E -S (local)\NetSDK -d Northwind -Q "sp_grantdbaccess 'MACHINENAME\ASPNET'"

osql -E -S (local)\NetSDK -d Northwind -Q "sp_addrolemember 'db_owner', 'MACHINENAME\ASPNET'"

Note: Replace the 'MACHINENAME' with the name of your server.

Reference: http://p2p.wrox.com/topic.asp?TOPIC_ID=7584

__________________
Iftikhar Ahmed Khan
For doing an experiment on programmer's mood please visit http://uxisfyp1.brunel.ac.uk/cspgiak

Samuaijack

ya that did it iftikhar,thnx
and thnx IR and DaWei too for trying to help.