Post reply

Stand Alone Database Server

  • February 4, 2012 at 5:18 am

    #251023

    Hi All,

    I am in the process on installing an VB.net application which will have to connect to a MSSQL 2008R2 database. The client currently has a SBS server networking about 20 client PCs.

    Currently that systm is only used to save files and for email via exchange.

    In order to have as little to do as possible with the client's IT vendor/contractor (who is not too happy that I got the contract to write the application) I would like to install a separate standalone machine to act as a MSSQL server. This would then simply be given a fixed IP with the corresponding logon details in the connection string of the application. Should it be necessary, the purchase of additional MS licenses is not a problem.

    Basically I need your help in discovering if there any way that I can install such a standalone server to service the MSSQL 2008 database? For example setting up a second windows server?

    Thanks in advance.

    Morke

  • February 4, 2012 at 6:08 am

    #1442740

    You didn't take the clients business model into consideration;

    the SBS solution is ideal for small businesses; minimal IT staff, and all that.

    you should recommend that they get the SBS Premium services addon, which includes SQL server. they may even have that installed already.

    depending on the version the client has, the existing Small Business Sever comes with either 25 or 75 licenses, so your proposal of a separate server pretty much goes against the existing client business model.

    the additional advantage for the client is the SBS system would add a maintenance plan to automatically backup their data as part of the built in SBS automatic backup and recovery solution.

    http://www.microsoft.com/en-us/server-cloud/windows-small-business-server/editions.aspx

    with those factors taken into consdieration, doesn't it make more sense for the client to forgo additional hardware and get SQL server that combines seemlessly with their exisitng business model?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • February 4, 2012 at 6:47 am

    #1442743

    Hi,

    Thanks for the reply. However, I did take the business model into considration. But that is not something I control. The client already has SBS, and I am not interested into taking over the whole site. Nor am I interested in getting stuck into an arguement with their third party IT provider.

    I am fully aware that I can simply install an instance of SQL server on their existing SBS system. (I have already done this on other similar client sites.)

    However, what I want to know if there is a way for me to simply stick another MS box to act as a database server onto their existing network.

    For instance if I changed the database over to MySQL and stuck in a Linux box then there would be no problem. However, I want to retain MSSQL as my data provider.

    All the best

    Morke

  • February 4, 2012 at 11:24 am

    #1442765

    Yes, that's all doable. The only thing the existing contractor could do is refuse to allow it to be connected to 'their' network, though that'd be getting very petty.

    I'm assuming you're going to be running it in Mixed Mode and just use SQL accounts?

    blog | napalmgram@Twitter

    Training cats makes SQL Server look easy

  • February 6, 2012 at 5:32 am

    #1443039

    I figured its doable, however, does anyone know how. The existing contractor will not have a choice in the matter, and if they to they will be replaced.

    Morke

  • February 6, 2012 at 5:34 am

    #1443042

    The installing of SQL on a standalone server is the easy part. You'll need to restore backups of all the databases, configure all logins and server-level permissions, change the connection strings of any application that currently connects to the SBS SQL instance.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 11, 2012 at 8:08 am

    #1445931

    Hi,

    Thanks for the reply.

    But is there a problem with two SBS servers running on the same network? If I simply disable DHCP on my server, give it a fixed IP, an stick it onto the network is there likely to be a problem?

    Yours

    Morke

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply