February 1, 2009 at 8:04 pm
Hello; I am totally new to SQL Server. I did have 2008 installed but I had a better experience with 2005. So I am now running SQL Server 2005 express w/ advanced. I am also running Visual Studio 2008. I created my database in VS. but when I try to run my program I get this error:
Login failed for user". The user is not associated with a trusted SQL Server connection.
Please Help
February 1, 2009 at 8:16 pm
Change the Authentication type to Mixed Mode it should work.
February 2, 2009 at 8:32 am
Hi,
In SSMS, rt click server properties -> security -> server authentication -> sql server and windows authentication mode.
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply