G
Guest
Hi
I have 1 web service posting data to a SQL server 2000 database and a
separate ASP.NET web site reading data from the same database. Both use the
same SQL user and password to connect to SQL. The web service is windows
authenticated for a single user and has impersonate set to true. (It needs
this for security to a COM component).
When attempting to post data to SQL from the web service I get the following
error:
Cannot open database requested in login <DBName>. Login fails.
The ASP.NET web reports data off the database. It uses anonymous access and
connects with the same SQL user account. The web can access the data without
any problem.
The SQL user has been placed db_owner role of the database.
The NT account has the same name as the SQL account except with the domain
qualifier prepended. ie.
SQL - user1
NT - MYDOMAIN\user1
Does anyone know why the user credentials would consistantly fail on the web
service and consistantly work on the ASP.NET site. Both are hosted on the
same web server (Win2k3).
Thanks in advance
I have 1 web service posting data to a SQL server 2000 database and a
separate ASP.NET web site reading data from the same database. Both use the
same SQL user and password to connect to SQL. The web service is windows
authenticated for a single user and has impersonate set to true. (It needs
this for security to a COM component).
When attempting to post data to SQL from the web service I get the following
error:
Cannot open database requested in login <DBName>. Login fails.
The ASP.NET web reports data off the database. It uses anonymous access and
connects with the same SQL user account. The web can access the data without
any problem.
The SQL user has been placed db_owner role of the database.
The NT account has the same name as the SQL account except with the domain
qualifier prepended. ie.
SQL - user1
NT - MYDOMAIN\user1
Does anyone know why the user credentials would consistantly fail on the web
service and consistantly work on the ASP.NET site. Both are hosted on the
same web server (Win2k3).
Thanks in advance