access to different SQL-Server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Erich Brunthaller - 21 Oct 2005 17:58 GMT

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?

Reply to this Message

Rainier [MCT] - 21 Oct 2005 20:20 GMT

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.

Signature

Rainier van Slingerlandt
www.slingerlandt.com

Please hit the Yes button If my effort is helpfull.

> 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
[quoted text clipped - 12 lines]
>
> can anybody help?

Reply to this Message

Erich Brunthaller - 23 Oct 2005 08:50 GMT

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

> Hi Erich,
>
[quoted text clipped - 26 lines]
> >
> > can anybody help?

Reply to this Message

access to different SQL-Server

Free Magazines