Problem connecting to SQL

gcouto
gcouto Member Posts: 11
edited 2008-04-17 in SQL General
Hi,

I'm having a problem to connect to my SQL Server (2005) in a specific computer.

I can connect to the SQL DB(using Dynamics NAV client) in my computer, but if try to do that in my partner computer I can't. The same situation with his login (in my computer works fine but not in his). The message we get is that user or password is invalid. So we think that the problem is in the computer, not in the login.

We tried to connect in his computer to SQL Server using the SQL Server Managment Studio but we can't too. In this case we got a timeout error.

Both computers have Windows Vista.

Any idea of what can be the problem and how to solve it?

Best regards.

Comments

  • nunomaia
    nunomaia Member Posts: 1,153
    Are you using SQL Server 2005 express?. By default in SQL Server express and developer edition remote connections aren't allowed
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • kine
    kine Member Posts: 12,562
    Exactly. If you are trying to connect to SQL which is on Vista box, it means that you are using Express or Developer edition. For these editions you need to configure the service to be able to accept remote connections - you can use "SQL Server Surface Area Configurator".
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • gcouto
    gcouto Member Posts: 11
    Hi,

    Thanks for the tips. I haven't done anything and the problem is solved. I can't explain how and why :shock:

    Sorry for the late answer.

    Best regards.

Categories