Post reply

connecting to sql server from another computer

  • October 3, 2005 at 6:20 am

    #91449

    I have SQL Server installed on my old computer.  I just got a new computer and am transfering all of my data from the old computer to the new one.  I was trying to connect from the new computer to the old one in sql server to copy the databases onto my new computer.  For some reason, SQL Server is not finding the server on my old computer although I have permissions and the correct passwords, etc.  Is there some reason why the server on my new computer is not finding the server on my old computer?  Any suggestions?  Is there something I need to do?

  • October 3, 2005 at 6:40 am

    #594523

    Theare may be a problem of network?

    Be sure that your network cable is connected properly?

     

     

  • October 3, 2005 at 7:26 am

    #594537

    Why not just detach the dbs on the old computer, copy them across using Explorer and then attach on the new PC?  This takes SQL Server out of the equation.

    Also, you talk about SQL Server not 'finding' the old server.  Do you mean that the server does not appear in a drop-down box?  It may just be a case of you needing to manually type in the name/IP address of the old server.

     

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • October 4, 2005 at 1:37 am

    #594738

    Also worth checking the instance name on your old computer. If you have ever upgraded or re-installed SQL Server on the old machine you may need to specify the instance name when you give the connection string.

    computername\instancename

    This has caught me out once or twice...

    David

    If it ain't broke, don't fix it...

  • October 4, 2005 at 6:51 am

    #594803

    Could be a DNS issue...can you ping the machine ?  If you are connecting to the default instance, you can also try doing a telnet to the machine on port 1433 (unless you are running the SQL Server instance on a separate port).  If all this still fails, try creating an alias via the client network utility.

  • October 4, 2005 at 11:46 am

    #594943

    When you say you can't find your "Old" sql, is the old computer using a desktop version of SQL2000?

    Desktop version db's aren't accessible from other computers. Easier to detach/reattach as mentioned in an earlier post.


    Greg H

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply