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