Re: Use DBI for pc-name\SQLEXPRESS

This may seem silly but have you configured your SQL Server Express to accept remote connections? Unlike the regular SQL Server, by default Express will only accept local connections. read more
The username/password must be for an SQL user account (with sufficient privileges), I could never get it to work with an AD account. I can't see what yours is so I just wanted to mention it. Each SQL Server instance can be configured to support one, the other, or both ("mixed mode").

I got 99 problems, most of them have to do with printers.

Comment on Re: Use DBI for pc-name\SQLEXPRESS

Replies are listed 'Best First'.
Re^2: Use DBI for pc-name\SQLEXPRESS by wcyoong (Initiate) on Aug 07, 2018 at 07:37 UTC
1. Thanks~ im able to connect his database in SQL Server Studio Management in my computer, so i believe the SQL Server Express can accept remote connection. Am i right?	[reply]
Re^3: Use DBI for pc-name\SQLEXPRESS by FloydATC (Deacon) on Aug 07, 2018 at 08:32 UTC
Yes, if you can remotely connect using SQL Management Studio, DBI should be able to connect as well. -- FloydATC I got 99 problems, most of them have to do with printers.	[reply]