locked
SA Password for RRS feed

  • Question

  • We moved database from SQL 2008 Express to new SQL 2012 full edition server. According the docs, I need to configure ODBC from the SQL 2008 Express server, but I don't know the password for "sa" account, and there is none knows it.

    Is there anyway I can find it out or change it? Please help.

    Friday, December 1, 2017 4:37 PM

Answers

  • Problem resolved after changed SQL server authentication mode to Mixed
    • Marked as answer by sju2402 Friday, December 1, 2017 9:21 PM
    Friday, December 1, 2017 9:21 PM

All replies

  • https://www.wikihow.com/Reset-SA-Password-in-Sql-Server

    A Fan of SSIS, SSRS and SSAS

    Friday, December 1, 2017 4:59 PM
  • Hi Guoxiong,

    Thanks for information, and I changed the sa password. However, when I ran ODBC and tried to connect to new SQL 2012 server. I got the following Connection failed error:

    SQLState: "01000"

    SQL Server Error: 67

    [Microsoft][ODBC SQL Driver][DBNETLIB]ConnectionOpen

    (Connect()).

    Connection: failed:

    SQLState: "08001"

    SQL Server Error: 17

    [Microsoft][ODBC SQL Server Drive][DBNETLIB]SQL Server doesn not exist or access denied.

    I checked firewall is off, and SQL remote access is allowed on both SQL servers. Is there anything I miss to check? Thanks!

    Friday, December 1, 2017 7:12 PM
  • Problem resolved after changed SQL server authentication mode to Mixed
    • Marked as answer by sju2402 Friday, December 1, 2017 9:21 PM
    Friday, December 1, 2017 9:21 PM