SQL Server authentication help

  • Hi there, I support a piece of proprietry payroll/hr software, and have a query regarding SQL authentication.  Where we use SQL to store our data, we use NT authentication, add a local or domain user to the login's on the SQL manager, and use the same user for our service (through which connections are made).

    A client wants to use SQL authentication, and I've found by using one of our oracle .ini files, we can pass clear text variables to the server.  Here's the question:

    If i can pass clear text (e.g. Username=username and password=password), can I use this method to login to the SQL database?, is there a variable name for the username and password that I can pass over in this .ini file to log us in?.

     

    It currently gives me an error "login failed for user '(null)' ..."

    Thanks!

  • is your server configured to use mixed-mode authentication?


    Cheers,

    david russell

  • Yes, it is set for mixed mode

  • I have been an oracle dba longer than sql server, and most of my sql server has been with windows authentication.  In either environment you can embed a user id and clear text password in a script (with SQL Server, when using mixed-mode authentication) in oracle "connect userid/password" and in SQL I believe it is just "userid/password"... perhaps followed by "go".  But an .ini file is a configuration file and does not contain SQL... and the format is in all likelyhood not a connect string.  I believe that the answer to your question is "yes"; but I am struggling for an exact answer as to how.  Your error message looks more like one from Windows authentication, which was why I asked if you were in mixed mode.  Sorry I can't be more help.


    Cheers,

    david russell

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

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