asked on Connect to sql 2019 failing
We recently installed sql 2019. We are trying to create an odbc from a windows 2008 server but it fails with error 17. Our knowledge of sql server is minimal so we are unsure how to proceed. We can connect from the 2008 server to the 2019 server using remote desktop.
How can we create a working odbc?
thanks.![odbc connect error]()
How can we create a working odbc?
thanks.
Microsoft SQL ServerDesktopsWindows OSWindows Server 2008SQL
Last Comment
baytowel
looks like you haven't enabled the TCP IP protocol for the new server
check this documentation from MS: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-or-disable-a-server-network-protocol?view=sql-server-ver15
ASKER
TCP IP was enabled on the sql server. After disabling it and then enabling it the sql service was restarted. Using odbc driver Sql Native the connection cannot find the server.
But it is clear that you are not using TCP IP to access the database. What is your connection string? You can specify to use TCP IP in your connection string by adding "Network Library=DBMSSOCN".
Why use ODBC in 2020 to access SQL Server?
Why use ODBC in 2020 to access SQL Server?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.