ActiveX program control merge replication.

Hi There, i am using msde 2000 sp3 and sql 2000 sp3 as a subscriber
and distributer or publisher.
I created a merge replication programatically so when user click
synchronize it synchronize between msde and server. When i try to run
the program the following message come.
" -2147221504- n[microsoft][odbc sql server driver] [tcp/ip sockets]
sql server does not exist or access denied. [microsoft][odbc sql
server driver] connection open connect().
please give me some information why this problem is coming. I would
like to know what are the dependent file or dll file for merge
replication. i am using merger replicaiton with pull subscriber.
the subscriber can be window 2000, xp etc.
I will be thankful if anyone give me some information for this
problem.
Indra.
From what you describe it sounds like you are having a problem connecting to the publisher from the subscriber, and furthermore it sounds like you are having a name resolution problem.
On your subscriber try to ping the publisher.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Indra" wrote:

> Hi There, i am using msde 2000 sp3 and sql 2000 sp3 as a subscriber
> and distributer or publisher.
> I created a merge replication programatically so when user click
> synchronize it synchronize between msde and server. When i try to run
> the program the following message come.
> " -2147221504- n[microsoft][odbc sql server driver] [tcp/ip sockets]
> sql server does not exist or access denied. [microsoft][odbc sql
> server driver] connection open connect().
> please give me some information why this problem is coming. I would
> like to know what are the dependent file or dll file for merge
> replication. i am using merger replicaiton with pull subscriber.
> the subscriber can be window 2000, xp etc.
> I will be thankful if anyone give me some information for this
> problem.
> Indra.
>

Activating MSDE for remote Access

I'm finding that when I install MSDE, by default no protocols are enabled
for remote access. I've found that I can use the SQL Server Network Utility
to enable the TCP/IP protocol and then the MSDE instance is accessible from
remote workstations.
But how can I do this without having the SQL Server Client Tools installed?
Is there a command line or configuration option I can use?
Thanks for your help,
Joe Geretz
I think I found it. DISABLENETWORKPROTOCOLS=0.
- Joe Geretz -
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:uoPxQ8DYEHA.3300@.TK2MSFTNGP09.phx.gbl...
> I'm finding that when I install MSDE, by default no protocols are enabled
> for remote access. I've found that I can use the SQL Server Network
Utility
> to enable the TCP/IP protocol and then the MSDE instance is accessible
from
> remote workstations.
> But how can I do this without having the SQL Server Client Tools
installed?
> Is there a command line or configuration option I can use?
> Thanks for your help,
> Joe Geretz
>
|||But how would I do this after the instance is already installed? I can't
rely on SQL Server Client Tools because presumably, they won't exist locally
on the MSDE box.
Thanks for your help,
- Joe Geretz -
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:ucsgMAEYEHA.716@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> I think I found it. DISABLENETWORKPROTOCOLS=0.
> - Joe Geretz -
> "Joseph Geretz" <jgeretz@.nospam.com> wrote in message
> news:uoPxQ8DYEHA.3300@.TK2MSFTNGP09.phx.gbl...
enabled
> Utility
> from
> installed?
>
|||Program Files\Microsoft SQL Server\80\Tools\Binn\SVRNETCN.exe
Enable tcp/ip and restart MSDE
David P. Lurie
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:e$2DuCEYEHA.3988@.tk2msftngp13.phx.gbl...
> But how would I do this after the instance is already installed? I can't
> rely on SQL Server Client Tools because presumably, they won't exist
locally
> on the MSDE box.
>
|||hi Joseph,
"Joseph Geretz" <jgeretz@.nospam.com> ha scritto nel messaggio
news:e$2DuCEYEHA.3988@.tk2msftngp13.phx.gbl...
> But how would I do this after the instance is already installed? I can't
> rely on SQL Server Client Tools because presumably, they won't exist
locally
> on the MSDE box.
on the box where MSDE has been installed, the Server Network Tools will be
alwayse available (as David already pointed out), and the Client Network
Tools (cliconfg.exe) too...
on all client, only the Client Network Tools will be available, installed by
MDAC...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thank David and Andrea!
I hadn't noticed that these tools are actually installed with MSDE. This is
great, exactly what I'll need.
Thanks,
- Joe Geretz -
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2kladsF3m4fmU1@.uni-berlin.de...
> hi Joseph,
> "Joseph Geretz" <jgeretz@.nospam.com> ha scritto nel messaggio
> news:e$2DuCEYEHA.3988@.tk2msftngp13.phx.gbl...
> locally
> on the box where MSDE has been installed, the Server Network Tools will be
> alwayse available (as David already pointed out), and the Client Network
> Tools (cliconfg.exe) too...
> on all client, only the Client Network Tools will be available, installed
by
> MDAC...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

Acess Denied Starting MSDE 2000

Hi

We have a demo version of our SQL2000 application that uses MSDE. This has always worked sucessfully in the past.

However, at the most recent installation however there is a problem which I cannot seem to fix.

MDSE was installed on Windows 2000 using the Local Admin account.

When the user logs on to the PC, SQL will not start gives error message '5 Access Denied'.

I have given the local user read/write permission to the Data directory and mdf/ldf files that it contains.

I have tried starting SQL specifiying it to log on using the Local Admin account but it makes no difference.

Does anyone know what else can I do?

Thank you

Mark

SQL Server controls the permissions if a user has access to the (database) server and the appropiate databases. it has nothing to do with file permissions. You will have to create a new login and grant the login the appropiate permissions on the database.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Hi Jens, thank you for this, but I think the problem is more fundemental as at the moment SQL Server will not even start unless a local administrator is logged in.

Mark

|||

Which service account is the service running under ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

The service is set to logon using a specified account and we are specifying the local administrator account.

These settings work when the local administrator is logged-on to the PC, so it looks like we have entered both the Account and Password correctly.

Many thanks

Mark

Accessing one Database from two PC's

Hi ,
Can anyone please give me some thoughts on how to achieve the
following:-
I have a SCADA system updating an SQL database using MSDE on a PC.
I have an analysis tool from which I want to access the same database
with also using MSDE via ADO from a second machine (here the updates
won't be continuous, but queries two or three times a day).
How would I effectively connect both processes to the same database ?
Many Thanks
Vic
Vic,
I'm not sure what your "real" problem is (I have no experience in SCADA
systems). Do you mean that you will have performance problems if you
query the database at the same time it is updated? 2-3 querys a day
doesn't seem to be "a lot", but it depends on the querys...
There is no problem "connecting" (more than one) process to the same
database (as long as you don't have the database in single-user mode).
Lars Broberg
Elbe-Data AB
http://www.elbe-data.se
Remove "nothing." when replying to private e-mail!
Victor. d'Hoop wrote:
> Hi ,
> Can anyone please give me some thoughts on how to achieve the
> following:-
> I have a SCADA system updating an SQL database using MSDE on a PC.
> I have an analysis tool from which I want to access the same database
> with also using MSDE via ADO from a second machine (here the updates
> won't be continuous, but queries two or three times a day).
> How would I effectively connect both processes to the same database ?
> Many Thanks
> Vic
|||Lars,
I guess my question is really, can I attach a database to more than
one server ?
Cheers
Vic
On Tue, 22 Mar 2005 17:23:20 +0100, Lars Broberg
<lars.b@.elbe-data.nothing.se> wrote:
[vbcol=seagreen]
>Vic,
>I'm not sure what your "real" problem is (I have no experience in SCADA
>systems). Do you mean that you will have performance problems if you
>query the database at the same time it is updated? 2-3 querys a day
>doesn't seem to be "a lot", but it depends on the querys...
>There is no problem "connecting" (more than one) process to the same
>database (as long as you don't have the database in single-user mode).
>Lars Broberg
>Elbe-Data AB
>http://www.elbe-data.se
>Remove "nothing." when replying to private e-mail!
>
>Victor. d'Hoop wrote:
|||Vic,
Why have two servers? Isn't is possible to connect to the _same_ server
from both clients?
If you _really_ need this, use backup and restore, if you don't need
"live" data for the querying. Otherwise look at replication...
Lars Broberg
Elbe-Data AB
http://www.elbe-data.se
Remove "nothing." when replying to private e-mail!
Victor. d'Hoop wrote:
> Lars,
> I guess my question is really, can I attach a database to more than
> one server ?
> Cheers
> Vic
> On Tue, 22 Mar 2005 17:23:20 +0100, Lars Broberg
> <lars.b@.elbe-data.nothing.se> wrote:
>
>
|||Vic,
To clarify, you can't attach "the same" mdf/ldf files to two different
servers at the same time. You can of course copy the mdf/ldf files to
two different places and attach these different file pairs to different
servers (but then you have two "different" databases...).
Lars Broberg
Elbe-Data AB
http://www.elbe-data.se
Remove "nothing." when replying to private e-mail!
Lars Broberg wrote:[vbcol=seagreen]
> Vic,
> Why have two servers? Isn't is possible to connect to the _same_ server
> from both clients?
> If you _really_ need this, use backup and restore, if you don't need
> "live" data for the querying. Otherwise look at replication...
> Lars Broberg
> Elbe-Data AB
> http://www.elbe-data.se
> Remove "nothing." when replying to private e-mail!
>
> Victor. d'Hoop wrote:
|||Lars,
Let me try to explain better.
There are two PC's which are networked.
PC A needs to write information to the database on a regular basis.
PC B needs to read information from the database on a regular basis.
Is there some way that both PC's can use the same server ?
From what I can see one of them won't have MSDE available to it. On
the other hand, I wouldn't be surprised if I'm overlooking something
obvious.
Many thanks for your patience. I'm used to dealing with .dbf's so I
find it difficult to get my head around this.
Cheers
Vic
On Wed, 23 Mar 2005 09:06:38 +0100, Lars Broberg
<lars.b@.elbe-data.nothing.se> wrote:
[vbcol=seagreen]
>Vic,
>To clarify, you can't attach "the same" mdf/ldf files to two different
>servers at the same time. You can of course copy the mdf/ldf files to
>two different places and attach these different file pairs to different
>servers (but then you have two "different" databases...).
>Lars Broberg
>Elbe-Data AB
>http://www.elbe-data.se
>Remove "nothing." when replying to private e-mail!
>
>Lars Broberg wrote:
|||Vic,
They can use the same server. MSDE 2000 SP3a is installed as default
without network support (DISABLENETWORKPROTOCOLS=1). You can change this
when you install (set the parameter to zero) or you may use
Network Utility to configure MSDE (use DbaMGR2k on the PC where you can
connect to MSDE and look in the menu "Tools & Settings"):
1.On the General tab, select the instance from the instance list (you
probably only have one).
2.Under Disabled protocols, click the protocol (such as TCP/IP)you want
to enable, and then click Enable.
3.Click OK.
4.Stop and restart the service to make any changes take effect.
If you have MSDE installed on a PC with Win XP/SP2, you have to manually
open TCP/IP port 1433 in the XP firewall. For testing, you can just
disable the firewall, but remember to activate it again...
Lars Broberg
Elbe-Data AB
http://www.elbe-data.se
Remove "nothing." when replying to private e-mail!
Victor. d'Hoop wrote:
> Lars,
> Let me try to explain better.
> There are two PC's which are networked.
> PC A needs to write information to the database on a regular basis.
> PC B needs to read information from the database on a regular basis.
> Is there some way that both PC's can use the same server ?
> From what I can see one of them won't have MSDE available to it. On
> the other hand, I wouldn't be surprised if I'm overlooking something
> obvious.
> Many thanks for your patience. I'm used to dealing with .dbf's so I
> find it difficult to get my head around this.
> Cheers
> Vic
>
>
>
> On Wed, 23 Mar 2005 09:06:38 +0100, Lars Broberg
> <lars.b@.elbe-data.nothing.se> wrote:
>
>
|||Lars,
Thank you very much..That puts my mind at rest considerably.
Cheers
Vic
On Wed, 23 Mar 2005 17:11:12 +0100, Lars Broberg
<lars.b@.elbe-data.nothing.se> wrote:
[vbcol=seagreen]
>Vic,
>They can use the same server. MSDE 2000 SP3a is installed as default
>without network support (DISABLENETWORKPROTOCOLS=1). You can change this
>when you install (set the parameter to zero) or you may use
>Network Utility to configure MSDE (use DbaMGR2k on the PC where you can
>connect to MSDE and look in the menu "Tools & Settings"):
>1.On the General tab, select the instance from the instance list (you
>probably only have one).
>2.Under Disabled protocols, click the protocol (such as TCP/IP)you want
>to enable, and then click Enable.
>3.Click OK.
>4.Stop and restart the service to make any changes take effect.
>If you have MSDE installed on a PC with Win XP/SP2, you have to manually
>open TCP/IP port 1433 in the XP firewall. For testing, you can just
>disable the firewall, but remember to activate it again...
>Lars Broberg
>Elbe-Data AB
>http://www.elbe-data.se
>Remove "nothing." when replying to private e-mail!
>
>Victor. d'Hoop wrote:

accessing MSDE over the internet

Hi!
I was wondering if it was possible to access a MSDE server through the
internet and if it is what settings have to be made on the server machine.
I would like this so I could make any required repairs of my application
over the internet...
Thanks,
sasoSaso,
The MSDE Database work fine if u have less than 15 concurrent users and the
Database maximum file is 1GB. You don't need do any special configuration to
MSDE work through internet, but the performance will be poor.
[ ]'s
PEDRO HENRIQUE NUNES - Brasil
"Saso Zagoranski" <saso.zagoranski@.guest.arnes.si> wrote in message
news:binqgk$fog$1@.planja.arnes.si...
> Hi!
> I was wondering if it was possible to access a MSDE server through the
> internet and if it is what settings have to be made on the server machine.
> I would like this so I could make any required repairs of my application
> over the internet...
> Thanks,
> saso
>|||let's say you are installing MSDE on your home PC. You give your IP address
to your friend and he can't connet to it. Here are things you should look
at:
1. your MSDE must use TCP/IP in net library.
2. you must know, and should change the default SQL port number 1433.
3. if you have a router you must have the router routes traffic on SQL port
to your MSDE box.
With a proper setup of your router and IP + port number given to your friend
he (she) can connect to SQL
"Saso Zagoranski" <saso.zagoranski@.guest.arnes.si> wrote in message
news:binuv2$iq8$1@.planja.arnes.si...
> I have MSDE installed on my computer and I gave my friend my IP address...
> and he cound't connect to my server...
> "Pedro Henrique" <pedro@.jew.com.br> wrote in message
> news:O9es1DkbDHA.3044@.TK2MSFTNGP11.phx.gbl...
> > Saso,
> >
> > The MSDE Database work fine if u have less than 15 concurrent users and
> the
> > Database maximum file is 1GB. You don't need do any special
configuration
> to
> > MSDE work through internet, but the performance will be poor.
> >
> > [ ]'s
> >
> > PEDRO HENRIQUE NUNES - Brasil
> >
> >
> >
> > "Saso Zagoranski" <saso.zagoranski@.guest.arnes.si> wrote in message
> > news:binqgk$fog$1@.planja.arnes.si...
> > > Hi!
> > > I was wondering if it was possible to access a MSDE server through the
> > > internet and if it is what settings have to be made on the server
> machine.
> > > I would like this so I could make any required repairs of my
application
> > > over the internet...
> > >
> > > Thanks,
> > > saso
> > >
> > >
> >
> >
>|||Hi Folks,
It also depends upon the version you have installed. At the SP3a level, MSDE
installs with network protocols disabled. Run the server network utility
SRVNETCN.exe to correct that.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Flicker" <hthan@.superioraccess.com> wrote in message
news:%23FaMV$kbDHA.2668@.TK2MSFTNGP09.phx.gbl...
> let's say you are installing MSDE on your home PC. You give your IP
address
> to your friend and he can't connet to it. Here are things you should look
> at:
> 1. your MSDE must use TCP/IP in net library.
> 2. you must know, and should change the default SQL port number 1433.
> 3. if you have a router you must have the router routes traffic on SQL
port
> to your MSDE box.
> With a proper setup of your router and IP + port number given to your
friend
> he (she) can connect to SQL
> "Saso Zagoranski" <saso.zagoranski@.guest.arnes.si> wrote in message
> news:binuv2$iq8$1@.planja.arnes.si...
> > I have MSDE installed on my computer and I gave my friend my IP
address...
> > and he cound't connect to my server...
> > "Pedro Henrique" <pedro@.jew.com.br> wrote in message
> > news:O9es1DkbDHA.3044@.TK2MSFTNGP11.phx.gbl...
> > > Saso,
> > >
> > > The MSDE Database work fine if u have less than 15 concurrent users
and
> > the
> > > Database maximum file is 1GB. You don't need do any special
> configuration
> > to
> > > MSDE work through internet, but the performance will be poor.
> > >
> > > [ ]'s
> > >
> > > PEDRO HENRIQUE NUNES - Brasil
> > >
> > >
> > >
> > > "Saso Zagoranski" <saso.zagoranski@.guest.arnes.si> wrote in message
> > > news:binqgk$fog$1@.planja.arnes.si...
> > > > Hi!
> > > > I was wondering if it was possible to access a MSDE server through
the
> > > > internet and if it is what settings have to be made on the server
> > machine.
> > > > I would like this so I could make any required repairs of my
> application
> > > > over the internet...
> > > >
> > > > Thanks,
> > > > saso
> > > >
> > > >
> > >
> > >
> >
> >
>

Accessing MSDE from Query Manager

Hey all,
Is it possible to use Query Manager (Sql Server 2000) to
access an instance of MSDE that's located on my Virtual
PC? I'm having trouble logging into it and was just
wondering if this was even possible?
Thanks in advance,
rodchar
If MSDE is configured to listen on named pipes and/or TCP/IP and you can
access the Virtual PC remotely then you should be able to connect.
Go to Start - Run and enter svrnetcn.exe. This will open Server Network
Utility. Verify that named pipes and/or TCP/IP are enabled. If not enable
them and stop and restart MSDE.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Also make sure that your MSDE is set up for the authentication you are
using to connect to it. For more information, refer to
325022 INFO: MSDE Security and Authentication
http://support.microsoft.com/?id=325022
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
|||Also make sure that your MSDE is set up for the authentication you are
using to connect to it. For more information, refer to
325022 INFO: MSDE Security and Authentication
http://support.microsoft.com/?id=325022
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

accessing msde from another terminal

Need Help!!!
I am accessing MSDE from another terminal running another
service of MSDE. Error message: Access Denied
How can I do this
That not much information, could you post the whole message it displays ?
Acces mean, that you either entered the wrong username or the wrong
associatet password.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"jesst" <anonymous@.discussions.microsoft.com> schrieb im Newsbeitrag
news:0d4401c54cab$8f836a00$a401280a@.phx.gbl...
> Need Help!!!
> I am accessing MSDE from another terminal running another
> service of MSDE. Error message: Access Denied
> How can I do this

Accessing MSDE 2000

I have downloaded msde 2000. I have edited and saved the setup.ini file for
a sa password.
[Options]
SAPWD="cfm56z"
Setup appears to run and install msde. However when I try to access it with
DbatMGR, I get
SQL Server does not exist or access is denied
Any suggestions would be helpful.
Thanks,
Fred Herring
hi Fred,
Fred Herring wrote:
> Setup appears to run and install msde. However when I try to access
> it with DbatMGR, I get
> SQL Server does not exist or access is denied
>
this kind of error is a general exception raised by MDAC... please check
http://support.microsoft.com/default...06&Product=sql
for more info on how to troubleshoot it
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Accessing MSDE

Can one access an MSDE database which is installed on a
m/c from an application which is running on some other m/c?
TIA,
Niranjan
Sorry, the term "m/c" is lost on me in this context. But if you are asking
if you can access a copy of MSDE on one computer from another computer, the
answer is yes. If you are asking if the database file(s) can be on a
different computer to the MSDE service (ie over a network share), the answer
is no.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Niranjan" <anonymous@.discussions.microsoft.com> wrote in message
news:095f01c539dc$c5adfeb0$a501280a@.phx.gbl...
> Can one access an MSDE database which is installed on a
> m/c from an application which is running on some other m/c?
> TIA,
> Niranjan
|||Thanks. What I am looking for is Whether I can run an
application (VC++ application) on one m/c on which I
create ODBC connection to the other machine which has MSDE
installed on it. Typical client server scenario where
client and server apps are running on 2 different
machines. Does MSDE support this kind of requirement? If
yes, what do I need to do on the client (and server side)?
TIA,
Niranjan

>--Original Message--
>Sorry, the term "m/c" is lost on me in this context. But
if you are asking
>if you can access a copy of MSDE on one computer from
another computer, the
>answer is yes. If you are asking if the database file(s)
can be on a
>different computer to the MSDE service (ie over a network
share), the answer
>is no.
>HTH,
>--
>Greg Low [MVP]
>MSDE Manager SQL Tools
>www.whitebearconsulting.com
>"Niranjan" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:095f01c539dc$c5adfeb0$a501280a@.phx.gbl...
m/c?
>
>.
>
|||hi Niranjan,
Niranjan wrote:
> Thanks. What I am looking for is Whether I can run an
> application (VC++ application) on one m/c on which I
> create ODBC connection to the other machine which has MSDE
> installed on it. Typical client server scenario where
> client and server apps are running on 2 different
> machines. Does MSDE support this kind of requirement? If
> yes, what do I need to do on the client (and server side)?
please excuse my poor english, but I do not understand the term "m/c" too..
anyway, the scenario you are interested with is fully supported..
loosely speaking, on the server you have to install MSDE 2000 enabling the
required network protocols (you can check with the Server Network Utility,
svrnetcn.exe)..
on the client side, you typically have to installs only the connectivity
software, included in the MDAC distribution, including the desired driver
(ODBC , OLE DB), and verifying the preferred network protocol(s) to
communicate with the server is enabled via the Client Network Utility
(cliconfg.exe)... and network connections must be available
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply