Categories


Tags


SQL Server数据库提示

SQL Server数据库登陆时提示报错如图:

图片19.png

源错误 :

行 135:        </roleManager>

行 136: </system.web>

行 137: <system.serviceModel>

行 138:        <extensions>

行 139:                <behaviorExtensions>

源文件 : C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Config/machine.config    行 : 137

版本信息 :  Microsoft .NET Framework 版本 :2.0.50727.3053; ASP.NET 版本 :2.0.50727.3053

出现这个错误可能是机器重启的时候,配置文件中.NETFRAMEWORK3.0部分的控制运行配置并没有加进去,所以造成配置文件出错,这时只需要添加配置就可以了。

<sectionGroup name="system.serviceModel" type="System.ServiceModel.Configuration.ServiceModelSectionGroup, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">

<section name="behaviors" type="System.ServiceModel.Configuration.BehaviorsSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<section name="bindings" type="System.ServiceModel.Configuration.BindingsSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<section name="client" type="System.ServiceModel.Configuration.ClientSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<section name="comContracts" type="System.ServiceModel.Configuration.ComContractsSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<section name="commonBehaviors" type="System.ServiceModel.Configuration.CommonBehaviorsSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowDefinition="MachineOnly" allowExeDefinition="MachineOnly"/>

<section name="diagnostics" type="System.ServiceModel.Configuration.DiagnosticSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<section name="extensions" type="System.ServiceModel.Configuration.ExtensionsSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<section name="machineSettings" type="System.ServiceModel.Configuration.MachineSettingsSection, SMDiagnostics, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowDefinition="MachineOnly" allowExeDefinition="MachineOnly"/>

<section name="serviceHostingEnvironment" type="System.ServiceModel.Configuration.ServiceHostingEnvironmentSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<section name="services" type="System.ServiceModel.Configuration.ServicesSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

</sectionGroup>

<sectionGroup name="system.serviceModel.activation" type="System.ServiceModel.Activation.Configuration.ServiceModelActivationSectionGroup, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">

<section name="diagnostics" type="System.ServiceModel.Activation.Configuration.DiagnosticSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<section name="net.pipe" type="System.ServiceModel.Activation.Configuration.NetPipeSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<section name="net.tcp" type="System.ServiceModel.Activation.Configuration.NetTcpSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

</sectionGroup>

将以上内容添加到C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Config/machine.config文件中的configSections之间就可以了。

重新打开SQL Server数据库测试数据库已经正常登陆,未再出现相关报错。

来源:景安


Public @ 2019-05-16 15:47:44

独立服务器win2003系统站点常见问题解答

独立服务器win2003系统站点常见问题解答问题1:未启用父路径症状举例:Server.MapPath() 错误 ASP 0175 : 80004005不允许的 Path 字符/0709/dqyllhsub/news/OpenDatabase.asp,行 4在 MapPath 的 Path 参数中不允许字符 ..。原因分析:许多Web页面里要用到诸如../格式的语句(即回到上一层的页面,也就是父路

Public @ 2016-04-30 16:13:23

SQL Server 2008R2数据库设置自动备份

SQL Server 2008R2 的自动备份功能可以通过 SQL Server Management Studio (SSMS) 的图形界面或 Transact-SQL (T-SQL) 命令来设置。 图形界面: 1. 打开 SQL Server Management Studio,连接到 SQL Server 数据库引擎。 2. 在左侧菜单栏中选择要备份的数据库。 3. 右键点击该数据库,选

Public @ 2023-05-28 14:00:42

SQL Server数据库启动报错1068解决办法

1.在启动【SQL Server 代理 (MSSQLSERVER)】服务时,弹出如图所示的窗口。图片12.png右键单击代理服务,选择【属性】打开属性对话框。图片13.png2.切换到【依赖关系】选项卡,我们可以看见它与【SQL Server(MSSQLSERVER)】服务存在依赖关系。图片14.png鼠标右键单击【SQL Server(MSSQLSERVER)】,选择【启动】。图片15.png3

Public @ 2014-03-20 15:47:44

更多您感兴趣的搜索

0.425504s