I have no idea on how SQL works. I'm just trying to use a program that is using SQL Server.
I have SQL Server 2005 and 2008.
In my start menu I only see a list of programs in 2008. In the 2005, I only see Upgrade Advisor.
I installed a program and it's asking for my username and password for the server : localhost:8090. During the installation you can chose between Windows authentication or SQL Server authentication. The SQL Server authentication doesn't work so I'm using the windows authentication.
I tried admin and I get a password error. If I try mycomputername\myusername or myusername mycomputername\sqlexpress sa and I always get wrong username
Is there a way to create a user/password or reset? I tried going into SQL Server Management Studio but I have no idea where to go or how to write.
Should I just reinstall ?
Best Answer
Passwords for SQL users and administrators are set while the SQL Server installation process takes place. Using SQL Server Management Studio (SSMS) you can access SQL Server on the same or other machine. To login, you should know the password, that SQL Server was installed with. The standard administrator is 'sa', not 'admin'. Also, if this is local machine, you should be able (if installation was made by local user/administrator) to login by Windows Authentication (with the same user, that the SQL Server was installed). There is no default password, but it can be empty. Try using 'sa' login with empty password or Windows Authentication. If this does not solve your login problem - try to find out what the password was=is. If this is not possible, you may need to reinstall SQL Server.