error

<i><b>Originally posted by : dimi (dieder@pandora.be)</b></i><br /><br />Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'DIEDERIKIUSR_DIEDERIK'.<br /><br />I always get this error when i try to connect to my msql server i use the local server with sa as uid.<br /><br />Conn.ActiveConnection = "Driver={SQL Server};server=(local);Uid=sa;Pwd=;Database=examen ;Trusted_Connection=Yes"<br /><br />any one who knows what could be the problem

<i><b>Originally posted by : Faisal (safaisal@saudionline.com.sa)</b></i><br />Hi!<br />If u want to use trusted relationship in ASP pages, you should have same UserName & Password ( Network password) in both Webserver and SqlServer, and your Usernane should have access permission to the database u are going to access.<br />Regards.<br />Faisal<br /><br />------------<br />dimi at 5/21/2002 2:04:27 PM<br /><br /><br />Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'DIEDERIKIUSR_DIEDERIK'.<br /><br />I always get this error when i try to connect to my msql server i use the local server with sa as uid.<br /><br />Conn.ActiveConnection = "Driver={SQL Server};server=(local);Uid=sa;Pwd=;Database=examen ;Trusted_Connection=Yes"<br /><br />any one who knows what could be the problem