Post reply

Connect ti DB via a ASP.NET issue

  • July 18, 2008 at 2:14 pm

    #194083

    I have and Asp.net page that needs to connect to a SQL DB and I gave the Domain\ASPNET account access to the DB. The server allows mixed mode security. But I keep getting the following error:

    Cannot open database requested in login 'TSDatawarehouse'. Login failed for user 'Domain\aspnetservice'.

    Any ideas?

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

  • July 24, 2008 at 9:39 am

    #847882

    Must be some issue with DBLogin or IIS Configaration.. Did you check the error log? It should give you better understanding


    CDBA

  • July 28, 2008 at 2:29 am

    #848984

    Are you using a connection string to specify the connection to the SQL DB? Supply a username and password of an existing account of the SQL server in the string.

    Check out this link. It tells you how to form connection strings correctly.

    http://www.connectionstrings.com/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply