Connecting to sql-server from asp

[zuza]

Dear all,

untill now my asp pages was on the same server as sql-server, so I'm connected to sql-server with dsn and normally create (give) access to the iusr_machinename (default IIS user) in order to work the connection between asp and sql-server.
But, now I have asp pages on server Intranet and source on server called SQL-SErver, how do I make the connection ??

Thnx,
ZuZa.

 

[JohnCMolyneux]

Hi.

You make the connection in the same way you did, but you're probably better off using SQL authentication, rather than windows.

Here's an example ActiveConnection value...

Provider=sqloledb;Data Source=SQL-Server-IP-or-Name;Initial Catalog=YourDatabaseName;User Id=username;Password=password

The "Data Source", "Initial Catalog", "User Id" and "Password" should be altered to suit, but that's the only difference between local and hosted database connections.

If you need more help, just ask.

John.