Error occurs

Login failed for user SA. Reason not associated with trusted sql server connection.

---
Posted via DotNetSlackers.com
rkantsingh80 [ Mo, 15 Januar 2007 09:39 ] [ ID #1595963 ]

Re: Error occurs

<rkantsingh80 [at] gmail.com> wrote in message
news:eaorzCIOHHA.536 [at] TK2MSFTNGP02.phx.gbl...
> Login failed for user SA. Reason not associated with trusted sql server
> connection.
>

http://www.google.co.uk/search?hl=en&q=Login+failed+for+user +SA.+Reason+not+associated+with+trusted+sql+server+connectio n&btnG=Google+Search&meta=
Mike Brind [ Mo, 15 Januar 2007 10:23 ] [ ID #1595964 ]

Re: Error occurs

rkantsingh80 [at] gmail.com wrote:
> Login failed for user SA. Reason not associated with trusted sql
> server connection.
>
In addition to what Mike posted, using the sa login in an application is a
major security risk. You should create a limited-rights sql login and use
that instead. Give that account the bare minimum rights needed for it to
perform the functions required by your application.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
reb01501 [ Mo, 15 Januar 2007 13:17 ] [ ID #1595965 ]
Webserver » microsoft.public.inetserver.asp.db » Error occurs

Vorheriges Thema: VERY strange issue with SQL 2000 + ADO Command object
Nächstes Thema: asp communicate to a db without an html form?