Post reply

connection string problem

  • February 22, 2004 at 10:47 pm

    #86077

    Hi

    I have a connection string like this which works

    "provider=sqloledb;server=UYT3;database=Wordman;uid=****;password=****"

    I want to use Trusted_Connection into my connection string and not userid but I get an error

    "provider=sqloledb;server=UYT3;database=Wordman;Trusted_Connection=true"

    What am I doing wrong? Please any help on this.

    Thanks

  • February 23, 2004 at 12:13 pm

    #495203

    What is the error?  Are you using OLE/DB or ODBC? 

    I assume that the userid you signed on with is a valid login for the server as well as having access to the Wordman database.

    Check out http://www.able-consulting.com/ADO_Conn.htm for samples of connection strings. 

    Francis

  • February 24, 2004 at 12:53 am

    #495249

    I am using a OLEDB connection

    I login to the server(which has IIS installed) using a userid "ABC" and my sql server database login is "XYZ"

    and when I request my asp.net webpage in browser I get a an error which is

    Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

  • February 24, 2004 at 7:32 am

    #495312

    I have seen this problem as well.  The issue could be that your NT login does not have rights on the SQL server or database or the SQL Server is not set up for Mixed Authentication. 

    If these are setup then you may need to reboot the server.  We have hasd this happen where the SQL Server will not authenticate NT Users because it has gotten out of sync with the domain.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

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

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