Tag Info

Hot answers tagged

1

One option is create login with default database option and add role member to login user in database USE [master] GO CREATE LOGIN [CUREMD\NewLogin] FROM WINDOWS WITH DEFAULT_DATABASE=[AdventureWorks] GO USE [AdventureWorks]--- Change DB name to Sharepoint DB Name GO CREATE USER [CUREMD\NewLogin] FOR LOGIN [CUREMD\NewLogin] GO USE [AdventureWorks] --- ...


1

View the default database in user's properties, may be it is master, if so, then change it


1

Verify if your user has permision to connect to database Engine. Right click on Logins -> Properties -> Status. Or grant CONNECT for user. CREATE LOGIN [mydomain\mygroup] FROM WINDOWS; GRANT CONNECT SQL TO [mydomain\mygroup]



Only top voted, non community-wiki answers of a minimum length are eligible