I installed Sharepoint 2010 Foundation on a server and chose the single server, stand-alone option. This option will install SQL 2008 R2 Express and Install SharePoint 2010.
The process does not prompt for any user id or password for the database.
I need to connect to the SQL Instance using SQL Management Studio and need to enter a user id/password to connect. Everything I try does not work, so there must be a specific SQL Server Authentication based ID and password that automatically gets created.
Does anyone know what it is? I need to log into the actual SQL Express database and I can't connect to the instance because I dont have a user id or password.