December 6, 2005 at 6:04 am
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!
December 6, 2005 at 11:19 am
December 7, 2005 at 3:32 am
Yes, it is set for mixed mode
December 7, 2005 at 5:16 pm
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.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy