Login Failed for user (null)

C

Calvin I

Hi All,

I am having a problem getting access to a SQL server on windows 2003. My
web server is running on a windows 2003 platform. I continually get the
Login failed for user null. Not associated...blah blah message each time.
There is no ASPNET user on the SQL server because I have removed IIS. I
cannot access the \\webserver\aspnet user from the enterprise admin to grant
them access to the database. I have disabled anonymous access on the
website - could this be the problem?

This is very frustrating...
 
S

Steven Campbell

Calvin said:
Hi All,

I am having a problem getting access to a SQL server on windows 2003. My
web server is running on a windows 2003 platform. I continually get the
Login failed for user null. Not associated...blah blah message each time.
There is no ASPNET user on the SQL server because I have removed IIS. I
cannot access the \\webserver\aspnet user from the enterprise admin to grant
them access to the database. I have disabled anonymous access on the
website - could this be the problem?

This is very frustrating...
You could turn on "simple security" or whatever its called (the opposite
of trusted security) on your SQL server box, to allow you to explicitly
specify a username and password.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,482
Members
44,901
Latest member
Noble71S45

Latest Threads

Top