Re: Trying to connect to SQL Server database on a web server.

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Steve Thompson (stevethompson_at_nomail.please)
Date: 06/22/04 

Date: Tue, 22 Jun 2004 15:24:27 -0400

"Roy" <Roy@discussions.microsoft.com> wrote in message
news:F115896B-86F8-4752-93CE-571046421157@microsoft.com...
> I have created a VB6 application that needs to access a SQL Server
database on my web server. I have the IP address for the web server, but I
keep receiving a connection string error. I have also created a test ODBC
DSN using the IP address for the server and the UID and PWD used. I get the
following error for the DSN
>
> Connection failed with SQLState 01000 SQL Server Error 10060 for the
Connection Failed and SQLState 08001 and SQL Server Error 17. It says that
SQL Server does not exist or access denied. I can access it thru the website
I created.

Is SQL Server configured for Windows Authentication only or SQL
Authentication? Can you post your DSN string (suppress any sensitive info)?

Steve

Relevant Pages

  • Re: Programmatically create DSN usind SQL Server Authentication
    ... Not when you create the DSN programmatically. ... >Server using SQL Server Authentication. ... >is off-topic for my purpose because it only shows Windows authentication. ...
    (microsoft.public.sqlserver.odbc)
  • Programmatically create DSN usind SQL Server Authentication
    ... I am trying to programmatically create a DSN on a target system for SQL ... Server using SQL Server Authentication. ... is off-topic for my purpose because it only shows Windows authentication. ...
    (microsoft.public.sqlserver.odbc)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Options for Accessing SQL Server without a Domain Server?
    ... SQL Server 2000 is running on machine 'A', and my client app will be ... I reconfigured the DSN on machine 'B' to use Windows Authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Remote development advice
    ... We are using IIS as the web server. ... The IIS and SQL Server is setup in his ... I want to be able to access the pages that my friend has done remotely ... Then whichever web site he has configured as the default site on IIS should appear, assuming the web server was configured correctly. ...
    (microsoft.public.dotnet.general)