Re: Connection string - trusted connection
- From: "Guillem" <guillemvicens-nospam@xxxxxxxxxxxxxxxxxx>
- Date: 17 Nov 2006 02:33:05 -0700
Alan T wrote:
This is the connection I used by using the wizard:
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=alan;Initial
Catalog=testdb;Data Source=server1;Integrated Security=SSPI
When I tried to set the adoconnection component to true I got the
error: 'Login failed for user'(null)'. Reason: Not associated with a
trusted SQL Server connection.'
If I take away the
Integrated Security=SSPI
then I can connect the database.
your dba probably did not select "mixed mode authentication" when
he/she installed SQL Server.
Go to SQL Server Enterprise Manager, expand the tree view until you
find your server, right-click annd select "SQL server properties
(configure), select the Security tab and for Authentication select "SQL
server and Windows", close the window and restart SQL Server.
See
http://support.microsoft.com/kb/889615/en-us
for more information.
--
Best regards :)
Guillem Vicens Meier
Dep. Informatica Green Service S.A.
www.clubgreenoasis.com
--
Contribute to the Indy Docs project: http://docs.indyproject.org
--
In order to contact me remove the -nospam
.
- References:
- Connection string - trusted connection
- From: Alan T
- Re: Connection string - trusted connection
- From: Brian Bushay TeamB
- Re: Connection string - trusted connection
- From: Alan T
- Re: Connection string - trusted connection
- From: Guillem
- Re: Connection string - trusted connection
- From: Alan T
- Connection string - trusted connection
- Prev by Date: Re: The data types varchar and text are incompatible in the equal to operator
- Next by Date: Re: Connection string - trusted connection
- Previous by thread: Re: Connection string - trusted connection
- Next by thread: Re: Connection string - trusted connection
- Index(es):
Relevant Pages
|
