Microsoft SQL Server

See if your 3rd party software (such as backup software) is compatible with our product.
Forum rules
This is a user forum for Synology users to share experience/help out each other: if you need direct assistance from the Synology technical support team, please use the following form:
https://myds.synology.com/support/suppo ... p?lang=enu
nickichino
I'm New!
I'm New!
Posts: 7
Joined: Fri Feb 18, 2011 10:15 pm

Microsoft SQL Server

Postby nickichino » Thu Sep 01, 2011 9:23 am

Hi,

Sorry if this may sound like a stupid question but I have tried searching on google and this forum for answers but simply cannot understand the terminology used.

I have a MS SQL Server running a custom made sales/accounting/reporting/billing program in a old Windows XP machine which over the year is starting to become unstable. I am now running a Synology DS209+ II as a file server and would like to know if any of the Synology NAS can handle running the MS SQL server for my custom billing program? It will be much better if I can run the program on a NAS because I don't know how to maintain a Windows Server and a NAS has much less requirements (ie. no 24/7 A/C required).

The program was written my someone I hired a long time ago and when I asked him about the possibility of running on NAS he had no idea/knowledge about NAS. He isn't really up to date about these technologies and I have know idea/knowledge about programming so I really need someone to please help explain.

Thank you very much in advance for any help/explanation given.

Nick
rde
Novice
Novice
Posts: 41
Joined: Wed Nov 03, 2010 10:52 am

Re: Microsoft SQL Server

Postby rde » Thu Sep 01, 2011 10:50 am

Not possible at all sorry. MSsql runs only on windows environments not on a linux based nas
deerpark
Experienced
Experienced
Posts: 118
Joined: Wed Sep 09, 2009 7:02 pm

Re: Microsoft SQL Server

Postby deerpark » Thu Sep 01, 2011 10:52 am

Microsoft SQL Server is, as far as I know, only available for Microsoft Windows. Windows is not installed on any of the NAS Synology produce.
While you might theoretically be able to install Windows on a few of the high end NAS, I don't think it would be possible in reality. It is certainly not possible on the DS209+II.
Your only options is therefore to port your application to one of the databases supported, like MySQL.
nickichino
I'm New!
I'm New!
Posts: 7
Joined: Fri Feb 18, 2011 10:15 pm

Re: Microsoft SQL Server

Postby nickichino » Mon Sep 05, 2011 4:02 am

Thank you both for your answers.

I now realized that part of my confusion in thinking that it can work is because I saw that Synology NAS supports MySQL. I now realized that MS SQL and MySQL are totally on different platform.

I will see if our program can be ported over to MySQL.

Again, thanks for you replies.

Nick
User avatar
iugrifma
Versed
Versed
Posts: 279
Joined: Thu Apr 02, 2009 12:25 pm
Location: Hachau, Austria

Re: Microsoft SQL Server

Postby iugrifma » Thu Nov 03, 2011 1:55 pm

Hi,
Just to let you know that Syno's also support PostgreSQL, if your application cant be ported to MySQL maybe it might run on Postgres. In theory if your app. is ANSI SQL compliant it should port across.

* Model: RS-810+ * Firmware: 4.1-2567
* Model: DS-209+ * Firmware: 4.2-3246
* Modification(s) DS-209+ RAM 1Gb / RS810 RAM 3Gb / +Optware
* Drives Seagate DS209+: 2x ST31500341AS / RS810: 3x ST3000VN000-1H41.
* Network: 1000xBASE T, Full duplex. [Bonded on 810+]
* Services enabled: Most of them!
bogusgeorge
I'm New!
I'm New!
Posts: 7
Joined: Fri Dec 02, 2011 5:11 am

Re: Microsoft SQL Server

Postby bogusgeorge » Wed Dec 07, 2011 4:08 pm

I might be a little late on this reply but you could store you .mdf and .ldf files on the NAS and have your system(s) point to the directory that they are in on the NAS.

George
psoiree
Trainee
Trainee
Posts: 15
Joined: Sat Feb 27, 2016 10:04 pm

Re: Microsoft SQL Server

Postby psoiree » Wed Apr 20, 2016 7:03 pm

bogusgeorge wrote:I might be a little late on this reply but you could store you .mdf and .ldf files on the NAS and have your system(s) point to the directory that they are in on the NAS.

George



I'm sorry for asking in such old topic but I couldn't find the answer elsewhere.

I have the same problem. I have an accounting programs running on Windows which use MS SQL databases. They produce .mdf files. Isn't the solution for this just moving the database file (.mdf) to the NAS and then pointing at it in the Windows program? So as far as I understand, the SQL engine by itself would work on Windows machine but the files would be stored on NAS, right??
jj001
I'm New!
I'm New!
Posts: 2
Joined: Wed Jun 29, 2016 8:45 am

Re: Microsoft SQL Server

Postby jj001 » Wed Jun 29, 2016 8:58 am

I read a short while ago , on a Microsoft post, that the new version of MSSQL will only run on Linux Servers. But I still dont think it will run on n NAS.
I work on MSSQL on an every day basis and its a really bad idea to host your mdf and ldf files on the nas, and still run MSSQL instance on another machine. I can just think of the amount of issues you going to encounter if you do this, and degrading database performance as well. Rather just schedule backups to copy to a Shared Folder.
I also wrote my own accounting system and to port it is a timely process.

Another option that you can look at is purchasing a NUC device and run it from there. Also a really nice lightweight machine that does not need all the 24/7 A/C requirements.

Hope this post help someone...
psoiree
Trainee
Trainee
Posts: 15
Joined: Sat Feb 27, 2016 10:04 pm

Re: Microsoft SQL Server

Postby psoiree » Sat Aug 13, 2016 12:25 pm

jj001 wrote:I read a short while ago , on a Microsoft post, that the new version of MSSQL will only run on Linux Servers. But I still dont think it will run on n NAS.
I work on MSSQL on an every day basis and its a really bad idea to host your mdf and ldf files on the nas, and still run MSSQL instance on another machine. I can just think of the amount of issues you going to encounter if you do this, and degrading database performance as well. Rather just schedule backups to copy to a Shared Folder.
I also wrote my own accounting system and to port it is a timely process.

Another option that you can look at is purchasing a NUC device and run it from there. Also a really nice lightweight machine that does not need all the 24/7 A/C requirements.

Hope this post help someone...


Could You please explain why would this run any issues? I just don't get it. Why is it so complicated to store the files elsewhere that the local disk? What if I have the program installed on one disk and the files on another one, mounted on the same computer?

Did You mean buying a NUC device for making the server of it?
oRBIT
Skilled
Skilled
Posts: 680
Joined: Tue Oct 18, 2011 2:17 pm
Location: Gothenburg, Sweden

Re: Microsoft SQL Server

Postby oRBIT » Tue Aug 30, 2016 12:40 pm

Assuming your NAS (and DSM version) supports it, you might be able to install phpVirtualbox and run a virtual Windows-machine to host your SQL server. Might not be the fastest solution but still...
DS415+ (8GB RAM, 3x3TB WD RED WD30EFRX-68EUZN0, 1x240GB SSD SSDSC2CW240A3)

My Synology blog: http://synofan.blogspot.se
psoiree
Trainee
Trainee
Posts: 15
Joined: Sat Feb 27, 2016 10:04 pm

Re: Microsoft SQL Server

Postby psoiree » Tue Aug 30, 2016 12:42 pm

oRBIT wrote:Assuming your NAS (and DSM version) supports it, you might be able to install phpVirtualbox and run a virtual Windows-machine to host your SQL server. Might not be the fastest solution but still...


And that's an idea! I love Your attitude, sir! Will try and let you guys know how it worked out.

Return to “Software Compatibility Lists”

Who is online

Users browsing this forum: No registered users and 1 guest