Page 1 of 1

MS Sql Server settings

Posted: Wed Jun 01, 2005 5:15 pm
by lansmank
I'm having an issue making the MS SQL Server plug-in connect to my instance of the MSDE. When connecting to the MSDE, you need to specify [machine name]\\[instance name] in the connection, assuming that you haven't installed the the MSDE as the default instance on the local client. When I specify localhost as the instance of the server, sql doesn't recognize localhost\\instancename as a valid server, neither does it recognize 127.0.0.1\\instancename as a valid server. It needs the machine name as a part of the instance name to establish a connection. My question is, is there a way to specify this in the MS Sql Server plug-in?

Posted: Wed Jun 01, 2005 6:06 pm
by lansmank
FYI; I found out that you can use (local)\\instancename as a valid connection to a named instance of sql. When i say (local), i mean that in the literal sense, including the opening and closing brackets.

I'm still getting an error when attempting to connect to the instance and run a simple table create script that runs just fine in the Sql Query Analyser. I've got the Create Database option checked, but i'm not getting the database created. Has anyone played with this functionality in InstallAware yet? What needs to happen for the plug-in to successfully create a new database from scratch?

Posted: Thu Jun 02, 2005 3:11 am
by sinan
As long as you have MDAC 2.8 installed, the MS SQL plug-in will work correctly.

Posted: Wed Jun 08, 2005 5:44 pm
by lansmank
I posted this finding in another thread, but i thought i would post it here too.

When installing the MSDE, you need to make sure that you start the service prior to attempting to run any scripts against the server. I'm still having an issue with the Control Service command, but i managed to incorporate a quickie work around by running a .bat file with a NET START <Service Name> in it after executing the MSDE setup and prior to executing any sql scripts against the db. Once the service was started, the MS-SQL plugin ran flawlessly.

Hope this helps