SQL Express - Vista - SA password

[DarwinIT]

I just installed SQL Rxpress on my laptop with Vista and then installed the Express Management studio. I tried to create a database and it said I didn't have permission. What is the default password assigned to sa when you install? I thought it was blank unless you set it and I don't remember seeing a screen prompting me for it during install.
Thanks!!

 

[DarwinIT]

Dang it. I figured it out. In order to have SQL work correctly with Vista I had to run the Management studio as an administrator. When I did that I was able to change to mixed mode authentication and change the sa password (I really didn't need to use SA except my local admin account was working - due to the Vista security features).

In case anyone else ever needs this info:

1. Login as a local admin in SQL Server machine
2. Open the SQL Server express management studio
3. Connect to SQL Server using windows authentication (Work only if you
login into OS using a previleged user in the local machine)
4. Right click the mouse above the server name and choose properties
5. Go to security tab...Change the server authentication to "SQL Server and
Windows Authentication mode"
6. Click OK and restart SQL Server service
7. Reconnect to SQL Server again using SQL Server studio management express
8. Expand the server and choose security and expand logins
9. Right click above SA, properties...modify the password and confirm
password