Solved

Creating Linked SQL Servers

Posted on 2016-09-12
7
53 Views
Last Modified: 2016-09-20
Our consultant firm for Dynamics GP is wanting to charge us for 15 hours to create a linked server between two SQL servers.  How can that possibly take 15 hours?
0
Comment
Question by:Bill Lalor
7 Comments
 
LVL 14

Expert Comment

by:Megan Brooks
ID: 41795336
Are you asking "what can possibly go wrong?"

Setting up an insecure linked server can be pretty quick. I have never had the time or patience to get a secure link working, but then I have been able to use SSIS (or DTS before that) and have never needed a linked server. It sounds like you don't have a choice.
0
 
LVL 18

Accepted Solution

by:
Steve Endow earned 500 total points
ID: 41795360
Hi Bill,

It depends on what the 15 hour proposal includes.  What is "in scope"?

If your SQL servers are both on the same LAN at the same site and the project does not include anything other than actually linking the SQL Server, then 15 hours seems ludicrous, and might be a sign that your GP partner doesn't know what they are doing.  I just linked two of my development SQL Server instances in under 60 seconds, which included me looking up where to find the Linked Servers folder in Management Studio (since I rarely do it).  In the real world, it could potentially take a few hours of back and forth communication to coordinate security, logins, permissions, etc. on the remote server, plus time to setup and test it, but 15 hours would be a stretch just for that one task.

On the other hand, if linking the SQL Servers is just one small task of a larger project, then sure, it could easily require up to 15 hours to complete.  

For instance, if you have a server off site or hosted at a data center, or as Megan notes, if the connection requires security (such as a VPN), then that will likely take several hours just to sort out how to best setup the connection.  And if that 15 hour estimate includes time to test connectivity to the remote databases and research databases and tables and sort out extra security on those objects, that would take more time.  And if the project involves having a query or report that retrieves data from the remote server, there's several hours more.  If it involves any replication of data from one server to another, then that's even more time.  If all of those tasks are "in scope" for the project, then sure, 15 hours might be a very reasonable estimate.

If you don't know what the 15 hours includes, I would ask for a Statement of Work / Proposal that clearly outlines what the consultant will be doing for you, and a breakdown for how those 15 hours will be used.  That type of proposal document should be easy for them to write up and submit to you for your review and approval.

If the proposal doesn't seem to justify the estimated hours, you can get another GP consultant or firm to look at it and give you a second opinion.  There are lots of GP partners and consultants who could review it.

Hope this helps.  Let me know how it goes.

Thanks,

Steve Endow
Microsoft MVP - Dynamics GP
Dynamics GP Certified IT Professional
2
 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 41795518
Ask them to justify those 15h (that's about 2 days of work).
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 41804370
How this ended?
0
 

Author Comment

by:Bill Lalor
ID: 41806967
Hi Vitor.  I went back to the vendor and asked for a detailed work breakdown of what was intended and, the 15 hours went down to 2.
1
 
LVL 18

Expert Comment

by:Steve Endow
ID: 41807024
Bill,

That is fantastic news! Interesting how a simple question can produce a discount of 87%.

It sounds like your intuition was right on, and you were right to question the hours.

Thanks for the update.

Steve
1
 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 41808139
I went back to the vendor and asked for a detailed work breakdown of what was intended and, the 15 hours went down to 2.
This is not good for the vendor trying to cheat their customers. Luckily you are smarter than them.
Cheers
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
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 backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

910 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

20 Experts available now in Live!

Get 1:1 Help Now