SQL Remote

[TankMarine]

Hi everyone, Sinergia is a good product i need to connect to a remote
SQL server how could i do it
what do i have to modify in the connections strings or where. The
server is on my network.

Thanks for your help.

[gabouy]

Maybe this will help you,

http://help-desk-framework.blogspot.com/2007/03/sinergia-help-desk-faq.html#30

regards,
gabo

[TankMarine]

I already done that my problem is, that i have the SQL Server and the
web server in different equipments in one of them, i have all of the
databases of my company and in the other i have all of the web
services and i already change the primary connection in IIS in the
ASP.NET Configuration.

data source=SERVER\Instance;Integrated Security=SSPI;AttachDBFilename=|
DataDirectory|aspnetdb.mdf;User Instance=true

Thanks for your help

[gabouy]

You have two choices,

1- Assing domain credentials to the process hosting the IIS Website Application Pool (I'm assuming IIS 6.0). And create a SQL Server Login for the domain user asigned.

2-Use SQL Server authentication. This implies changing the connection string, and making sure SQL Server authentication is enabled in SQL Server instance.

regards,
gabo

On 9/5/07, TankMarine <tankm...@gmail.com> wrote:

[TankMarine]

We advance, but now is showing me Service Unavailable

On Sep 5, 2:57 pm, gabouy <g...@gabouy.com> wrote:
> You have two choices,
>
> 1- Assing domain credentials to the process hosting the IIS Website
> Application Pool (I'm assuming IIS 6.0). And create a SQL Server Login for
> the domain user asigned.
>
> 2-Use SQL Server authentication. This implies changing the connection
> string, and making sure SQL Server authentication is enabled in SQL Server
> instance.
>
> regards,
> gabo
>

> On 9/5/07, TankMarine <tankmar...@gmail.com> wrote:
>
>
>
>
>
> > I already done that my problem is, that i have the SQL Server and the
> > web server in different equipments in one of them, i have all of the
> > databases of my company and in the other i have all of the web
> > services and i already change the primary connection in IIS in the
> > ASP.NET Configuration.
>
> > data source=SERVER\Instance;Integrated Security=SSPI;AttachDBFilename=|
> > DataDirectory|aspnetdb.mdf;User Instance=true
>

> > Thanks for your help- Hide quoted text -
>
> - Show quoted text -

[gabouy]

Service Unavailable, might be you havent started your Application Pool service. Check if it's not stopped.

On 9/5/07, TankMarine < tankm...@gmail.com> wrote: