Re: SQL connection

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Steve Caliendo (scaliendo_at_epion.com)
Date: 03/11/04 

Date: Thu, 11 Mar 2004 10:27:50 -0500

Use this syntax:

Dim cn As New SqlClient.SqlConnection("Server=(local);Database=LSP;User
Id=yourname;Password=yourpw;Trusted_Connection=False;")

cn.open()

Then on you're SQL database, set up a user with the correct username and
password. The ASPNET user should then be able to access your database.

Steve

"Robert" <anonymous@discussions.microsoft.com> wrote in message
news:b02201c4076f$fb0687d0$a401280a@phx.gbl...

> Running ASP.NET 1.1 application on Windows XP Pro.
> Trying to connect to a SQL 2000 server as the annonymous
> user using a trusted connection.
>
> I keep getting:
> System.Data.SqlClient.SqlException: Login failed for
> user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
>
> The IUS_machinename login is a valid user in my SQL
> database.
>
> Does .NET use some other user authority to connect to a
> sql database?

Relevant Pages

  • Re: Relational database & OO
    ... And when was the last time you saw an RDB that stored a telephone ... The modern relational theory permits to store values of user-defined type: ... Neither do the relational model or SQL. ... Your comprehension of the SQL database performance is not good. ...
    (comp.object)
  • Event log errors after moving sharepoint 3.0 database
    ... After following a procedure to move the location of the SQL databases from ... SQL Database 'WSS_Content' on SQL Server instance ... The local computer may not have the necessary registry ... information or message DLL files to display messages from a remote computer. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: ISA Log to SQL Database Question
    ... I am actually logging to an Access DB and the logs had grown to over 2 GB. ... The MSDE that comes with ISA or the real "full" MS SQL ... >> I have a question about ISA Logging to a SQL Database. ...
    (microsoft.public.isa.configuration)
  • RE: Automate Active Directory User Maintenance
    ... Hmmm...I know Quest has an ID management tool as well, but they are pricey. ... We've set it up for a client where the information is read from a SQL table ... could it evaulate the users in the SQL database ...
    (microsoft.public.windows.server.active_directory)
  • Re: Inventory and Stock Monitoring in Project
    ... through SQL. ... stock is used changing the information presented within the Inventory ... Inventory software places information in an SQL database which Project can ... VBA macros to keep track of stock. ...
    (microsoft.public.project)