in reply to Use DBI for pc-name\SQLEXPRESS

  1. 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
  2. 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").
-- FloydATC

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

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?

      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.