Long path names to files on sql server installation media как исправить ошибку

• December 13, 2013 at 10:17 am

  #285954

  I’m getting a rule check fail “Long path names to files on SQL Server Installation media failed” when installing SQL 2012 Standard edition from a network share. What is the work around for this?

  Thanks

• Steve Jones – SSC Editor

  SSC Guru

  Points: 731245

  My understanding is that this is a check to be sure all files/paths are < 256 characters. Do you have long paths for the installation folder?

• Lowell

  SSC Guru

  Points: 323498

  cathy.baker (12/13/2013)

  ---

  I’m getting a rule check fail “Long path names to files on SQL Server Installation media failed” when installing SQL 2012 Standard edition from a network share. What is the work around for this?

  Thanks

  i believe you can simply map a drive to the share,and install form that, instead of from the share with the long file name;;

  here’s gui instructions:

  http://windows.microsoft.com/en-us/windows/create-shortcut-map-network-drive#1TC=windows-7

  from a command line, it’s pretty simple:

  net use m: \servernamesharenamesubsharesubshare2

  Lowell

  ---

  —help us help you! If you post a question, make sure you include a CREATE TABLE… statement and INSERT INTO… statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• cathy.baker

  Hall of Fame

  Points: 3412

• cathy.baker

  Hall of Fame

  Points: 3412

  I renamed the folder that was WAY long to something shorter and simpler then mapped the drive. That fixed the problem.

• Jeff Moden

  SSC Guru

  Points: 1002798

  cathy.baker (12/13/2013)

  ---

  I renamed the folder that was WAY long to something shorter and simpler then mapped the drive. That fixed the problem.

  Thanks for the feedback, Cathy.

• adamenko1984

  Valued Member

  Points: 67

  Long Path Tool could be the answer to your problem. I too faced a similar predicament some time back. Long Path Tool came in very handy at that time.

• virenderverma

  SSC Journeyman

  Points: 75

  On my case my sql server path was very long

  D:Softwareen_sql_server_2008_r2_enterprise_x86_x64_ia6t4_dvd_520517en_sql_server_2008_r2_enterprise_x86_x64_ia64_dvd_520517setup.exe

  I just renamed that to

  D:Softwaresql serversql serversetup.exe

  then work fine for me

  😀

• bitf11m050

  Valued Member

  Points: 67

  Thanks dude, solved my problem the same way:-)

• March 24, 2017 at 2:02 am

  This was removed by the editor as SPAM

• March 24, 2017 at 2:03 am

  This was removed by the editor as SPAM

• March 24, 2017 at 2:03 am

  This was removed by the editor as SPAM

• March 24, 2017 at 2:03 am

  This was removed by the editor as SPAM

• March 24, 2017 at 2:03 am

  This was removed by the editor as SPAM

• March 24, 2017 at 2:04 am

  This was removed by the editor as SPAM

it seems you are installing SQL2K8 from a network share with more than 260 characters in its path name. this can be fixed by shorten the path name using SUBST command.

SUBST /?
Associates a path with a drive letter.

SUBST [drive1: [drive2:]path]
SUBST drive1: /D

  drive1:        Specifies a virtual drive to which you want to assign a path
  [drive2:]path  Specifies a physical drive and path you want to assign to
                 a virtual drive.
  /D             Deletes a substituted (virtual) drive.

Type SUBST with no parameters to display a list of current virtual drives.

Open in new window

for example, to shorten \server1path2folder3subfolder4sql2008 to drive Z:, type the following on command prompt.

SUBST Z: \server1path2folder3subfolder4sql2008

then install SQL2K8 from Z:

hope it helps,
bbao

DAKTRONICS DOES NOT PROMISE THAT THE CONTENT
PROVIDED HEREIN IS ERROR-FREE OR THAT ANY DEFECTS WILL BE CORRECTED, OR THAT
YOUR USE OF THE CONTENT WILL PROVIDE SPECIFIC RESULTS. THE CONTENT IS DELIVERED
ON AN “AS-IS” AND “AS-AVAILABLE” BASIS. ALL INFORMATION PROVIDED IN THIS ARTICLE
IS SUBJECT TO CHANGE WITHOUT NOTICE. DAKTRONICS DISCLAIMS ALL WARRANTIES,
EXPRESS OR IMPLIED, INCLUDING ANY WARRANTIES OF ACCURACY, NON-INFRINGEMENT,
MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. DAKTRONICS DISCLAIMS ANY
AND ALL LIABILITY FOR THE ACTS, OMISSIONS AND CONDUCT OF YOU OR ANY THIRD
PARTIES IN CONNECTION WITH OR RELATED TO YOUR USE OF THE CONTENT. ADJUSTMENT,
REPAIR, OR SERVICE OF THE EQUIPMENT BY ANYONE OTHER THAN DAKTRONICS OR ITS
AUTHORIZED REPAIR AGENTS MAY VOID THE EQUIPMENT WARRANTY. YOU ASSUME TOTAL
RESPONSIBILITY FOR YOUR USE OF THE CONTENT AND ANY LINKED CONTENT. YOUR SOLE
REMEDY AGAINST DAKTRONICS FOR DISSATISFACTION WITH THE CONTENT IS TO STOP USING
THE CONTENT. THIS LIMITATION OF RELIEF IS A PART OF THE BARGAIN BETWEEN THE
PARTIES.

The above disclaimer applies to any property damage, equipment
failure, liability, infringement, or personal injury claim arising out of or in
any way related to your use or application of the content, whether such claim is
for breach of contract, tort, negligence or any other cause of action.