Deployment Help

I'm trying to test my ASP.NET application. Everything is working to the point of getting to my login page to open. When I try to login I receive and error that the database does not exist or access is denied. I used the developer version of SQL Server to create the database and installed the MSDE on my test PC. Then I copied the mdf and ldf files to the new PC. Is there something else I should be doing? Or any suggestions?

Thank you,::Then I copied the mdf and ldf files to the new PC

did you "attach" the database ??

hth|||The test PC only has the MSDE installed. I don't know of a way to run the attach sp without query analyzer, is there a way?

Thank you,|||I tested, and I can connect the SQL Server database to a Access adp. Would this mean that I should be able to connect to my ASP.NET web pages? Could there be a problem with my connection string when I moved the app to the new PC? What is the simplest connect string to a SQL Server database, so I can test it?

Thanks you any suggestions,|||Can you install SQL Server tools (only)?
That would be easier to attach a db via Enterprise Manager (right-click DB / all tasks).|||I was trying to do this as if those tools were not available. I read that it was possible, but I cannot find the listing again.

Thank you,sql

Deploy fails telling me the user don''t have permissions, but the user listed isn''t me!

I'm trying to deploy a project that I deployed yesterday just fine, but today I get the following error:

Deploy started: Project: Point Reports, Configuration: Debug

Deploying to http://reporting.companyname.com/reportserver

Deploying data source '/Data Sources/Srv24.FieldResponse2_1'.

The permissions granted to user 'DOMAIN\harley.p.bartman' are insufficient for performing this operation.

Deploy complete -- 1 errors, 0 warnings

This seems like a basic permission issue, except I'm not logged in as the user listed! I've never logged into my computer as the user. I did log in to the reporting services website yesterday as that user, but since have rebooted my machine and logged into bothe my computer and the reporting services website as me. Yesterday this report deployed fine. Today, this error message. I've even tried creating a new project and just creating a simple datasource and deploying just that, but still this message! Where is Visual Studio storing and reusing this user name during my deploy process?

It seems to me that it is storing those credentials in your datasource for the report.

Open your datasource for your report and check the credentials tab. Is "use a specific username and password" checked? If so, you might want to change that.

|||Everything is set to Windows Credentials (Integrated Security) on the datasource. At this point I can create a new project from scratch and when I try to deploy is still tries to do so under this other user's name. Obviously his name must be cached somewhere but I can't find how to clear it or to get Visual Studio to recognize that I'm me! I've tried clearing all my IE cache, but no luck.

|||

I've seen something like this in another thread, but I can't seem to dig it up. I think it has something to do with credentials in IIS.

Right click report server and reports in IIS and click properties. On the directory security tab, click edit under anonymous access. What is checked on this screen?

|||

Enable anonymous access is NOT checked. The only checked box in the Authentication Methods window is "Integrated Windows authentication". True for both Reports and ReportServer websites.