Re: SQL Server Databases in VS

From: John Newsom (anonymous_at_discussions.microsoft.com)
Date: 05/07/04

  • Next message: ÌÀ½¨¾ü: "Re: Visual c#" 
    Date: Fri, 7 May 2004 14:36:04 -0700

    This was puzzling to us as well. We ran a class last year on asp.net development, and were confused by sql server telling us it did not have a trusted connection. This article sheds some light on the problem: http://support.microsoft.com/default.aspx?scid=kb;en-us;815154&Product=aspnet

    But I am wondering how to set up a lab of machines using VS so that they can access SQL server without having to add each individual machinename\aspnet account to SQL Server security. Is there a way to tell VS in some config file to use a different default method for authenticating against sql server?

    Thanks,

    John
         
         ----- Dave Strickland wrote: -----
         
         When you drag and drop the connection onto your form you should be able to
         edit the connection string. If you want to force a connection to appear as
         SQL authentication in Server Explorer. Add a new data connection in the
         server Explorer("Right Click 'Data Connections' and Select 'Add new'")
         specify the server the userID and the Password you want to use.
         
         
         "newbie" <bari@sos.REMOVETHIS.state.ga.us> wrote in message
         news:OIsUGRJLEHA.1416@TK2MSFTNGP09.phx.gbl...
    > I'm running SQL Server 2000. When I originally set up the localhost, I
         set
    > it for Windows Authentication. For the purpose of going through an
         ASP.NET
    > project in a book, I changed the properties to SQL Authentication (using
    > Enterprise Manager). However, when I visually connect to the database, in
    > VS.NET, it still creates a connection string using Windows Authentication,
    > and furthermore does not allow that property to be edited. What would be
    > causing this. Thanks in advance.
    >> Bari
    >>

  • Next message: ÌÀ½¨¾ü: "Re: Visual c#"

    Relevant Pages

    • Re: [SOLVED] Cannot display provider-specific login prompt
      ... scenario where the program wouldn't have to know about the database, ... ConnectionStringBuilder up to a PropertyGrid for the end user to populate), ... details of the connection, for the sake of the program being able to connect ... information about the connection string that I will need. ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Complicated Connection Problems bewteen ADP and SQL Server
      ... front end on the 5-8 workstations where the users happen to sit. ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... thought that I should instead change my connection string to something ...
      (microsoft.public.access.adp.sqlserver)
    • Re: Fujitsu NetCobol 8.0
      ... You cannot use a connection string in the way you have shown and expect it ... Any Fujitsu NetCobol / PowerCobol users here? ... Use the ADO control provided in PowerCOBOL, ...
      (comp.lang.cobol)
    • Re: perplexing SQL authentication from ASP.net issue
      ... the sql must be local or sql standard secuirty must be used. ... > directory security is set to Integrated Windows Authentication only. ... > I've tried a variety of connection strings. ... > connection string that VS.net uses. ...
      (microsoft.public.sqlserver.security)
    • Re: Changing Connection String programmatically
      ... This is a good situation for putting the connection string information in the app.config file. ... every year we will create new database. ... change the body of the private void InitConnection(), ...
      (microsoft.public.sqlserver.connect)