Issue:
You receive the "SQL Server does not exist or access denied" error during adding SharePoint farm. The server exists and you have all the required permissions. You can successfully connect to the SQL server via ODBC or UDL test. The server running discovery process is 64bit. You have SQL alias configured for SQL server.
How to confirm:
The discovery is 32 bit process but when you perform ODBC/UDL test it is running as 64bit application. To run the 32bit ODBC connection, run the following application:
You receive the "SQL Server does not exist or access denied" error during adding SharePoint farm. The server exists and you have all the required permissions. You can successfully connect to the SQL server via ODBC or UDL test. The server running discovery process is 64bit. You have SQL alias configured for SQL server.
How to confirm:
The discovery is 32 bit process but when you perform ODBC/UDL test it is running as 64bit application. To run the 32bit ODBC connection, run the following application:
C:\Windows\SysWOW64\odbcad32.exe
How to fix:
Compare 64bit and 32bit SQL aliases.
For 64 bit client aliasing use cliconfg.exe from system32 (already in path and you can just type and run).
For 32 bit client aliasing switch to C:\Windows\SysWOW64 folder and run cliconfg.exe from there.
For 32 bit client aliasing switch to C:\Windows\SysWOW64 folder and run cliconfg.exe from there.
Configure 32bit aliases the same way as 64bit:
No comments:
Post a Comment