Sql Server or Windows Authentication not working

Posted on 2009-04-16
Last Modified: 2012-05-06
I am unable to log into sql server with my sa account or windows account. It was working before. The error im getting......
A connection was successfully established with the server, but an error occurred during the login process
Question by:u2envy1
    LVL 25

    Expert Comment

    Try enabling the TCP/IP protocol.. using the Surface Area Configuration Utility..

    Author Comment

    Still nothing.......

    Author Comment

    reporting services was not working for remote clients so I was messing around with the Encryption Keys.
    I do not have any backup of it now I cant log into sql server.

    Accepted Solution

    Permissions on CAS

    Author Comment

    Found Solution

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now