[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL Express 2005: sp_attachsubscription Query

Posted on 2009-02-13
3
Medium Priority
?
336 Views
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:

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.
0
Comment
Question by:usk1
  • 2
3 Comments
 
LVL 25

Expert Comment

by:slam69
ID: 23632187
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

http://www.microsoft.com/technet/prodtechnol/exchange/guides/DCM/28863eac-af5d-4997-aa6e-358ad7d782fe.mspx?mfr=true
0
 

Author Comment

by:usk1
ID: 23648500
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
0
 
LVL 25

Accepted Solution

by:
slam69 earned 2000 total points
ID: 23680923
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
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

830 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