Re: Connection string - trusted connection


How to specify a trusted connection in the connection string to connect to
SQL SERVER 2000?

You need this property in your Connection string "Integrated Security=SSP"


Are you using the Connection wizard to create your connection string. The
Wizard make it very easy

--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: Connection string - trusted connection
    ... SQL SERVER 2000? ... Are you using the Connection wizard to create your connection string. ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • thanks Brian, but it comes a new problem
    ... Its on the ALL tab of the connection Wizard ... if the ADOtable use 'connection string' property as same as the string ... refer the ADOtable's 'connection' property to the ADOconnection in main ... form, when running, it will prompt 'invalid password' as the mdichild form ...
    (borland.public.delphi.database.ado)
  • Re: One Connection String for Multiple Users (SQL)
    ... Hitchhiker’s Guide to Visual Studio and SQL Server ... "William Vaughn" wrote: ... This uses the> same connection string for all instances of the application. ...
    (microsoft.public.sqlserver.connect)
  • RE: How do I configure Analysis Services for Excel 2003 users?
    ... they had had Office 2003 installed AFTER SQL Server. ... > I have been preparing a set of cubes in Analysis Services 2005 to be viewed ... > Excel reports have been designed as pivot tables based on AS cubes, ... > Surely it must be that the connection string is incorrect but I seem to have ...
    (microsoft.public.sqlserver.olap)
  • Re: Connecting to Sql Server using an IP address
    ... using IP address without port number (default port number ... of SQL Server is 1433) cannot connect to the SQL Server on a remote ... name in the connection string can connect the remote machine successfully. ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.framework.adonet)