Stuart McLachlan
stuart at lexacorp.com.pg
Sat Jan 22 23:52:59 CST 2011
When you delete a use and create a new one with the same name, that is NOT the same user. It has a different Security ID (SID). You will need to give rights to the new user all over again. One solution would be to shut down the SQL Server service, backup the database files then create a new instance and attach the databases to it. -- Stuart On 23 Jan 2011 at 0:07, jwcolby wrote: > Well this is annoying. It seems I deleted the user that I created the > instance of sql server with SSMS Security Logins object. Now I have > no authority to do anything. > > Is there a way to put it back in? I tried to create it over again but > I cannot seem to do so. In fact I recreated the vmDev\jwcolby user > but I can't even see the properties of that user, even though that is > me... > > I think... > > Am I just screwed? > > Can I even delete the server instance? > > Luckily I wasn't all that far along in defining databases but I have > probably a dozen hours involved in two specific databases. > > -- > John W. Colby > www.ColbyConsulting.com > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >