Post reply

Best way to set up SQL Server 2005 to work with ASP.NET 3.5

  • May 22, 2009 at 9:39 am

    #205162

    I would like to know the best way to set up SQL Server 2005 to work with ASP.NET 3.5.

    I have both applications installed on Windows Server 2003 Standard Edition. I have a registered domain but my server does not use Active Directory or function as a domain controller. I am also using BlogEngine.NET from Codeplex with SQL Server 2005 as the backend.

    Right now I am getting errors on both my web pages and blog because I attempted to set up a user to access one of my databases through a user control bound to an ObjectDataSource configured to use parameterized stored procedures. I am getting login errors now and I can't access my blog anymore since making these changes.

    What I would like to do is backtrack and start again from scratch and get this set up securely and properly. Right now I have identity impersonation turned on in Web.config and I think that may be interfering with my blogUser since I'm using a different user name and Windows Authentication.

    I need help figuring out how to undo the mess I've created and how to properly set up SQL Server 2005 to work with my ASP.NET 3.5 website.

  • May 22, 2009 at 2:33 pm

    #999174

    Hi smallbytes_99,

    I've sucessfully setup sql server on aspnet. You probably want to make sure that you're using the right version of IIS. IIS 7.0 only works with Vista, I have version 5.1 running. Then you want to make sure the asp web extension is enabled. If it isn't then go to a cmd prompt and type, 'c:\windows\microsoft.net\framework\v2.0.50727 or 'framework64' if you have 64 bit. and type, 'aspnet_regiis.exe -i' this will register asp.net as an extension.

    Then extend a vitual site in IIS and make sure all your settings are correct.

    I also have sql server configuraion manager installed as a service. If you have that make sure that the services are running. I was having some problems setting it up too, and then I realized I had to enable my named pipes as well.

    If you give an example of some of the errors it might be easier to help.

    I hope this helps a little!

    Michelle

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply