Tech Off Thread

2 posts

Forum Read Only

This forum has been made read only by the site admins. No new threads or comments can be added.

Reconfigure SQL Server authentication

Back to Forum: Tech Off
  • User profile image

    I have started to use some of SQL Server 2005 and have it installed in a Virtual Machine running Windows 2003 Server setup.  This server is in its own workgroup.  However when I installed the server, I chose Windows Authentication.
    I would like to use the SQL Managemnt Studio from my own PC to login and work on it, however I can't connect due to problems with Windows Authentication.  Can I change it to login in as SA?  I'm a novice to SQL so sorry for the stupidity.  

  • User profile image

    From within SQL Server Management Strudio on the virtual server, connect to the local sql instance and them right click on the name of the server. Select Properties. On the modal window, click on the Security node on the left and then change the Server Autentication to SQL Server and Windows Authentication.


Conversation locked

This conversation has been locked by the site admins. No new comments can be made.