(Resolvido) Erro ao tentar conectar no SQLServer Managment Studio

[Lucas Senior]

Olá Pessoal, boa tarde.

Ao tentar conector no SQLManagment Studio (SQL 2005 Express), tenho esse erro abaixo:

http://img713.imageshack.us/img713/7573/erro.jpg

Seria algo relacionado ao framework?

Ambiente

Win Server 2008 64bits

Win Instaler 3.1

Framework 2.0

SQLServer 2005 Express

Ps.: O Sistema está funcionando normalmente...

Só não consigo conectar nessa parte gráfica do SQLServer...

Que informa o seguinte:

===================================

Cannot connect to SERVIDOR\SQLEXPRESS.

===================================

The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception. (System.Data)

------------------------------

Program Location:

at System.Data.SqlClient.SqlConnection..ctor()

at Microsoft.SqlServer.Management.UI.ConnectionDlg.SqlServerType.Microsoft.SqlServer.Management.UI.ConnectionDlg.IServerType.GetConnectionObject(UIConnectionInfo ci)

at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)

at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

===================================

The type initializer for 'System.Data.SqlClient.SqlConnectionFactory' threw an exception. (System.Data)

------------------------------

Program Location:

at System.Data.SqlClient.SqlConnection..cctor()

===================================

The type initializer for 'System.Data.SqlClient.SqlPerformanceCounters' threw an exception. (System.Data)

------------------------------

Program Location:

at System.Data.SqlClient.SqlConnectionFactory..cctor()

===================================

Configuration system failed to initialize (System.Configuration)

------------------------------

Program Location:

at System.Configuration.ClientConfigurationSystem.EnsureInit(String configKey)

at System.Configuration.ClientConfigurationSystem.PrepareClientConfigSystem(String sectionName)

at System.Configuration.ClientConfigurationSystem.System.Configuration.Internal.IInternalConfigSystem.GetSection(String sectionName)

at System.Configuration.ConfigurationManager.GetSection(String sectionName)

at System.Configuration.PrivilegedConfigurationManager.GetSection(String sectionName)

at System.Diagnostics.DiagnosticsConfiguration.GetConfigSection()

at System.Diagnostics.DiagnosticsConfiguration.Initialize()

at System.Diagnostics.DiagnosticsConfiguration.get_SwitchSettings()

at System.Diagnostics.Switch.InitializeConfigSettings()

at System.Diagnostics.Switch.InitializeWithStatus()

at System.Diagnostics.Switch.get_SwitchSetting()

at System.Diagnostics.TraceSwitch.get_Level()

at System.Data.ProviderBase.DbConnectionPoolCounters..ctor(String categoryName, String categoryHelp)

at System.Data.SqlClient.SqlPerformanceCounters..ctor()

at System.Data.SqlClient.SqlPerformanceCounters..cctor()

===================================

Unrecognized configuration section system.serviceModel. (C:\Windows\Microsoft.NET\Framework\v2.0.50727\Config\machine.config line 146) (System.Configuration)

------------------------------

Program Location:

at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal)

at System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(ConfigurationSchemaErrors schemaErrors)

at System.Configuration.BaseConfigurationRecord.ThrowIfInitErrors()

at System.Configuration.ClientConfigurationSystem.EnsureInit(String configKey)

Editado Junho 23, 2010 por Lucas Senior

[Lucas Senior]

<system.serviceModel> <<<< ------- Aqui começa a linha 146

<extensions>

<behaviorExtensions>

<add name="persistenceProvider" type="System.ServiceModel.Configuration.PersistenceProviderElement, System.WorkflowServices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

<add name="workflowRuntime" type="System.ServiceModel.Configuration.WorkflowRuntimeElement, System.WorkflowServices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

<add name="enableWebScript" type="System.ServiceModel.Configuration.WebScriptEnablingElement, System.ServiceModel.Web, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

<add name="webHttp" type="System.ServiceModel.Configuration.WebHttpElement, System.ServiceModel.Web, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

</behaviorExtensions>

<bindingElementExtensions>

<add name="webMessageEncoding" type="System.ServiceModel.Configuration.WebMessageEncodingElement, System.ServiceModel.Web, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

<add name="context" type="System.ServiceModel.Configuration.ContextBindingElementExtensionElement, System.WorkflowServices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

</bindingElementExtensions>

<bindingExtensions>

<add name="wsHttpContextBinding" type="System.ServiceModel.Configuration.WSHttpContextBindingCollectionElement, System.WorkflowServices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

<add name="netTcpContextBinding" type="System.ServiceModel.Configuration.NetTcpContextBindingCollectionElement, System.WorkflowServices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

<add name="webHttpBinding" type="System.ServiceModel.Configuration.WebHttpBindingCollectionElement, System.ServiceModel.Web, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

<add name="basicHttpContextBinding" type="System.ServiceModel.Configuration.BasicHttpContextBindingCollectionElement, System.WorkflowServices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

</bindingExtensions>

</extensions>

<client>

<metadata>

<policyImporters>

<extension type="System.ServiceModel.Channels.ContextBindingElementImporter, system.workflowservices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL"/>

</policyImporters>

<wsdlImporters>

<extension type="System.ServiceModel.Channels.ContextBindingElementImporter, system.workflowservices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL"/>

</wsdlImporters>

</metadata>

</client>

</system.serviceModel>

</configuration>

Editado Junho 23, 2010 por Lucas Senior

[Lucas Senior]

:huh:

Editado Junho 23, 2010 por Lucas Senior

[fulvio]

Bom dia Lucas,

Tente reinstalar a ultima versao do .NET Framework.

Verifique se o serviço do SQL na sua instância está iniciado.

Verifique a opção Windows Authentication.

[Lucas Senior]

Olá Fulvio, bom dia.

Cara, vai entender...

Fiz a conexão remota no cliente hoje e tentei conectar conforme suas instruções.. e a supresa...

Conectou das duas formas...

Vai entender... hehe

De qualquer forma, agradeço seu apoio!

Um abraço!

[fulvio]

rs... Vai entender mesmo. Tem algumas coisas q é preferível nem tentar... hehehe.

Um abraço!!