access to different SQL-Server

[Guest]

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?

 

[Guest]

Hi Erich,

I think I'm having the same kind of problem,
Ive written a Web interface on the messenger api so my customer can offer
anyone in there organisation chat functonality using a LCS backend.

Everything works fine but messenger clients from outside VM Ware can't
access the IIS Server that is running within the VM Ware .

When IIS initiates the connection.
Everything works fine.

So I suspect that VMWare is the one that's causing the bugs.

 

[Guest]

Hi Rainier !

It is definitely the VM-Ware which causes the problem.
I checked it with a different SQL Server instance on a W98 system with no
problems.
But how to solve this unpleasant behaviour?
I took a look at the VM-Ware support page but without any hint.

best regards

Erich