pbootcms网站模板|日韩1区2区|织梦模板||网站源码|日韩1区2区|jquery建站特效-html5模板网

在 SQL Server Management Studio 中從 VS2010 啟動(dòng) SQL Ser

Launching SQL Server 2008 Express from VS2010 in SQL Server Management Studio(在 SQL Server Management Studio 中從 VS2010 啟動(dòng) SQL Server 2008 Express)
本文介紹了在 SQL Server Management Studio 中從 VS2010 啟動(dòng) SQL Server 2008 Express的處理方法,對(duì)大家解決問(wèn)題具有一定的參考價(jià)值,需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)吧!

問(wèn)題描述

我的筆記本電腦裝有 Windows 7,x64 位,是去年 12 月(2 個(gè)月前)制造的.它安裝了 Microsoft Visual Studio 2010SQL Server 2008 Express,但我之前沒(méi)有在這臺(tái)電腦上使用過(guò)Sql2008".

SQL Server Management Studio 一直安裝,我用它連接到我們公司的 SQL Server 實(shí)例.

現(xiàn)在,我需要對(duì)一個(gè)未返回我們期望的數(shù)據(jù)的大型存儲(chǔ)過(guò)程進(jìn)行一些開(kāi)發(fā)和調(diào)試.我獲得了數(shù)據(jù)庫(kù) companyDB.bak 的備份,并將其移動(dòng)到我的 Win7x64 筆記本電腦的以下文件夾中:C:\Temp\companyDB.bak.

我打開(kāi) SQL Server Management Studio 并選擇 (本地) 并單擊連接":

一段時(shí)間后,我收到錯(cuò)誤消息:

<塊引用>

與 SQL Server 建立連接時(shí)發(fā)生與網(wǎng)絡(luò)相關(guān)或特定于實(shí)例的錯(cuò)誤.服務(wù)器未找到或無(wú)法訪問(wèn).驗(yàn)證實(shí)例名稱(chēng)是否正確以及 SQL Server 是否配置為允許遠(yuǎn)程連接.(提供程序:命名管道提供程序,錯(cuò)誤:40 - 無(wú)法打開(kāi)與 SQL Server 的連接)(Microsoft SQL Server,錯(cuò)誤:2)

我做了一些研究,發(fā)現(xiàn)了這個(gè)有用的鏈接:

在安裝過(guò)程中,我收到此錯(cuò)誤消息,指出在刪除 **SQL Server 2005 Express Tools" 之前無(wú)法安裝:

現(xiàn)在下面,如果你注意到了,我搜索了我電腦下安裝的項(xiàng)目,標(biāo)題中唯一帶有2005"的是VC++ 2005 Redistributable::>

所以,我取消了安裝并重新開(kāi)始,這次選擇了從 SQL Server 2000、SQL Server 2005 或 SQL Server 2008 升級(jí)"選項(xiàng),但我收到了相同的錯(cuò)誤消息.

我似乎無(wú)法繼續(xù)了.

顯然,我安裝的一些應(yīng)用程序需要VC++ 2005 Redistributable,否則幾個(gè)月前我不會(huì)安裝它.

我該如何進(jìn)行?

[更新]:

遵循 Davide Mauri 的 SQL Server 2008 R2 Installation and the Phantom of SQL Server 2005 Express 博客,我在日志文件C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\yyyymmdd_hhmmss\Detail.txt".

它只指向一個(gè)注冊(cè)表項(xiàng)(他指向兩個(gè)):""

初始化規(guī)則目標(biāo)對(duì)象:Microsoft.SqlServer.Configuration.SetupExtension.Sql2005SsmsExpressFacetSco:嘗試創(chuàng)建基本注冊(cè)表項(xiàng) HKEY_LOCAL_MACHINE,機(jī)器Sco:試圖打開(kāi)注冊(cè)表子項(xiàng)Sco:試圖打開(kāi)注冊(cè)表子項(xiàng) SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM規(guī)則 'Sql2005SsmsExpressFacet' 檢測(cè)結(jié)果:SQL 2005 Ssms EE installed=True評(píng)估規(guī)則:Sql2005SsmsExpressFacet在機(jī)器上運(yùn)行的規(guī)則:5000-C6E8-1規(guī)則評(píng)估完成:失敗規(guī)則評(píng)估消息:已安裝 SQL Server 2005 Express Tools.要繼續(xù),請(qǐng)刪除 SQL Server 2005 Express Tools.

但是,我的注冊(cè)表甚至沒(méi)有那個(gè)目錄:

[更新 2]:

好的,所以我們的 IT 人員給了我完整的 SQL Server 2008 R2 CD 來(lái)安裝,但我仍然遇到同樣的障礙,認(rèn)為 SQL Server 2005 Express 工具 仍然安裝 - 所以我無(wú)法前進(jìn).

解決方案

為了解決這個(gè)問(wèn)題,我做了以下事情:

  • 卸載我擁有的所有 SQL Management Studio 實(shí)例
  • 重啟
  • 安裝 SQL Server 2008(不是 Express 版本)
  • 重啟

多田!

我猜微軟喜歡銷(xiāo)售他們的產(chǎn)品,而且效果很好.

My laptop has Windows 7, x64 bit, and was built this past December (2 months ago). It has Microsoft Visual Studio 2010 installed with SQL Server 2008 Express, but I had not used "Sql2008" before on this PC.

SQL Server Management Studio has been installed all that time, and I use it to connect to our company's instance of SQL Server.

Now, I need to do some development and debugging on a large stored procedure that is not returning the data we expect. I got a backup of the database companyDB.bak and moved that to my Win7x64 laptop in this folder: C:\Temp\companyDB.bak.

I open SQL Server Management Studio and select (local) and click "Connect":

After some time, I get error message:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

I do some research and found this helpful link: SQL SERVER – FIX : ERROR : (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: )

His first step is to make sure SQL Server is running, which it seems to be:

Next, it says to make sure I am using TCP/IP Port 1433. When I looked, it seemed all of mine were BLANK, so I changed them so that all use Port 1433, then Stopped and Restarted the service:

OK, now I can get my local instance to start up.

When I attempted to restore the database using my "companyDB.bak" file, I get an error saying the database I am restoring from is newer than I am saving it to:

System.Data.SqlClient.SqlError: The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.2531. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo)

So, I downloaded SQLEXPRWT_x64_ENU.exe from here: from here: http://www.microsoft.com/en-us/download/details.aspx?id=30438

During installation, I get this error saying that it can't install until **SQL Server 2005 Express Tools" are removed:

Now below, if you will notice, I did a search of the items installed under my computer, and the only thing there is with "2005" in the title is VC++ 2005 Redistributable:

So, I cancelled the installation and started it again, this time selecting the "Upgrade from SQL Server 2000, SQL Server 2005 or SQL Server 2008" option, but I got the same error message.

I do not seem to be able to continue.

Obviously, some of my installed applications need VC++ 2005 Redistributable, or I would not have installed it a few months ago.

How do I proceed?

[UPDATE]:

Following Davide Mauri's SQL Server 2008 R2 Installation and the Phantom of SQL Server 2005 Express blog, I searched for the term Sql2005SsmsExpressFacet in the log file "C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\yyyymmdd_hhmmss\Detail.txt".

It only pointed to a single registry entry (where his pointed at two): ""

Init rule target object: Microsoft.SqlServer.Configuration.SetupExtension.Sql2005SsmsExpressFacet
Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine 
Sco: Attempting to open registry subkey 
Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM
Rule 'Sql2005SsmsExpressFacet' detection result: SQL 2005 Ssms EE installed=True
Evaluating rule        : Sql2005SsmsExpressFacet
Rule running on machine: 5000-C6E8-1
Rule evaluation done   : Failed
Rule evaluation message: The SQL Server 2005 Express Tools are installed. To continue, remove the SQL Server 2005 Express Tools.

But, my registry does not even HAVE that directory:

[UPDATE 2]:

OK, so our IT guy has given me the full blown SQL Server 2008 R2 CD to install, but I am still hitting this same roadblock with it thinking that SQL Server 2005 Express tools are still installed - so I can not move forward.

解決方案

To fix this, I did the following:

  • Uninstall all of the SQL Management Studio instances I had
  • reboot
  • Install SQL Server 2008 (not the Express version)
  • reboot

Tada!

I guess Microsoft likes selling their product, and it worked.

這篇關(guān)于在 SQL Server Management Studio 中從 VS2010 啟動(dòng) SQL Server 2008 Express的文章就介紹到這了,希望我們推薦的答案對(duì)大家有所幫助,也希望大家多多支持html5模板網(wǎng)!

【網(wǎng)站聲明】本站部分內(nèi)容來(lái)源于互聯(lián)網(wǎng),旨在幫助大家更快的解決問(wèn)題,如果有圖片或者內(nèi)容侵犯了您的權(quán)益,請(qǐng)聯(lián)系我們刪除處理,感謝您的支持!

相關(guān)文檔推薦

Modify Existing decimal places info(修改現(xiàn)有小數(shù)位信息)
The correlation name #39;CONVERT#39; is specified multiple times(多次指定相關(guān)名稱(chēng)“CONVERT)
T-SQL left join not returning null columns(T-SQL 左連接不返回空列)
remove duplicates from comma or pipeline operator string(從逗號(hào)或管道運(yùn)算符字符串中刪除重復(fù)項(xiàng))
Change an iterative query to a relational set-based query(將迭代查詢更改為基于關(guān)系集的查詢)
concatenate a zero onto sql server select value shows 4 digits still and not 5(將零連接到 sql server 選擇值仍然顯示 4 位而不是 5)
主站蜘蛛池模板: 桑茶-七彩贝壳桑叶茶 长寿茶| 机床主轴维修|刀塔维修|C轴维修-常州翔高精密机械有限公司 | 大型工业风扇_工业大风扇_大吊扇_厂房车间降温-合昌大风扇 | pbootcms网站模板|织梦模板|网站源码|jquery建站特效-html5模板网 | 成都LED显示屏丨室内户外全彩led屏厂家方案报价_四川诺显科技 | 电池高低温试验箱-气态冲击箱-双层电池防爆箱|简户百科 | 聚合氯化铝-碱式氯化铝-聚合硫酸铁-聚氯化铝铁生产厂家多少钱一吨-聚丙烯酰胺价格_河南浩博净水材料有限公司 | 重庆小面培训_重庆小面技术培训学习班哪家好【终身免费复学】 | 深圳侦探联系方式_深圳小三调查取证公司_深圳小三分离机构 | 定硫仪,量热仪,工业分析仪,马弗炉,煤炭化验设备厂家,煤质化验仪器,焦炭化验设备鹤壁大德煤质工业分析仪,氟氯测定仪 | 外贸网站建设-外贸网站设计制作开发公司-外贸独立站建设【企术】 | 电池挤压试验机-自行车喷淋-车辆碾压试验装置-深圳德迈盛测控设备有限公司 | 钢格板|镀锌钢格板|热镀锌钢格板|格栅板|钢格板|钢格栅板|热浸锌钢格板|平台钢格板|镀锌钢格栅板|热镀锌钢格栅板|平台钢格栅板|不锈钢钢格栅板 - 专业钢格板厂家 | 液压油缸生产厂家-山东液压站-济南捷兴液压机电设备有限公司 | 澳门精准正版免费大全,2025新澳门全年免费,新澳天天开奖免费资料大全最新,新澳2025今晚开奖资料,新澳马今天最快最新图库-首页-东莞市傲马网络科技有限公司 | 天津市能谱科技有限公司-专业的红外光谱仪_红外测油仪_紫外测油仪_红外制样附件_傅里叶红外光谱技术生产服务厂商 | 钢格栅板_钢格板网_格栅板-做专业的热镀锌钢格栅板厂家-安平县迎瑞丝网制造有限公司 | 沈阳庭院景观设计_私家花园_别墅庭院设计_阳台楼顶花园设计施工公司-【沈阳现代时园艺景观工程有限公司】 | 喷播机厂家_二手喷播机租赁_水泥浆洒布机-河南青山绿水机电设备有限公司 | 环氧铁红防锈漆_环氧漆_无溶剂环氧涂料_环氧防腐漆-华川涂料 | 钢格板|镀锌钢格板|热镀锌钢格板|格栅板|钢格板|钢格栅板|热浸锌钢格板|平台钢格板|镀锌钢格栅板|热镀锌钢格栅板|平台钢格栅板|不锈钢钢格栅板 - 专业钢格板厂家 | 金属清洗剂,防锈油,切削液,磨削液-青岛朗力防锈材料有限公司 | 暴风影音| 分轨 | 上传文件,即刻分离人声和伴奏 | 短信通106短信接口验证码接口群发平台_国际短信接口验证码接口群发平台-速度网络有限公司 | 不锈钢螺丝 - 六角螺丝厂家 - 不锈钢紧固件 - 万千紧固件--紧固件一站式采购 | 青州搬家公司电话_青州搬家公司哪家好「鸿喜」青州搬家 | 深圳天际源广告-形象堆头,企业文化墙,喷绘,门头招牌设计制作专家 | 电子天平-华志电子天平厂家 | 搜木网 - 木业全产业链交易平台,免费搜货、低价买货! | 钢丝绳探伤仪-钢丝绳检测仪-钢丝绳探伤设备-洛阳泰斯特探伤技术有限公司 | 中式装修设计_全屋定制家具_实木仿古门窗花格厂家-喜迎门 | 最新范文网_实用的精品范文美文网 | hdpe土工膜-防渗膜-复合土工膜-长丝土工布价格-厂家直销「恒阳新材料」-山东恒阳新材料有限公司 ETFE膜结构_PTFE膜结构_空间钢结构_膜结构_张拉膜_浙江萬豪空间结构集团有限公司 | 茶楼装修设计_茶馆室内设计效果图_云臻轩茶楼装饰公司 | hc22_hc22价格_hc22哈氏合金—东锜特殊钢 | 岩棉板|岩棉复合板|聚氨酯夹芯板|岩棉夹芯板|彩钢夹芯板-江苏恒海钢结构 | 闭端端子|弹簧螺式接线头|防水接线头|插线式接线头|端子台|电源线扣+护线套|印刷电路板型端子台|金笔电子代理商-上海拓胜电气有限公司 | 企业微信scrm管理系统_客户关系管理平台_私域流量运营工具_CRM、ERP、OA软件-腾辉网络 | 涡街流量计_LUGB智能管道式高温防爆蒸汽温压补偿计量表-江苏凯铭仪表有限公司 | 冷却塔风机厂家_静音冷却塔风机_冷却塔电机维修更换维修-广东特菱节能空调设备有限公司 |