Hi all, I know very little about SQL Server but so far we have been managing to login to our DB via the servers Administrator account. Now we are required to not use this and use proper users' Windows accounts. So I have created a new user in Databases>Our Database>Security>Users
The new user (lets say john.smith) can now get past the 'cannot open database requested by the login' error. However, they are now getting...
'There was a problem connecting to the database. The exception was The EXECUTE permission was denied on the object 'getalerts', database 'OurDatabaseName', schema 'dbo'
This default schema for this user was Blank but after the first login attempt this field has now changed to 'dbo'
There are a lot of tick boxes (I'm looking at Database Role Membership) but I don't want to go ticking everything when its not recommended.
Would someone be able to provide some advice please?