Logon Failed for User...It is not an trusted conn? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

Logon Failed for User...It is not an trusted conn?

Author

Topic

manoj_mj
Starting Member

1 Post

Posted - 2009-08-27 : 02:38:28

I have to Pcs in network
In both I have installed SQL Server 2005 Express Edition.
When I try to connect or login using Management studio from one PC into another it gives error..

Cannot connect to BIT2\SQLEXPRESS.
------------------------------
ADDITIONAL INFORMATION:

Login failed for user 'TEST'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)

Here 'TEST' is a Database which I have created in BIT2\Administrator

I have confusion that what User Login name i should here?
It should be a Database name or what?

I also read on internet that I can't use EXpress edition for behaviour like Developer or Enterprise edition?
Is it true?

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2009-08-27 : 06:39:42

this might help

http://support.microsoft.com/kb/295414

ScottWhigham
Starting Member

49 Posts

Posted - 2009-09-03 : 06:50:13

quote:
Originally posted by afrika

this might help

http://support.microsoft.com/kb/295414

That gives the article "STS: Error 18452 While Extending a SharePoint Team Web Site" which doesn't seem like it fits here....

By default, Express Edition is not network enabled therefore you won't be able to connect to it remotely until you enable a network protocol. Also it appears that your server is using Windows authentication yet you are trying to login with a SQL login?

Express can be used "for behaviour like Developer or Enterprise edition" although I'm not 100% sure what you are referring to. There are differences in the editions to be sure.

========================================================

I have about 1,000 video tutorials on SQL Server 2008, 2005, and 2000 over at http://www.learnitfirst.com/Database-Professionals.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources