SQL Server – “SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, ‘{old_name}’. (Replication.Utilities)”

If network name or server name is changed and you want to setup the server for replication you’ll receive the following error message:

SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, ‘{old_name}’. (Replication.Utilities)

To get the Current Server Name (Instance Name) run these two queries in Microsoft SQL Server Management Studio that return old_name

sp_helpserver
select @@servername

Solution:

Run this:

sp_dropserver 'old_name'
go
sp_addserver 'new_name','local'
go

then start Command Prompt Window (Start -> Run -> cmd) and execute the following command:

net stop mssqlserver
net start mssqlserver

to restart SQL Server Service.

Did my solution solve your problem?

HOW TO read text from data type Image of Microsoft SQL Server [VB.NET]

The data type image of Microsoft SQL Server is used to store
Variable-length binary data from 0 through 2^31-1 (2,147,483,647) bytes.

The following sample code show how to read text from data type Image using VB.NET:

Dim query As String = "SELECT [Image Column] FROM MyTable"
Dim conn As New SqlConnection(connString)
Dim cmd As New SqlCommand(query, conn)

conn.Open()
Dim rdr As SqlDataReader = cmd.ExecuteReader(CommandBehavior.SingleRow)

Try
    If rdr.Read() Then
        Dim i As Integer = rdr.GetOrdinal("Image Column")
        If Not rdr.IsDBNull(i) Then
            Dim bufferSize = rdr.GetBytes(i, 0, Nothing, 0, Integer.MaxValue) - 1
            Dim outbyte(bufferSize) As Byte
            rdr.GetBytes(i, 0, outbyte, 0, bufferSize)
            Dim enc As New System.Text.ASCIIEncoding
            MyTextBox.Text = enc.GetString(outbyte, 0, bufferSize)
      End If
    End If
Finally
    ' Always call Close when done reading
    '
    rdr.Close()

    ' Always call Close when done reading
    '
    conn.Close()
End Try

Did my HOW TO help you?