in reply to connection issues to MS SQL Server

Since you're asking, I'm assuming your $user does not contain "company/lsxo" as shown in the error message. Are you passing "lsxo" as your user name and the server prepended the domain, or did you send something completely different?

Do you know if the database instance is using domain-only, sql-only or mixed-mode authentication?

-- Time flies when you don't know what you're doing

Replies are listed 'Best First'.
Re^2: connection issues to MS SQL Server
by lsxo (Novice) on Aug 07, 2009 at 18:23 UTC
    Yes.. sorry about not clarifying! $user is the database username and $password is the database password. I am not passing lsxo as my username but a different username. lsxo is my windows login username. I'm not sure which authentication the database instance is using..how do I find out? Thank you!
[reply]
      First, check the server configuration. You will most likely want to use mixed mode, unless there are special security concerns that dictate otherwise.

      Secondly, check the ODBC data source. I don't have much experience with using DBI against SQL Server, but I do know that incorrect settings in the ODBC data source will usually override whatever the application is trying to do.

      Hope this helps :-)

      -- Time flies when you don't know what you're doing
[reply]

In Section Seekers of Perl Wisdom