Converting to SQL authentication

Hello there
When i started programming on sql server I started with windows
authentication.
Now my administrator told me to move to work with sql server authentication.
When i changed the authenticaion on Enterprise manager i got an error that
(There is no trust connection)
How can i move to work with Sql Authentication?
any help would be usefulSounds like your server is still in windows-only authentication. Change
your connection back to windows auth, right click on your server, select
properties, security, and change to "Windows and SQL Server" authentication.
As an aside why would you switch? Windows auth is much
preferred/recommended...
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"Roy Goldhammer" <roygoldh@.hotmail.com> wrote in message
news:ekcyTjOvDHA.2712@.TK2MSFTNGP11.phx.gbl...

quote:

---

> Hello there
> When i started programming on sql server I started with windows
> authentication.
> Now my administrator told me to move to work with sql server

---

authentication.

quote:

---

> When i changed the authenticaion on Enterprise manager i got an error that
> (There is no trust connection)
> How can i move to work with Sql Authentication?
> any help would be useful
>
>

---

|||Well Richard
I'm not the administrator of the the server i'm going to work with.
I can't trust on my clients security: what if the my client have a global
user for department? in this case as you can see there won't be folloup on
atcions taken on the application
I changed it as you said but i can still enter the system with windows
authentication. On another computer with Windows 98 The logon manu always go
on
How can i cause this also on computers with Win2000/xp?
any help would be useful
"Richard Waymire [MSFT]" <rwaymi@.online.microsoft.com> wrote in message
news:evM#c9PvDHA.1788@.tk2msftngp13.phx.gbl...

quote:

---

> Sounds like your server is still in windows-only authentication. Change
> your connection back to windows auth, right click on your server, select
> properties, security, and change to "Windows and SQL Server"

---

authentication.

quote:

---

> As an aside why would you switch? Windows auth is much
> preferred/recommended...
> --
> Richard Waymire, MCSE, MCDBA
> This posting is provided "AS IS" with no warranties, and confers no

---

rights.

quote:

---

> "Roy Goldhammer" <roygoldh@.hotmail.com> wrote in message
> news:ekcyTjOvDHA.2712@.TK2MSFTNGP11.phx.gbl...
> authentication.
that[QUOTE]
>

---

|||right, you can never turn off windows auth - you are either pure windows
only or windows and SQL logins - you can't go to just SQL logins.
Not sure I understand the rest of your question - there shouldn't be any
difference in the connection string on Windows 2000/XP/2003.
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"Roy Goldhammer" <roygoldh@.hotmail.com> wrote in message
news:%23TdhnggyDHA.560@.TK2MSFTNGP11.phx.gbl...

quote:

---

> Well Richard
> I'm not the administrator of the the server i'm going to work with.
> I can't trust on my clients security: what if the my client have a global
> user for department? in this case as you can see there won't be folloup on
> atcions taken on the application
> I changed it as you said but i can still enter the system with windows
> authentication. On another computer with Windows 98 The logon manu always

---

go

quote:

---

> on
> How can i cause this also on computers with Win2000/xp?
> any help would be useful
> "Richard Waymire [MSFT]" <rwaymi@.online.microsoft.com> wrote in message
> news:evM#c9PvDHA.1788@.tk2msftngp13.phx.gbl...
> authentication.
> rights.
> that
>

---