Friday, March 23, 2012

Problem in changing Account Name, Password

Hi

I installed SQL Server 2005 Express Edition. When I try changing the account name, password in the SQL Server Configuration Manager, i.e. by clicking on Apply, the SQLEXPRESS restarts and the password gets replaced by a longer password. Also the user name gets prefixed with "./". Any help on this will be highly appreciated.

Another query: Do we have the query analyser (gui or command line) kind of thing in Express Edition? Also where can I get a proper documentation of doing elementary things in setting up a database, like creating a database, adding a user, etc)

Thanks and Regards
Roopesh

For the pasword thing, the field is obfuscated with more chars than you entered, thats as planned.

There is a query edit built into express, just select file new query from the menu.

In terms of docs I recomend SQL Server Books On Line, which can be downloaded from the same place as you downloaded express.

|||

A few additional notes, if you've only downloaded Express Edition (not Advanced Services) you can get Management Studio Express separately from http://msdn.microsoft.com/vstudio/express/sql/download/.

You can find some videos to help you understand some of the basics of database usage at http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx. If you're interested in learning about a programming language, I'd recomend the Absolute Beginners series as well as some of the other learning resources that are language specific. (VB.NET C#)

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

sql

No comments:

Post a Comment