MS SQL database permissions problem??

[dlacloche]

So, I detached a database from our testing server and moved the .MDF and .LDF over to our web server and reattached it, but I can't get to the data thru a web application I created in Dreamweaver. What am I missing?

Is ODBC the right way to connect to the database?
Do I have to define a certain user in the database? IUSER or something?

Does anyone have any advice?

Thanks.

[chazzy]

it depends on how your app is setup. is there a special DSN that you're using to connect from dreamwearver? what language are you using? are you able to perform the same test on the test server?

I odn't know if this might help....
http://support.microsoft.com/kb/224071

[dlacloche]

Thanks for the response. I think we got it figured out. Now, another question, we have 3 SQL servers running on our intranet on 3 different machines. We also have it running on our web server. When I go to Enterprise Manager I can only see the intranet SQL servers. Is there a way to 'see' the SQL server on the web server thru my Enterprise Manager?