I'm trying to connect to a remote MS SQL Server from CLSQL. I've
downloaded and installed FreeTDS's drivers, and tsql seems to work. So
when I try to connect with (connect '(<DSN> <username> <password>)
:database-type :odbc) I get a login incorrect error. I typed in my
username and password correctly, but I don't know what the username
format for a domain login should be. For example, if my username is bob
and my domain name is DOMAIN, do I type in DOMAIN\\bob in the un? I've
tried every combination I can think of and it doesn't work
Jeffery Zhang wrote:
> I'm trying to connect to a remote MS SQL Server from CLSQL. I've
> downloaded and installed FreeTDS's drivers, and tsql seems to work. So
> when I try to connect with (connect '(<DSN> <username> <password>)
> :database-type :odbc) I get a login incorrect error. I typed in my
> username and password correctly, but I don't know what the username
> format for a domain login should be. For example, if my username is bob
> and my domain name is DOMAIN, do I type in DOMAIN\\bob in the un? I've
> tried every combination I can think of and it doesn't work
Not entirely sure but either DOMAIN\bob or ยทยทยท@DOMAIN should work in
theory. I would stick with the first form though, a lot of software
does not seem to understand that the second is valid. (that said CLSQL
and MS SQL server should know this)