Can't log into website having migrated to sql server from mysql

[hoanchec]

I can seem to get a correct connection to my website have moved from a mysql database to a sql server 2008 r2 db. The website is written in classic asp and uses conn.inc file. The contents of this file is as below. I have ** the password. \[code\]<%Dim strConnDim connstrConn = "Provider=SQLNCLI10;Server=chintranet2;Database=Gremlin;Uid=Gremlin;Pwd=********;"Set conn = Server.CreateObject("ADODB.Connection")conn.ConnectionString= strConnconn.Open%>\[/code\]The error I get is:\[code\]Microsoft SQL Server Native Client 10.0 error '80040e4d' Login failed for user 'Gremlin'. /Gremlinv4/connections/conn.inc, line 7 \[/code\]Can anyoine please shed any light on this. The user is created in sql server and has permissions assigned as "owner".Thanks for any help.