|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server 2005 Errorthe 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.SqlServerType.Microsoft.SqlServer.Management.UI.ConnectionDlg.IServerType.GetConnectionObject(UIConnectionInfo ci) en Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server) en Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.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.EnsureInit(String configKey) en System.Configuration.ClientConfigurationSystem.PrepareClientConfigSystem(String sectionName) en System.Configuration.ClientConfigurationSystem.System.Configuration.Internal.IInternalConfigSystem.GetSection(String sectionName) en System.Configuration.ConfigurationManager.GetSection(String sectionName) en System.Configuration.PrivilegedConfigurationManager.GetSection(String sectionName) en System.Diagnostics.DiagnosticsConfiguration.GetConfigSection() en System.Diagnostics.DiagnosticsConfiguration.Initialize() en System.Diagnostics.DiagnosticsConfiguration.get_SwitchSettings() 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..cctor() =================================== Sección de configuración no reconocida system.serviceModel. (c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Config\machine.config line 146) (System.Configuration) ------------------------------ Ubicación del programa: en System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal) en System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(ConfigurationSchemaErrors schemaErrors) en System.Configuration.BaseConfigurationRecord.ThrowIfInitErrors() en System.Configuration.ClientConfigurationSystem.EnsureInit(String configKey) Futurist (futur***@gmail.com) writes:
> While trying to connect to Local or Remote Server on the network I "My car won't start, what is happening?"> received the following error, what could be happening? I need help... 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, esq***@sommarskog.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/prodinfo/previousversions/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. Show quoteHide quote "Erland Sommarskog" <esq***@sommarskog.se> wrote in message news:Xns9C13D3C96C23Yazorman@127.0.0.1... > Futurist (futur***@gmail.com) writes: >> While trying to connect to Local or Remote Server on the network I >> received the following error, what could be happening? I need help... > > "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, esq***@sommarskog.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/prodinfo/previousversions/books.mspx > Futurist (futur***@gmail.com) writes:
> Version SQL Server 2005 Std. That's right, I forgot to ask which car you cannot start...> 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. 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, esq***@sommarskog.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/prodinfo/previousversions/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, Show quoteHide quote "Erland Sommarskog" <esq***@sommarskog.se> wrote in message news:Xns9C14162F3081Yazorman@127.0.0.1... > Futurist (futur***@gmail.com) writes: >> 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. > > 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, esq***@sommarskog.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/prodinfo/previousversions/books.mspx > Futurist (futur***@gmail.com) writes:
> Thanks for your help. I think you are going farther than where I am. So you are now saying that you only have problem when you connect locally?> > 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. Can you connect to other SQL Server instances from this machine? What do you specify for the server when you connect? Have you tried just specifying a single dot? How long time does it take before you get the error message? Does it come immediately, or is there a delay? -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.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/prodinfo/previousversions/books.mspx I suspect that this issue could be because of the .Net framework
installation. -- Show quoteHide quoteEkrem Önsoy "Futurist" <futur***@gmail.com>, iletisinde þunu yazdý, news:%23$tWsTx2JHA.3812@TK2MSFTNGP05.phx.gbl... > 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" <esq***@sommarskog.se> wrote in message > news:Xns9C13D3C96C23Yazorman@127.0.0.1... >> Futurist (futur***@gmail.com) writes: >>> While trying to connect to Local or Remote Server on the network I >>> received the following error, what could be happening? I need help... >> >> "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, esq***@sommarskog.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/prodinfo/previousversions/books.mspx >> > >  
Other interesting topics
SSMS 2008 Add-ons: What is the 2008 replacement for SQLWB.EXE?
Move SQL2008 Express to another machine 2008 SSMS object explorer execute long sql script saving SQL files in SSMS as ASCII Maintenance Plan Fails script to cliboard in microsoft SQL server management studio sql server balnk date SQL Server Profiler and Prepared Queries Database diagrams in ss2008 |
|||||||||||||||||||||||
