question

YohanCan-7967 avatar image
0 Votes"
YohanCan-7967 asked YohanCan-7967 commented

[SQL] [MDT] SQL server does not exist or access denied

Hello,

I'm studying in school and looking to associate SQL Server Express with MDT (Microsoft Deployment Toolkit) to get custom install deployment.
Note that everything is working well normaly without SQL Server Express, my standard conf on MDT is okay.

I have 2 servers :

Both servers are connected with the admin domain account FUJITSU\administrator.
After verifying standard WDS + MDT is working :

  • I installed SQL Server Express 2017 (also tried with 2019)

  • I openned 1433/1434 TCP and UDP port In and Out (also tried to disabled firewall)

  • SQL Server and SQL Server Browser services are Enabled

  • Named Pipes is Enabled

  • On MDT i created a Database following many simple tutorials


But when i boot my client he's trying to contact my SQL Server and he got this error :

 ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL server does not exist or access denied (-2147467259)    ZTIGather   25/03/2022 06:54:01 0 (0x0000)


You can check my SQL Server =>


186908-error-sql.png




Do you have an idea ?
Thank you,
Regards.

sql-server-generaloffice-deploymentmem-mdt
error-sql.png (43.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MartinCairney-6481 avatar image
1 Vote"
MartinCairney-6481 answered

Your SQL Express has installed as a Named Instance. By default this does not listen on Port 1433 so your firewall rules that are set for that access will not be permitting traffic through.

You can update your SQL deployment to set the port to 1433 by following the instructions here


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

YohanCan-7967 avatar image
0 Votes"
YohanCan-7967 answered YohanCan-7967 commented

Hello Martin,

Thank you i checked that and i did it !
But just to know, what's was wrong with my previous configuration ? Because i didn't did more than enabled Named Pipes services and selected it also on MDT as nobody did more on many tutorials. Maybe i had to configure something else ?

Thank you again.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Maybe in the tutorials the instructor had them all on a single server or used a default instance? Without following one of the tutorials I would not be able to comment in detail.

It is a common assumption that SQL "always" listens on Port 1433, but this is only certain for a default instance. As you can imagine, if you put more than one instance on the same server then only one of these can listen on Port 1433.

Fixing your Port allows you to set Firewall rules by port, you could also allow firewall access by application traffic.

Your config is close to being correct but just missing that variation between a default instance and a named instance.

0 Votes 0 ·
YohanCan-7967 avatar image YohanCan-7967 MartinCairney-6481 ·

I don't know exactly but i'll study all of these mecanics, thanks to you again :)

0 Votes 0 ·