sql remote access - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

Other Topics

sql remote access

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-29 : 09:34:59

Ricardo writes "Hi,
I hope you can bring some light here.

I have an SQL Server and IIs 5.1 on IP 200.176.110.82. In that machine, when I run a page http://200.176.110.82/vml/achardados.asp, it’s work fine.

I want to have my pages in another server, for example, www.smachado.com.br/achardados_remoto.asp, and retrieve the data on the SQL server.

It’s not working, and even in the same machine, I try http://200.176.110.82/vml/achardados_remoto.asp, it doesn’t work any more.

Could you be o kind and help me to find a way to make this work? I already made the adjustments in msdfmap.ini file and others adjustments in IIS and SQL, b adjustments in IIS and SQL, but it is not working.

Is there some kind of tutorial or check list to make this working? Should be possible for you to give a working demo on how to make this work?

Thank you,

Ricardo Machado

Error are in IIS,
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

And in SQL
Error Type:
Microsoft ADO/RDS (0x800A20FF)
Internet Server Error.
/vml/achardados_remoto.asp, line 51"

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2002-03-29 : 18:04:34

Ricardo,

You might want to check your web server's web log for more details on that HTTP 500.100 error, but basically, from your question, it sounds like you're having connectivity problems. Why you would have problems connecting between IIS and SQL on the same machine is probably related to Login/Password issues. Between two servers, you need to make sure that you are connecting to the right IP Address, check for whether there are firewalls between the servers, in which case you'll need a conduit through the firewall.

A simple way of checking this is to create a UDL or ODBC on the web server, fill in all of the appropriate boxes, and then there will be a Test Connection button. You might find that installing the SQL Client Network Utility helps you in your configuration between servers.

------------------------
GENERAL-ly speaking...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources