Event ID: 18483 Source: MSSQLSERVER

Event ID/Source search

Keyword search

Example: Windows cannot unload your registry file

EventID.Net Splunk Add-on

Build a great reporting interface using Splunk, one of the leaders in the Security Information and Event Management (SIEM) field, linking the collected Windows events to www.eventid.net. The EventId.Net for Splunk Add-on assumes that Splunk is collecting information from Windows servers and workstation via the Splunk Universal Forwarder.

Event ID: 18483 Source: MSSQLSERVER

Source: MSSQLSERVER

Type: Error

Description:
Could not connect to server '<server>' because '<login>' is not defined as a remote login at the server.

English: Request a translation of the event description in plain English.

Comments:
Ayman M. Galal
If you try to register the server (Publisher or the Subscriber) by using an IP address instead of a client alias or if the client alias is different from the actual SQL Server NetBIOS name, the Merge Agent may fail and you receive this error. See article ME321822.

Solutions:

A.
- Use the Master database:
USE master
GO

- Declare local variables:
DECLARE @serverproperty_servername varchar(100)
@servername varchar(100)

- Get the value returned by the SERVERPROPERTY system function:
SELECT @serverproperty_servername = CONVERT(varchar(100) SERVERPROPERTY(‘ServerName’))

- Get the value returned by @@SERVERNAME global variable:
SELECT @servername = CONVERT(varchar(100) @@SERVERNAME)

- Drop the server with incorrect name:
EXEC sp_dropserver @server=@servername

- Add the correct server as a local server:
EXEC sp_addserver @server=@serverproperty_servername @local=’local’

See article ME818334.

or

B.
Note: You may not have to reinstall Microsoft SQL Server to resolve this problem.
1. Log on by using an account that has administrative credentials.
2. Click Start click Programs click Microsoft SQL Server and then click Query Analyzer.
3. In the Connect to SQL Server dialog box click (local) in the SQL Server list and then click OK.
4. In SQL Query Analyzer type the following code:

sp_dropserver ‘old_name’
GO
sp_addserver ‘new_name’ ‘local’
GO

Note: In this code, old_name is a placeholder for the old name of the computer and new_name is a placeholder for the new name. Type the actual old name and new name instead of these placeholders.
5. Click Execute Query (F5) to run the query.
6. Quit SQL Query Analyzer.

Note: After you run the sp_addserver stored procedure you must restart the SQL Server service for the change to take effect. After the server is restarted confirm that the correct value of the new server name is returned by executing the following commands in Query analyzer:
Select @@servername Select ServerProperty('machinename')
The names returned should match in spelling and case.

See article ME899159.

In my case, I used solution B and the problem was solved.
Click if the comment is good!

EventID.Net
See the link to "Microsoft event 18483 from source MSSQLSERVER" for information on this event.
Click if the comment is good!

Private comment: Subscribers only. See example of private comment

Links: ME321822, ME818334, ME899159, Microsoft event 18483 from source MSSQLSERVER

Search: Google - Bing - Microsoft - Yahoo - EventID.Net Queue (0) - More links...

Feedback: Send comments or solutions - Notify me when updated

Printer friendly