Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server / July 2008

Tip: Looking for answers? Try searching our database.

Can't connect to database engine in Mgmt Studio (newbie)

Thread view: 
Enable EMail Alerts  Start New Thread
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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.