Re: Client applications

On Thu, 01 May 2008 16:17:44 -0400, Nubie <nubie@xxxxxxxxxxxx> wrote:

Check this out:
http://www.connectionstrings.com/?carrier=sqlserver2005
and you'll find many ways to build a connection string without a DSN.

-Tom.


Hello,

I have been given the responsibility of upgrading a client application
to use Windows authetication. Previously the application was designed
with database authentication with SQL Server. A particular request is
to eliminate the dsn connections if possible. (This is all on SQL
Server 2005)

Any tips or help from those who have already done this sort of thing
will be much appreciated.




.

Relevant Pages

  • RE: Invalid authorization specification
    ... Does your application use a DSN to connect to SQL Server? ... DSN is setup correctly on the client machine. ... How to troubleshoot connectivity issues in SQL Server 2000 - ...
    (microsoft.public.sqlserver.connect)
  • Re: Problem connecting to sql server
    ... go to Client Configuation properties on the client machine ... I need to clarify that I didn't change anything on the SQL server. ... The account my web application is using is the 'sa' account and yes, ... And I'm sure the connection string is ...
    (microsoft.public.dotnet.framework.adonet)
  • Changing Sql7 TCP Port
    ... If the website is running on the same machine as the sql server, and the DSN ... connection string in each website has the IP address hard coded and no port ...
    (microsoft.public.sqlserver.security)
  • Re: Please advice
    ... Are your clients and your SQL Server in the same domain? ... If all of them are in a domain and every component are able to resolve others' names then use my sample connection string. ... You can create an alias for a server from SQL Server Configuration Manager. ... Go to "SQL Native Client Configuration" node and expand it. ...
    (microsoft.public.sqlserver.clients)
  • Re: dsn connection
    ... of processing and file IO to accomplish the same thing. ... All a DSN does is ... store information that you can put right into your Connection String. ... > points to the SQL Server and DB? ...
    (microsoft.public.dotnet.framework.aspnet)