accessing sql server (OT?)

[Mark]

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?

 

[Joyjit Mukherjee]

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

 

[Patrick Olurotimi Ige]

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

 

[Eliyahu Goldin]

If you connect with SQL Server authentication you don't need any special
rights for asp.net.

Eliyahu

 

[Patrick Olurotimi Ige]

By the way Mark..
Have u solved the connection problem?
Patrick

 

[Mark]

Not yet, getting to it now........