This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: Cannot Connect to remote SQL Server 2008 Express DB
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 14, 2009
10:28 PM
Cannot Connect to remote SQL Server 2008 Express DB
Hi Guys
I cannot connect to the remote SQL Server 2008 Express DB. I am getting error dbnetlib invalid connection when I try and use in the DB Import Wizard.
And during inistallation I get Error 27502.
It works fine on a local server.
I need this fixed as we have deploy in 2 days.
Please see attachments for screen prints of errors
Regards,
Fred
I cannot connect to the remote SQL Server 2008 Express DB. I am getting error dbnetlib invalid connection when I try and use in the DB Import Wizard.
And during inistallation I get Error 27502.
It works fine on a local server.
I need this fixed as we have deploy in 2 days.
Please see attachments for screen prints of errors
Regards,
Fred
(7) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 15, 2009
07:47 AM
use FEYNMAN\SQLExpress in place of FEYNMAN where you are using SQL server in you IS project.
SQL express needs to explicitly mentioned, only the server name is not sufficient. It should be like following :
\SQLExpress
SQL express needs to explicitly mentioned, only the server name is not sufficient. It should be like following :
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 15, 2009
04:01 PM
you may also want to verify that the SQL Server Express 2008 is configured properly for recieving remote connections. I have not worked with 2008 much yet, but I know by default SQL Server 2005 Express edition had remote connections disabled.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 17, 2009
07:26 PM
ChandanOmkar wrote:
use FEYNMAN\SQLExpress in place of FEYNMAN where you are using SQL server in you IS project.
SQL express needs to explicitly mentioned, only the server name is not sufficient. It should be like following :\SQLExpress
Tried that still does not work
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 17, 2009
07:27 PM
Lurean wrote:
you may also want to verify that the SQL Server Express 2008 is configured properly for recieving remote connections. I have not worked with 2008 much yet, but I know by default SQL Server 2005 Express edition had remote connections disabled.
Works fine from managemnet SQL Management studio and other apps on my machine, just will not work from the install
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 18, 2009
09:55 AM
Please make sure that the instance of the Microsoft SQL Server 2008 Express in question has been configured to listen to the TCP/IP protocol. Also, try forcing InstallShield to use the Microsoft SQL Server Native Client OLE DB Provider by following the steps below, and see if the problem is solved:
[LIST=1]
Go to the ISSQLDBMetaData table in the Direct Editor.
Find the "MSSQLServer" row.
Change the AdoDriverName column from "sqlolddb" to "sqlncli".
Change the DsnODBCName column from "{SQL Server}" to "{SQL Native Client}"
Rebuild your setup.
[LIST=1]
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 22, 2009
06:59 PM
Thanks That Worked. Does this fix only for 2005 and 2008 sql server ?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 24, 2009
12:04 PM
I think that the SQL Native Client provider works with Microsoft SQL Server 2000 and MSDE.