error logging on SQL 2008

Hello All,

I did have the same kind of a problem previously, and I now got it again -
"cannot connect to localhost".

I made a new installation of SQL 2008 on a Windows Server 2008, installed
SP1 for SQL 2008, and after the restart of the machine, I cannot get in
using SQL Server Management Studio (I get the error below).

It is funny - I am logged on as local administrator, so I should have all
the rights...!

Anyhow, how do I connect to the server now, to check the security/logins...?

Thank you in advance,

regards

Zoran

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

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

Cannot connect to localhost.

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

Login failed for user 'OurMachine\Administrator'. (.Net SqlClient Data
Provider)

------------------------------
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

------------------------------
Server Name: localhost
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536


------------------------------
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.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK)
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()

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


.

Relevant Pages

  • Re: Value does not fall within the expected range.
    ... stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, ... String newPassword, Boolean redirectedUserInstance, SqlConnection ... owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at ...
    (microsoft.public.sharepoint.windowsservices)
  • connection failure
    ... I have set up the set up the SQL Server 2005 developer, ... owningObject, SqlConnectionString connectionOptions, Int64 timerStart) ... owningObject, SqlConnectionString connectionOptions, String newPassword, ... Boolean redirectedUserInstance) ...
    (microsoft.public.sqlserver.setup)
  • Re: error logging on SQL 2008
    ... Administrators group as a Login in SQL server! ... owningObject, SqlConnectionString connectionOptions, Int64 timerStart) ... owningObject, SqlConnectionString connectionOptions, String newPassword, ...
    (microsoft.public.sqlserver.server)
  • Re: How do I use sp_configure user instances enabled
    ... Message="Generating user instances in SQL Server is disabled. ... owningObject, SqlConnectionString connectionOptions, Int64 timerStart) ... owningObject, SqlConnectionString connectionOptions, String newPassword, ... I have a running version of SQL SERVER Express on my system and whether I ...
    (microsoft.public.sqlserver.connect)
  • Re: connection failure
    ... Login as a login Administartor and connect to SSMS. ... I have set up the set up the SQL Server 2005 developer, ... owningObject, SqlConnectionString connectionOptions, Int64 timerStart) ... owningObject, SqlConnectionString connectionOptions, String newPassword, ...
    (microsoft.public.sqlserver.setup)