I run the SQL-server on VM-Ware with mixed mode auth.
When I host the ASP service on IIS in VM-Ware access is possible from
everywhere. But hosting the service on the IIS outside VM-Ware can not access
the SQL-Server. The error is "SQL server does not exist, or access denied".
The problem can not be any firewall because EnterpriseManager sees the
Server and is dissabled. One possibility for solving this might be
Impersonation I guess. Adding <identity impersonate="true" userName="user"
password="pass"/> to web.config gives an error when compiling. Only <identity
impersonate="true" /> works but does not bring any effect.
btw. The systems are not in a domain and the conn.string is:
"Data Source=192.168.0.10,1433; Initial Catalog=pubs; user id = user;
password="
or
"Data Source=COMPUTER; Initial Catalog=pubs; user id = user; password="
can anybody help?