Ошибка Sql Server сразу после старта
От: Eugeni  
Дата: 28.10.06 13:01
Оценка:
У меня такая проблема... запускаю SQL Server 2005 следующим кодом:



            string myServiceName = "MSSQLSERVER"; //Служба SQL Server
            string status; //Статус слуббы (Например, Running or Stopped)

            ServiceController sqlServer = new ServiceController(myServiceName);
            try
            {
                status = sqlServer.Status.ToString();
            }
            catch
            {
                return false;
            }
            if (sqlServer.Status.Equals(ServiceControllerStatus.Running))
            {
                return true;
            }

            //Если сервер остановлен - его необходимо запустить
            if ((sqlServer.Status.Equals(ServiceControllerStatus.Stopped)) || (sqlServer.Status.Equals(ServiceControllerStatus.StopPending)))
            {
                try
                {
                    sqlServer.Start();
                    sqlServer.WaitForStatus(ServiceControllerStatus.Running);
                }
                catch
                {
                    return false;
                }

            }


После этого сразу пытаюсь открыть соединение SqlConnection следующим кодом:



            SqlConnection conn = new SqlConnection()
            conn.ConnectionString = "Initial Catalog=SISTEMA;Data Source=localhost;Integrated Security=SSPI;" providerName="System.Data.SqlClient"
            conn.Open()


При попытке открыть соединение возникает ошибка

Cannot open database "SISTEMA" requested by the login. The login failed.
Login failed for user 'WINTAGE\Eugeni'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open database "SISTEMA" requested by the login. The login failed.
Login failed for user 'WINTAGE\Eugeni'.

Source Error:

Line 99: comm1.Connection = conn;
Line 100: comm1.CommandText = "SELECT * FROM DocumentType";
Line 101: conn.Open();
Line 102: SqlDataReader reader1 = comm1.ExecuteReader();
Line 103: while (reader1.Read())


Source File: D:\Work\LexTransWork\Logic\Repository\MetaData\Configuration.cs Line: 101

Stack Trace:

[SqlException (0x80131904): Cannot open database "SISTEMA" requested by the login. The login failed.
Login failed for user 'WINTAGE\Eugeni'.]
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +575
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +160
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +122
System.Data.SqlClient.SqlConnection.Open() +229
SISTEMA.Repository.Configuration..ctor(DBConnection dbconn, User usr) in D:\Work\LexTransWork\Logic\Repository\MetaData\Configuration.cs:101
SISTEMA.ViewLayer.ApplicationController..ctor(DBConnection dbconn, String htmlHead, String lang) in D:\Work\LexTransWork\ViewLayer\ApplicationController.cs:132
ASP.global_asax.Session_Start() in d:\Work\LexTransWork\View\Global.asax:29

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0
System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +72
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +296
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29
System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters) +17
System.Web.Util.ArglessEventHandlerProxy.Callback(Object sender, EventArgs e) +52
System.Web.SessionState.SessionStateModule.RaiseOnStart(EventArgs e) +175
System.Web.SessionState.SessionStateModule.OnStart(EventArgs e) +29
System.Web.SessionState.SessionStateModule.CompleteAcquireState() +293
System.Web.SessionState.SessionStateModule.BeginAcquireState(Object source, EventArgs e, AsyncCallback cb, Object extraData) +1152
System.Web.AsyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +168
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +191




Если соединение потом попытаться открыть спустя некоторое время (3-5 секунд) Ошибки не возникает, и соединение устанавливается нормально...

Есть идеи в чём проблема?
 
Подождите ...
Wait...
Пока на собственное сообщение не было ответов, его можно удалить.