1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

IIS7 and MS SQL Server 2008

Discussion in 'Plesk 9.x for Windows Suggestions and Feedback' started by Andy_Acute, Dec 16, 2009.

  1. Andy_Acute

    Andy_Acute Guest

    Can anyone point me in the right direction with creating the database connection?
    I don't want to use a dsn, but rather a dsnless connection.
    I'm not sure if this can be set up through Plesk!
    My connection works fine locally, and i've changed it to suite the server name.
    I'm using the following:
    "Driver={SQL Server}; Server=myservername; Database=mydatabasename;"
    Do i need to add the UID and PWD even though i'm using Windows Authentication? Although I think i have tried that already.
    My web application is in Classic ASP.
    I can connect to my database through RDP and SQL Server Management Studio and create Quiries fine.

    I just can't connect my web application to my database through the web browser!

    Any advice much appreciated.
    Thanks in advance