If a Database controller cannot read, the SQL Server itself may need setting up. Your database administrator should check the following:
|
Problem
|
Cause and Fix
|
|
Other devices cannot reach the server
|
TCP/IP is disabled on the server, the server has no fixed port, or the firewall is blocking it. Ask your IT department.
|
|
Login fails
|
SQL Server logins need the server to use mixed-mode (SQL Server and Windows) authentication. A login created with "User must change password at next login" ticked cannot connect until its password has been changed.
|
|
Connects, but no data
|
The login needs a user in that database with read access (the db_datareader role).
|