Release A Install Problems

We have packaged MSDE 2000 release A with our applicaiton. A user ran the
install, but when MSDE goes to start it says, MSDE is either currport or has
been tampered with, please uninstall and reinstall MSDE, invalid package ID.
We go to unstill MSDE and it says MSDE is not installed... We tried
reinstalling, since it thought it wasn't installed and when the installer
starts, we get the same invaled package id error... Does anyone have any
ideas, or thoughts on what is happening or what I can do to fix this? Thanks,
Brian
Did you define a strong password for SA using the SAPWD parameter? MSDE SP3A
setup.exe will not install a new instance without it.
joe.
"Brian" <Brian@.discussions.microsoft.com> wrote in message
news:C8D287B9-BCD6-4423-AF48-21455901D596@.microsoft.com...
> We have packaged MSDE 2000 release A with our applicaiton. A user ran the
> install, but when MSDE goes to start it says, MSDE is either currport or
> has
> been tampered with, please uninstall and reinstall MSDE, invalid package
> ID.
> We go to unstill MSDE and it says MSDE is not installed... We tried
> reinstalling, since it thought it wasn't installed and when the installer
> starts, we get the same invaled package id error... Does anyone have any
> ideas, or thoughts on what is happening or what I can do to fix this?
> Thanks,
> Brian
>

Relationships on MSDE

I am an Access user.
In Access when I create a relationship between 2 tables is use
Enforce Referential Integrity
Cascade Update Related Fields
Cascade Delete Related Records
If I change data in Primary Table is Update automaticaly in Foreign table.

I use a MSDE database, and I create 2 tabele
Table 1 - with a primary key (AUT_ID)
Table 2 (Foreign table) with 2 fields
Field :AUT_ID
Field: Field1
I use Access interfaces (adp Database) and I create a Diagram
Primary key table: Table_1; Field: AUT_ID
Foreign table: Table_2; Field: AUT_ID

PROBLEM: If I change data in Table_1 (field AUT_ID) data is not change in Table_2 and error occurs.[i]
PROBLEM: If I change data in Table_1 (field AUT_ID) data is not change in Table_2 and error occurs.

I see nothing that requests any sort of cascading-update.

Furthermore, Table_2 is clearly the master-table of the relationship and Table_1 the subordinate. Thus a change to Table_1 to introduce a key not in Table_2 would be disallowed, as you see.|||Is a version problem if I understud corectly
SQL vers.7 did not suport ON UPDATE NO ACTION / CASCADE
SQL vers.8 (suport ON UPDATE NO ACTION / CASCADE)
I installed vers.8 and everything is OK.

Thanks.

Relationships in MSDE - how do I do it?

Hi
I am using the Web Matrix Project to write a .NETapplication. I have set up a database using MSDE which Iaccessed through the Web Matrix Project to start with. I have nowfound the Web Data Administrator which I use to backup my database andhelp to transfer it to the Server where I hope to run this application(if I ever get it finished!).
I need to set up some relationships between database tables but cannotsee a way to do this. SQL Server Books on Line referes toEnterprise Manager which I believe ships with the full MS SQL Serverpackage (and costs a package). I am doing this on ashoe-string. Any ideas on how to do it?
Thanks in advance.
Mike
CREATE TABLE order_part
(order_nmbr int,
part_nmbr int
FOREIGN KEY REFERENCES part_sample(part_nmbr)
ON DELETE NO ACTION,
qty_ordered int)
GO

you could do an alter table if its already there|||Hi DeveloperMCDBA
I did not realise I could create a table using a StoredProcedure. It certainly takes me longer than just using theWebMatrix but I seem to be getting there. Many thanks for thehelp - much appreciated.
Mike

Reinstating Replication on a subscriber automatically

Hi all

I am setting up a system using SQL Server 2005 replicating to both SQL Express and MSDE clients. My question is this - if a client PC has been rebuilt - i.e. new hard disk etc, how can I automatically make that machine realise that it is already a subscriber of a SQL Server database and for it to automatically get a snapshot?

I hope this makes sense, thanks for your help.

D

If the subscriber has the same name as the old one, the SQL Server version of the subscriber is the same as the old one, and the history or distribution retention period has not passed you merely need to restore the subscriber database and the distributor will backfill the missing commands.

If this is not the case you should try to do a no-sync and then a validation to determine what is missing, or how out of sync you are. At that point you might want to evaluate re-initializing.sql

re-install MSDE

Hi,
I've been trying to install the IBUYSPY samples and have been running into server problems. I've done everything from uninstalling and reinstalling MSDE to manually erasing the data files via window explorer. I've got everything so screwed up now, that e
ven though MSDE is installed, I can't access it through Server Explorer in VS DotNet. I have 2 questions
1) How can I do a clean install of MSDE (erase everything, then reinstall everything)?
2) What significance do the aspnet_wp and SQLDebugger accounts have? Should these accounts be set as administrator accounts, and should they be password protected?
I've had both IBUYSPY samples installed and working properly before... I'm almost ready to re-format my hard drive and start from scratch!!
Thanks!!
Curt
Hi Curt,
For reinstalling MSDE, I would suggest you go through the steps listed in
the following KB article of uninstalling the MSDE and then you can do a
fresh installation.
HOW TO: Manually Remove a Microsoft SQL Server 2000 Desktop Engine (MSDE
2000) Instance
http://support.microsoft.com/default...&Product=sql2k
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
sql

reinstall msde

we are not able to reinsatall msde in the same server..we are getting the
errors. we uninstaaled the msde and using add/remove programs and also
deleted instance of microsoft sql server folder.. still we can't access the
server from the client machines.. got the error "server does not exist". how
do we solve this problem/
priya
You have specified that there is more than one issue.
1. You cant re-install MSDE
2. You cant connect to it.
Can you access SQL from the server itself?
How are you trying to connect to the server from a client?
"hardhat" wrote:

> we are not able to reinsatall msde in the same server..we are getting the
> errors. we uninstaaled the msde and using add/remove programs and also
> deleted instance of microsoft sql server folder.. still we can't access the
> server from the client machines.. got the error "server does not exist". how
> do we solve this problem/
> priya
|||we were not able to connect to the local machine too. first we got login
error even if we set the password . . server was working for the last 8
months ..all of a sudden we got the error catalog information could not be
found" we figured out that in the server the TCP\IP got disabled (we don't
know how)..we downloaded sql server express and its inface had the choice to
enable\disable TCP\IP ..i believe that was the problem..
"Legend" wrote:
[vbcol=seagreen]
> You have specified that there is more than one issue.
> 1. You cant re-install MSDE
> 2. You cant connect to it.
> Can you access SQL from the server itself?
> How are you trying to connect to the server from a client?
> "hardhat" wrote:

reinitialize deleted data

hi
i have sql 2000 sp3 and a merge publication with a filter. additional i
have a client with msde also sp3 with is subscriber to the
server-publication.
the replication worked just fine for weeks. on one day i made a sync
with lots of data. while synchronizing the computer shutdown into
standby. after waking up i had a error message from the sql server that
he lost connection or something. til here no problem. so i just tried
again to synchronize. i received the error "merge process could not
initialize publisher XXX"
so i clicked on "reinitialize" on the subscriber. he said then that he
would do it when the merge agent starts the next time. so i synchronized
again and it worked very fast. a bit too fast because ALL data in the
table he should have synchronized has gone. obviously deleted...
can i restore this data again without backup :-)
is this the correct behavour of a reinitialize? if yes, what should i
have done else? if no, what happend then?
thanx for every hint
jazper
You should be able to restore the subscriber from the subscriber backup.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jazper Manto" <ejazper@.hotmail.com> wrote in message
news:uy8gN83aFHA.2900@.TK2MSFTNGP15.phx.gbl...
> hi
> i have sql 2000 sp3 and a merge publication with a filter. additional i
> have a client with msde also sp3 with is subscriber to the
> server-publication.
> the replication worked just fine for weeks. on one day i made a sync
> with lots of data. while synchronizing the computer shutdown into
> standby. after waking up i had a error message from the sql server that
> he lost connection or something. til here no problem. so i just tried
> again to synchronize. i received the error "merge process could not
> initialize publisher XXX"
> so i clicked on "reinitialize" on the subscriber. he said then that he
> would do it when the merge agent starts the next time. so i synchronized
> again and it worked very fast. a bit too fast because ALL data in the
> table he should have synchronized has gone. obviously deleted...
> can i restore this data again without backup :-)
> is this the correct behavour of a reinitialize? if yes, what should i
> have done else? if no, what happend then?
> thanx for every hint
> jazper
|||hi hilary
what is a "subscriber backup"?
is this the correct behavour of a reinitialize?
jazper

ReIndexing

SQL SERVER 2000 & MSDE
We have a commercial app in which the customers will not have any real
computer literate users (software for dummies, who would have thought)
What should I be doing to re-index the database from time to time? There are
around 300 tables.
Does SQL Server take care of this itself or should i have some sort of code
or stored procedure that re-indexes?
TIA
Tim MorrisonCheck fragmentation and index those tables with appreciable fragmentation.
Look up dbcc showcontig in BOL for an example of such a script.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tim Morrison" <sales@.NOSPAM_kjmsoftware.com> wrote in message
news:uKYMrDHBHHA.1196@.TK2MSFTNGP02.phx.gbl...
> SQL SERVER 2000 & MSDE
> We have a commercial app in which the customers will not have any real
> computer literate users (software for dummies, who would have thought)
> What should I be doing to re-index the database from time to time? There
> are around 300 tables.
> Does SQL Server take care of this itself or should i have some sort of
> code or stored procedure that re-indexes?
> TIA
> Tim Morrison
>|||Tim Morrison wrote:
> SQL SERVER 2000 & MSDE
> We have a commercial app in which the customers will not have any real
> computer literate users (software for dummies, who would have thought)
> What should I be doing to re-index the database from time to time? There are
> around 300 tables.
> Does SQL Server take care of this itself or should i have some sort of code
> or stored procedure that re-indexes?
> TIA
> Tim Morrison
>
http://realsqlguy.com/serendipity/archives/12-Humpty-Dumpty-Sat-On-A-Wall...html
Tracy McKibben
MCDBA
http://www.realsqlguy.com

Registry entries for SQL Server/MSDE

Where can I find a listing of all the registry entries made at install time - or, better yet - what entries I need to elminate on uninstall? I've installed and uninstalled MSDE a number of times on my development machine, and now I can't get MSDE 2000 Rel A to install at all. I think there is one or more key blocking the installer. I appreciate your input!HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

Registering SQL Server...

Hi,
I am trying to connect remotely to a client's MSDE database with my SQL
Enterprise Manager so I can administer the database. I have established a
VPN to the client which I can ping and terminal serve into the server but I
cannot register the server with the SQL Enterprise Manager. I have even
tried turning off my Windows Firewall.
What connection property am I missing at either the client site or at my
office that is preventing me from connecting?
Thanks,
Chris
hi Chris,
Chris Marsh wrote:
> Hi,
> I am trying to connect remotely to a client's MSDE database with my
> SQL Enterprise Manager so I can administer the database. I have
> established a VPN to the client which I can ping and terminal serve
> into the server but I cannot register the server with the SQL
> Enterprise Manager. I have even tried turning off my Windows
> Firewall.
> What connection property am I missing at either the client site or at
> my office that is preventing me from connecting?
what kind of exception are you prompted with, at connection try?
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
|||I enter the IP into the Server line (leave Windows Auth or switch to SQL
Auth) and then I get the messagebox:
SQL Server registraion failed bause of hte connection falure displayed
below....
SQL Server does not exist or access denied.
ConnectionOpen (Connect())
Yes | No
Thanks!
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3cq5dpF6qk3gpU1@.individual.net...
> hi Chris,
> Chris Marsh wrote:
> what kind of exception are you prompted with, at connection try?
> --
> 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
>
|||Did you make a portscan to see wheter the SQLServer is reachable and
listening on that adress ?
Perhaps the ports are blocked by the VPN Gateway, ping could be reachable
beacuse ICMP is treated in antoher way than ports. Its a own protocol:
http://www.iana.org/assignments/icmp-parameters
Try to use a portscanner.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Chris Marsh" <cmarsh@.synergy-intl.com> schrieb im Newsbeitrag
news:Or8DSspRFHA.3704@.TK2MSFTNGP12.phx.gbl...
>I enter the IP into the Server line (leave Windows Auth or switch to SQL
>Auth) and then I get the messagebox:
> SQL Server registraion failed bause of hte connection falure displayed
> below....
> SQL Server does not exist or access denied.
> ConnectionOpen (Connect())
> Yes | No
> Thanks!
>
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:3cq5dpF6qk3gpU1@.individual.net...
>
|||Chris Marsh wrote:
> I enter the IP into the Server line (leave Windows Auth or switch to
> SQL Auth) and then I get the messagebox:
> SQL Server registraion failed bause of hte connection falure displayed
> below....
> SQL Server does not exist or access denied.
> ConnectionOpen (Connect())
which is a general error reported by the MDAC stack..
please have a look at
http://support.microsoft.com/default...06&Product=sql
for a list of the more common causes of this kind of exception
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
|||Chris, see an earlier post 'Getting to the bottom of ..." in the
subject. (just a few days ago).
If it's running on XP it's an XP login problem which can be cured on
the XP/Msde machine. There's a long explanation of how to cure this
(without re-installing).
It's not an MDAC problem. Come on MVP's you should know this stuff!
-Nick
On Thu, 21 Apr 2005 12:35:05 -0400, "Chris Marsh"
<cmarsh@.synergy-intl.com> wrote:

>Hi,
>I am trying to connect remotely to a client's MSDE database with my SQL
>Enterprise Manager so I can administer the database. I have established a
>VPN to the client which I can ping and terminal serve into the server but I
>cannot register the server with the SQL Enterprise Manager. I have even
>tried turning off my Windows Firewall.
>What connection property am I missing at either the client site or at my
>office that is preventing me from connecting?
>Thanks,
>Chris
>

Registering MSDE 2000 in EM

Greetings,
anyone knows how to register MSDE 2000 SP3 in EM?
Thank you,
Aleksandar Andjelkovic
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
Hi,
MSDE is not coming with client tools like Enterprise manager, Query
analyzer. To utilize that
you need to purchase the client access license.
FYI, if you have the license already then you can install the client and
register the MSDE server.
Have a look into the below links for the details and free tools to access
MSDE.
http://www.aspfaq.com/show.asp?id=2442
Thanks
Hari
MCDBA
<Aleksandar Andjelkovic> wrote in message
news:eY2Hr9GTEHA.3016@.tk2msftngp13.phx.gbl...
> Greetings,
> anyone knows how to register MSDE 2000 SP3 in EM?
> Thank you,
> Aleksandar Andjelkovic
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!
|||Just register it. Note that MSDE doesn't listen to any netlib by default, you have to configure that.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<Aleksandar Andjelkovic> wrote in message news:eY2Hr9GTEHA.3016@.tk2msftngp13.phx.gbl...
> Greetings,
> anyone knows how to register MSDE 2000 SP3 in EM?
> Thank you,
> Aleksandar Andjelkovic
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!
|||Thank you for your replay. I found the answer, MSDE is visible on the
network now, and I was able to register it in EM. I was missing
DISABLENETWORKPROTOCOLS=0 in setup command when installing MSDE.
Here is the link:
http://www.experts-exchange.com/Data...rver/Q_2067987
3.html
Thank you, Aleksandar
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Registering MSDE 2000 in EM

Greetings,
anyone knows how to register MSDE 2000 SP3 in EM?
Thank you,
Aleksandar Andjelkovic
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!Hi,
MSDE is not coming with client tools like Enterprise manager, Query
analyzer. To utilize that
you need to purchase the client access license.
FYI, if you have the license already then you can install the client and
register the MSDE server.
Have a look into the below links for the details and free tools to access
MSDE.
http://www.aspfaq.com/show.asp?id=2442
Thanks
Hari
MCDBA
<Aleksandar Andjelkovic> wrote in message
news:eY2Hr9GTEHA.3016@.tk2msftngp13.phx.gbl...
> Greetings,
> anyone knows how to register MSDE 2000 SP3 in EM?
> Thank you,
> Aleksandar Andjelkovic
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Just register it. Note that MSDE doesn't listen to any netlib by default, yo
u have to configure that.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<Aleksandar Andjelkovic> wrote in message news:eY2Hr9GTEHA.3016@.tk2msftngp13.phx.gbl...[vbco
l=seagreen]
> Greetings,
> anyone knows how to register MSDE 2000 SP3 in EM?
> Thank you,
> Aleksandar Andjelkovic
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it![/vbcol]|||Thank you for your replay. I found the answer, MSDE is visible on the
network now, and I was able to register it in EM. I was missing
DISABLENETWORKPROTOCOLS=0 in setup command when installing MSDE.
Here is the link:
http://www.experts-exchange.com/Dat...erver/Q_2067987
3.html
Thank you, Aleksandar
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Registering MSDE 2000 in EM

Greetings,
anyone knows how to register MSDE 2000 SP3 in EM?
Thank you,
Aleksandar Andjelkovic
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!Hi,
MSDE is not coming with client tools like Enterprise manager, Query
analyzer. To utilize that
you need to purchase the client access license.
FYI, if you have the license already then you can install the client and
register the MSDE server.
Have a look into the below links for the details and free tools to access
MSDE.
http://www.aspfaq.com/show.asp?id=2442
Thanks
Hari
MCDBA
<Aleksandar Andjelkovic> wrote in message
news:eY2Hr9GTEHA.3016@.tk2msftngp13.phx.gbl...
> Greetings,
> anyone knows how to register MSDE 2000 SP3 in EM?
> Thank you,
> Aleksandar Andjelkovic
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Just register it. Note that MSDE doesn't listen to any netlib by default, you have to configure that.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<Aleksandar Andjelkovic> wrote in message news:eY2Hr9GTEHA.3016@.tk2msftngp13.phx.gbl...
> Greetings,
> anyone knows how to register MSDE 2000 SP3 in EM?
> Thank you,
> Aleksandar Andjelkovic
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!

registering MSDE 2000 FROM SQL 2000

Hi There,

I have install msde in one computer and try to register from my sql server, the following error message is coming.

A connection could not be established to Cal-itimilsina (computer in which MSDE IS INSTALLED)

RESON: SQL SERVER DOES NOT EXIST OR ACCESS DENIED

CONNECTIONOPEN(CONNECT())

====

BUT THE MSDE IS RUNNING IN THE CLIENT MACHINE. Could any one please help me

Thanks.

Indra.Check this (http://www.microsoft.com/sql/msde/productinfo/features.asp) site, but in short, - Named Pipes is not supported on MSDE. You need to create an alias on your server for MSDE instance using TCP/IP protocol, and specify the alias during server registration in EM. You can also use the IP address for registration.|||Thanks, i will have a check now.|||Hi,

I setup alias with TCP/IP and try to connect with alias name as well with tcp/ip, but same error message is comming. by the way what cold be my instance, i just install msde with setup.exe from command prompt.

thanks for help|||Type "OSQL -L" in command window.|||Originally posted by rdjabarov
Type "OSQL -L" in command window.

it display the name of the sql server available inthe network.

Registering a remote instance of MSDE

Hi..
I have been trying to register a remote instance..but have no success.
The MSDE instance is behind a firewall...So in the firewall im doing a port
fowarding.
The port that i have setup for forwarding is 1433 (TCP), is that correct?
i have installed the MSDE just like this:
setup SAPWD="MyPass" INSTANCENAME="MSDE" DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL
Is there anything wrong?
Why i cant register that instance in my machine?
Thanks
hi Marcos,
Marcos Lommez wrote:
> Hi..
> I have been trying to register a remote instance..but have no success.
> The MSDE instance is behind a firewall...So in the firewall im doing
> a port fowarding.
> The port that i have setup for forwarding is 1433 (TCP), is that
> correct?
> i have installed the MSDE just like this:
> setup SAPWD="MyPass" INSTANCENAME="MSDE" DISABLENETWORKPROTOCOLS=0
> SECURITYMODE=SQL
> Is there anything wrong?
> Why i cant register that instance in my machine?
TCP 1433 should be wrong as you installed a named instance...
Microsoft only got 1 unique TCP/IP port for SQL Server
assigned by IANA, port TCP/IP 1433... but named instances never listen to
that port that is "reserved" for default instances... so Microsoft embedded
an additional service in order to allow dynamic ports assignemen/resolution
for named instance, and the MDAC stack has been modified as well to
integrate this feature (MDAC 2.6 and above)
for named instance you have 2 options... dynamic (default) or fixed static
port assignement..
loosely speaking, for dynamic port, when the specified instance starts, it
always searches for an unused port (actually it always uses the very same
port, if free)... the SQL Server Resolution Service, listening on UDP 1434
port, intercepts all remote connections to the instances, asks the instance
for it's used port, and redirects all connections to that specific port,
adding some little overhead to the traffic...
again, very very loosely speaking, the client makes a query, which is
reloaded by the MDAC stack to the appropriate network protocol [we are
talking about TCP/IP], that intiates the connection over a random tcp port
greater than 1024 to destination port; the listener service is the first
hand-shaker and intercepts the foreign call, queries the instance for it's
used port and negotiates a TCP/IP port for the 2 end points...
for a static assigned port, the listener on UDP 1434 port is not required,
but you have to map a server alias on each remote client pointing to the
correct fixed assigned port.. and again, the client intiates the connection
over a random tcp port greater than 1024 to destination port (say 1059). The
Subscriber should be allowed to make inbound (ANY) connections to
{say 1059} on a random port. The Publisher should be allowed to establish
outgoing connections to the subscriber from (ANY) to {say 1059}...
for Windows XP sp2 integrated Firewall closes all ports, you have to add an
exception for that in order to allow external access,
http://support.microsoft.com/default.aspx?scid=kb;[LN];841251 ,
http://support.microsoft.com/?id=841249 ,
http://support.microsoft.com/default.aspx?kbid=839980
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks so much Andrea...
In my case the solution is to use a fixed port.
But how do i set a specific port to use?
Im using MSDE 2000 running on Win2k Server
Thanks again
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> escreveu na mensagem
news:47np01Fg9pf2U1@.individual.net...
> hi Marcos,
> Marcos Lommez wrote:
> TCP 1433 should be wrong as you installed a named instance...
> Microsoft only got 1 unique TCP/IP port for SQL Server
> assigned by IANA, port TCP/IP 1433... but named instances never listen to
> that port that is "reserved" for default instances... so Microsoft
embedded
> an additional service in order to allow dynamic ports
assignemen/resolution
> for named instance, and the MDAC stack has been modified as well to
> integrate this feature (MDAC 2.6 and above)
> for named instance you have 2 options... dynamic (default) or fixed static
> port assignement..
> loosely speaking, for dynamic port, when the specified instance starts, it
> always searches for an unused port (actually it always uses the very same
> port, if free)... the SQL Server Resolution Service, listening on UDP 1434
> port, intercepts all remote connections to the instances, asks the
instance
> for it's used port, and redirects all connections to that specific port,
> adding some little overhead to the traffic...
> again, very very loosely speaking, the client makes a query, which is
> reloaded by the MDAC stack to the appropriate network protocol [we are
> talking about TCP/IP], that intiates the connection over a random tcp port
> greater than 1024 to destination port; the listener service is the first
> hand-shaker and intercepts the foreign call, queries the instance for it's
> used port and negotiates a TCP/IP port for the 2 end points...
> for a static assigned port, the listener on UDP 1434 port is not required,
> but you have to map a server alias on each remote client pointing to the
> correct fixed assigned port.. and again, the client intiates the
connection
> over a random tcp port greater than 1024 to destination port (say 1059).
The
> Subscriber should be allowed to make inbound (ANY) connections to
> {say 1059} on a random port. The Publisher should be allowed to establish
> outgoing connections to the subscriber from (ANY) to {say 1059}...
> for Windows XP sp2 integrated Firewall closes all ports, you have to add
an
> exception for that in order to allow external access,
> http://support.microsoft.com/default.aspx?scid=kb;[LN];841251 ,
> http://support.microsoft.com/?id=841249 ,
> http://support.microsoft.com/default.aspx?kbid=839980
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Marcos,
Marcos Lommez wrote:
> Thanks so much Andrea...
> In my case the solution is to use a fixed port.
> But how do i set a specific port to use?
> Im using MSDE 2000 running on Win2k Server
just run the Server Network Utility (svrnetcn.exe), select the TCP/IP
protocol and access it's properties.. the port currently use is there...
just type the port you want to use and confirm...
then you can access the registry value
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\SuperSocketNetLib\Tcp
(for a default instance)
or
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\InstanceName\MSSQLServer\SuperSocketNetLib\ Tcp (for a named instance)
and check the
TcpDynamicPorts ...
it's value should be empty...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea Montanari wrote:
> hi Marcos,
> Marcos Lommez wrote:
> just run the Server Network Utility (svrnetcn.exe), select the TCP/IP
> protocol and access it's properties.. the port currently use is
> there... just type the port you want to use and confirm...
> then you can access the registry value
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\SuperSocketNetLib\Tcp
> (for a default instance)
> or
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> Server\InstanceName\MSSQLServer\SuperSocketNetLib\ Tcp (for a named
> instance) and check the
> TcpDynamicPorts ...
> it's value should be empty...
http://support.microsoft.com/default...b;en-us;823938
:-D
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

register local instance with MSDE

Thanks in advance.
I am trying to register my local machine with MSDE 2000.
SQL server authetication keep rejecting my login id and password.
Please, advised me why it is not accepting.
Is it because I don't have installed server portion of SQL 2000 Server?
What exactly do you mean "register local instance with MSDE"?
When you say "SQL Server authentication keep rejecting my login id and
password", do you mean you was trying to connect to the MSDE by supplying
username/password pair (meaning the MSDE must be enabled on mixed security
mode)? Since by default installation, only Windows Integrated Authentication
mode is enabled, unless you specifically enabled mixed security mode on the
MSDE, you will not be able to access the MSDE by supplying
username/password. This could be the cause of your problem.
"Jay" <Jay@.discussions.microsoft.com> wrote in message
news:C83EC5C8-012D-4155-AA55-5228713A967C@.microsoft.com...
> Thanks in advance.
> I am trying to register my local machine with MSDE 2000.
> SQL server authetication keep rejecting my login id and password.
> Please, advised me why it is not accepting.
> Is it because I don't have installed server portion of SQL 2000 Server?
>
>
|||Thank you Norman for your clarification.
In MSDE SQL Server Enterprise Manage, under Microsoft Servers and SQL Server
Groups, I am trying to connect (LOCAL)(Windows NT: this is my local machine).
I am having this error message: Connection Failed, check SQL server
Registration
1.Using Windows Authentication in "Edit SQL Server Registration Properties"
Error message: A connection can not be established to (LOCAL).
Reason: Login failed
2.SQL Server Authentication in "Edit SQL Server Registration Properties"
Error message: SQL server registration failed.
Login failed for user.
3. Network administrator can connect to this "LOCAL" machine.
Will you help me to clear oou my confused minds?
Thanks, again.
"Norman Yuan" wrote:

> What exactly do you mean "register local instance with MSDE"?
> When you say "SQL Server authentication keep rejecting my login id and
> password", do you mean you was trying to connect to the MSDE by supplying
> username/password pair (meaning the MSDE must be enabled on mixed security
> mode)? Since by default installation, only Windows Integrated Authentication
> mode is enabled, unless you specifically enabled mixed security mode on the
> MSDE, you will not be able to access the MSDE by supplying
> username/password. This could be the cause of your problem.
> "Jay" <Jay@.discussions.microsoft.com> wrote in message
> news:C83EC5C8-012D-4155-AA55-5228713A967C@.microsoft.com...
>
>
|||There is no such product as: "MSDE SQL Server Enterprise Manage".
Are you using EM with a properly licensed SQL Server installation?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Jay" <Jay@.discussions.microsoft.com> wrote in message
news:8CBFEED6-75E2-4215-9D38-B55F8E98F348@.microsoft.com...[vbcol=seagreen]
> Thank you Norman for your clarification.
> In MSDE SQL Server Enterprise Manage, under Microsoft Servers and SQL
> Server
> Groups, I am trying to connect (LOCAL)(Windows NT: this is my local
> machine).
> I am having this error message: Connection Failed, check SQL server
> Registration
> 1.Using Windows Authentication in "Edit SQL Server Registration
> Properties"
> Error message: A connection can not be established to (LOCAL).
> Reason: Login failed
> 2.SQL Server Authentication in "Edit SQL Server Registration Properties"
> Error message: SQL server registration failed.
> Login failed for user.
> 3. Network administrator can connect to this "LOCAL" machine.
> Will you help me to clear oou my confused minds?
> Thanks, again.
>
> "Norman Yuan" wrote:
|||Sorry for confusion!
I just put MSDE in front of SQL Server Enterprise Manager to emphasize that
it is MSDE not SQL Server.
Thanks
"Arnie Rowland" wrote:

> There is no such product as: "MSDE SQL Server Enterprise Manage".
> Are you using EM with a properly licensed SQL Server installation?
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "Jay" <Jay@.discussions.microsoft.com> wrote in message
> news:8CBFEED6-75E2-4215-9D38-B55F8E98F348@.microsoft.com...
>
>

register database

I have installed an application made with VB6 on a computer, and have
installed MSDE 2000. I've copied the .ldf and .mdf files in the appropriate
folder. However, the login information that is contained in the application
doesn't allow me to access the database. I was able to access the database
when I was designing the application. I used a dataenvironment. When I ran
the application on the user's computer, it asked for the password for the sa
account and also for the name of the instance of SQL Server to connect to.
I was able to give that information correctly. What is the problem? Was I
supposed to do more than copy the .ldf and .mdf files onto the hard drive.
Was I supposed to somehow register those files with SQL Server? MSDE
doesn't come with the same tools as SQL Server. Can someone help?To be honest I do not know MSDE 2000 as well as I should
but with Server 2000 you need to perform a sp_attach_db.
J
>--Original Message--
>I have installed an application made with VB6 on a
computer, and have
>installed MSDE 2000. I've copied the .ldf and .mdf
files in the appropriate
>folder. However, the login information that is
contained in the application
>doesn't allow me to access the database. I was able to
access the database
>when I was designing the application. I used a
dataenvironment. When I ran
>the application on the user's computer, it asked for the
password for the sa
>account and also for the name of the instance of SQL
Server to connect to.
>I was able to give that information correctly. What is
the problem? Was I
>supposed to do more than copy the .ldf and .mdf files
onto the hard drive.
>Was I supposed to somehow register those files with SQL
Server? MSDE
>doesn't come with the same tools as SQL Server. Can
someone help?
>
>.
>|||Daniel,
Julia's TSQL is right.
Just an extra point though - if you want to do this sort of thing
graphically using SQL Server client tools - Enterprise Manager, query
analyser etc - then you could register the MSDE instance on another
Enterprise Manager on the network. If it is a stand-alone PC then you might
install Developer Edition just to get the tools ($40ish).
HTH,
Paul Ibison|||However, last time I heard, this is violating the license agreements. We have had a discussion about this in
the MVP group, and hopefully MS will make these things much clearer on their web pages (if that haven't
already been done...). :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message news:%23vf8$GvSEHA.3968@.TK2MSFTNGP09.phx.gbl...
> Daniel,
> Julia's TSQL is right.
> Just an extra point though - if you want to do this sort of thing
> graphically using SQL Server client tools - Enterprise Manager, query
> analyser etc - then you could register the MSDE instance on another
> Enterprise Manager on the network. If it is a stand-alone PC then you might
> install Developer Edition just to get the tools ($40ish).
> HTH,
> Paul Ibison
>|||Hi,
MSDE will not come up with normal tools graphical tools. Follow the below
steps to attach the database in MSDE
1. From command prompt execute
OSQL -Usa -Ppassword -S servername (Enter Key)
This will go go to a sql prompt, there execute the sp_attach_db to attach
the MDF and LDF file to sql server
1> sp_attach_db
'dbname','c:\mssql\data\dname_data.mdf','c:\mssql\data\dname_log.ldf'
(enter Key)
2>go (enter key)
This will attach the database to sql server. After this you can access the
database. Provide the directory and MDF and LDF file names appropriately.
---
Microsoft is giving a free tool named "SQL Server web data Administrator" to
manager and administrator the SQl server. This will be more useful to
MSDE users.
Download the free tool from below site.
http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
Thanks
Hari
MCDBA
"Daniel" <dwbnews@.hotmail.com> wrote in message
news:OIsozWpSEHA.3332@.tk2msftngp13.phx.gbl...
> I have installed an application made with VB6 on a computer, and have
> installed MSDE 2000. I've copied the .ldf and .mdf files in the
appropriate
> folder. However, the login information that is contained in the
application
> doesn't allow me to access the database. I was able to access the
database
> when I was designing the application. I used a dataenvironment. When I
ran
> the application on the user's computer, it asked for the password for the
sa
> account and also for the name of the instance of SQL Server to connect to.
> I was able to give that information correctly. What is the problem? Was
I
> supposed to do more than copy the .ldf and .mdf files onto the hard drive.
> Was I supposed to somehow register those files with SQL Server? MSDE
> doesn't come with the same tools as SQL Server. Can someone help?
>|||Thanks fo rthis feedback. I'll hold off from this recommendation (here and
in class) until things are sorted.
Regards,
Paul Ibison|||I was a bit surprised to here that you can't even use your own EM to manage your own MSDE's, but that is the
way I read one of the posts. Hopefully, MS will understand that first step is to document this as clearly as
possible...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message news:uKEI5YGTEHA.3660@.tk2msftngp13.phx.gbl...
> Thanks fo rthis feedback. I'll hold off from this recommendation (here and
> in class) until things are sorted.
> Regards,
> Paul Ibison
>|||Thank you for the comments. You may be interested to learn what I've found
out. It is actually possible to use code (in my case I use Visual Basic 6)
to attach the database to MSDE. Here is a link I found that leads to other
links that give more information:
http://msdn.microsoft.com/vstudio/downloads/addins/msde/deploying.aspx.
Paul Ibison mentioned in his post about a class? I'm curious about what
class that is.
Daniel
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uKEI5YGTEHA.3660@.tk2msftngp13.phx.gbl...
> Thanks fo rthis feedback. I'll hold off from this recommendation (here and
> in class) until things are sorted.
> Regards,
> Paul Ibison
>

register database

I have installed an application made with VB6 on a computer, and have
installed MSDE 2000. I've copied the .ldf and .mdf files in the appropriate
folder. However, the login information that is contained in the application
doesn't allow me to access the database. I was able to access the database
when I was designing the application. I used a dataenvironment. When I ran
the application on the user's computer, it asked for the password for the sa
account and also for the name of the instance of SQL Server to connect to.
I was able to give that information correctly. What is the problem? Was I
supposed to do more than copy the .ldf and .mdf files onto the hard drive.
Was I supposed to somehow register those files with SQL Server? MSDE
doesn't come with the same tools as SQL Server. Can someone help?
Daniel,
Julia's TSQL is right.
Just an extra point though - if you want to do this sort of thing
graphically using SQL Server client tools - Enterprise Manager, query
analyser etc - then you could register the MSDE instance on another
Enterprise Manager on the network. If it is a stand-alone PC then you might
install Developer Edition just to get the tools ($40ish).
HTH,
Paul Ibison
|||However, last time I heard, this is violating the license agreements. We have had a discussion about this in
the MVP group, and hopefully MS will make these things much clearer on their web pages (if that haven't
already been done...). :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message news:%23vf8$GvSEHA.3968@.TK2MSFTNGP09.phx.gbl...
> Daniel,
> Julia's TSQL is right.
> Just an extra point though - if you want to do this sort of thing
> graphically using SQL Server client tools - Enterprise Manager, query
> analyser etc - then you could register the MSDE instance on another
> Enterprise Manager on the network. If it is a stand-alone PC then you might
> install Developer Edition just to get the tools ($40ish).
> HTH,
> Paul Ibison
>
|||Hi,
MSDE will not come up with normal tools graphical tools. Follow the below
steps to attach the database in MSDE
1. From command prompt execute
OSQL -Usa -Ppassword -S servername (Enter Key)
This will go go to a sql prompt, there execute the sp_attach_db to attach
the MDF and LDF file to sql server
1> sp_attach_db
'dbname','c:\mssql\data\dname_data.mdf','c:\mssql\ data\dname_log.ldf'
(enter Key)
2>go (enter key)
This will attach the database to sql server. After this you can access the
database. Provide the directory and MDF and LDF file names appropriately.
Microsoft is giving a free tool named "SQL Server web data Administrator" to
manager and administrator the SQl server. This will be more useful to
MSDE users.
Download the free tool from below site.
http://www.microsoft.com/downloads/d...798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
Thanks
Hari
MCDBA
"Daniel" <dwbnews@.hotmail.com> wrote in message
news:OIsozWpSEHA.3332@.tk2msftngp13.phx.gbl...
> I have installed an application made with VB6 on a computer, and have
> installed MSDE 2000. I've copied the .ldf and .mdf files in the
appropriate
> folder. However, the login information that is contained in the
application
> doesn't allow me to access the database. I was able to access the
database
> when I was designing the application. I used a dataenvironment. When I
ran
> the application on the user's computer, it asked for the password for the
sa
> account and also for the name of the instance of SQL Server to connect to.
> I was able to give that information correctly. What is the problem? Was
I
> supposed to do more than copy the .ldf and .mdf files onto the hard drive.
> Was I supposed to somehow register those files with SQL Server? MSDE
> doesn't come with the same tools as SQL Server. Can someone help?
>
|||Thanks fo rthis feedback. I'll hold off from this recommendation (here and
in class) until things are sorted.
Regards,
Paul Ibison
|||I was a bit surprised to here that you can't even use your own EM to manage your own MSDE's, but that is the
way I read one of the posts. Hopefully, MS will understand that first step is to document this as clearly as
possible...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message news:uKEI5YGTEHA.3660@.tk2msftngp13.phx.gbl...
> Thanks fo rthis feedback. I'll hold off from this recommendation (here and
> in class) until things are sorted.
> Regards,
> Paul Ibison
>
|||Thank you for the comments. You may be interested to learn what I've found
out. It is actually possible to use code (in my case I use Visual Basic 6)
to attach the database to MSDE. Here is a link I found that leads to other
links that give more information:
http://msdn.microsoft.com/vstudio/do...eploying.aspx.
Paul Ibison mentioned in his post about a class? I'm curious about what
class that is.
Daniel
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uKEI5YGTEHA.3660@.tk2msftngp13.phx.gbl...
> Thanks fo rthis feedback. I'll hold off from this recommendation (here and
> in class) until things are sorted.
> Regards,
> Paul Ibison
>
|||Daniel,
I work for a CTEC (like several others on the MS newsgroups, inc Tibor) - www.pygmalion.com.
Regards,
Paul Ibison

register database

I have installed an application made with VB6 on a computer, and have
installed MSDE 2000. I've copied the .ldf and .mdf files in the appropriate
folder. However, the login information that is contained in the application
doesn't allow me to access the database. I was able to access the database
when I was designing the application. I used a dataenvironment. When I ran
the application on the user's computer, it asked for the password for the sa
account and also for the name of the instance of SQL Server to connect to.
I was able to give that information correctly. What is the problem? Was I
supposed to do more than copy the .ldf and .mdf files onto the hard drive.
Was I supposed to somehow register those files with SQL Server? MSDE
doesn't come with the same tools as SQL Server. Can someone help?Daniel,
Julia's TSQL is right.
Just an extra point though - if you want to do this sort of thing
graphically using SQL Server client tools - Enterprise Manager, query
analyser etc - then you could register the MSDE instance on another
Enterprise Manager on the network. If it is a stand-alone PC then you might
install Developer Edition just to get the tools ($40ish).
HTH,
Paul Ibison|||However, last time I heard, this is violating the license agreements. We hav
e had a discussion about this in
the MVP group, and hopefully MS will make these things much clearer on their
web pages (if that haven't
already been done...). :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message news:%23vf8$GvSEHA.3968@.TK2MSFTNG
P09.phx.gbl...
> Daniel,
> Julia's TSQL is right.
> Just an extra point though - if you want to do this sort of thing
> graphically using SQL Server client tools - Enterprise Manager, query
> analyser etc - then you could register the MSDE instance on another
> Enterprise Manager on the network. If it is a stand-alone PC then you migh
t
> install Developer Edition just to get the tools ($40ish).
> HTH,
> Paul Ibison
>|||Hi,
MSDE will not come up with normal tools graphical tools. Follow the below
steps to attach the database in MSDE
1. From command prompt execute
OSQL -Usa -Ppassword -S servername (Enter Key)
This will go go to a sql prompt, there execute the sp_attach_db to attach
the MDF and LDF file to sql server
1> sp_attach_db
'dbname','c:\mssql\data\dname_data.mdf','c:\mssql\data\dname_log.ldf'
(enter Key)
2>go (enter key)
This will attach the database to sql server. After this you can access the
database. Provide the directory and MDF and LDF file names appropriately.
---
Microsoft is giving a free tool named "SQL Server web data Administrator" to
manager and administrator the SQl server. This will be more useful to
MSDE users.
Download the free tool from below site.
http://www.microsoft.com/downloads/...A798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
Thanks
Hari
MCDBA
"Daniel" <dwbnews@.hotmail.com> wrote in message
news:OIsozWpSEHA.3332@.tk2msftngp13.phx.gbl...
> I have installed an application made with VB6 on a computer, and have
> installed MSDE 2000. I've copied the .ldf and .mdf files in the
appropriate
> folder. However, the login information that is contained in the
application
> doesn't allow me to access the database. I was able to access the
database
> when I was designing the application. I used a dataenvironment. When I
ran
> the application on the user's computer, it asked for the password for the
sa
> account and also for the name of the instance of SQL Server to connect to.
> I was able to give that information correctly. What is the problem? Was
I
> supposed to do more than copy the .ldf and .mdf files onto the hard drive.
> Was I supposed to somehow register those files with SQL Server? MSDE
> doesn't come with the same tools as SQL Server. Can someone help?
>|||Thanks fo rthis feedback. I'll hold off from this recommendation (here and
in class) until things are sorted.
Regards,
Paul Ibison|||I was a bit surprised to here that you can't even use your own EM to manage
your own MSDE's, but that is the
way I read one of the posts. Hopefully, MS will understand that first step i
s to document this as clearly as
possible...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message news:uKEI5YGTEHA.3660@.tk2msftngp1
3.phx.gbl...
> Thanks fo rthis feedback. I'll hold off from this recommendation (here and
> in class) until things are sorted.
> Regards,
> Paul Ibison
>|||Thank you for the comments. You may be interested to learn what I've found
out. It is actually possible to use code (in my case I use Visual Basic 6)
to attach the database to MSDE. Here is a link I found that leads to other
links that give more information:
http://msdn.microsoft.com/vstudio/d...deploying.aspx.
Paul Ibison mentioned in his post about a class? I'm curious about what
class that is.
Daniel
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uKEI5YGTEHA.3660@.tk2msftngp13.phx.gbl...
> Thanks fo rthis feedback. I'll hold off from this recommendation (here and
> in class) until things are sorted.
> Regards,
> Paul Ibison
>|||Daniel,
I work for a CTEC (like several others on the MS newsgroups, inc Tibor) - alion.com." target="_blank">www.pygm
alion.com.
Regards,
Paul Ibison