大龙在win7下安装SQLServer2008r2的悲惨经历-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

大龙在win7下安装SQLServer2008r2的悲惨经历

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 04:20 PM

win7Install

首先下载SQL Server 2008 R2 企业版/开发版/标准版(中英文下载，带序列号) 然后安装时出错：存在早版本vs2008，请升级。于是升级呗，下载 Microsoft Visual Studio 2008 Service Pack 1 (iso) 然后安装时又出错：原版本安装不完全，或已安装补丁，请下载Vis

　　首先下载SQL Server 2008 R2 企业版/开发版/标准版(中英文下载，带序列号)

　　然后安装时出错：存在早版本vs2008，请升级。

　　于是升级呗，下载

　　Microsoft Visual Studio 2008 Service Pack 1 (iso)

　　然后安装时又出错：原版本安装不完全，或已安装补丁，请下载Visual Studio 2008 Service Pack Preparation Tool

　　于是下载呗。安装时又提示缺少XXX文件。

　　我去你大爷啊，微软。

　　经过多方查阅，直接重装vs2008即可安装sp1。

　　于是重装呗。重装就要先完全卸载vs2008。在控制面版，右击vs2008卸载，运行后出错：缺少XXX文件。崩溃了有木有在msdn论坛上，，一个老外提供了一个下载工具UninstallTool，抱着死马当活马医的心态，下载并运行了。中间提示了个错误，感觉貌似又失败了，无语。

　　但是人生总是在不经意间峰回路转虽然过程出现了错误，但我看到最后仍提示卸载成功。于是我打开开始菜单，vs2008选项依然存在，左击之，提示“程序不存在”! 莫非真的卸载成功?我再次抱着死马当活马医的心态，点开了vs2008的setup。程序如流水般流畅的运行，我的心也仿佛被流水洗涤，紧张的心弦渐渐舒缓了下来。 vs2008安装成功。接着vs2008 sp1也安装成功。这种感觉真的很美妙。

　　只差最后一步了。sqlserver2008r2安装的过程亦如流水般流畅。正当我趁她慢悠悠的安装的空隙慢悠悠的看《我是歌手》时，一个报错的声音横空出世。 msmdctr.ini 文件不存在。在微软的支持文档中查到，由于安装时选的是默认实例名，导致电脑上sqlserver2008r2和sqlserver2005的实例名重复了。这俩货掐起架来了。忧郁的点着下一步，直到结束，提示安装失败。无奈的准备卸载sqlserver2008r2，再继续重复刚才的故事。

　　但是人生总是在不经意间峰回路转。我尝试打开sqlserver2005，提示实例名无效。然后我又手贱的点开安装失败的sqlserver2008r2。居然可以进去。然后运行了一下网站，没有问题!部分的数据库功能可用!而我安装sqlserver2008r2的原因只是为了打开一个sqlserver2008r2的数据库。目的达到!收工。

　　此刻，窗外记忆中那一轮酒红色的太阳，已变作万家灯火。

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

MySQL: BLOB and other no-sql storage, what are the differences?May 13, 2025 am 12:14 AM

MySQL'sBLOBissuitableforstoringbinarydatawithinarelationaldatabase,whileNoSQLoptionslikeMongoDB,Redis,andCassandraofferflexible,scalablesolutionsforunstructureddata.BLOBissimplerbutcanslowdownperformancewithlargedata;NoSQLprovidesbetterscalabilityand

MySQL Add User: Syntax, Options, and Security Best PracticesMay 13, 2025 am 12:12 AM

ToaddauserinMySQL,use:CREATEUSER'username'@'host'IDENTIFIEDBY'password';Here'showtodoitsecurely:1)Choosethehostcarefullytocontrolaccess.2)SetresourcelimitswithoptionslikeMAX_QUERIES_PER_HOUR.3)Usestrong,uniquepasswords.4)EnforceSSL/TLSconnectionswith

MySQL: How to avoid String Data Types common mistakes?May 13, 2025 am 12:09 AM

ToavoidcommonmistakeswithstringdatatypesinMySQL,understandstringtypenuances,choosetherighttype,andmanageencodingandcollationsettingseffectively.1)UseCHARforfixed-lengthstrings,VARCHARforvariable-length,andTEXT/BLOBforlargerdata.2)Setcorrectcharacters

MySQL: String Data Types and ENUMs?May 13, 2025 am 12:05 AM

MySQloffersechar, Varchar, text, Anddenumforstringdata.usecharforfixed-Lengthstrings, VarcharerForvariable-Length, text forlarger text, AndenumforenforcingdataAntegritywithaetofvalues.

MySQL BLOB: how to optimize BLOBs requestsMay 13, 2025 am 12:03 AM

Optimizing MySQLBLOB requests can be done through the following strategies: 1. Reduce the frequency of BLOB query, use independent requests or delay loading; 2. Select the appropriate BLOB type (such as TINYBLOB); 3. Separate the BLOB data into separate tables; 4. Compress the BLOB data at the application layer; 5. Index the BLOB metadata. These methods can effectively improve performance by combining monitoring, caching and data sharding in actual applications.

Adding Users to MySQL: The Complete TutorialMay 12, 2025 am 12:14 AM

Mastering the method of adding MySQL users is crucial for database administrators and developers because it ensures the security and access control of the database. 1) Create a new user using the CREATEUSER command, 2) Assign permissions through the GRANT command, 3) Use FLUSHPRIVILEGES to ensure permissions take effect, 4) Regularly audit and clean user accounts to maintain performance and security.

Mastering MySQL String Data Types: VARCHAR vs. TEXT vs. CHARMay 12, 2025 am 12:12 AM

ChooseCHARforfixed-lengthdata,VARCHARforvariable-lengthdata,andTEXTforlargetextfields.1)CHARisefficientforconsistent-lengthdatalikecodes.2)VARCHARsuitsvariable-lengthdatalikenames,balancingflexibilityandperformance.3)TEXTisidealforlargetextslikeartic

MySQL: String Data Types and Indexing: Best PracticesMay 12, 2025 am 12:11 AM

Best practices for handling string data types and indexes in MySQL include: 1) Selecting the appropriate string type, such as CHAR for fixed length, VARCHAR for variable length, and TEXT for large text; 2) Be cautious in indexing, avoid over-indexing, and create indexes for common queries; 3) Use prefix indexes and full-text indexes to optimize long string searches; 4) Regularly monitor and optimize indexes to keep indexes small and efficient. Through these methods, we can balance read and write performance and improve database efficiency.

See all articles