Showing posts with label couple. Show all posts
Showing posts with label couple. Show all posts

Monday, March 26, 2012

MSDE sa password - newbie

I downloaded and installed (somehow) MSDE a couple weeks ago but have not used it. Now I try to access MSDE using sa account but it does not accept an empty password and I do not remember providing one at install. MSDE appears to be installed because I se
e data files at C:\Program Files\Microsoft SQL Server\MSSQL$VSDOTNET\Data. Is there any way I can start using this install or do I need to start all over?
hi Mike,
"Mike" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:C864FCBB-655C-4D66-9DC4-9215C74A47C7@.microsoft.com...
> I downloaded and installed (somehow) MSDE a couple weeks ago but have not
used it. Now I try to
>access MSDE using sa account but it does not accept an empty password and I
do not remember
>providing one at install. MSDE appears to be installed because I see data
files at C:\Program
>Files\Microsoft SQL Server\MSSQL$VSDOTNET\Data. Is there any way I can
start using this install or
>do I need to start all over?
you probably changed the sa password...
try login in using a trusted authenticated Windows login member of the
sysadmin group
all sysadmin are granted privilege to modify password of other user...
then execute (osql, or the query tool of your choice)
EXEC sp_password @.new = 'new_password', @.loginame = 'sa'
in order to modify the forgotten sa pwd..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi,
If you have not provided a password for the SA login at installation time,
then it should be blank and it should accept it.
What I doubt is the Server name that you would be entering to connect to
the MSDE.
From the folder name that you have sent, I understand that it is a named
instance and you should use "computername\Instancename", in your case
"Computername\VSDOTNET", replace computername with the name of your
computer and try it.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

MSDE questions.

Hello, I am new to MS SQL database and have recently downloaded MSDE (Coming
in from an Oracle background). I have installed it and have a couple of
questions.

1.) Is there a product something like SQLPLUS (hopefully shipped with MSDE)
where you can log on to the database and view tables/data/views and so on?

2.) I need to set up an account with a username/password. Is there a
executable that I require to be able to perform this task?

3.) I see Enterprise manager on microsoft website, but is that shipped with
MSDE?

I know that these may sound simple, but I would appreciate your comments.

Kind regards,

Harry.Harry,

MSDE comes with Osql command line utility that you can use to interact with your
server. Unfortunately, MSDE does not come with any UI tool.

Andrea has done a great job at getting a free UI tool for you. You can get more
info at http://www.asql.biz/DbaMgr.shtm
If you're already familiar with T-SQL, you can use our free tool, QALite from
site.

--
-oj
http://www.rac4sql.net

"Harry J" <xx@.yy.com> wrote in message news:5B6Lb.20979$ts4.2084@.pd7tw3no...
> Hello, I am new to MS SQL database and have recently downloaded MSDE (Coming
> in from an Oracle background). I have installed it and have a couple of
> questions.
> 1.) Is there a product something like SQLPLUS (hopefully shipped with MSDE)
> where you can log on to the database and view tables/data/views and so on?
> 2.) I need to set up an account with a username/password. Is there a
> executable that I require to be able to perform this task?
> 3.) I see Enterprise manager on microsoft website, but is that shipped with
> MSDE?
> I know that these may sound simple, but I would appreciate your comments.
> Kind regards,
> Harry.|||Hi

You may want to check out:
http://vyaskn.tripod.com/oracle_sql...equivalents.htm
http://msdn.microsoft.com/library/d.../oracle2sql.asp

John

"Harry J" <xx@.yy.com> wrote in message news:5B6Lb.20979$ts4.2084@.pd7tw3no...
> Hello, I am new to MS SQL database and have recently downloaded MSDE
(Coming
> in from an Oracle background). I have installed it and have a couple of
> questions.
> 1.) Is there a product something like SQLPLUS (hopefully shipped with
MSDE)
> where you can log on to the database and view tables/data/views and so on?
> 2.) I need to set up an account with a username/password. Is there a
> executable that I require to be able to perform this task?
> 3.) I see Enterprise manager on microsoft website, but is that shipped
with
> MSDE?
> I know that these may sound simple, but I would appreciate your comments.
> Kind regards,
> Harry.|||Hi Harry,

I see that TOAD now comes with a freeware version for SQL Server. I
haven't tried it, but I presume you could use it to connect to MSDE.

Coming from an Oracle background you may have used TOAD before so it
could give you a leg up.

http://toadsoft.com

Peter

"Harry J" <xx@.yy.com> wrote in message news:<5B6Lb.20979$ts4.2084@.pd7tw3no>...
> Hello, I am new to MS SQL database and have recently downloaded MSDE (Coming
> in from an Oracle background). I have installed it and have a couple of
> questions.
> 1.) Is there a product something like SQLPLUS (hopefully shipped with MSDE)
> where you can log on to the database and view tables/data/views and so on?
> 2.) I need to set up an account with a username/password. Is there a
> executable that I require to be able to perform this task?
> 3.) I see Enterprise manager on microsoft website, but is that shipped with
> MSDE?
> I know that these may sound simple, but I would appreciate your comments.
> Kind regards,
> Harry.

Wednesday, March 21, 2012

MSDE on a Dedicated Webserver

Hi, our company is running a couple of java based applications on a dedicated webserver. We are interested in running the Rainbow Portal on this server as well (as a public website), but the actual owner of the server doesn't want to outlay the cash for S
QL Server at the moment. Would it be legal for us to install MSDE on this webserver to use as the database engine for the Rainbow Portal? (bearing in mind that it's a dedicated webserver, and that there would only be one instance of MSDE, and probably onl
y one database)
Sounds like it would be ok, but check the information at this link.
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
Jim
"Nicholas Smeaton" <nsmeaton@.footbag.org> wrote in message
news:89AA18C5-9A3B-47CE-914B-9DC0263196BD@.microsoft.com...
> Hi, our company is running a couple of java based applications on a
dedicated webserver. We are interested in running the Rainbow Portal on this
server as well (as a public website), but the actual owner of the server
doesn't want to outlay the cash for SQL Server at the moment. Would it be
legal for us to install MSDE on this webserver to use as the database engine
for the Rainbow Portal? (bearing in mind that it's a dedicated webserver,
and that there would only be one instance of MSDE, and probably only one
database)
|||Thanks Jim, but I'm still a bit hazy on the details. The "Appropriate Uses of MSDE FAQ" page says it's appropriate to use it as a database for a website, but the EULA says: "NO RENTAL/COMMERCIAL HOSTING". Seems a bit contradictory, and I need to be absolu
tely sure. I guess it'll be the owner of the dedicated webserver that'll be offering it to our company, but they won't be charging us to use it, and we'll be the only one's using it. It *sounds* like it should be ok, but can someone give me a definitive y
ea or nay?
|||IMHO u cant legally use MSDE in this situation
"Nicholas Smeaton" <nsmeaton@.footbag.org> wrote in message
news:89AA18C5-9A3B-47CE-914B-9DC0263196BD@.microsoft.com...
> Hi, our company is running a couple of java based applications on a
dedicated webserver. We are interested in running the Rainbow Portal on this
server as well (as a public website), but the actual owner of the server
doesn't want to outlay the cash for SQL Server at the moment. Would it be
legal for us to install MSDE on this webserver to use as the database engine
for the Rainbow Portal? (bearing in mind that it's a dedicated webserver,
and that there would only be one instance of MSDE, and probably only one
database)
|||John,
MS changed licensing for MSDE a while ago. Nowadays, it is "free". As far as I can read below URL, using MSDE
in the scenario described would be OK...
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"John Smith" <a__@.abv.bg> wrote in message news:uEW7yg0NEHA.3672@.TK2MSFTNGP11.phx.gbl...
> IMHO u cant legally use MSDE in this situation
>
> "Nicholas Smeaton" <nsmeaton@.footbag.org> wrote in message
> news:89AA18C5-9A3B-47CE-914B-9DC0263196BD@.microsoft.com...
> dedicated webserver. We are interested in running the Rainbow Portal on this
> server as well (as a public website), but the actual owner of the server
> doesn't want to outlay the cash for SQL Server at the moment. Would it be
> legal for us to install MSDE on this webserver to use as the database engine
> for the Rainbow Portal? (bearing in mind that it's a dedicated webserver,
> and that there would only be one instance of MSDE, and probably only one
> database)
>
|||but what about this: "
Q. How do I acquire rights to deploy MSDE throughout my company?
A. The following products allow you to deploy MSDE throughout your
organization:
a.. MSDN Universal, Enterprise, and Professional subscriptions
b.. SQL Server 2000 Developer, Standard, and Enterprise Editions
c.. Visual Studio .NET Architect, Developer, and Professional
Editions
d.. Visual FoxPro 7.0 or 8.0
Note: Microsoft Access only provides rights to use MSDE on the device
on which Microsoft Access is installed.
"
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:Oxouso0NEHA.3264@.tk2msftngp13.phx.gbl...
> John,
> MS changed licensing for MSDE a while ago. Nowadays, it is "free". As far
as I can read below URL, using MSDE
> in the scenario described would be OK...
> http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "John Smith" <a__@.abv.bg> wrote in message
news:uEW7yg0NEHA.3672@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
this[vbcol=seagreen]
be[vbcol=seagreen]
engine[vbcol=seagreen]
webserver,
>
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end
|||Yes, I asked MS to clarify that point, something they apparently didn't do. My assumption is that it is either
a leftover or it refers to re-distributing within your own organization...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"John Smith" <a__@.abv.bg> wrote in message news:eYfrXi%23NEHA.3348@.TK2MSFTNGP09.phx.gbl...
> but what about this: "
> Q. How do I acquire rights to deploy MSDE throughout my company?
> A. The following products allow you to deploy MSDE throughout your
> organization:
> a.. MSDN Universal, Enterprise, and Professional subscriptions
> b.. SQL Server 2000 Developer, Standard, and Enterprise Editions
> c.. Visual Studio .NET Architect, Developer, and Professional
> Editions
> d.. Visual FoxPro 7.0 or 8.0
> Note: Microsoft Access only provides rights to use MSDE on the device
> on which Microsoft Access is installed.
> "
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:Oxouso0NEHA.3264@.tk2msftngp13.phx.gbl...
> as I can read below URL, using MSDE
> news:uEW7yg0NEHA.3672@.TK2MSFTNGP11.phx.gbl...
> this
> be
> engine
> webserver,
>
>
|||if u get an answer post it here plz
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OB2Hqx%23NEHA.3012@.tk2msftngp13.phx.gbl...
> Yes, I asked MS to clarify that point, something they apparently didn't
do. My assumption is that it is either
> a leftover or it refers to re-distributing within your own organization...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
|||I asked again last week, but I didn't get a reply yet. Probably an MS representative or below is the best bet:
"To speak to someone regarding licensing:
You can call 1-800-426-9400 (select option 4), Monday through Friday, 6:00
A.M. to 6:00 P.M. (PST) to speak directly to a Microsoft licensing
specialist for licensing problem. Worldwide customers can use the Guide to
Worldwide Microsoft Licensing Sites
http://www.microsoft.com/licensing/index/worldwide.asp to find contact
information in their locations."
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Smith" <a__@.abv.bg> wrote in message news:%23aOzQ0%23NEHA.4036@.TK2MSFTNGP12.phx.gbl...
> if u get an answer post it here plz
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:OB2Hqx%23NEHA.3012@.tk2msftngp13.phx.gbl...
> do. My assumption is that it is either
>

Monday, March 19, 2012

MSDE Merge Replication (feasibility and licensing)

I am new to replication and have a couple of questions.
My requirement is to keep several (2 - 10) databases in sync. My current thinking is to use MSDE, along with merge replication. I have determined from the documentation that MSDE has the features and capabilities to fulfil the data storage and retrieval
requirments.
1) Is merge replication possible among a number of MSDE databases across a network (no SQL Server involved)
2) Do any licenses have to be purchased? The documentation is a little inconsistent on this point.
Thanks a lot.
1) yes, but MSDE is optimized for 8 concurrent workloads
2) check out this link for MSDE licensing information
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
"JW" <anonymous@.discussions.microsoft.com> wrote in message
news:F861246B-EBDA-4EEA-8CA0-6077C3F5DBCD@.microsoft.com...
> I am new to replication and have a couple of questions.
> My requirement is to keep several (2 - 10) databases in sync. My current
thinking is to use MSDE, along with merge replication. I have determined
from the documentation that MSDE has the features and capabilities to fulfil
the data storage and retrieval requirments.
> 1) Is merge replication possible among a number of MSDE databases across a
network (no SQL Server involved)
> 2) Do any licenses have to be purchased? The documentation is a little
inconsistent on this point.
> Thanks a lot.
|||I must admit that I've never tested this, but as far as I
recall MSDE is throttled at 5 connections.
Regards,
Paul Ibison
|||Thanks for the replies.
1) I think that it's the number of concurrent batches that chokes MSDE, not the number of connections.
From "The SQL Server 2000 Workload Governor" at http://msdn.microsoft.com/library/?u...asp?frame=true :
"Like all versions of SQL Server 2000, SQL Server 2000 Personal Edition and MSDE 2000 allow 32,767 connections to an instance of the database engine. There is no limit for the number of connections that can be executing operations at the same time. The on
ly effect of the workload governor is that it starts slowing down the database engine when more than eight operations are actively running at the same time."
2) Based on my research, it looks like no extra licensing is required if there is no connection to any of the 'regular' SQL Server editions:
From "HOW TO: Use Replication with SQL Server 2000 Desktop Engine (MSDE 2000)" at http://support.microsoft.com/4
"Licensing Issues
MSDE 2000 does not require any licensing when you use it in a stand-alone mode, but when you use it as part of a replication topology that involves regular SQL Server editions, if the server is in Per Seat mode as opposed to a Per Processor mode, each MSD
E 2000 Subscriber must have a client-access license (CAL).
For more information about SQL Server licensing, visit the following Microsoft Web site:
http://www.microsoft.com/sql/howtobuy/SQL2KLic.doc"
Again, thanks for your time.
Regards,
Joe
|||JW,
interesting. In the MS knowledgebase it mentions throttling after 5
concurrent connections:
MSDE 2000-Specific Limitations and Caveats
a.. MSDE 2000 limits the size of the database to 2 GB...
b.. The number of connections to MSDE 2000 is optimized for five
connections. This may affect the performance of replication if MSDE 2000 is
the Publisher and there are a enough Subscribers to the publication or if it
is a Subscriber to multiple publications.
see: http://support.microsoft.com/default...;en-us;Q324992
I have seen this 'limit' mentioned elsewhere, so the mentioning of 8 is
strange. I'll do some more research and see if we can get a definitive
answer.
Regards,
Paul Ibison

Friday, March 9, 2012

MSDE instance being broadcast

I work in a domain environment with a couple of Enterprise Edition SQL
Servers. Using SSMS, when I go to register a new installation and I 'Browse
for more' in the dialog box, I see a whole bunch of workstations that I know
are set up with MSDE.
How do I keep these machines from broadcasting their presence to the domain?
All these MSDE installs are strictly for local machine use only and none of
them should allow external connections. The fact that they are broadcasting
their presence (they don't have SQL Browser because they are only MSDE) I see
as a security risk. How can I stop this?
Any suggestions.
Thanks
Todd Chittenden
Yes, it is a security risk. It's been some time since I worked with MSDE,
but I would investigate disabling the ports and protocols--much as the
surface area configuration tool does for SQL Express 2005. This can be done
if the applications are coded to use the shared memory provider (and bypass
the network) and are not (in fact) shared on the net.
hth
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Todd C" <ToddC@.discussions.microsoft.com> wrote in message
news:E302F2D1-165D-4DDB-BCA4-9BA587CBB237@.microsoft.com...
>I work in a domain environment with a couple of Enterprise Edition SQL
> Servers. Using SSMS, when I go to register a new installation and I
> 'Browse
> for more' in the dialog box, I see a whole bunch of workstations that I
> know
> are set up with MSDE.
> How do I keep these machines from broadcasting their presence to the
> domain?
> All these MSDE installs are strictly for local machine use only and none
> of
> them should allow external connections. The fact that they are
> broadcasting
> their presence (they don't have SQL Browser because they are only MSDE) I
> see
> as a security risk. How can I stop this?
> Any suggestions.
> Thanks
> --
> Todd Chittenden
>
|||Bill:
That's all well and good, but HOW do I go about configuring an instance of
MSDE when there is no user interface installed because it came packaged as
part of some 3rd party app?
Thanks
Todd Chittenden
"William (Bill) Vaughn" wrote:

> Yes, it is a security risk. It's been some time since I worked with MSDE,
> but I would investigate disabling the ports and protocols--much as the
> surface area configuration tool does for SQL Express 2005. This can be done
> if the applications are coded to use the shared memory provider (and bypass
> the network) and are not (in fact) shared on the net.
> hth
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> ------
> "Todd C" <ToddC@.discussions.microsoft.com> wrote in message
> news:E302F2D1-165D-4DDB-BCA4-9BA587CBB237@.microsoft.com...
>
>
|||Again, it's been some time since I worked with MSDE and no, I know it does
not come with configuration tools. I expect you're going to have to visit
each system and run a reconfig script or use SQL Server Management studio
(not as easy). I found a site that seems to address some of these issues.
http://www.codeproject.com/database/ConfigureMSDE.asp#7. I hope it helps.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Todd C" <ToddC@.discussions.microsoft.com> wrote in message
news:2DF6889A-A64A-483F-BE42-766155FC8AF7@.microsoft.com...[vbcol=seagreen]
> Bill:
> That's all well and good, but HOW do I go about configuring an instance of
> MSDE when there is no user interface installed because it came packaged as
> part of some 3rd party app?
> Thanks
> --
> Todd Chittenden
> "William (Bill) Vaughn" wrote:
|||Bill:
Thanks.
Good stuff!
Todd

MSDE instance being broadcast

I work in a domain environment with a couple of Enterprise Edition SQL
Servers. Using SSMS, when I go to register a new installation and I 'Browse
for more' in the dialog box, I see a whole bunch of workstations that I know
are set up with MSDE.
How do I keep these machines from broadcasting their presence to the domain?
All these MSDE installs are strictly for local machine use only and none of
them should allow external connections. The fact that they are broadcasting
their presence (they don't have SQL Browser because they are only MSDE) I se
e
as a security risk. How can I stop this?
Any suggestions.
Thanks
--
Todd ChittendenYes, it is a security risk. It's been some time since I worked with MSDE,
but I would investigate disabling the ports and protocols--much as the
surface area configuration tool does for SQL Express 2005. This can be done
if the applications are coded to use the shared memory provider (and bypass
the network) and are not (in fact) shared on the net.
hth
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Todd C" <ToddC@.discussions.microsoft.com> wrote in message
news:E302F2D1-165D-4DDB-BCA4-9BA587CBB237@.microsoft.com...
>I work in a domain environment with a couple of Enterprise Edition SQL
> Servers. Using SSMS, when I go to register a new installation and I
> 'Browse
> for more' in the dialog box, I see a whole bunch of workstations that I
> know
> are set up with MSDE.
> How do I keep these machines from broadcasting their presence to the
> domain?
> All these MSDE installs are strictly for local machine use only and none
> of
> them should allow external connections. The fact that they are
> broadcasting
> their presence (they don't have SQL Browser because they are only MSDE) I
> see
> as a security risk. How can I stop this?
> Any suggestions.
> Thanks
> --
> Todd Chittenden
>|||Bill:
That's all well and good, but HOW do I go about configuring an instance of
MSDE when there is no user interface installed because it came packaged as
part of some 3rd party app?
Thanks
--
Todd Chittenden
"William (Bill) Vaughn" wrote:

> Yes, it is a security risk. It's been some time since I worked with MSDE,
> but I would investigate disabling the ports and protocols--much as the
> surface area configuration tool does for SQL Express 2005. This can be don
e
> if the applications are coded to use the shared memory provider (and bypas
s
> the network) and are not (in fact) shared on the net.
> hth
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> ----
---
> "Todd C" <ToddC@.discussions.microsoft.com> wrote in message
> news:E302F2D1-165D-4DDB-BCA4-9BA587CBB237@.microsoft.com...
>
>|||Again, it's been some time since I worked with MSDE and no, I know it does
not come with configuration tools. I expect you're going to have to visit
each system and run a reconfig script or use SQL Server Management studio
(not as easy). I found a site that seems to address some of these issues.
http://www.codeproject.com/database...gureMSDE.asp#7. I hope it helps.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Todd C" <ToddC@.discussions.microsoft.com> wrote in message
news:2DF6889A-A64A-483F-BE42-766155FC8AF7@.microsoft.com...[vbcol=seagreen]
> Bill:
> That's all well and good, but HOW do I go about configuring an instance of
> MSDE when there is no user interface installed because it came packaged as
> part of some 3rd party app?
> Thanks
> --
> Todd Chittenden
> "William (Bill) Vaughn" wrote:
>|||Bill:
Thanks.
Good stuff!
Todd