Login Failed to Newly Created SQL Database
Posted on 2016-10-19
Running SQL Express 2012 and have created a database "Admin_Data".
Using ODBC connection I can connect to the system databases but get an error on the "Admin_Data"
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Login failed for user 'DOMAIN\username'.
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot open database "Admin_Data" requested by the login. The login failed.
Disconnecting from server
I cannot see what the difference is between the 2..
Any help gratefully received