locked
Connecting to local SQL server with third party software (EMS Data Export) RRS feed

  • Question

  • Hi all,

    I'm currently running a SQL Server 2005 setup (or so I believe) to use Windows Authentication. When I load Management Studio, the following popup box appears:

    Server Type (greyed out): Database Engine

    Server Name: Thor

    Authentication: Wndows Authentication

    U/N and P/W: greyed out

    I can connect to my databases using PHP by specifying 'Thor' as my DB host, the DB name and then the username and password of a user I created.

    The problem is that I cannot connect to my local server using EMS Data Export 2005 for SQL Server. I can use it to connect to a remote SQL DB on our web server but if I try to connect locally, it generates an error saying that the 'SQL Server does not exist or access denied'.

    Does anyone have any experience with connecting to a local SQL server? I'm assuming that I need to setup my server to allow for external connections or something but I'm in the dark on the matter.

    Any help would be very appreciated!

    Thanks.

    Monday, June 19, 2006 4:27 PM

Answers

  • Hi,

    make sure you enabled the remote connection option: http://www.sqlserver2005.de/SharedFiles/Remoteconnection.jpg if you want to connect via TCP/IP. If your SQL Server uses another port than 1433 you either have to specifiy the port within the syntax machineName\Instancename,Portnumber (or if you only have a default instance with another port number leave out the \InstanceName) or have to turn on SQL Server Browser which redirects client requests to the appropiate port.


    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
    Tuesday, June 20, 2006 3:09 AM