Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re: Use DBI for pc-name\SQLEXPRESS

by FloydATC (Deacon)
on Aug 06, 2018 at 10:40 UTC ( [id://1219935]=note: print w/replies, xml ) Need Help??


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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1219935]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others musing on the Monastery: (4)
As of 2024-03-29 05:50 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found