By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,919 Members | 1,625 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,919 IT Pros & Developers. It's quick & easy.

accessing sql server (OT?)

P: n/a
I have a SQL server on my small development lan, and also a webservere, both
running Win2kServer. When I try to accessss a sql db from an asp.net page, I
get an access denied error. (the slq server is a fresh os install, I lost my
old server, but the db's are backups). What access needs to be allowed for
an asp.net page to be able to open a connection to the sql server?
Nov 19 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Hi Mark,

Make sure the ASP .NET worker process has permissions to access SQL Server
or, create a user, give it access to your SQL Server, and run the worker
process under the contexts of this account.

Are you running MSDE. There are a number of MSDE configurations problem
reported in newsgroup, so see them.

Let me know if this works.

Thanks

Joyjit

"Mark" <py*******@hotmail.com> wrote in message
news:Og****************@TK2MSFTNGP11.phx.gbl...
I have a SQL server on my small development lan, and also a webservere, both running Win2kServer. When I try to accessss a sql db from an asp.net page, I get an access denied error. (the slq server is a fresh os install, I lost my old server, but the db's are backups). What access needs to be allowed for
an asp.net page to be able to open a connection to the sql server?

Nov 19 '05 #2

P: n/a
Mark i guess it must be a permission problem.
U neither don't have permission to the Database or u don't have ASPNET
acct..
Since u have .net framework installed you must have ASP.NET acct so make
sure it has access to ur SQL server.
Patrick

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 19 '05 #3

P: n/a
If you connect with SQL Server authentication you don't need any special
rights for asp.net.

Eliyahu

"Mark" <py*******@hotmail.com> wrote in message
news:Og****************@TK2MSFTNGP11.phx.gbl...
I have a SQL server on my small development lan, and also a webservere, both running Win2kServer. When I try to accessss a sql db from an asp.net page, I get an access denied error. (the slq server is a fresh os install, I lost my old server, but the db's are backups). What access needs to be allowed for
an asp.net page to be able to open a connection to the sql server?

Nov 19 '05 #4

P: n/a
By the way Mark..
Have u solved the connection problem?
Patrick

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 19 '05 #5

P: n/a
Not yet, getting to it now........
"Patrick Olurotimi Ige" <ig*@iprimus.com.au> wrote in message
news:uN****************@TK2MSFTNGP09.phx.gbl...
By the way Mark..
Have u solved the connection problem?
Patrick

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 19 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.