Re: Reason: Not associated with a trusted SQL Server connection.

Is the new box's Sql Server using Integrated Windows authentication ?

If it is, you'll have to change it to use both Windows and SQL Server authentication,
if you want SQL server users who are not Windows accounts to have access.

You could also create a"cc" user in the Windows box (and not change the authentication method).
I prefer to use SQL Server authentication, instead of Windows authentication, though.

To change the authentication mewthod, open the Enterprise Manager,
highlight your server, right-click and select "Properties".

Then, open the Security tab.




Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
===================================
"Sehboo" <MasoodAdnan@xxxxxxxxx> wrote in message
news:1163256729.911584.225960@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I posted this in another newsgroup but haven't received the answer, so
I am trying my luck here as well.

My database is running on a seperate machine and my connection string
is
"user id=cc;data source=Custom;initial catalog=Dev;password=cc". I
backed and restored the database on my local machine and changed the
connection string to this: "user id=cc;data source=(local);initial
catalog=Dev;password=cc".

But now when I run my asp.net application, I get this error:
Login failed for user 'cc'. Reason: Not associated with a trusted SQL
Server connection.


Can somebody please tell me what I need to do?


thanks



.

Relevant Pages

  • Re: Windows Authentication in asp.net 2005 to SQL Server?
    ... If the domains do not trust each other, Windows authentication is not going ... Basic authentication sometimes makes the need for Kerberos delegation go ... generic account to do the backend data stuff on our SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: Changing passwords / Blocking SA login attempts
    ... I went into the Server Config properties and changed to Windows ... My login for Start and Run SQL server was in this format. ... I am supposing this was an SQL authentication, ...
    (microsoft.public.sqlserver.security)
  • Windows Authentication with IIS on separate machines
    ... Yes, setting Basic Authentication in IIS works, but the ... >in SQL server but doesn't work if user account was ... >imported from a Windows account. ...
    (microsoft.public.sqlserver.security)
  • Re: Login failed for ServerGuest
    ... I think it is not a limitation in Windows 2000. ... access SQL server on Win2000 server by using Windows authenctication if I ... | I have noticed that when I try to log in using Windows Authentication ...
    (microsoft.public.sqlserver.connect)