sql server connect: SQL Server Express, Remote Connection and Self Install -- sql server connect

You're in the

sql server connect

group:

SQL Server Express, Remote Connection and Self Install

SQL Server Express, Remote Connection and Self Install

jroozee NO[at]SPAM gmail.com
4/26/2006 2:48:03 PM

sql server connect: I am trying to package SQL Server Express 2005 with my application. I
got it to self install just fine and I am passing the
DISABLENETWORKPROTOCOLS=0 to the setup file to enable remote
connections, BUT still, after it's all installed I still am having a
problem with the TCP connection for each IP address being disabled. I
can not figure out how to self install SQL Server Express 2005 and
automatically configure the TCP connection to be enabled and also
preset the port to 1433?

Here's what I got so far:

SQLEXPR.EXE /qb INSTANCENAME=SQLExpress ADDLOCAL=SQL_Engine
SAPWD=xe15wz DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL

Any ideas?

Jason Roozee

Re: SQL Server Express, Remote Connection and Self Install

Roger Wolter[MSFT]
4/26/2006 3:13:16 PM

I'm pretty sure this is the only thing you can do from the command line
install, See this reference:
http://msdn2.microsoft.com/en-us/library/ms143446(SQL.90).aspx

To enable listening for connections you will have to enable the SQL Browser
(unless you install SQL Express as the default instance). The easiest way
to do this from your setup program is to use the Surface Area Configuration
command line utility (sac utility). Look here for more information on doing
this:

http://msdn2.microsoft.com/en-us/library/ms162800(SQL.90).aspx

and here for Express setup in general:

http://msdn2.microsoft.com/en-us/library/ms143441(sql.90).aspx

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[quoted text, click to view]

Re: SQL Server Express, Remote Connection and Self Install

jroozee NO[at]SPAM gmail.com
4/26/2006 5:52:15 PM

I do not see how its possible to enable the TCP connection (not set
active, but enable0

Re: SQL Server Express, Remote Connection and Self Install

Roger Wolter[MSFT]
4/26/2006 6:49:45 PM

Doesn't setting disablenetworkconnections to 0 enable it?

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[quoted text, click to view]

Re: SQL Server Express, Remote Connection and Self Install

jroozee NO[at]SPAM gmail.com
4/27/2006 11:28:35 AM

It does not seem to, no. It seems to only enabled the "TCP Protocol",
but each individual IP address remains disabled. Thus, prohibiting
remote access still.

Re: SQL Server Express, Remote Connection and Self Install

Roger Wolter[MSFT]
4/27/2006 2:40:32 PM

This should work so I assume you are doing more than using the default
connection settings. If so you will have to use SMO to change the default
settings.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[quoted text, click to view]

Re: SQL Server Express, Remote Connection and Self Install

jroozee NO[at]SPAM gmail.com
4/27/2006 8:58:10 PM

So what I am doing SHOULD be working and enabling each IP address also?
Sorry, little confused with your reply.

SMO?

Jason

Re: SQL Server Express, Remote Connection and Self Install

Roger Wolter[MSFT]
4/27/2006 10:00:31 PM

What I meant was if you leave the default dynamic port configuration you
shouldn't have to mess with the individual port setting but if you want to
specify the ports to use you will need to use SMO to do it programmatically.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[quoted text, click to view]

Re: SQL Server Express, Remote Connection and Self Install

jroozee NO[at]SPAM gmail.com
4/28/2006 4:56:44 AM

I'll give it a try.... but I still seem to have no success. Even with
out specifying the ports, I still only seem to be able to connect
remotley after I enable the individual IP addresses (not set the port
#).

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server connect group.

View Other Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007

home · blog · groups

Questions? Comments? Contact the dn