Почему не запускается sql сервер?

Question

[VeyDlin]

Использую EntityFramework
Сервер без проблем запускаться на моем ПК, но как только я публикую приложение на raspberry pi c windows 10 iot то получаю исключение

.\TestApp.exe : Unhandled exception. Microsoft.Data.SqlClient.SqlException (0x80131904): 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: SNI_
PN11, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly in
stalled and that the Local Database Runtime feature is enabled.)
+ CategoryInfo : NotSpecified: (Unhandled excep...re is enabled.):String) [], RemoteException
+ FullyQualifiedErrorId : NativeCommandError

---> System.ComponentModel.Win32Exception (2): The system cannot find the file specified.
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1
wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConne
ctionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean i
gnoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean w
ithFailover, SqlAuthenticationMethod authType)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Secu
reString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Secu
reString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential creden
tial, TimeoutTimer timeout)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString conne
ctionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInsta
nce)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString co
nnectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boo
lean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean apply
TransientFaultHandling, String accessToken, DbConnectionPool pool)
at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey p
oolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOpt
ions)
at Microsoft.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owning
Object, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at Microsoft.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOpti
ons, DbConnectionInternal oldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions use
rOptions, DbConnectionInternal oldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleOb
jectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInterna
l& connection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 r
etry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSou
rce`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnec
tionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactor
y connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides)
at Microsoft.Data.SqlClient.SqlConnection.Open()
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenDbConnection(Boolean errorsExpected)
at Microsoft
.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerDatabaseCreator.<>c__DisplayClass18_0.b
__0(DateTime giveUp)
at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.<>c__DisplayClass12_0`2.b__0(DbContext c, TSta
te s)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TStat
e state, Func`3 operation, Func`3 verifySucceeded)
at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.Execute[TState,TResult](IExecutionStrategy strategy, TS
tate state, Func`2 operation, Func`2 verifySucceeded)
at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.Execute[TState,TResult](IExecutionStrategy strategy, TS
tate state, Func`2 operation)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerDatabaseCreator.Exists(Boolean retryOnNotExists
)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerDatabaseCreator.Exists()
at Microsoft.EntityFrameworkCore.Storage.RelationalDatabaseCreator.EnsureCreated()
at Microsoft.EntityFrameworkCore.Infrastructure.DatabaseFacade.EnsureCreated()
at TestApp.Database.DatabaseContext..ctor() in D:\Projects\C#\TestApp\TestApp\Database\DatabaseContext.cs:line 36
at TestApp.Program.Main(String[] args) in D:\Projects\C#\TestApp\TestApp\Program.cs:line 37
ClientConnectionId:00000000-0000-0000-0000-000000000000
Error Number:2,State:0,Class:20

Answer 1

[d-stream]

The server was not found or was not accessible

сервер откликается на внешние подключения? малинка знает "как к нему пройти"?

Comments

[VeyDlin]

Если честно, я не очень понимаю как работает EntityFramework внутри, я пытался найти описание, но везде только инфа о его использовании

У меня вызывается метод

UseSqlServer("Server=(localdb)\\mssqllocaldb;Database=XylaraxDB;Trusted_Connection=False;");

На моем ПК я вообще не поднимаю никаких серверов, приложение само его поднимает, само находит путь, и эта часть меня немного смущает своей неизвестностью. Но я предположил что малина должна была сама все сделать так же (точнее мой код), но нет

[NewDevLab]

ВэйДлин, так сервер должен быть, а его нет.
и там mssql не уверен, что поставится.
лучше на iot более легковесные СУБД использовать.
sqlite например.

[#]

ВэйДлин, гуглите sql server connection string

[#]

NewDevLab, по ошибке, было автору

[#]

ВэйДлин, в частности Server=(localdb) это всегда попытка подключиться к серверу, на том же компе где запускается приложение

.. у вас на малинке есть sql server? ;))