Post reply

Permissions messed up with Service Pack?

  • November 8, 2010 at 8:23 am

    #231094

    I installed SP1 and SP2 on a SQL 2008 instance. Before the service packs, I could access the databases in the instance using Windows Authentication. Since then I can not. I'm not too familiar with permissions in SQL Server. How can I check/correct this issue.

    (Edit: I can still get in using sa but I am having some issue with an application that uses the DB)

  • November 8, 2010 at 12:24 pm

    #1247829

    first off you could have gone straight to service pack 2 and missed out service pack 1 install, they are cumulative.

    to fix your problem, log onto server with SSMS, right click server name, select properties, got to security, select windows and SQL authentication, OK that, restart SQL.

    ---------------------------------------------------------------------

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply