Skip to main content
SRB SIS Knowledge Base

Error: Cannot create a connection to data source 'SchoolLogic'

Error Message

Cannot create a connection to data source 'Schoollogic.'  Login failed for user. Most commonly, this comes up when trying to run reports but a new installation or a new user could run across it when simply trying to access SchoolLogic.

Here's a look at the actual error:

Cannot create a connection to data source show 1.png

Resolution

The user listed in the error -- RHOLZER\Reporter in the screen shot above -- does not have access to the SQL DB.

1. Launch SQL Management Studio, open Security, right-click Logins. Click New Login..

Cannot create a connection to data source shot 2.png 

 

2. Fill in the Login name which came up on the error and enter/confirm a password.

Cannot create a connection to data source shot 3.png

 

4. On the left, click Server Roles. Then check everything you see here:

Cannot create a connection to data source shot 44.png

 

5. In the end, your list of users will include the username you've been editing:

Cannot create a connection to data source shot 5 FINAL.png

  • Was this article helpful?