April 2, 2002 at 12:01 pm
The server NetBIOS name was changed on our SQLServer7 server. We had to run setup again to reconfigure the SQLServer installation with the new name. However, the value returned by:
select @@SERVERNAME
is NULL. If I run sp_helpserver, it gives me the new server name as expected. I though these two values should be identical.
Question: Will @@SERVERNAME = NULL cause me grief? I am having weird problems not being able to connect ADO recordsets and wonder if this "null" @@SERVERNAME is causing any problems.
April 2, 2002 at 2:57 pm
This should do the trick.
The following is from MS Knowledge Base article at http://support.microsoft.com/default.aspx?scid=kb;en-us;Q195759
Run SQL Server 7.0 Setup from the original product CD. Doing so will not reinstall SQL Server or any components; however, it will update SQL Server 7.0 internally to reflect the new Windows computer name. You also need to update SQL Server's internal servername by running the following two stored procedures:
sp_dropserver <old_name>
go
sp_addserver <newname>, local
go
If SQL Server is configured to listen on either the Multiprotocol or NWLink IPX/SPX network libraries, you'll need to remove them, and then add them back using the SQL Server Network Utility.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply