Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    5

    Question Unanswered: Microsoft iSCSI Initiator & SQL Server services

    Hello all,
    I have Microsoft iSCSI Initiator (SAN) installed on a SQL Server machine and has this drive acting as a local drive. All the database's data files are residing on this drive, attached with SAN.
    It runs as a service "Microsoft iSCSI Initiator" on the SQL Server machine.

    Now the question is, when we restart the SQL Server all the databases change their status to "Suspect" and we have to stop all the sqlserver services (all the SQL instances) and start them all up. This is the only temporary solution we came up with.
    Could any one has any real solution or had encounter such a problem before?

    Any help is appreciated.

    Thanks bunch!
    imransi.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Looks like your SQL Service starts before your SAN is available.

  3. #3
    Join Date
    Sep 2003
    Posts
    5
    Originally posted by rdjabarov
    Looks like your SQL Service starts before your SAN is available.
    You are 100% right. So thats why we are restarting SQL services.
    We can manually start sql services but thats not what we wnat and really thsi should not be the solutuion

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    See if you can "impose" a dependency on MSSQLSERVER service in regards to this SAN service.

  5. #5
    Join Date
    Feb 2009
    Posts
    1
    We had this problem, too. According to our SAN vendor, the fix is as follows:
    Open iSCSI Initiator
    Click the 'Bound Volumes/Devices' tab
    Click 'Bind All"
    Click OK.

    This will force the iSCSI Initiaotr to mount all the volumes before it relinquishes control to other processes, such as SQL Server.

    I just found this solution and haven't had a chance to test it, yet. We will find out if it works tommorrow.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •