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

SQL Server Express 2005 Not Working

Discussion in 'Plesk for Windows - 8.x and Older' started by webhostheaven, Jan 27, 2006.

  1. webhostheaven

    webhostheaven Guest

    I just installed SQL Server Express 2005 fresh (no MSDE) - Plesk does not recognize it under Components Management. When I go to System->Databases and try to put in the host information manually, it does not connect either. However, using SQL Express Connection Tools, I am able to connect to the database with the sa password without a problem. How can I get Plesk to recognize my install of SQL Server Express 2005?
  2. webhostheaven

    webhostheaven Guest

    If anybody runs into the same problem, this is how I fixed it: uninstall SQL 2005, install MSDE, configure it to work with Plesk to make sure everything is working OK. Uninstall MSDE. Reinstall SQL 2005, (I made sure it ran under Default Instance rather than SQLExpress), configure tcp/ip for sql server 2005 express and you should be good.
  3. sergius

    sergius Golden Pleskian

    Nov 6, 2005
    Likes Received:
    You should specify instance name for Plesk > Server > Services > Databases > Microsoft SQL Server > Server name. SQL Express instance is "sqlexpress" by default. You may type ".\sqlexpress" in Server name.
  4. Soulhuntre

    Soulhuntre Guest

    Is there any hope that SQL Server 2005 will actually be fully supported? Right now it is only semi-sort of supported.

    The permissions need to be set up so that the IIS instance can mount and dismount databases under SQL Server and Express the right way - allowing for .NET 2.0 development int he pattern Microsoft reccomends.

    My other (ignored) post on the topic.
  5. Subtle

    Subtle Guest