how to reset sa password in sql server 2014

reprint please indicate from Zhu Zhu Homeland http://blog.csdn.net/zhgl7688To modify the SA authentication login method in SQL Server:1. In the Start menu, locate SQL Server Management Studio, double-click Open, enter with Windows authentication.2. Select "

SQL2008 user ' sa ' Login failed (Error 18456) graphic solution SQL2008 unable to connect to. \sqlexpress, user ' sa ' Login failed (Error 18456) graphic solutionA problem occurred:Title: Connecting to a server------------------------------Unable to connect to. \sqlexpress.------------------------------Additional Information:User '

Suitable for sqlserver2005 and above, not fit to 2000 First find SQL Server Management Studio in the Start menu and start it, and connect with Windows authentication, as shown in the following figure: Figure 1 Figure II Expand Security----The login name in Object Explorer on the left to locate the SA user, as shown in Righ

1. Using management Studio Express, log in with Windows authentication, select the SQL Server name, right-click the mouse to select Properties, and in the Server Properties Options page, select Security to change server authentication from Windows authentication to SQL

Tags: problem: Mode needs to manage LTE account the Mode editor RosTo resolve an issue that does not have SQL Server authentication enabled:1. Run regedit and go to Registry Editor2. Open: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL server\mssql14. Mssqlserver\mssqlserver (MSSQL14. MSSQLSERVER This section is s

Error message: Change to log on SA failed ...With the impression that it takes two steps to enable, the login mode in the server properties is changed to SQL Server and Windows mode first.The second step of the server login name in the right-click

Home Install SQL Server How to turn on SA user logon:(Remember to follow the Web site operation, the final must be in the "Administrative Tools" in the "service" in the "SQL Server (MSSQL server)" to deactivate once before startin

I have to write down some of the problems that I have encountered many times. The lessons have been delayed for a lot of time. Problem description Write a code to connect to the Database SQL Server in Java; As follows: Import java. SQL .*; Public class tosql2000 {Public static void main (string [] SRG ){String drivername = "com. Microsoft. JDBC. sqlserver. sqlser

Today, after I installed the database, I encountered a Problem When configuring the obdc of the data source. As follows: The reason is that the database is not connected successfully. When performing the following link, Unexpected situation Solution: 1. Open the database-log on to the database as a Windows User 02. login name -- double-click SA (Open attributes) 03. General -- set the

Tags: io using SP data issues AD BS database serverIt is dangerous to allow SA users to be remote. The recommended practice is to create a new local user that allows remote connections.1. Enable the TCP/IP protocol.2. Configure the listening port (1433).Net-an Check if the local port is listening, use the online IP port test tool to test if the remote port is open.3. Create a remote login user4.1. Using Management Studio ExpressWithWindowsAuthenticati

Solution: User 'sa 'logon fails. Cause: it is not associated with a trusted SQL server connection. I encountered this problem during my authentication today, so I sorted out my solutions for my friends who encountered the same problem: Problem description:User 'sa 'Login Failed. Cause: it is not associated with a trus

You can use the following solutions. 1. enable SQL Serve Authentication SQL Server Management studio -- Object resource manager -- Right-click your server (. \ sqlexpress or localhost) -- properties -- Security -- Server Authentication --

Solution: User 'sa 'logon fails. Cause: it is not associated with a trusted SQL server connection. I encountered this problem during my authentication today, so I sorted out my solutions for my friends who encountered the same problem: Problem description:User 'sa 'Login Failed. Cause: it is not associated with a tru

After obtaining the SA password, the Administrator account cannot be added because the Server Manager or "predecessors" will net.exe and Net1.exe be restricted to use. We know that VBS has a Winnt object in the Active Directory (ADSI) that manages local resources and can be used to add an administrator without relying on commands like CMD, as follows: After obt

Tags: lib trigger log-Eve Disable Origin event NSAOriginal Sticker Address:51580102The specific methods are:Create a TriggerCREATE TRIGGER Forbiddensaon all SERVER with EXECUTE as'SA'For Logonasbegin--Select SA user to restrict: IF Original_login ()='SA'--allow SA to log on natively "" and (select EVENTDATA (). Value (

First: The local IP cannot be logged in (mainly because the remote server is not turned on)Note details: Determine if the port is in a spell, Telnet IP port (if the error is not an internal or external command, and is not a running program)Workaround:1: Open the Control Panel--------program and features---------turn window function on or off-------select Telnet client--------Click Done, then test the Telnet IP port2: Notice whether firewall blocking,

Tags: view article sql Alt issue by resolving fileAfter SQL Server is installed today, SQL Server can only log on with Windows identity, and cannot log on with SQL Server, such as

A connection has been established with the server, but an error occurs during logon. When you log on to sql2005 Enterprise Manager, you can use Windows for authentication. However, when you use SQL Server for authentication, that is, the SA user name is logged on, the following error message is displayed: "provider: Sh

Server Prerequisites need tools: SQL Query Analyzer and SqlExec sunx Version 　　 The first part: 　　 Analysis and summary of the protection system for removing xp_cmdshell: First know the statement: 1. The way to remove the xp_cmdshell extension process is to use the following statement: if exists (SELECT * from dbo.sysobjects where id=object_id (N ' [dbo].[ Xpcmdshell] and OBJECTPROPERTY (id,n ' Isextend

Problem: Login Failed for user 'sa '. Reason: not associated with a trusted SQL server connection. You can connect to the database on the local SQL Server, but there is a problem with the connection to the server, the reason is a