Restoring Backup On New Machine

Hi all,

My first post on these forums and I'm hoping someone can please help me before I pull all of my hair out.

I'm currently working on the redevelopment of a website. The old one was written in ASP and we're going to totally redo the whole thing. As a lot of the content was dynamic I want to fire up the old site on my laptop to browse and pull content from. I have a backup of the entire website which I have put under a fresh IIS install. I also have a backup of the MSSQL database. I have restored this to the local machine and can view it using the SQL Server Management Studio. The problem is that I think I am having lots of trouble synching the users/permissions for it. We don't have a backup of the Master databases so I am stuck with what I can extract from the site backup and web code.

Trying to load the old index.asp I get either of these error messages quote:'Login failed for user 'Username'. The user is not associated with a trusted SQL Server connection' or 'SQL Server does not exist or access denied.' depending on how I've played with the user permissions.

Please can someone help me sort this out so that the old ASP webpages can access the DB again? I'm used to mySQL/PHP so am struggling a bit to get this going.

-Edit-
Bit more info. Here are the connection details the site uses within an ASP page.
<%
dim Conn

'---------------------Create connection------------------------------------------------------
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Driver={SQL Server};Server=MYSERVER;Database=dbTest;uid=dbTestUser;pwd=testpasssql"

%>
Cheers
PR