My sql server is on anther machine. I tried to use my asp.net page to connect it. But I got error message "SQL sever access denied".

However, I have a user account in the sql server, like "username/pwd". And I can reach it from programming machine when in asp design status, I mean, using .net's built-in database function.

I read a Microsoft's book "ADO.Net", in which it says that connecting to sql server on a remote box is different from to the local one. But I still do not know how to do it exactly.

Any help? Thanks very much.

Hello,

You need to specify the data source, initial catalog, and integrated security properties. The data source is the server name, the initial catalog is the database. If you are using a SQL login, you must also specify the user id and password parameters. If you are using your account ID to login, you must set that up in SQL Server.

Brian

Dim strConn ' Connection String
strConn = "Provider=sqloledb;" & _
           "Data Source=myServerName;" & _
           "Initial Catalog=myDatabaseName;" & _
           "User Id=myUsername;" & _
           "Password=myPassword"