Problem connecting to SQL

gcouto

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.

nunomaia

Are you using SQL Server 2005 express?. By default in SQL Server express and developer edition remote connections aren't allowed

kine

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".

gcouto

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.