Problem to create ODBC in PLESK 10.4.4 with SQL Server driver

[iHosting]

I am trying to create an ODBC DSN connection in PLESK 10.4.4 with Microsoft Windows 6.0;build-6002;sp2.0;suite1296;product3 and MS SQL Server 2008 but when click in "test connection" i receive the following error:

Error: Unable to connect to the data source using the defined settings. Server has returned the following error:
ODBCError 08001: [Microsoft][ODBC SQL Server Driver][Shared Memory]Conexión no válida.
ODBCError 01000: [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Invalid Instance()).

Any one had experience with this problem?

 

[minosj]

Hi,

did you checked the odbc service is running in the server ?

Thank you.

 

[Plesk_kidv]

When creating the ODBC Connection change the [server] name to the instance name of your MSSQL server. So you would change it to something like .\MSSQLSERVER2008 or .\MSSQLEXPRESS . Make sure SQL Server Browser is also running from the SQL configuration manager.