ITKeyword,专注技术干货聚合推荐

注册 | 登录

Step-by-Step: Installing SQL Server Management Studio2008 Express after Visual Studio 2010(zz)

分享于

2021腾讯云限时秒杀,爆款1核2G云服务器298元/3年!(领取2860元代金券),
地址https://cloud.tencent.com/act/cps/redirect?redirect=1062

2021阿里云最低价产品入口+领取代金券(老用户3折起),
入口地址https://www.aliyun.com/minisite/goods

推荐:Visual Studio 2010已安装,sql server 2008 management studio安装教程

(Mac和Linux用户请无视本文,本文是在Windows7旗舰版下测试通过) 最近学校学习.net,要用到sql server。一般来说,管理数据库一种是像mySQL一样,在命令行那个

Step-by-Step: Installing SQL Server Management Studio2008 Express after Visual Studio 2010 Beth Massi 18 Feb 2011 8:14 AM 37 One of the first things I always do after installing Visual Studio is toinstall SQL Server Management Studio (SSMS). Visual Studio 2010 installs SQLServer 2008 Express on your machine but doesn’t include SSMS. Although you canuse Visual Studio to create/connect/design databases, I like having SSMS aroundfor advanced management. I recall SSMS for SQL Server 2005 was a simpleinstall, unfortunately they threw the kitchen sink into the SSMS 2008 installerand I’m always confused at which buttons I need to push to get it to do what Iwant. So I’m writing up this blog post for two reasons 1) So I remember thesteps and 2) So you can be less frustrated :-) (BTW, a birdie tells me that theSQL team is looking at making this installer much simpler in the future.Hooray!) Okay the first thing you need is to make sure you get the right version ofSSMS. If you installed Visual Studio 2010 then you will need the 2008 version(not R2). STEP 1: Download Microsoft® SQL Server® 2008 ManagementStudio Express and select eitherSQLManagementStudio_x64_ENU.exe or SQLManagementStudio_x86_ENU.exe depending onyour machine’s OS bit-ness. I’m running Windows 7-64bit so I’ll be detailingthe steps as it pertains to that OS. STEP 2: Make sure you’re logged in as an administrator of the machine thenright-click on the exe you downloaded and select “Run as Administrator”. Ifyou’re on Windows 7 then you’ll get a compatibility warning. Click past it fornow to continue with the install. Later you’ll need to apply SQL 2008 Service Pack 2. STEP 3: You should now see the “SQL Server Installation Center” window.Yes it looks scary. Select the “Installation” tab. STEP 4: Select “New SQL Server stand-alone installation or add features toan existing installation”. It will then run a rule check. Make sure there areno failures and then click OK. STEP 5: The next step is misleading. The Setup Support Files window lookslike it’s doing something and stuck on “Gathering user settings.” It’s actuallywaiting for you to click the Install button! Doh! STEP 6: Another rule check. You’ll

推荐:Error 29506 while installing SQL Server Management Studio Express

Error 29506 while installing SQL Server Management Studio Express <!--Call @Core Meta hook--> Published on April 28, 2010 by Andrew in error, Microsof

probably end up with a Windows Firewallwarning this time. If you want to enable remote access to SQL Server you’llneed to configure the firewall later. Since I’m using SQL Server Express for developmentpurposes on this machine only, I won’t need to worry about that. Click Next. STEP 7: Okay here is the step I always mess up because it’s just notintuitive at all. On the Installation Type window you have a choice between“Perform a new installation of SQL Server 2008” OR “Add features to an existinginstance of SQL Server 2008”. You need to select new installation, NOTadd features. I know I know, totally weird. You would think that since you justwant to add SSMS that it would be Add features to existing instance – I mean Idon’t want a new instance, just the dang tools. Sigh. Click Next. STEP 8: Next you get the Product Key window. You obviously don’t need aproduct key for SQL Server Express since it’s free so just click Next. STEP 9: Accept the License Terms and click Next. STEP 10: Okay now for the window we’ve all been waiting for - FeatureSelection. Check off “Management Tools – Basic” and then click Next. STEP 11: Verify your disk space requirements and click Next. STEP 12: Help Microsoft improve SQL Server features and services byselecting to send usage and error reports to them (or not). Click Next. STEP 13: Another quick rule check runs. Click Next. STEP 14: Now it looks like we’re ready to install. Click the Installbutton. The install will kick off and will take about 5 minutes to complete. STEP 15: Once the installation completes, click the Next button again. STEP 16: Complete! Click the Close button and you should be all set. STEP 17: Fire up SQL Server Management Studio! You should now see it in yourPrograms under Microsoft SQL Server 2008. Make sure you run it as anadministrator for access to all the features. And don’t forget at some point to install the latest SQL Server 2008 Service Pack. I hope this helps people who have just installed VisualStudio 2010 but also want to install SQL Server Management Studio. I know I’llbe referring to my own post on this when I need to do it again :-) Enjoy!

安装 sql server

2008 management studio

express

推荐:最靠谱 Visual Studio 2010已安装,sql server 2008 management studio安装教程

(Mac和Linux用户请无视本文,本文是在Windows7旗舰版下测试通过) 最近学校学习.net,要用到sql server。一般来说,管理数据库一种是像mySQL一样,在命令行那个

Step-by-Step: Installing SQL Server Management Studio2008 Express after Visual Studio 2010 Beth Massi 18 Feb 2011 8:14 AM 37 One of the first things I always do after installing Vi

相关阅读排行


相关内容推荐

最新文章

×

×

请激活账号

为了能正常使用评论、编辑功能及以后陆续为用户提供的其他产品,请激活账号。

您的注册邮箱: 修改

重新发送激活邮件 进入我的邮箱

如果您没有收到激活邮件,请注意检查垃圾箱。