Changing server, user name and password

  • I have the SQL server setup and running on a Windows 7 Pro-64bit machine with no issues. However, I need to change the name of the machine in Windows as well as the user account. When I do this, the SQL server will not log in anymore.

    The software company that uses the SQL server for the software package has been less than helpful with any issues with SQL server.

    Is there a way I can change the computer name and user account name without breaking the SQL server login?

    Thanks

    Brian

  • changing the computer name will essentially change the sql instance name, this is likely the issue you are having. Supply the new servername or the IP address and retry the connection

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Thanks for the reply Perry.

    This is single machine in a small flooring office.

    I'll forge through and see if I can the proper places to change this in the management console.

    Brian

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

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