MSDE and ISA

I am running 2 instances of MSDE2000 on a server with Win2K server SP4 and
ISA Server 2000. From the workstations on the network I am able to create
an ODBC connection to the default instance of SQL (MSSQL) but receive an
error when trying to connect to the 2nd instance (MSSQL\INSTANCENAME). Both
names appear in the dropdown list when creating the ODBC connection. Both
instances are running and networking for TCP/IP is enabled using SVRNETCN.
Both instances use the same SA password and connection is made using SQL
Authentication.
Error Message is
Connection Failed
SQLState 01000
SQL Server Error: 10048
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())
Connection Failed
SQLState 08001
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied
If I stop both instances of SQL and start only the 2nd instance i am then
able to connect to it but am unable to connect to the default instance when
it is restarted. It seems that the first instance of SQL to start can have
a connection made to it and any other instances cannot have an ODBC
connection. I think it may be related to ISA Server but cannot confirm at
this stage
Any advice would be appreciated.
Darrin
Darrin Acreman wrote:
> I am running 2 instances of MSDE2000 on a server with Win2K server SP4 and
> ISA Server 2000. From the workstations on the network I am able to create
> an ODBC connection to the default instance of SQL (MSSQL) but receive an
> error when trying to connect to the 2nd instance (MSSQL\INSTANCENAME). Both
> names appear in the dropdown list when creating the ODBC connection. Both
> instances are running and networking for TCP/IP is enabled using SVRNETCN.
> Both instances use the same SA password and connection is made using SQL
> Authentication.
> Error Message is
> Connection Failed
> SQLState 01000
> SQL Server Error: 10048
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())
> Connection Failed
> SQLState 08001
> SQL Server Error: 17
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
> access denied
> If I stop both instances of SQL and start only the 2nd instance i am then
> able to connect to it but am unable to connect to the default instance when
> it is restarted. It seems that the first instance of SQL to start can have
> a connection made to it and any other instances cannot have an ODBC
> connection. I think it may be related to ISA Server but cannot confirm at
> this stage
> Any advice would be appreciated.
> Darrin
>
Check the port numbers for both instances, they should be different
different. Check the application log/system log for any errors generated
by the second instance you start.

MSDE 2000 SP3a Workgroup Access

Greetings everyone.

I work in a retail environment and have an MSDE2000 SP3a server installed in 350+ stores. I need to access the server from another computer in the workgroup (not domain) and I can't. I'm getting "SQL Server does not exist or access denied." The server was installed using the default option of Windows Authentication and I have changed it to Mixed mode authentication on one of my in-house lab systems with no luck. Also, when I try to create and OLEDB connection for the database and drop down the list of servers, there is nothing there (not even the local server.) Sorry but I do not have the error message that I get when that happens but I think when I solve the first problem the second will go away too.

Thanks for your inputHi,

Are you saying that when you changed a server to mixed mode you were still unable to connect to it? Even from the local machine?

In my experience with MSDE, when running in mixed mode you should be able to connect remotely with EM or QA with the UID & PWD.

Have you confirmed that you are able to connect over 1433/1434 on the network? I guess this is the equivalent of "have you checked your cables" but it's worth checking to make sure.

Dan|||Hi Dan -- thanks for the reply.

I have always been able to connect to the server, both in Windows Authentication mode and Mixed mode from the local machine on which the server resides. The problem is that I cannot connect in either mode from a different machine in the workgroup. I tried telnet to the local machine using port 1433 and got a connect failed even on the same machine as the server. I did not know about port 1434. I'll try that one when I get back to the office tomorrow.

Thanks Again|||Use the server network utility.|||Not to be dense but what's the "Server Network Utility?"

I know about osql and can connect to the server while on the local machine but not from another machine.|||It's one of the utilities installed with SQL. You'll need to run it from the machine you want to connect from. You'll need to set up the connection. You create an alias where you specify the connection properties for the server.

Dan|||Nevermind -- I found it. I dialed into my office computer and ran the server network utility and all protocols were disabled. I won't be able to check the results until Friday but I'm optimistic that this will resolve my problems. Thanks a lot.|||all protocols were disabled That will do it.|||Once I enabled named pipes and tcp/ip on the server, the workgroup connection works fabulously. Thanks for your help.

One more question. Is there a registry setting for this that I can download a .reg file to the stores to set this or do I have to manually configure this setting in all my stores? Thanks again.

MSDE 2000 Installation

May i ask how you installed MSDE2000 using the command
line prompt? Thanks
>--Original Message--
>I am new to MSDE. Not MS-SQL server was installed in
this desktop before. I have downloaded MSDERelA and
installed it using the command line prompt. I can not the
see the SQLServer programs under Start/Programs menu.
What am I doing wrong? Should I be installing a different
program instead of MSDE2000RelA? Please help. Thank you.
>.
>
At a dos command prompt, go to the folder where you extracted the MSDE (c:\program files\MSDERelA). Then type in the following command.
setup SAPWD="AStrongSAPwd"
You can find about this in the readme file.
HTH
Sukhendu

msde 2000 and sql server

Hi group!
I am developing an application using MSDE 2000.
I made a Setup.exe by using Installshield tool.
in Installshield I add the msde2000.msm with named
instance. so msde2000 will be installed to the end client
machine.
my question is if the end client machine has SQL server
(for example version 2000, 7.5, 6.0), after my installtion
the sql server in end client machine is still OK?
I found the msde installtion will install dll file to
C:\Program Files\Microsoft SQL Server\80,if end client
machine has SQL server, the msde installtion will rewrite
C:\Program Files\Microsoft SQL Server\80.
thank?
yan
Hi Yan,
I'd strongly suggest you:
1. Modify the setup.ini file to have the settings you want for MSDE and to
install it with an instance name that is unique to you. (That will avoid any
clash with an existing installation)
2. Get the end-customer to run the ms-supplied setup for the MSDE before
installing your app.
Unfortunately, there are just way too many problems with auto-installing it
at present. These will be rectified with SQL Express in the future.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"ycjj" <yan@.mcr-sol.pic.melco.co.jp> wrote in message
news:061a01c49b8f$74866590$a301280a@.phx.gbl...
> Hi group!
> I am developing an application using MSDE 2000.
> I made a Setup.exe by using Installshield tool.
> in Installshield I add the msde2000.msm with named
> instance. so msde2000 will be installed to the end client
> machine.
> my question is if the end client machine has SQL server
> (for example version 2000, 7.5, 6.0), after my installtion
> the sql server in end client machine is still OK?
> I found the msde installtion will install dll file to
> C:\Program Files\Microsoft SQL Server\80,if end client
> machine has SQL server, the msde installtion will rewrite
> C:\Program Files\Microsoft SQL Server\80.
> thank?
> yan

MSDE - Cluster Aware

Hi
Can anyone tell me if there are any problems associated with installing MSDE
2000 on a cluster? Or even if it is possible in the first place?
Thanks
> Can anyone tell me if there are any problems associated with installing
MSDE
> 2000 on a cluster? Or even if it is possible in the first place?
Clustering is supported with Enterprise Edition only. Check the "Choosing an
Edition of SQL Server 2000" whitepaper at
http://www.microsoft.com/sql/techinf...KChooseEd.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
|||Hi
So if I just install MSDE 2000 by itself then it is not cluster aware? I
read the white paper but it's not really clear.
Could you also tell me if merge replication will work with MSDE 2000 as all
the articles I have read so far only seem to suggest it will work for a
subscriber and not as a publisher.
Thanks
"Dejan Sarka" wrote:

> MSDE
> Clustering is supported with Enterprise Edition only. Check the "Choosing an
> Edition of SQL Server 2000" whitepaper at
> http://www.microsoft.com/sql/techinf...KChooseEd.asp.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>
|||> So if I just install MSDE 2000 by itself then it is not cluster aware? I
> read the white paper but it's not really clear.
No, it is not cluster aware.

> Could you also tell me if merge replication will work with MSDE 2000 as
all
> the articles I have read so far only seem to suggest it will work for a
> subscriber and not as a publisher.
Merge replication is supported entirely, while tansactional replication
works if MSDE is subscriber only.
Here is a better lik, with clearer info:
http://msdn.microsoft.com/library/de...r_ts_1cdv.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com

MSDE - Cluster Aware

Hi
Can anyone tell me if there are any problems associated with installing MSDE
2000 on a cluster? Or even if it is possible in the first place?
Thanks> Can anyone tell me if there are any problems associated with installing
MSDE
> 2000 on a cluster? Or even if it is possible in the first place?
Clustering is supported with Enterprise Edition only. Check the "Choosing an
Edition of SQL Server 2000" whitepaper at
http://www.microsoft.com/sql/techin...sKChooseEd.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||Hi
So if I just install MSDE 2000 by itself then it is not cluster aware? I
read the white paper but it's not really clear.
Could you also tell me if merge replication will work with MSDE 2000 as all
the articles I have read so far only seem to suggest it will work for a
subscriber and not as a publisher.
Thanks
"Dejan Sarka" wrote:

> MSDE
> Clustering is supported with Enterprise Edition only. Check the "Choosing
an
> Edition of SQL Server 2000" whitepaper at
> http://www.microsoft.com/sql/techin...sKChooseEd.asp.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>|||> So if I just install MSDE 2000 by itself then it is not cluster aware? I
> read the white paper but it's not really clear.
No, it is not cluster aware.

> Could you also tell me if merge replication will work with MSDE 2000 as
all
> the articles I have read so far only seem to suggest it will work for a
> subscriber and not as a publisher.
Merge replication is supported entirely, while tansactional replication
works if MSDE is subscriber only.
Here is a better lik, with clearer info:
http://msdn.microsoft.com/library/d...r />
1cdv.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com