ASP and SQL Server 2005

[eSPiYa]

I'm having problem in deploying an ASP site in my PC w/ an SQL Server 2005.
I'm having some problem in my connection string.

What connection string should I need to use to make it run?
I don't want to install a SQL Server 2000 to test this application because it will slows my PC.

Thanks for any help.

[DanInManchester]

You don't specify the security you are using but this page lists all the options:

http://www.connectionstrings.com/?carrier=sqlserver2005

You also need to make sure that your remote database server is allowing remote connections and that any other obsticals in the path such as firewalls routers etc. are configured if necessary.

[eSPiYa]

I already fixed it, I found out that my connection string is for .NET applications.
I changed it to native client.

Thanks for your help anyway.

But I'm still having some troubles. This is my first time to deploy an ASP WEB application though I already deployed many ASP.NET Applications.

I'll check the problem when I got home and then post it here.