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!
No comments:
Post a Comment