Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2008
    Posts
    28

    Unanswered: i want to connect to sql server 2005 from other computer

    example :
    i have 2 computer
    computer 1 : This is my sql server 2005 is Database of Local
    computer 2 : This is my computer

    work of it:
    computer 1 : use program sale product and has database at here
    computer 2 : use program the same but don't has database

    computer 2 : use database from computer 1

    How do?
    computer 2 has to install sql server 2005 ?

    This is small business
    I think i'll use sql server 2005 developer
    true or false?

    thank you very much

  2. #2
    Join Date
    Nov 2008
    Posts
    23
    1.
    computer does not have to install SQL Server, unless you want to access the database on computer1 using sql server client like Sql Server Management Studio. In that case you will need to just install the client components on computer2.

    2.
    You can remote into computer1 from computer2 and do what ever you want to do.

    3.
    I am not sure what is your application (VB, java etc)accessing the database is written in. The application may need a change on computer2 to access the database on computer1

    4.
    Definitely you need not have to install SQL Server on computer2

    hope it helps
    jambu

  3. #3
    Join Date
    Nov 2008
    Posts
    23
    you cannot use sql server developer. it is not for production/commercial use

  4. #4
    Join Date
    Aug 2008
    Posts
    28
    if i use windows server 2005 and have database is use SQL server 2005 (vb.net 2005) " i like 2005"

    what's model of sql server for small business
    i don't want to use sql server 2005 express

    new question :
    i ever find file .sql in program but i don't know how to do it?
    i think that file for restore to sql server
    true or false

  5. #5
    Join Date
    Nov 2008
    Posts
    23
    Stabdard Edition

    .sql is just a script file. I have never seen it being used like in Oracle, where you can that script file with the RUN command

  6. #6
    Join Date
    Aug 2008
    Posts
    28
    i want to know it?
    because i think it can be help me for program database
    can you help me?

  7. #7
    Join Date
    Nov 2008
    Posts
    23
    you want to know about the Standard Edition or the .sql rfile? or both :0

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •