Posted  05 Feb 2009 - 08:17:27

Category: SQL

Can not create login, set permissions in SQL SSMS

When you basically try to change anything on your local MSSQL database (in my case SQL express 2005) you get the message that you don't have sufficient rights, although you are using a Windows Login admin user account.

My best solution so far is to run the SSMS (SQL Server Management Studio) as an Admin user. To do this, right click on the shortcut of it and choose "Run as Administrator". I'm using Windows 7 but I can imagine this happening on Vista as well.


© SolutionCottage 2008-2011 9/24/2017 1:09:54 PM