Re: Connection string - trusted connection

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.

"Guillem" <guillemvicens-nospam@xxxxxxxxxxxxxxxxxx> wrote in message
news:455c3275@xxxxxxxxxxxxxxxxxxxxxxxxx
Alan T wrote:

Sorry,

Should it be
"Integrated Security=SSP"
or
"Integrated Security=SSPI"


"Integrated Security=SSPI"


--
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



.

Relevant Pages

  • Re: What does the "Configure email and Internet Connection Wizard"
    ... > the CEICW does (listed under "Configure Email and Internet Connection ... > Configure E-mail and Internet Connection Wizard is designed to correctly ... > configure settings for your network, firewall, secure Web site, and e-mail ...
    (microsoft.public.windows.server.sbs)
  • Re: What does the "Configure email and Internet Connection Wizard"
    ... Understanding the Configure E-mail and Internet Connection WizardThe ... Configure E-mail and Internet Connection Wizard is designed to correctly ... configure settings for your network, firewall, secure Web site, and e-mail ...
    (microsoft.public.windows.server.sbs)
  • Re: ADC Object Replication Fails In Exchange 2003 Setup
    ... So you have run the Resource Mailbox Wizard and the Connection Wizard, ... > running the Resource Mailbox Wizard and the Connection Agreement ... > resource mailboxes before they can be replicated to Active Directory. ...
    (microsoft.public.exchange.setup)
  • Re: ICS problems with Client net access
    ... >>connection manually'. ... I hate dealing with the wizard, ... Which means using the wizard that came with the USB modem to install its ...
    (microsoft.public.windowsxp.network_web)
  • Sharing DSL connection via WiFi
    ... The Network Connection Wizard in XP leads me to ... believe that I can turn my XP-using computer (ThinkPad R40) ... AL5410-G), I run the Wizard, and voila, the laptop becomes, ... a wireless router for the Internet connection ...
    (microsoft.public.windowsxp.network_web)