SQL Server Performance Forum – Threads Archive
How do I login using SQL Server Management ConsoleI just installed the SQL Server 2005 Standard Edition which I got for free at the Launch event. During installation I wasn’t prompted for any SA passwords, I told it to use my local service account for the system to boot with. When I get to the console management tool I’m asked for login information. My local account won’t log in, and I have no idea what the tool ships with as a default for SA. Anybody know what I need to do to just login for the first time?
I have no protocols showing in my SQL Server Configuration Manager for the SQL Server 2005 Network Configuration option. The help indicates I should be able to change the properties for the various options (like I do see under my Client Protocols) but alas there are no protocol options listed. I am running an XP Pro with nothing installed (for SQL Server anyway) other than what came on the DVD, and I am not running IIS services on my machine. The installation warned me that certain SQL processes needed to have IIS installed, but I didn’t want to do that, as I’ve never been happy when running IIS in the past. Do I need it in order for SQL Server to just be able to accept a connection?
*** Never Mind *** When I did the installation I chose the default instance, and apparently there had previously been a failed sql server 2000 installation on the machine so it didn’t install the database engine itself. I removed the previous stuff from the registry, reinstalled with a named instance and I did get the database engine installed, and was able to see the SA and put a password in for it.