why is it my sql server does not exist or access denied?

Answer 1

did you start the 'sql service manager'?
c:\program files\microsoft sql server\80\tools\binn\sqlmangr.exe

also check that the service is running:
start->program -> administrative tools->services
click on MSSQLSERVER
right click
select start

Answer 2

Create the relationship at deliver at the same time-time extremely than run-time... i.e. drag and drop sq. connection administration on the web page rather of writing the code. the relationship wizard will immediately generate the relationship string for you and also you may want to even attempt if it extremely works or no longer. If even this fails, save your tables in the draw close database and by no skill in a separate database document.