Prev: Unattended Windows XP error ASMS not found
Next: Windows Keeps rebooting
From: DLH on 19 Apr 2006 09:57
I am using the OSD Feature pack in SMS in conjunction with the
ZeroTouchInstallation.vbs script to deploy operating systems. When the ZTI
script attempts to connect to the SQL server 2005 databases I receive the
following error in the ZTI log.
ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL
Server does not exist or access denied.
(-2147467259) ZeroTouchInstallation.vbs 4/19/2006 8:39:06 AM 0 (0x0000)
ADO error: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not
exist or access denied. (Error #-2147467259; Source: Microsoft OLE DB
Provider for SQL Server; SQL State: 08001; NativeError:
17) ZeroTouchInstallation.vbs 4/19/2006 8:39:07 AM 0 (0x0000)
I have allowed appropriate permissions on the database and the SQL database
is on the same server as the SMS server, but am still receiving this error.
Are there additional steps that need to be taken to connect to the database
on SQL Server 2005 ?
Thanks,
DLH
From: DLH on 19 Apr 2006 11:13
I was scanning the newsgroup and found the following post that was exactly
the solution. I just needed to enable name pipes because they are disabled
by default in SQL 2005. Thanks CCA.

http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?&query=ZTI+SQL&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sms.admin&p=1&tid=4179e788-a2e1-4d90-8548-b115c0449a6c

DLH

"DLH" wrote:

> I am using the OSD Feature pack in SMS in conjunction with the
> ZeroTouchInstallation.vbs script to deploy operating systems. When the ZTI
> script attempts to connect to the SQL server 2005 databases I receive the
> following error in the ZTI log.
> ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL
> Server does not exist or access denied.
> (-2147467259) ZeroTouchInstallation.vbs 4/19/2006 8:39:06 AM 0 (0x0000)
> ADO error: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not
> exist or access denied. (Error #-2147467259; Source: Microsoft OLE DB
> Provider for SQL Server; SQL State: 08001; NativeError:
> 17) ZeroTouchInstallation.vbs 4/19/2006 8:39:07 AM 0 (0x0000)
> I have allowed appropriate permissions on the database and the SQL database
> is on the same server as the SMS server, but am still receiving this error.
> Are there additional steps that need to be taken to connect to the database
> on SQL Server 2005 ?
> Thanks,
> DLH
 | 
Pages: 1
Prev: Unattended Windows XP error ASMS not found
Next: Windows Keeps rebooting