Welcome to weblogs.com.pk Sign in | Join | Help

Aziz ur Rahman

Random Thoughts

News

  • The WeatherPixie
    Listed on BlogShares


    Counter : simple hit counter
Default sa password in SQL Server Express

Referring to Khurram's Post , @Khurram ,Can you explain a little more on the "Installing SQL Express on Domain" problem. Do you want to install SQL Express on machine having the active directory and access using some other machine? Or
You want to install SQL express on a machine that is a part of a domain?

One question from my side. If you install web express, SQL express will be installed automatically without asking you anything :( . What will the default password for "sa" user? I have tried hard to change authentication mode of default instance ".\sqlexpress" to SqlServer mode but no success. Finally I installed another instance with the "Hide advance settings" unchecked so that I can select SQL Server mode and enter a desirable password. Is there any way around to change it?

SQL express is not much stable. There was no problems during installation but it is throwing exceptions here and there.

Posted: Saturday, November 26, 2005 1:20 PM by aziz
Filed under:

Comments

Mohamed A. Meligy said:

Hello Syed,
Have you heard of Microsoft SQL Server Express Manager ? Are you using it ?
You'll find a link to it inn the page of sql server express most likely.It can help alot I guess.
Regards
# November 26, 2005 11:50 PM

Mohamed A. Meligy said:

Hello Syed,
Have you heard of Microsoft SQL Server Express Manager ? Are you using it ?
You'll find a link to it inn the page of sql server express most likely.It can help alot I guess.
Regards
# November 26, 2005 11:50 PM

aziz said:

Are you talking about Microsoft SQL Server Management Studio Express http://www.microsoft.com/downloads/details.aspx?familyid=993c0bcf-3bcf-4009-be21-27e85e1857b1&displaylang=en? I don't have to say anything about MS (Management Studio) myself. Check it http://jaysonknight.com/blog/archive/2005/11/22/4655.aspx. I will just add that the GUI is so much annoying showing message boxes all the time and has a lot of other bugs (throwing exceptions).
# November 27, 2005 9:59 AM

Khurram said:

I have couple of machines on a domain being used by developers. I want to have SQLExpress and VWD configured on each machine.

Once I will manage to get it done; I will post. On my machine its working fine; but on two other machines it still giving odd errors.

Using that Management Studio Express; you can enable SQL Authentication; by default it uses Windows auth only (similar to MSDE); once SQL authentication is enabled; you can set sa password from studio easily.
# November 27, 2005 11:59 PM
Anonymous comments are disabled