|
|
Posted by Erland Sommarskog on 09/21/07 21:32
Daniel Loose (no@reply.de) writes:
> but for hours, i cannot establish a working connection, i cannot login
> to the ms sql server from the asp scripts. i try and try, nothing
> works. i always get [note: this is my own translation from german, not
> the actual english error msg] 'error when logging in user bla. this
> user isn't assigned to any trusted sql connection.'
>
> i am absolutely new to ms sql and asp. i myself actually develop in
> php/apache/mysql. i don't have time to go deeper - i just want to run
> this project, for viewing only. *please can anyone tell me what and
> where exactly i have to set in ms sql server management studio 9.0*
> ???!!!
>
> what i did so far:
>
> - set the auth mode to "sql server and win";
> (however the manager is connected through win auth because of that
> very error)
> - my conn string currently is
> PROVIDER=SQLOLEDB;DATA SOURCE=DANIEL; Initial Catalog=dbo; User
> ID=bla;Password=fasel; (dbo is the database name, DANIEL is the mssql
> server name)
> - in managemnet studio, in security>auth (?, anmeldungen), where sa
> etc is, i created bla, with password=fasel; and in databases>dbo i
> added bla to users (i hope so/it looks like).
In Management Studio, in the Object Explorer, right-click the server
itself, and select Properties. Find Security to the left. On the top
of this page, you have two choices for Server authentication. Select
SQL Server and Windows Authentication mode, the second option. You
need to restart the server for it to take effect.
Once you've done this, use the connect string with User ID and Password.
Windows authentication is usually the recommended means of authentication,
but I believe that for ASP and ASP .Net solutions, SQL authentication
is preferred.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
[Back to original message]
|