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

Where will i have to install ms sql?

Discussion in 'Plesk for Windows - 8.x and Older' started by pepsyxanh, Nov 24, 2004.

  1. pepsyxanh

    pepsyxanh Guest

    0
     
    After i remove msde, i install ms sql standart edition but i don't know where are the paths for install ms sql. In my computer have two path for that C:\website\mssql\data and C:\Program files\swsoft\Plesk\MSDE\MSSQL. Where will i have to config paths when i install ms sql for plesk know and run ms sql correct.
    Please help me
    Thanks!
     
  2. AbsolutelyFreeW

    AbsolutelyFreeW Guest

    0
     
    I've heard you can "upgrade" msde to sqlserver.. not uninstall/install it.

    the data path is for data I believe, so your real mssql should be the other..
     
  3. pepsyxanh

    pepsyxanh Guest

    0
     
    I never success for that. If any know how to config it run correct please tell me.
    Thanks
     
  4. cviviani

    cviviani Guest

    0
     
    Standard Path is "C:\Program Files\Microsoft SQL Server"

    Set - sql and windows - Authentication

    give to "SA" (SystemAdministrator) the same password as with plesk admin logon

    mssql or mysql does not depend on the path

    mfg Claudius Viviani
     
  5. pepsyxanh

    pepsyxanh Guest

    0
     
    I use SQL Server Enterprise from client and connect to SQL SERVER but i get error "SQL server does not exist or access denied ConnectionOpen(Connect())"
    anyone know please help me
    Thanks
     
  6. cviviani

    cviviani Guest

    0
     
    I hope the sql the servers run on the same maschiene as plesk.
    did you only install client tools?
    does the SQL Server service run?

    when ok
    start under Programms>Microsoft SQL Server> SQL Query Analyzer and try to logon on our SQL Server with "sa"

    can you logon successfully ?
     
  7. pepsyxanh

    pepsyxanh Guest

    0
     
    I installed ms sql on the same server with plesk and installed client/server. And the service for ms sql is running
    But i can't login to ms sql from another pc to this server.
     
  8. cviviani

    cviviani Guest

    0
     
    on the server with mssql and plesk

    run SQL Query Analyzer

    start under Programms>Microsoft SQL Server> SQL Query Analyzer and try to logon on our SQL Server with "sa" or us integratet Authentification

    can you logon successfully ?
    set password for "sa" or install mssql again and set the password for "sa"
     
  9. pepsyxanh

    pepsyxanh Guest

    0
     
    I login successfull from SQL Query Analyzer on my server. But i can't logint successfull from Client computer to this server.
     
  10. cviviani

    cviviani Guest

    0
     
    are you logged in with "SA" ? ? ? ? ?
    tell me please more

    and what you mean with client computer ??
    what is your application ??

    I think you make somewhat crazy and abuse plesk
    it is more one asks of as one from one client on mssql accesses, as of plesk
     
  11. pepsyxanh

    pepsyxanh Guest

    0
     
    I logged with user name SA.
    On client computer i connection with username and password SA to this ms sql server. I user SQL Enterprise & SQL Query
     
  12. cviviani

    cviviani Guest

    0
     
    is activ firewall?
    do you make the connection over the IP or over the netbios name ? (set client for microsoft network in the properties of the LAN network)

    ar the computers in the same subnet or it goes over a router?
     
  13. pepsyxanh

    pepsyxanh Guest

    0
     
    My server don't have any firewall. And it stay in GNAX. I make connection to ms sql on this server throw ip.
    Cviviani, do you have YM nick name? i will chat with you for details.
    Thanks
     
  14. cviviani

    cviviani Guest

    0
     
    aah

    is under the plesk panel under >system>server> service Microft sql server running

    got to the plesk panel under >system>server>database set the password for "sa"

    it doesn't help make a backup from plesk and make a new clean instalation

    Look howto install
     
  15. pepsyxanh

    pepsyxanh Guest

    0
     
    The service for ms sql started. And all login from client or server to ms sql is SA. I don't set firewall on plesk and on my network to now. Do you know active port 1433 of ms sql. I think i don't open and i don't know how to open it.
     
  16. cviviani

    cviviani Guest

    0
     
    you set the passwort to:
    >system>server>database set the password for "sa"

    for the clients you can create database user the must not have sa permission.
    it gives som application the needs administrator rights under mysql like typo3.

    sql goes over the localhost.
     
  17. pepsyxanh

    pepsyxanh Guest

    0
     
    I think plesk block port 1433 and 1434 so i can't login to ms sql from client. Do you know open these ports?
    System>server>database I get "Editing Credentials for Access to the Database
    Microsoft SQL server
    Server:localhost
    (Unable to change the database server name: one or several databases are used on this server by control panel )"
     
  18. cviviani

    cviviani Guest

    0
     
    ohh man

    set up your server new

    you can try the computer name on localhost to change :D

    localhost means 127.0.0.1

    otherwise you could not connect with the query analyzer.

    look to the log sql and event viewer

    one can perhaps make it - but

    set up your server new
    that saves time and you has a clean server (us plesk backup)

    I cannot help you any longer
     
  19. pepsyxanh

    pepsyxanh Guest

    0
     
    everything now work perfect. After i install microsoft sql sp3 it work well. I can't reinstall windows because more websites running on my server it can't stop. Thanks for support from cviviani
     
  20. sezhian

    sezhian Guest

    0
     
    Dear Friends
    This is sezhian,I am New To this Forum
    I am Using plesk for windows.
    I am using asp.net 2.0 and sqlserver2000 for dveloping my website
    In this regard ,i dont know how to create tables in my Database.
    And also i need the connection string to connect to the database
    pls help me.its very urgent.
    thanks
    urs'
    sezhian.k
    sezhian.pec@gmail.com
     
Loading...