Post reply

Vb.net App - Sql Server Login

  • March 28, 2008 at 9:58 am

    #188555

    I have a vb.net app connecting to a sql database.

    When I run the app on the PC running Sql Server it logins ok.

    When I try and run the app on a different PC, I get the following error

    System.Data.SqlClient.SqlException: Login failed for user 'BM-PC\Guest'.

    I am using the following connection string

    Dim connstring As String = "server=BM-PC;Initial Catalog=EquinexMasterSql;User ID=username;Password=password;Trusted_Connection=False;"

    It looks like the users, login and database security is configured correctly

    in Sql Server Management Studio.

    Any suggestions are most welcome.

  • April 19, 2008 at 8:01 am

    #804657

    Hello,

    Normal as you are using Windows authentification and you can't use it except if you are in a windows domain. In this case, you must add the user computer\user to the users authorized to access to the instance and to the database.

    I'd this problem. I solved with enabling Sql Server Authentification and adding the Sql Server login to the logins which may connect to the database.

    Have a nice day

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

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