"Stig Benning" <s_benning@yahoo.com> wrote in message
news:ad16a2c6.0502231640.72521880@posting.google.com...
> Hi!
>
> I have MSDE installed and everything works fine on a local desktop.
> But when I want to log in from i.e. a development environment from
> another machine on my intranet, I can only do that if I have the guest
> account on the machine where the MSDE runs set as a member of
> administrators. I'd prefer not to do that, but if I try to connect in
> any other way, I get this error message: "Login failed for user ....
> Reason: Not accociated with a trusted SQL Server Connection". Is there
> any way I can set up such a trusted connection so that I can create a
> connection string with uid and pwd instead of using SSPI?
>
> I installed the server instance with the following parameters:
>
> instancename=instancename security=SQL disablenetworkprotocols=0
> sapwd=strongpwd
>
> If it is possible to create such a trusted connection, how should the
> connection string look?
>
> All hints are welcome..! Thanks.
>
> Stig Benning

"Jim Young" <thorium48@hotmail.com> wrote in message news:<#cy9UxhGFHA.3628@TK2MSFTNGP15.phx.gbl>...
> A trusted connection is one that uses the security credentials of the
> network connection to connect to the database. This is different from an SQL
> user connection where the connection is challenged with a user name and
> password request before the connection is allowed. The kind of connection
> string you want to use would look something like:
>
> Database=MyDatabase;Server=MyServer;User ID=MyUser;Password=MyPassword
> etc.
>
> The Books Online have a fairly good explaination of ADO connection strings.
>
>
>
> Jim
>
> "Stig Benning" <s_benning@yahoo.com> wrote in message
> news:ad16a2c6.0502231640.72521880@posting.google.com...
> > Hi!
> >
> > I have MSDE installed and everything works fine on a local desktop.
> > But when I want to log in from i.e. a development environment from
> > another machine on my intranet, I can only do that if I have the guest
> > account on the machine where the MSDE runs set as a member of
> > administrators. I'd prefer not to do that, but if I try to connect in
> > any other way, I get this error message: "Login failed for user ....
> > Reason: Not accociated with a trusted SQL Server Connection". Is there
> > any way I can set up such a trusted connection so that I can create a
> > connection string with uid and pwd instead of using SSPI?
> >
> > I installed the server instance with the following parameters:
> >
> > instancename=instancename security=SQL disablenetworkprotocols=0
> > sapwd=strongpwd
> >
> > If it is possible to create such a trusted connection, how should the
> > connection string look?
> >
> > All hints are welcome..! Thanks.
> >