none
Problem with IIS and database in virtual machine RRS feed

  • Question

  • Hello

    I've a problem with database acces from IIS

    My solution has a database, a server, a federation STS, an identity STS and finally a client

    For test it, I create some virtual machine in a domain, one is for IIS applications (server, federation and identity, OS windows server 2008 R2) one for the client (OS windows7) and one for the database(Windows server 2008R2)

    I open SQL server to remote connection and create a user with Network service in my DB for access it.

    In debug with visual studio, everything works fine, I can access my database and connect.But in IIS it seems I cannot, I know the server part is working, my first call return a hardcode value and it's ok, but for federation and identity, i can't have access to database.

    Is anyone have an idea?


    • Edited by ange.fr Wednesday, May 23, 2012 10:13 AM
    • Moved by Mike Dos Zhang Friday, May 25, 2012 5:52 AM not a C# problem, though maybe the programming language is C# (From:Visual C# General)
    Wednesday, May 23, 2012 10:12 AM

Answers

  • Thank you for changing the topic.

    I've found the solution, just need to create a user in database and change the connection string in entity framework with user Id and password

    I do not have this probleme in local developement

    Now everything works fine.


    • Marked as answer by ange.fr Friday, May 25, 2012 6:58 AM
    • Edited by ange.fr Friday, May 25, 2012 6:59 AM
    Friday, May 25, 2012 6:58 AM

All replies