How do I connect to a SQL Server database?

Nathan Schroeder shared this question ago

Answered

I am trying to connect to my SQL Server database, but I keep getting connection refused errors. What do I have to do to get this to work?

The same question

Replies (1)

Nathan Schroeder ●

Getting Yellowfin to work with SQL Server can be a little tricky due to the security settings with in SQL Server

Typically it is best to use SQL Server Authentication rather than Windows Authentication, but both can be done. The instructions below are specific to SQL Server Authentication, but many of the same steps apply.

Open SQL Server Configuration Manager
Open SQL Server Network Configuration
Click on the server
Ensure TCP/IP is enabled by right clicking tcp/ip and selecting Yes for the Enabled attribute
Tab over to IP Addresses
Scroll to the bottom under IPAll
Clear the value under dynamic ports
Enter your port under TCP Port “1433 is default”
Restart SQL Server
Log into SQL Server Management Studio
Create a user and give the user sysadmin permissions
Use sql server authentication instead of windows for that user
Save the user
Go to the object explorer and right click the server name
Select properties
Select Security
Change windows authentication to sql server and windows authen
It should work now!

Reply URL