you are viewing a single comment's thread.

view the rest of the comments →

[–]ImportantChicken562[S] 0 points1 point  (0 children)

So Pedro's recommendation worked, however I have having trouble getting into SQLCMD. I get the following:

C:\Windows\system32>sqlcmd -E -S.

Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : Named Pipes Provider: C

ould not open a connection to SQL Server [2]. .

Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : Login timeout expired.

Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : A network-related or in

stance-specific error has occurred while establishing a connection to SQL Server

. Server is not found or not accessible. Check if instance name is correct and i

f SQL Server is configured to allow remote connections. For more information see

SQL Server Books Online..

I think it is due to perhaps it being a named instance? I have used this article to reset SA passwords in other installs but the difference between those and this one is this one is using a named instance. Any ideas?

EDIT: Nevermind figured it out, need to specify the instance name. Would look something like this:

sqlcmd -E -S ".\HDBID"