Hi,
I am hoping to install CommunityServer (an ASP based blogging/forum
software) on my local computer. CommunityServer requires me to have
access to SQL Server. Because this will eventually be hosted by my
website hosting server that i can not remote into (i.e. i will push
the files via FTP), i can not use Windows Authenication for my Sql
server access. Therefore i tried creating a new login for my sql
server that i would like to use with SQL Authentication.

However, when i try to login using this newly created login using SQL
Server authentication using Microsoft SQL Server Management Studio
Express, it is telling me "Login failed for user 'MACHINE\user'. The
user is not associated with a trusted SQL Server connection.
(Microsoft SQL Server, Error: 18452)"

Any advice would be appreciated.

On Feb 10, 12:29 pm, "farseer" <fars...@optonline.net> wrote:
> Hi,
> I am hoping to install CommunityServer (an ASP based blogging/forum
> software) on my local computer. CommunityServer requires me to have
> access to SQL Server. Because this will eventually be hosted by my
> website hosting server that i can not remote into (i.e. i will push
> the files via FTP), i can not use Windows Authenication for my Sql
> server access. Therefore i tried creating a new login for my sql
> server that i would like to use with SQL Authentication.
>
> However, when i try to login using this newly created login using SQL
> Server authentication using Microsoft SQL Server Management Studio
> Express, it is telling me "Login failed for user 'MACHINE\user'. The
> user is not associated with a trusted SQL Server connection.
> (Microsoft SQL Server, Error: 18452)"
>
> Any advice would be appreciated.

i figured out that with SQL Server 2005, i needed to enable "mixed"
mode to be able to use SQL Server Authentication.