provider: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol) (.Net SqlClient Data Provider)
Hello please help.Am using Sql Server Express..I installed Driver for PHP and for Sql Server,then
wanted to access Adventureworks Database from PDO php data object and I got an error message requesting me to Install ODBC Driver 17,in which i deed, ODBC Driver 17 was installed,I started having this issue,,
Now,, I couldn't login with PDO Driver nor login directly to my SSMS,,I have tried to uninstall ODBC Driver 17 but still having error 28..it says
[Cannot connect to A@@@sss\SQLEXPRESS
. ===================================
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol) (.Net SqlClient Data Provider) ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476 ------------------------------ Error Number: -1 Severity: 20 State: 0 ------------------------------ Program Location: at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) 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()]
Are you trying to access it from the same machine as the SQL Server Express instance, or from another machine?
Which protocols are enabled? https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-or-disable-a-server-network-protocol?view=sql-server-ver15
Yes from the same machine,this started when I installed ODBC Driver 17,,because I want to access my database with PDO Driver(PHP) then a message pop up asking me to install ODBC Driver 17,then
after the ODBC Driver was installed,I couldn't login still,and I decided to login directly to my SSMS to see if I could login,I started seeing this error 28..
But now if I disconnect my internet (Network) I could Login,as soon as the internet is connected access is denied ..Please what is causing this..
I enable Named Pipe
Shared Memory and
TCP/iP......
I'm getting this message from my Event view
Log Name: Microsoft-Windows-Kernel-EventTracing/Admin Source: Microsoft-Windows-Kernel-EventTracing Date: 3/9/2020 4:56:08 PM Event ID: 2 Task Category: Session Level: Error Keywords: Session User: NT SERVICE\MSSQL$SQLEXPRESS Computer: AtlantaHome Description: Session "RsFx0600 Kernel Log" failed to start with the following error: 0xC0000035 Event Xml: <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">; <System> <Provider Name="Microsoft-Windows-Kernel-EventTracing" Guid="{b675ec37-bdb6-4648-bc92-f3fdc74d3ca2}" /> <EventID>2</EventID> <Version>0</Version> <Level>2</Level> <Task>2</Task> <Opcode>12</Opcode> <Keywords>0x8000000000000010</Keywords> <TimeCreated SystemTime="2020-03-09T20:56:08.869289900Z" /> <EventRecordID>107</EventRecordID> <Correlation /> <Execution ProcessID="7156" ThreadID="8320" /> <Channel>Microsoft-Windows-Kernel-EventTracing/Admin</Channel> <Computer>AtlantaHome</Computer> <Security UserID="S-1-5-80-3880006512-4290199581-1648723128-3569869737-3631323133" /> </System> <EventData> <Data Name="SessionName">RsFx0600 Kernel Log</Data> <Data Name="FileName"> </Data> <Data Name="ErrorCode">3221225525</Data> <Data Name="LoggingMode">33024</Data> </EventData> </Event>
I have to enable those if am using my Local computer ,?? Thank you @ThomasRushto
n
