Issue for creating a Microsoft Sever

Trung_Tin_Nguyen · April 19, 2024, 2:51pm

Had this pop up when I was trying to create a sever according to the Inductive University, anyone have any ideas?

Cannot create PoolableConnectionFactory (Login failed for user 'admin'. ClientConnectionId:c64ce8ea-fca2-4a24-b69e-05bf6875f138)

PGriffith · April 19, 2024, 3:02pm

I mean... Is the password correct?

Login failed is pretty unambiguous.

kcollins1 · April 19, 2024, 3:15pm

Keep in mind that with SQL Server, you have to create a "login" and then associate that login to a database via a "user".

Trung_Tin_Nguyen · April 21, 2024, 2:23am

Yes, I even copy paste to ensure it was

Trung_Tin_Nguyen · April 21, 2024, 2:26am

I was able to login on the SQL Server Management Studio a couple of times, but the Igntion never had a Valid status.

kcollins1 · April 22, 2024, 1:42pm

Another thing to check is in SQL Server Configuration Manager, make sure that TCP/IP protocol is enabled. I think that some installations of SQL Express may not default to enabling TCP/IP.

Trung_Tin_Nguyen · April 22, 2024, 6:55pm

thank you for letting me know, yes, I have it set to enable already.