SQL Express 2005: sp_attachsubscription Query

Posted on 2009-02-13
Last Modified: 2012-05-06
Hi all,

I have a query that I'm hoping someone can assist me with. Apologies in advance for the lenghty post. Some background:

We are an IT company supporting a client who uses a software package for billing. The database for this software is currently running on an SQL Express 2005 installation and being accessed remotely using a custom port. All users can connect to this database and use the software without any problems from their respective client machines (located remotely to the DB). The connection is established using a FQDN which is mapped to the server's hardware firewall. The firewall then forwards requests on the custom SQL port to the server.

We recently had a complaint from one of the user's regarding a form they are attempting to generate from within the software. The error message they receive is:

"Could not find server GGPBLAID\PIBLAID in sys.servers. Verify that the correct server name was specified . If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers."

I am by no means an expert on SQL Server. I can install and maintain a basic installation and have worked with backups etc but this message means nothing to me. I have done some background reading and attempted to use the procedure referenced (according to the Microsoft website) and although I did not encounter any problems with this, it did not resolve the problem.

I have spoken to the developers of the software and they have assured me that it is not their problem. They mentioned that they could fix it (so it is their problem!) by rewriting sections of the software but this would take a very long time. One of the developers pointed me here:

According to him the problem appears to be related to the period (.) that is used in the FQDN to reference the SQL server. Prior to this remote environment the client worked from a local SQL server and did not experience this issue. The GGPBLAID/PIBLAID mentioned in the error message is the local server name and instance of the server. I am unsure as to why this is being reference as opposed to the FQDN but am assuming that this is part of the problem.

Is this problem resolvable and if so how would I go about doing so?

Any information that someone could provide would be greatly appreciated. The client is in desperate need of having this fixed as soon as possible and, as with most of the third party software we have seen in the past the responsibility has been put on us!

Thanks in advance guys, hope someone can help me out.

Edit: This problem does not occur when running the software in question on the SQL server itself.
Question by:usk1
    LVL 25

    Expert Comment

    does the user have a local version of sql installed to run the app locally which then goes out to the remote db

    sounds like you need to add the linked server locally

    Author Comment

    Hi Slam,

    Many thanks for the reply.

    As far as I am aware there are no local versions of SQL installed on any of the client machines. The software connects directly to the DB remotely. I am unfamiliar with exactly what the software puts onto the machine during the installation process but do not believe there are any SQL components installed.

    With regards to the link, I am ending up at a page for the Microsoft System Center Configuration Manager - is this where I should be looking? Do you think that I need to do something on the local machines as opposed to making a change on the SQL server itself?

    Thanks again Slam
    LVL 25

    Accepted Solution

    well the error message you are getting points to there being no linked server set up for the sp that is trying to run,

    you would need to look at the form that isnt running and from the code identify the process that it tries to initiate. With that infromation you can trace it backt o the stored procedure that is trying to occur with that form and that shoudl identify where teh problem lies.

    if you can get to teh code and identify teh proceudre paste teh code here and we can try and sort it for you.

    Apologies for delay

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now