usk1
asked on
SQL Express 2005: sp_attachsubscription Query
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:
http://support.microsoft.com/kb/308714/en-us
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.
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:
http://support.microsoft.com/kb/308714/en-us
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.
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
sounds like you need to add the linked server locally
http://www.microsoft.com/technet/prodtechnol/exchange/guides/DCM/28863eac-af5d-4997-aa6e-358ad7d782fe.mspx?mfr=true