ODBC Data Source Error

[gustaf111]

Hello,

I hope anyone could help me with this problem ...

1) I have installed MS SQL Server Express 2008 on two machines(XP, SP3) within the same LAN.

2) I have created a login and password (SQL Server authentication)

3) I have created a database and attached the databsse to the SQL Server. The user have access to the database.

4) The SQL Server is set to "SQL Server and Windows Authentication mode"

5) All firewalls are disabled.

When I tried to create a ODBC Data Source to the SQL Server on the other machine I get an error (se attachment).

I create a System DSN which look like this:

SQL Native Client
Server: <My computer name>\SQLEXPRESS
LoginId = Test
Password: 1qaz2wsx

Do I need to enable any ports ? When I connect to the local machine it works fine, but to to the other machine So the Login and password is okay. I can ping the other machine, login to the machine, but not connect to the SQL Server.

Please, help.

Thanks Gustaf

 

[simian336]

Your attachment does not show up for me..

Simi

 

[gustaf111]

Hello Simi,

You have to download it ... sorry

Gustaf

 

[DataOne]

the id and password in #3 needs to match odbc connection id and password. then do a test connection

 

[gustaf111]

Thanks 'DataOne' I have tested that with no success

The error look like:

Connection faild:
SQLState: '08001'
SQL Server Error: -1
[Microsoft][SQL Server Native Client 10.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified[xFFFFFFFF]
Connection faild:
SQLState 'HYT00'
SQL Server Error: 0
[Microsoft][SQL Server Native Client 10.0]Login timeout expired

 

[DataOne]

1) Is SQL Browser running? Start>Run>type Services.msc and hit Enter. Find SQL Server Browser and make sure it's running and that the startup type is automatic. If it's running try restarting it.

2)It could be an issue with how you specified your server name in your connection string. Double and triple check that. ==> Error Locating Server/Instance <==