Error logging in to SQL to move WSUS
i running sbs 2008 , trying move susdb database c: drive drive when logging in sql server management studio following error: "cannot connect \\.\pipe\mssql$microsoft##ssee\sql\query login failed user domain\network admin error 18456.this might more of sql issue wsus have ideas? following guide http://blogs.technet.com/b/sbs/archive/2009/09/23/how-to-move-wsus-content-and-database-files-to-a-different-partition.aspx , have tried can think of
cannot connect \\.\pipe\mssql$microsoft##ssee\sql\query login failed user domain\network admin
since sbs2008, , not standard windows server system, , sbs2008 (premium edition) includes sql server workgroup edition -- possible wsus running on workgroup edition instance , not windows internal database?
generally speaking domain\administrator account should able establish named pipes connection wid instance running on domain controller. (in fact, think may account can connect!) so, yes, think sql server question.
lawrence garvin, m.s., mcitp:ea, mcdba, mcsa
product manager, solarwinds
microsoft mvp - software distribution (2005-2012)
mvp profile: http://mvp.support.microsoft.com/profile/lawrence.garvin
Windows Server > WSUS
Comments
Post a Comment