Member Avatar for JModak

Show error when I login to the SQL server management. First, I change the server name. Second restart the server/1st stop services the start services. Then I check the server name

SELECT @@servername AS 'ServerName'

using this line the show new change server name. Then I closed the window of SQL server then open it and type the new change server but show error. Please help me.... I use SQL Server 2008 r2. Windows authentication

Click Here

SELECT  HOST_NAME() AS 'host_name()',
@@servername AS 'ServerName\InstanceName',
SERVERPROPERTY('servername') AS 'ServerName',
SERVERPROPERTY('machinename') AS 'Windows_Name',
SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS 'NetBIOS_Name',
SERVERPROPERTY('instanceName') AS 'InstanceName',
SERVERPROPERTY('IsClustered') AS 'IsClustered'

EXEC sp_DROPSERVER 'JAYANTA'
EXEC sp_ADDSERVER 'SIASERVER', 'local'
Edited by Dani because: Moved to correct forum
  • 2 Contributors
  • 1 Reply
  • 5K Views
  • 2 Months Discussion Span
  • Latest Post Latest Post by sanjay.vaniya
Member Avatar for sanjay.vaniya

Right click on the server

click Properties

Go to the Security page

Under Server authentication choose the SQL Server

and

Windows Authentication mode radio button

Click OK

Restart SQL Services

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.