Post reply

Server Name in Errorlog I different than physical

  • April 8, 2003 at 4:54 pm

    #58778

    Hi All,

    I am not understanding why my errorlog is displaying worng server name as my server name. The Server Name in Errorlog is different than physical name of the server. Any Thoughts??

    Regards,

    Murali Damera.

    .

  • April 8, 2003 at 5:09 pm

    #453521

    Are you looking at the Event Viewer application logs or the sql server logs? If it's the latter, what is the name of your SQL server registration in Enterprise Manager? Is that different than your PC name?

    Darren


    Darren

  • April 8, 2003 at 9:20 pm

    #453531

    I am looking at the SQL Server Error Logs. My Server Name (Physical Machine Name) & SQL Server Name is the same. Which is exactly the same same it is registered in EM. But SQL Server Error Logs are showing a different name.

    .

  • April 10, 2003 at 4:03 pm

    #453806

    Any Thought?!?!?

    .

  • April 11, 2003 at 1:16 am

    #453834

    Try running select @@servername. If the result is not the same then you need to drop the name using sp_dropserver and then re-add using sp_addserver with local option - check Books Online. Warning this requires SQL services to be restarted.

  • April 13, 2003 at 6:30 pm

    #453998

    Excellent. Thank You neiljacobson.

    I did try this (select @@servername) and this miraculous name did apprear there. I am going to drop and add the server again. Actually this server name is being stored in sysservers table.

    .

Viewing 6 posts - 1 through 5 (of 5 total)

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