I just installed SQL Express 2008, and for some reason I've 2 instances.
one SQLEXPRESS and one MSSQLERVER.
when i try to connect to 127.0.0.1 via SQL authentication, it works.
when i try to connect to 127.0.0.1\SQLEXPRESS via SQL authentication, it doesn't work, but it works for windows authentication.
how can i fix it? i want to connect to 127.0.0.1\SQLEXPRESS.
View Complete Post