"THE JOK3R" <a@a.a> wrote in message
news:%23GL$eDNjHHA.4520@TK2MSFTNGP02.phx.gbl...
> Hello.
> I've an application that has to do a bunch of "SELECT" and INSERT into a
> couple of tables. On my machine everything works fine, but if I try to
> deploy the app on a VM for a test i have many probs.
> The most common is "(Named Pipes Provider, error: 40 - Could not open a
> connection to SQL
> Server)", but using (local)\SQLEXPRESS i've "Request for the permission of
> type
> 'System.Data.SqlClient.SqlClientPermission, System.Data, version=2.0.0.0,
> Culture=neutral, PublicKeyToken=b77a5c561934e89'" too...I think it's a
> connectionstring problem. I used "Data Source=(local)\SQLEXPRESS;Initial
> Catalog=Clienti;Integrated
> Security=True", where "Clienti" is the DB, but i tried the string I found
> on http://www.connectionstrings.com/?carrier=sqlserver2005 too.
> It's being absurd...please give me an help...thanks...

"THE JOK3R" <a@a.a> wrote in message
news:O8v9ZKOjHHA.4936@TK2MSFTNGP03.phx.gbl...
>
>
> "William (Bill) Vaughn" <billvaRemoveThis@betav.com> wrote in message
> news:OpGW39NjHHA.1624@TK2MSFTNGP06.phx.gbl...
>> Ah, did you enable TCP/IP on the target server? Why are you using named
>> pipes? If you do, you must enable additional ports in the firewall (if
>> there is one).
>
> I both did everything...enabled TCP/IP and Remote Connection, opened port
> 1431 default port...

"William (Bill) Vaughn" <billvaRemoveThis@betav.com> wrote in message
news:OpGW39NjHHA.1624@TK2MSFTNGP06.phx.gbl...
> Ah, did you enable TCP/IP on the target server? Why are you using named
> pipes? If you do, you must enable additional ports in the firewall (if
> there is one).