update details using excel file in asp.net C# with sql server 2008

Question

0.00/5 (No votes)

See more:

I working on website. it have page 'UpdateRegisterNo.aspx'. in this page i need to update student registration number using excel file. in excel file contains admision nuber registration number. but it can't work in server. i got an error

The error is

User does not have permission to perform this action.
You do not have permission to run the RECONFIGURE statement.
The configuration option 'Ad Hoc Distributed Queries' does not exist, or it may be an advanced option.
You do not have permission to run the RECONFIGURE statement.

please help me

Posted 12-Sep-11 0:12am

ijaziju

Updated 12-Sep-11 2:06am

v3

Add a Solution

Comments

Prerak Patel 12-Sep-11 6:13am

Added code block for error.

Prerak Patel 12-Sep-11 6:16am

Share some relevant code.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sachin10d · Answer 1 · 2011-09-12T01:33:00

sqlserver user which is used in asp.net programming is not having the permission to execute the RECONFIGURE statement.

create a new user, login with the new user and use it in asp.net.

use the following snippet to create new user

SQL

use master;
go
drop login TestUser;
go
create login TestUser with password = '';

USE <yourdatabase>;
drop user TestUser;
create user TestUser for login TestUser with default_schema = dbo;
go
setuser 'TestUser'
go

exec sp_configure 'allow updates', 1
RECONFIGURE
go
setuser
</yourdatabase>