I am looking for a resource that will speak to the process of how to create a SQL Express database within VS 2005 - create relationships within the Database Diagrams (right now it complains that it does not have a valid dbo user and that I do not have permission impersonate the dbo user - if i tel it to grant me access it gives me the same message) - what security issues need to be considered as far as the SQL Express stuff is concerned.
I am also wanting to know what pieces I need to have on my Internet and Intranet web servers so that when I delpoy my .net 2.0 app that the servers will be able to deal with the SQL Express database that gets copied out there? Should SQL Express on the web server be set to windows auth or mixed mode auth? If I choose windows auth does that mean that the ISP (internet server) has to have an NT account created for my web app so that I can connect to the SQL mdf?
I guess I am just kinda struggling with the process from creation of the database to making sure that when I deploy the application that it will be available.
Any help would be appreciated!
Thanks,
Derek
Try these links below download the full developer edition in the first link and the second link is a guided tour of Visual Web developer which includes SQL Server related development. The developer edition installs with the BOL( books online) the best in the RDBMS(relational database management system) business, just run searches for all you need to know about the product, it is better than most books on the product. Hope this helps.
http://www.microsoft.com/sql/2005/productinfo/ctp.mspx
http://beta.asp.net/GuidedTour/
No comments:
Post a Comment