While trying to connect to Local or Remote Server on the network I received
the following error, what could be happening? I need help...
It's a SQL SERVER 2005 + SP2

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

No se puede conectar a SQLSERVER2005.

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

Se produjo una excepción en el inicializador de tipo de
'System.Data.SqlClient.SqlConnection'. (System.Data)

------------------------------
Ubicación del programa:

en System.Data.SqlClient.SqlConnection..ctor()
en
Microsoft.SqlServer.Management.UI.ConnectionDlg.Sq lServerType.Microsoft.SqlServer.Management.UI.Conn ectionDlg.IServerType.GetConnectionObject(UIConnec tionInfo
ci)
en
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.ObjectExplorer.ValidateConnection(UIC onnectionInfo
ci, IServerType server)
en
Microsoft.SqlServer.Management.UI.ConnectionDlg.Co nnector.ConnectionThreadUser()

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

Se produjo una excepción en el inicializador de tipo de
'System.Data.SqlClient.SqlConnectionFactory'. (System.Data)

------------------------------
Ubicación del programa:

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

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

Se produjo una excepción en el inicializador de tipo de
'System.Data.SqlClient.SqlPerformanceCounters'. (System.Data)

------------------------------
Ubicación del programa:

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

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

Error en la inicialización del sistema de configuración
(System.Configuration)

------------------------------
Ubicación del programa:

en System.Configuration.ClientConfigurationSystem.Ens ureInit(String
configKey)
en
System.Configuration.ClientConfigurationSystem.Pre pareClientConfigSystem(String
sectionName)
en
System.Configuration.ClientConfigurationSystem.Sys tem.Configuration.Internal.IInternalConfigSystem.G etSection(String
sectionName)
en System.Configuration.ConfigurationManager.GetSecti on(String
sectionName)
en System.Configuration.PrivilegedConfigurationManage r.GetSection(String
sectionName)
en System.Diagnostics.DiagnosticsConfiguration.GetCon figSection()
en System.Diagnostics.DiagnosticsConfiguration.Initia lize()
en System.Diagnostics.DiagnosticsConfiguration.get_Sw itchSettings()
en System.Diagnostics.Switch.InitializeConfigSettings ()
en System.Diagnostics.Switch.InitializeWithStatus()
en System.Diagnostics.Switch.get_SwitchSetting()
en System.Diagnostics.TraceSwitch.get_Level()
en System.Data.ProviderBase.DbConnectionPoolCounters. .ctor(String
categoryName, String categoryHelp)
en System.Data.SqlClient.SqlPerformanceCounters..ctor ()
en System.Data.SqlClient.SqlPerformanceCounters..ccto r()

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

Sección de configuración no reconocida system.serviceModel.
(c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Con fig\machine.config line
146) (System.Configuration)

------------------------------
Ubicación del programa:

en System.Configuration.ConfigurationSchemaErrors.Thr owIfErrors(Boolean
ignoreLocal)
en
System.Configuration.BaseConfigurationRecord.Throw IfParseErrors(ConfigurationSchemaErrors
schemaErrors)
en System.Configuration.BaseConfigurationRecord.Throw IfInitErrors()
en System.Configuration.ClientConfigurationSystem.Ens ureInit(String
configKey)

Futurist (futurist (AT) gmail (DOT) com) writes:
"My car won't start, what is happening?"

For the local server, please show the connect string you are using, and
tell us which edition of SQL Server you are connecting to. Also, before
you post back, please check in SQL Server Configuration Manger that the
server is running.

For the remote server, I would again like to see the connection string,
and that you verify that the instance is running. Also check in SQL Server
Configuration Manager on the remote server that it accepts remote
connections. If it's a named instance, check that the SQL Browser Service
is running. Also, check the firewall connection on the remote connection.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Version SQL Server 2005 Std.
It seems to be a Tools Error. All the servers can be logged through the
network, but I cannot do it locally. I tried to uninstall SQL Tools and
reinstall it, with no results. Still the same error.




"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

Futurist (futurist (AT) gmail (DOT) com) writes:
That's right, I forgot to ask which car you cannot start...

Really, you cannot get much help, if you don't provide enough information.
Connectivity problems often concerns network configuratons, firewalls etc
that are not part of SQL Server themselves, but still can cause a lot of
problems. Therefore it is essential that you provide as much information
as possible?

So the problem is that you cannot connect to any SQL Server instances from
your workstation? Can you connect to the instances from other machines?
Can you connect with other programs than just the SQL tools? (There is
little reason to believe the problem would be them as such.)

What do you mean with "All the servers can be logged throuh the network"?
What can you reach? The machines themselves? Or the actual SQL Server
instances?

What is "locally"? Are you in a domain? Or a workgroup? Is there a VPN
connection involved?

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Erland,

Thanks for your help. I think you are going farther than where I am.

SQL Version: SQL Server 2005 Std + SP2 as a Member Server
No Firewalls Activated.
The server can be seen from the network: Management Studio
The only problem is in the server, when I try to connect with the management
studio in front of the server to the default instance I have, Windows or SQL
authentication, I received the message written before.

Regards,


"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

I suspect that this issue could be because of the .Net framework
installation.

--
Ekrem Önsoy


"Futurist" <futurist (AT) gmail (DOT) com>, iletisinde þunu yazdý,
news:%23$tWsTx2JHA.3812 (AT) TK2MSFTNGP05 (DOT) phx.gbl...