Cant connect to db after web setup

I have an asp 2.0 app that connects to a database in another city.

When I test this app through VS2005 is connects and works great. After I created a web setup project it goes bad.

I ran the setup on 2 different computers, including the dev machine, both start ok and bring up the applications main menu, but when I choose a menu item that is supposed to bring up a datagrid from the sql server I get an error saying it's not a trusted connection.

Any advice on where I should start looking? It's got me beat.

Thanks.

Hi,

How are you connecting to the remote SQL server DB? Can you paste the connection string from the config file (with changes password, IPs ofcourse)?

Vivek

|||

I've tried these 2 strings and get the same results with each:

connectionString="Data Source=xx.xxx.xx.xxx;Initial Catalog=xxxxxx;Integrated Security=True; provider Name=System.Data.SqlClient"

and:

connectionString="Data Source=xx.xxx.xx.xxx;Network Library=DBMSSOCN;Initial Catalog=xxxxxx;Trusted_Connection=yes;"

providerName="System.Data.SqlClient"

|||

It seems you are trying to connect to a remote DB. You need to check what authentication type is applicable: Sql Server or Windows Integrated. Refer this article on details:

http://builder.com.com/5100-6371_14-6084879.html

HTH,

Vivek

|||Thank you, I will read that tonight and see what I can come up with.