Linux 安装 SQL server 提示This program requires a machine with at least 2000 megabytes of memory

这个是说要求你的机器要有2G以上的可用空间,可以对sqlservr更改可执行程序做一点小小的修改来绕过限制。

cd /opt/mssql/bin/ # 进入目录 
mv sqlservr sqlservr.bak # 保存备份文件 
python # 使用python修改内存限制代码
>>> if __name__ == '__main__':
    print(u"修改sqlservr文件至少2G内存的限制为512MB\n")
    oldfile = open("sqlservr.bak", "rb").read()
    open("sqlservr.bak", "wb").write(oldfile)
    print(u"生成备份文件 sqlservr.bak \n")
    if(oldfile.find("\xff\x93\x35\x77")!=-1 or oldfile.find("\x00\x94\x35\x77")!=-1):
        newfile = oldfile.replace("\xff\x93\x35\x77", "\x00\x80\x84\x1e").replace("\x00\x94\x35\x77", "\x00\x80\x84\x1e")
        open("sqlservr.bak", "wb").write(newfile)
        print(u"替换成功\n")
    else:
        print(u"未能找到可替换的数据,如还有内存限制的问题可私信联系我解决(xuing)")
		
>>>exit()
  • 2
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Book Description SQL Server 2012 accounts for a huge share of the database market, and more and more companies are implementing SSRS as part of their BI implementation. Its Reporting Services offers a comprehensive, highly scalable solution that enables real-time decision making. SQL Server 2012 Reporting Services Blueprints is intended to be just that, a series of Blueprints – things that work straight out of the box and that mirror what a real job requires real report developers to do. You will not be bored with an “Introduction to X” or “What’s under the hood of Y”. We go straight to the practical development of reporting skills, explaining actions as they are taken. This book is a step-by-step, task-driven tutorial. It provides enterprise reporting blueprints that address your day-to-day issues and requirements. Right from the very start, you’ll learn SSRS beyond the basics, giving you the skills to create the best reports for any task. Explore the possibilities, master your options, and choose the best tool for the job. What you will learn from this book Fully understand the structure and properties of your reports Add interactive elements to your reports Use parameters effectively in different scenarios Utilize a range of advanced graphs Make use of geospatial data and maps Use OLAP Cubes in your reports Deploy your SSRS projects Integrate SharePoint, PowerPivot, and Power View into your reports Approach Follow the fictional John Kirkland through a series of real-world reporting challenges based on actual business conditions. Use his detailed blueprints to develop your own reports for every requirement. Who this book is written for This book is for report developers, data analysts, and database administrators struggling to master the complex world of effective reporting in SQL Server 2012. Knowledge of how data sources and data sets work will greatly help readers to speed through the tutorials. Book Details Paperback: 246 pages Publisher: Packt Publishing (October 2013) Language: English ISBN-10: 1849685088 ISBN-13: 978-1849685085

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值