Articles in this section

See more

Why SQL Auditor can't refresh schema with TCP/IP protocol disabled in SQL Server Configuration Manager?

Avatar
SSW Admin
Follow

I got "[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())" when SQL Auditor was refreshing schema (TCP/IP protocol disabled in SQL Server Configuration Manager), how to resolve this problem?

connecttoserverfailed.gif

Please follow the 2 steps to figure this out:

1. make sure the SQL Server service is running; 2. SQL Auditor is using SQLMDO object to retrieve the schema from your databases, so you may need to check if the required Protocols are enabled in SQL Server Configuration Manager:

Normally, there are three parts in “Server” or “DataSource” field in the connection string. <Prefix><Server>\<InstanceName>, in the server part, it could be any of those: a. “.” b. “(local)” c. “localhost” d. <machinename>> e. “127.0.0.1” f. FQDN(Server Fully Qualified Domain Name) g. <IpAddress>

  • If you are using as server part in your connection string, then you need to enable Shared Memory Protocol;
  • Or if you are using a, b, c, e, f or g, or "tcp" prefix for server part in your connection string, then you need to enable TCP/IP Protocol or replace it with <machinename> (and remove "tcp" prefix);