0
Try to use command prompt to change your sql sa password.
First, open a command prompt (Start -> Run -> cmd)
Then, type the follow commands, and press Enter after each line:
Osql -S yourservername -E
1> EXEC sp_password NULL, 'yourpassword', 'sa'
2> GO
Wiki User
∙ 13y ago
Wiki User
∙ 15y agoGo to "Start Menu" then to the right select "Control Panel" then click the "User Accounts" icon select the account you wish to modify, and click change password.
Add your answer:
Earn +20 pts
What are the login authentication methods in sql server 2005?
SQL Authentication Windows Authentication (Domain)
How do you make an SQL Server login account for MySQL admin and query?
All MySQL user accounts can be made by querying "CREATE '[username]' @ '[server]' IDENTIFIED BY '[password]'", where [username], [server], and [password] should be filled in with appropriate data. The two exceptions to this are usernames "admin" and "dummy" which have no passwords.
Difference between sql server 2003 sql server 2005?
There is no such thing as SQL Server 2003. Microft released SQL Server 2005 as the next version of SQL Server 2000.
I lost sql server password how i can reset sql sa password?
Hi, you can try to use command prompt to reset your lost password. I have used it to reset sql sa password successfully on sql server 2000/2005. First, open a command prompt (Start -> Run -> cmd) Then, type the follow commands, and press Enter after each line: Osql -S yourservername -E 1> EXEC sp_password NULL, 'yourpassword', 'sa' 2> GO
From sql server 2000 and sql 2005 which one is best?
It's a long list check this website: http://www.eweek.com/c/a/Database/Change-Is-Good-for-SQL-Server-2005/
What is the advantage and disadvantage of sql server 2000 and sql server 2005?
The list of changes is too long to type so here is a website that has everything you ned to know:http://www.eweek.com/c/a/Database/Change-Is-Good-for-SQL-Server-2005/
Introduction to sql server?
The nintroduction sql server is are the following
Where could one purchase a Sequel or SQL server?
The Sequel, or SQL, Server is owned by Microsoft. One can purchase an SQL Server from the Microsoft website. Microsoft also offers a free trial of the SQL Server.
Describe IDE of SQL Server 2005?
An IDE for SQL Server 2005 refers to an Integrated Development Environment for SQL Server 2005. This is a tool that can be used by a programmer to create and maintan a SQL server database. Some commonly used IDE tools for SQL Server 2005 are:SQL Server Management StudioTOAD for SQL ServerTOAD for Data Analysts
What is a SQL Server instance?
An SQL Server instance is a complete SQL server and you can install many instances on a machine but you can have only 1 default instance.
What has the author Louis Davidson written?
Louis. Davidson has written: 'Pro SQL Server 2005 Database Design and Optimization' 'Pro SQL server 2008 relational database design and implementation' -- subject(s): Client/server computing, SQL server 'Pro SQL Server 2005' 'SQL Server 2000 Stored Procedures Handbook (Expert's Voice)'
What is SQL Server Encryption used for?
SQL Server Encryption is used for hiding confidential data one enters online, for example a password. If the encryption is functioning as it is supposed to, one will be less susceptible to hackers taking over private information on one's computer.
