connection string problem

  • 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

  • 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

  • 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'

  • 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 4 (of 4 total)

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