locked
Changed Computer Name now cant connect to SQLExpress DataBases, HELP ! RRS feed

  • Question

  • User1063681570 posted

    I kept getting injected so I started taking some mesures against it. Changed my computer name - now cant connect to any database. When I go to attach a database it says that It does not see it. When I run the application I get an eror saying that the ComputerName/Username cant login... But i added the roles and users into the SQL express Studio. Can someone help me out with this. Spend about a day and still cant figure this thing out. Thanks...

     

     

    Wednesday, August 20, 2008 3:12 PM

Answers

  • User-1811063981 posted

    Hi

    In SSME, if you issue SELECT @@SERVERNAME, what do you get? Still the old computer name? If so, do the following:

    sp_dropserver 'oldname[\myinstance]'
    GO
    sp_addserver 'newname[\myinstance]', local
    GO

    The code in [], you only need if you're running a named instance. Now, verify that the change has properly taken effect by doing another SELECT @@SERVERNAME.

    Regards

    Steve

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, August 21, 2008 1:36 AM