Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pearlyred
Starting Member
7 Posts |
 Posted - 2007-01-04 : 04:50:14
|
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" %> CheersPR |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-04 : 06:14:41
|
| You need to change the server to allow sql server connections (rather than just integrated security) and add the login dbTestUser - easiest to add it to the sysadmin server role for testing.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Restoring backup on new machine