Re: Connection String for classic ASP to SQL Server 2005

Well, there are a number of reasons. First, you should be using the SQL
Native Provider instead of SQLOLEDB when connecting to SS 2005. Use SQLNCLI
instead.
Next, you need to make sure that the SQL Server is configured to accept
"mixed-mode" security. This is off by default during setup.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Padmalochan Sahu" <PadmalochanSahu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:D60C4786-94AB-430E-A72F-3256E6AE7AA9@xxxxxxxxxxxxxxxx
How can i connect to SQL server 2005 from classic ASP without trusted
connection ? I have an application in classic ASP which is currently
connecting to SQL server 2000. with connection string as
Driver={SQL Server};Server=Servername;Database=DBNm;user id="DD"; password
="ff"; it is working fine.

I am getting error while connecting to SQL Server 2005. i have given
connection string as Provider=SQLOLEDB;Data
Source=servername\SQL2005,8701;Initial Catalog=Alps;Network=DBMSSOCN;user
id="DFDF"; password ="FF". Can anyone send me the connection string used
to
connect to SQL Server 2005 from classic ASP application without trusted
connecting.

Thanks in advance
Padmalochan Sahu


.

Relevant Pages

  • Re: How to connect a workstation to SQL Server 2005 thru ODBC?
    ... and open the port in the Windows XP ... Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... Either SQL Server Management Studio or Management Studio Express. ...
    (microsoft.public.sqlserver.connect)
  • Re: Cannot connect a remote sql server
    ... I too have written quite a bit about connecting. ... Hitchhiker's Guide to Visual Studio and SQL Server ... such as the server's firewall, SQL Server's remote connection setting, ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.adonet)
  • Use Single Sign on to connect to sql server
    ... connection in an excel file that connects using an odc file connecting using ... The logon account information that you configure here must match the logon ... Name: SQL Server ... If I'm connecting using a sql username, do i need to use the domain piece ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Problem connectin SQL Server 2005
    ... Have you configured the SQL Server 2005 to allow remote connections? ... Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... Configuring a Fixed Port ...
    (microsoft.public.sqlserver.connect)
  • Re: Starter kit error when using SQL Server Dev instead of Express.
    ... There are a couple of whitepapers there that discuss connecting. ... Hitchhiker's Guide to Visual Studio and SQL Server ... I have changed the name of the DB server in the connection string, ... under the default settings SQL Server does not allow remote connections. ...
    (microsoft.public.sqlserver.connect)
Loading