SQL Server Forum / DB Engine / SQL Server / July 2008
Can't connect to database engine in Mgmt Studio (newbie)
|
|
Thread rating:  |
Mike in Nebraska - 30 Jul 2008 12:52 GMT [also posted in microsoft.public.sqlserver.setup newsgroup] I need some more help.
I have uninstalled & reinstalled SQL Server 2005 5 times now and keep getting stuck at the same point. During setup I use a Domain User account for SQL; I choose (this last time) Mixed Mode on authentication and set a long sa password; I installed the database engine, integration, and the online books, etc. selection; I do not install a default instance, but DO install a named instance.
It completes the installation with no errors, same with the configuration wizards. I then open up SQL Server Management Studio and attempt to connect to the datbase engine -- it fails every time. I've tried Windows Authentication (which has the Domain Admin's name greyed out - I logged on with this account to install SQL), and SQL Authentication -- trying the sa account and the Domain User account I installed SQL under. All no good. I can connect to integration services and the online books, etc (can't remember the name) just fine. The error I get is:
===================================
Cannot connect to WCT-SHAREPOINT.
===================================
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)
------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer& EvtID=2&LinkId=20476
------------------------------ Error Number: 2 Severity: 20 State: 0
------------------------------ Program Location:
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server) at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
I've verified that the SQL Server 2005 service is started, and then restart it for good measure. Makes no difference. I've also rebooted, no change.
What did I do wrong?
 Signature Mike Webb Platte River Whooping Crane Maintenance Trust, Inc. a conservation non-profit (501 (c)(3)) organization Wood River, NE
vinu - 30 Jul 2008 13:29 GMT Hi
Do this
start->all programs->sql server 2005->Configuration tools->SQL Server Surface Area Configuration
on the SQL Server Surface Area Configuration screen click the Surface Area Configuration for service and connection->Remote Connection-> select the Local and remote connections and select using tcp/ip only. click apply and restart sql server service
 Signature vinu http://oneplace4sql.blogspot.com/
> [also posted in microsoft.public.sqlserver.setup newsgroup] > I need some more help. [quoted text clipped - 92 lines] > > What did I do wrong? Mike in Nebraska - 30 Jul 2008 13:39 GMT Will do, thanks.
> Hi > [quoted text clipped - 113 lines] >> >> What did I do wrong? Mike in Nebraska - 30 Jul 2008 14:29 GMT Crud, same result. I did as suggested; I was already at "local and remote", but had to change to "TCP/IP only". Restarted the SQL service, tried to connect to the database engine via Windows Authentication and got this error:
===================================
Cannot connect to WCT-SHAREPOINT.
===================================
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)
------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer& EvtID=2&LinkId=20476
------------------------------ Error Number: 2 Severity: 20 State: 0
------------------------------ Program Location:
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server) at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser() ============================ What next? Mike =============================
> Hi > [quoted text clipped - 113 lines] >> >> What did I do wrong? vinu - 30 Jul 2008 14:49 GMT Ok.. Have you tried to connect using sa and sa password.? Is this is a default instance or named instance ?
try this
open management studio on the Connect to server window, select <browse for more..> in the Server name drop down on browse for server>Data base engine (what does it say)
 Signature vinu http://oneplace4sql.blogspot.com/
> Crud, same result. I did as suggested; I was already at "local and > remote", but had to change to "TCP/IP only". Restarted the SQL service, [quoted text clipped - 195 lines] >>> >>> What did I do wrong? Mike in Nebraska - 30 Jul 2008 15:09 GMT Okay, I got in.
To answer your questions in order: (1) Not yet. Would I do that from the connection window by selecting SQL Server Authentication? (2) Named instance. I didn not install a default instance. (3) It said: "WCT-SHAREPOINT\WCTINTRANET". Interestingly enough, when I looked at the other tab for server connections, I saw a workstation and my DC that are running editions of SQL Server 2005 (Visual Studio 2007, and Symantec Backup Exec version 12).
Once I chose the listing in (3), I was able to connect. Thanks!
Mike
> Ok.. > Have you tried to connect using sa and sa password.? [quoted text clipped - 210 lines] >>>> >>>> What did I do wrong? Aaron Bertrand [SQL Server MVP] - 30 Jul 2008 14:57 GMT Is WCT-SHAREPOINT in the same domain as your workstation? Are you sure your domain account (or an AD group you are in) has valid access to SQL Server?
On 7/30/08 9:29 AM, in article e9TD$fk8IHA.3336@TK2MSFTNGP03.phx.gbl, "Mike in Nebraska" <Mike_Webb@whoopingcrane.org> wrote:
> Crud, same result. I did as suggested; I was already at "local and remote", > but had to change to "TCP/IP only". Restarted the SQL service, tried to [quoted text clipped - 146 lines] >>> exception, Boolean breakConnection) >>> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjec>>> t
>>> stateObj) >>> at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, [quoted text clipped - 14 lines] >>> Boolean redirectedUserInstance) >>> at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentit>>> y
>>> identity, SqlConnectionString connectionOptions, Object providerInfo, >>> String [quoted text clipped - 30 lines] >>> >>> What did I do wrong? Mike in Nebraska - 30 Jul 2008 15:13 GMT Yes, but let me explain. WCT-SHAREPOINT is an application server running Windows Server 2003 R2 SP2. I'm not using a workstation in this process at all. The account I used is a Domain User with logon rights for WCT-SHAREPOINT. I don't know what else I should have done to the account so that it has all access necessary for SQL. Can you point me to a reference in Technet or elsewhere?
TIA, Mike
> Is WCT-SHAREPOINT in the same domain as your workstation? Are you sure > your [quoted text clipped - 228 lines] >>>> >>>> What did I do wrong? Aaron Bertrand [SQL Server MVP] - 30 Jul 2008 14:57 GMT Also, have you tried by IP instead of name? Who named the server with a dash in it? That is bound to cause problems down the road.
On 7/30/08 9:29 AM, in article e9TD$fk8IHA.3336@TK2MSFTNGP03.phx.gbl, "Mike in Nebraska" <Mike_Webb@whoopingcrane.org> wrote:
> Crud, same result. I did as suggested; I was already at "local and remote", > but had to change to "TCP/IP only". Restarted the SQL service, tried to [quoted text clipped - 146 lines] >>> exception, Boolean breakConnection) >>> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjec>>> t
>>> stateObj) >>> at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, [quoted text clipped - 14 lines] >>> Boolean redirectedUserInstance) >>> at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentit>>> y
>>> identity, SqlConnectionString connectionOptions, Object providerInfo, >>> String [quoted text clipped - 30 lines] >>> >>> What did I do wrong? Mike in Nebraska - 30 Jul 2008 15:15 GMT I didn't try by IP. I'm the guy who named it. Didn't know about the "dash" being a source of problems. No error when I created it so I assumed it was valid.
Mike
> Also, have you tried by IP instead of name? Who named the server with a > dash in it? That is bound to cause problems down the road. [quoted text clipped - 227 lines] >>>> >>>> What did I do wrong?
|
|
|