we have an SQL Server called sql01. On this,we have attached a number of databases, including the SSRS report server, which people can access. I have created a new database called ToolingSystem and added some data into table in it. I have also written an application that access this database using the following connection string:
Data Source=sql01;Initial Catalog=ToolingSystem;Integrated Security=True
But no one is able to see the data but me and the people in my IT group. Is there something I need to do in order to allow people to connect to this server/database (I don't know which). They are getting a "Login failed for user 'username'". What i'm looking for is people in our domain to see this information. It seems they can see the server (like the reporting stuff) but not my new database
I created a user for the database and am using it in the connection string but its still not letting me log in.