The last programmer also had problem in connectiong to local database.This is the way I&#039;m trying to connect to the local server.<BR><BR>set objConn = server.CreateObject("ADODB.connection")<BR>set cnd=server.CreateObject("ADODB.Command")<BR>mydb=" PROVIDER=MSDASQL;DRIVER={SQL Server};"<BR>mydb=mydb & "SERVER=Maserati;DATABASE=JobTop;"<BR>mydb=myd b & "UID=sa;PWD=;"<BR>objConn.Open mydb<BR><BR>But when I try to run the program, the error shown is as below:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80040e4d&#039; <BR>[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user &#039;MASERATIIUSR_MASERATI&#039;. <BR>/prototype/jobtop/general.asp, line 10 <BR><BR><BR>Is there any other way of connecting it....<BR><BR>Hope one of U&#039;ll help me....<BR>