Can anyone see what's wrong with this pls?

------------------------------------------------------
Dim sServer
Dim sDatabase
Dim sUserName
Dim sPassword
Dim oConn
Dim oCmd

sServer = "XX.XX.XX.XX"
sDatabase = "databasename"
sUserName = "username"
sPassword = "XXXXXXXX"

Set oConn = Server.CreateObject("ADODB.Connection")

oConn.ConnectionString = "DRIVER={SQL Server};SERVER=" + sServer + _
";UID=" + sUserName + _
";PWD=" + sPassword + _
";DATABASE=" + sDatabase
Set oCmd = Server.createObject("ADODB.command")
oConn.Open
----------------------------------------------------

I am getting 'Login failed for user'username'.

I can get into the sql server via query analyser with the same username and password. I don't understand why I can't get in from the asp.