Installing SQL Express R2
Michel Vanderbeke
I installed SQL Server 2008 R2 Express with advanced services edition
november x64 on a Windows 7 Ultimate x64 system.
Altough I see that SQL server is running when I check the services, I cannot
make a connection through SQL Server Management Studio. The error I get is:
===================================
Cannot connect to (local).
===================================
Er is een netwerkfout of een exemplaarspecifieke fout opgetreden tijdens het
maken van verbinding met SQL Server. De server is niet gevonden of is niet
toegankelijk. Controleer of de exemplaarnaam correct is en of in de
instellingen van SQL Server externe verbindingen zijn toegestaan. (provider:
Provider van named pipes, error: 40 - Kon geen verbinding met SQL Server
openen) (.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.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection(UIConnectionInfo
ci, IServerType server)
at
Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
Can someone please help me to solve this?
Many thanks and greetings,
Michel
mp
I installed c# express and vbnet express which I'm pretty sure install sql
express at the same time
I think sql server is installed and running, as I can find sql server
configuration manager and it shows sql server (running)
but i can't find any shortcut to SQL Server Management Studio.
i don't see any obviously named exe files in C:\Program Files\Microsoft SQL
Server\MSSQL10.SQLEXPRESS\MSSQL\Binn
I can go to command prompt and type sqlcmd -L and get
Servers :
(nothing following that line so apparently something is not turned on???
I'm a total newb at all this, just wondering if you knew how to find SQL
Server Management Studio
thanks
mark
"Michel Vanderbeke" <michel.v...@skynet.be> wrote in message
news:ukvSTfub...@TK2MSFTNGP06.phx.gbl...
Erland Sommarskog
> I installed SQL Server 2008 R2 Express with advanced services edition
> november x64 on a Windows 7 Ultimate x64 system. Altough I see that SQL
> server is running when I check the services, I cannot make a connection
> through SQL Server Management Studio. The error I get is:
>
>
>===================================
> Cannot connect to (local).
>===================================
to .\SQLEXPRESS or (local)\SQLEXPRESS rather than just "(local)".
--
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 Sommarskog
> sorry to hijack your thread but I also am trying to get this to run...
> I installed c# express and vbnet express which I'm pretty sure install sql
> express at the same time
> I think sql server is installed and running, as I can find sql server
> configuration manager and it shows sql server (running)
> but i can't find any shortcut to SQL Server Management Studio.
> i don't see any obviously named exe files in C:\Program Files\Microsoft
> SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn
>
> I can go to command prompt and type sqlcmd -L and get
> Servers :
>
> (nothing following that line so apparently something is not turned on???
>
> I'm a total newb at all this, just wondering if you knew how to find SQL
> Server Management Studio
sqlcmd -S .\SQLEXPRESS