Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
swagatika
Starting Member
3 Posts |
 Posted - 2008-05-23 : 09:25:07
|
| HI,I m swagatika and working on a s/w company.I am facing some problem in MS SqlServer2005.my problem is:-i installed sql server2005 completely .At the install time , i set the username='xyz' and password=blank (windows authentication mode).Now i want to change my user account to 'sa' and password to blank.After installation,how to change the user account and password.Please can anybody help me ? |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2008-05-23 : 10:14:38
|
| NEVER have SA blank!!!!!!!!!!!!!!!!!!!!!!!!!!I think you are asking, can you change a WINDOWS AUTHENTICATION installation to a MIXED MODE installation? Taken from here (http://www.codeproject.com/KB/database/SQL_Server_2005_remote.aspx):1. Configuration in SQL Server Management Studio Click “All Programs” -> Click “Microsoft SQL Server 2005” -> click “Microsoft SQL Server Management Studio”Log in to SQL Server 2005 with windows authentication or sa user;Highlight the server and right click “Properties”;Highlight “Security” -> Under “Server authentication”, choose “SQL Server and Windows authentication mode”;Highlight “Connections” -> Under “Remote server connections”, choose “Allow remote connections to this server”; Click OK to save the settings. 2. Configuration in SQL Server Surface Area ConfigurationClick “All Programs” -> Click “Microsoft SQL Server 2005” -> click “Configuration Tools” -> click “SQL Server 2005 Surface Area Configuration” Click “Surface Area Configuration for Services and Connections” -> click “MSSQLSERVER” -> click “Database engine” -> click “Remote connections ” -> Under “Local and remote connections”, choose “Using TCP/IP only” or other protocols. Click “Apply” to save the settings. 3. Stop SQL server and restart SQL serverUse “SQL Server Management Studio” or Services in Control Panel to stop SQL Server and then restart the SQL Server. This process is used to initialize the change settings. 4. Test the changesa. Create the user through “Security” -> “Logins” -> “New Logins…” b. log in with the newly created user when “Authentication” is “SQL Server authentication” under local SQL server or under remote SQL server. If you have any questions or suggestions, please email me at hong_wei_li@yahoo.com Happy SQLing! *##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-05-25 : 00:24:23
|
| You may not keep passord blanck for SA a/cManojMCP, MCTS |
|
|
|
swagatika
Starting Member
3 Posts |
Posted - 2008-05-26 : 05:55:50
|
| Hi,Thnks yar .I implemented.It is working fine. |
|
|
|
|
|
|
|
|
how to change the user account and password