Connecting to SQL Server from ASP

Hey guys..

Bit of a complicated situation here - let me try and explain as best I can..

We are not using Active directory and as such do not have access to Kerberos authentication methods. What I need to do is connect to an SQL (2000) database using ASP 3.0 - I have setup an account on SQL Server with read access to two tables (and no password). Just to complicate the issue even further, the IIS server and the SQL server reside on different machines on the network.

Can anyone give me some advice on connection strings that will work within this environment as i'm not having much luck at present.

Thankyou in advance

You'll need to create SQL logins on the database server with appropriate permissions.

To generate a connection string, the easiest way is:

• create a new text document
• rename it to conn.udl (so long as the extension is .udl it doesn't matter what you call it) You will need to switch "hide extensions for known filetypes" off if you haven't already (in explorer: tools > folder options > view)
• conn.udl's icon should have changed. If it hasn't, see above for showing the full extension. Double click on it.
• You now have a nice gui to play with - select an appropriate provider and fill in the other bits as needed. Test the connection. If you've done it right you should get a popup box saying test connection succeeded.
• Click OK
• Open up conn.udl in notepad or your favourite text editor. One connection string ready made...