Mixed Mode Authentication Conversion-Post Setup

I need help changing the authentication mode from Windows Authentication to Mixed Mode (for Project Server 2003). I am unable to find the Enterprise Management area. Evidently in this area, I can make this change. Is this the place to make these changes, or is there a better place? I am a novice, only days into this process. I need to setup a Project Server, and it needs Sql to breathe. Please help me!!

Kristoff, what SKU of SQL Server 2005 are you using? Standard, eval, etc? You should be able to go to the start menu and launch /SQL Server Management Studio from there. Are you seeing it there?

Thanks,
Sam Lester (MSFT)

Missing Tools after Setup

In the MSDE BOOKs there is a list of utilities and there directorys that i
should have:
x:\Program Files\Microsoft SQL Server\MSSQL\Binn1
-bcp2
-console
-isql2
-sqlagent
-sqldiag
-sqlmaint
-sqlservr
-vswitch
x:\Program Files\Microsoft SQL Server\80\Tools\Binn
-bcp2
-dtsrun
-dtswiz
-isql2
-isqlw
-itwiz
-odbccmpt
-osql
-rebuildm
-sqlftwiz
x:\Program Files\Microsoft SQL Server\80\Com
-distrib3
-logread3
-replmerg3
-snapshot3
x:\Program Files\Common Files\Microsoft Shared\Service Manager
-scm
x:\Program Files\Common Files\Microsoft Shared\?
-regxmlss
That is the list that i should have, here is the list that i do have:
x:\Program Files\Microsoft SQL Server\MSSQL\Binn1
-cmdwrap.exe
-sqlagent.exe
-sqlmaint.exe
-sqlservr.exe
x:\Program Files\Microsoft SQL Server\80\Tools\Binn
-bcp.exe
-cnfgsvr.exe
-dcomscm.exe
-DTSRUN.exe
-OSQL.exe
-scm.exe
-sqladhlp.exe
-sqlmangr.exe
-SVRNETCN.exe
x:\Program Files\Microsoft SQL Server\80\Com
-DISTRIB.exe
-replmerg.exe
-snapshot.exe
x:\Program Files\Common Files\Microsoft Shared\Service Manager
NO Service Manager Directory Exists
x:\Program Files\Common Files\Microsoft Shared\?
It says that this all should have been installed on the install by default
here is how installed
i moved my command prompt to the directory containing the setup folder
(C:\MSDERela)
then i ran
setup SAPWD="??"
this installed fine
what did i do wrong?
ALso i am very new to databases
the only thing that i have ever used is access which is pretty cut and dry.
I have had a lot of trouble finding simple tutorials for a beginner if any
one knows of one please let me know.
In the mean time a couple of quick questions:
1) does a database file have to be in the directory: C:\Program
Files\Microsoft SQL Server\MSSQL\Data
in order for it to work?
2) other than osql how can i access my data? The Books say that thre is a
SQL Server Query analyzer but could not find it (see beginning of post)
thanks Again for the help
WStoreyII
Hi,
I'm not sure which MSDE book you are referring to but the tools you mention
are those that are installed with SQL Server, not with the MSDE. The MSDE
ships with limited tools. The intention is that your application will do the
work. We have some tools you could try at our site. Others are at:
http://www.microsoft.com/sql/msde/pa.../default.aspx.
The data files do not have to be in a specific folder but you will find life
much easier if you have them all in a particular folder.
If you are going to be doing development for the MSDE, I'd strongly suggest
you purchase a copy of the SQL Server Developer Edition. I gather it's
currently only around $49 USD and provides a wealth of things you'll find
useful during development.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"WStoreyII" <WStoreyII@.discussions.microsoft.com> wrote in message
news:9109A07D-4093-4473-AB0A-CFDFD9611C06@.microsoft.com...
> In the MSDE BOOKs there is a list of utilities and there directorys that i
> should have:
> x:\Program Files\Microsoft SQL Server\MSSQL\Binn1
> -bcp2
> -console
> -isql2
> -sqlagent
> -sqldiag
> -sqlmaint
> -sqlservr
> -vswitch
> x:\Program Files\Microsoft SQL Server\80\Tools\Binn
> -bcp2
> -dtsrun
> -dtswiz
> -isql2
> -isqlw
> -itwiz
> -odbccmpt
> -osql
> -rebuildm
> -sqlftwiz
> x:\Program Files\Microsoft SQL Server\80\Com
> -distrib3
> -logread3
> -replmerg3
> -snapshot3
> x:\Program Files\Common Files\Microsoft Shared\Service Manager
> -scm
> x:\Program Files\Common Files\Microsoft Shared\?
> -regxmlss
> That is the list that i should have, here is the list that i do have:
> x:\Program Files\Microsoft SQL Server\MSSQL\Binn1
> -cmdwrap.exe
> -sqlagent.exe
> -sqlmaint.exe
> -sqlservr.exe
> x:\Program Files\Microsoft SQL Server\80\Tools\Binn
> -bcp.exe
> -cnfgsvr.exe
> -dcomscm.exe
> -DTSRUN.exe
> -OSQL.exe
> -scm.exe
> -sqladhlp.exe
> -sqlmangr.exe
> -SVRNETCN.exe
> x:\Program Files\Microsoft SQL Server\80\Com
> -DISTRIB.exe
> -replmerg.exe
> -snapshot.exe
> x:\Program Files\Common Files\Microsoft Shared\Service Manager
> NO Service Manager Directory Exists
> x:\Program Files\Common Files\Microsoft Shared\?
> It says that this all should have been installed on the install by default
> here is how installed
> i moved my command prompt to the directory containing the setup folder
> (C:\MSDERela)
> then i ran
> setup SAPWD="??"
> this installed fine
> what did i do wrong?
> ALso i am very new to databases
> the only thing that i have ever used is access which is pretty cut and
> dry.
> I have had a lot of trouble finding simple tutorials for a beginner if any
> one knows of one please let me know.
> In the mean time a couple of quick questions:
> 1) does a database file have to be in the directory: C:\Program
> Files\Microsoft SQL Server\MSSQL\Data
> in order for it to work?
> 2) other than osql how can i access my data? The Books say that thre is a
> SQL Server Query analyzer but could not find it (see beginning of post)
> thanks Again for the help
> WStoreyII
>
|||Greg's correct. MSDE was not intended to ship
with the full compliment of (management) tools
as SQL Server is.
If you're want to get up and running as quick as
possible then Microsoft Access (2000 and above)
is an excellent interface to MSDE for your own
internal development purposes. Micrsoft press has
a decent book on Access Data Projects also.
If you're wanting to use MSDE to develop a
distributable application, then you'll need to
be coding everything yourself.
Good luck.

Missing table log_shipping_monitor table

We upgraded SQL Server from standard to enterprise edition. When attempting to setup a maintenance plan we got an error 208: Invalid object name: msdb.dbo.log_shipping_monitor.
The table log_shipping_monitor doesn't exist in the msdb database.
Any ideas?
what happens if you appy/re-apply the latest sp.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"John M. Snarski" <John M. Snarski@.discussions.microsoft.com> wrote in
message news:8C1CFC6B-49B9-44A9-8FDC-E5A463C6E1D7@.microsoft.com...
> We upgraded SQL Server from standard to enterprise edition. When
attempting to setup a maintenance plan we got an error 208: Invalid object
name: msdb.dbo.log_shipping_monitor.
> The table log_shipping_monitor doesn't exist in the msdb database.
> Any ideas?
|||no change
"Hilary Cotter" wrote:

> what happens if you appy/re-apply the latest sp.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "John M. Snarski" <John M. Snarski@.discussions.microsoft.com> wrote in
> message news:8C1CFC6B-49B9-44A9-8FDC-E5A463C6E1D7@.microsoft.com...
> attempting to setup a maintenance plan we got an error 208: Invalid object
> name: msdb.dbo.log_shipping_monitor.
>
>

Missing Primary Keys

HI Folks ,

I have a problem with the primary keys in my main Db , I want to setup replication and looks like someone tampered with my database by removing the primary keys.and in order to setup replication i need this table to have primary keys .THere are duplicates in that table but they are nessecary...and for this reason the primary keys do not want to "stick" when i try and specify them.Can anybody help

BurnerWithout the PK, transactional replication won't work. You could use snapshot replication if you wanted.

If your table needs to have duplicate primary keys, you have a design problem. At some point, you'll probably need to fix it.

-PatP|||Hi pat ,

I know taht it wont work. What I want to know is ; is there a way to "restore" the primary keys ?What i did now was create another table with the exact same design ..specified my primary keys..but what i want to do now is import all my data into this table including my duplicates ..is there a way to do this ...using a script or something ..cause dts will not allow duplicates to be importing because of the primary key set on the table .|||I'm confused. I think that you wnat ALTER TABLE ADD CONSTRAINT if you want to put the PK constraint back on the table.

If you are trying to clean out the table, you can use:SELECT *
FROM icky_table AS a
WHERE 1 < (SELECT Count(*)
FROM icky_table AS b
WHERE b.PK = a.PK)This will show you the duplicate rows based on the PK values. You'll have to sort out which of those rows you want to keep and which you want to discard.

-PatP

missing Enterprise Manager after installation of MSDE

My MSAccess application uses MSDE. For creating the setup, I use
InstallShield Developer 8, which installs the MSDE. Among the features for
MSDE, included in the redistributables is the Enterprise Manager.
But after executing the setup I cannot find the Enterprise Manager.
I think, I need the Enterprise Manager to connect to the Database to which
my Access application must be connected.
Or does there exist another method, to set up the connection?
Thank for help,
Rudolf
I didnt think MSDE came with Enterprise Manager at all. Including it in release files generated by InstallShield Developer presupposes that it comes with MSDE. Can someone confirm that it Enterprise Manager does come with MSDE (2000 Release A)?
Mark Ferguson
"Rudolf Hennemuth" wrote:

> My MSAccess application uses MSDE. For creating the setup, I use
> InstallShield Developer 8, which installs the MSDE. Among the features for
> MSDE, included in the redistributables is the Enterprise Manager.
> But after executing the setup I cannot find the Enterprise Manager.
> I think, I need the Enterprise Manager to connect to the Database to which
> my Access application must be connected.
> Or does there exist another method, to set up the connection?
> Thank for help,
> Rudolf
>
>
|||EM does *not* come with MSDE. You get a database without much interface.
jan
"Mark Ferguson" <MarkFerguson@.discussions.microsoft.com> wrote in message
news:C71FA1B3-2E82-4DF2-9DCB-D9278C18AA63@.microsoft.com...
> I didnt think MSDE came with Enterprise Manager at all. Including it in
release files generated by InstallShield Developer presupposes that it comes
with MSDE. Can someone confirm that it Enterprise Manager does come with
MSDE (2000 Release A)?[vbcol=seagreen]
> --
> Mark Ferguson
>
> "Rudolf Hennemuth" wrote:
for[vbcol=seagreen]
which[vbcol=seagreen]
|||hi,
"Jan Doggen" <j.doggen@.BLOCKqsa.nl> ha scritto nel messaggio
news:u%23sJmh6UEHA.2408@.tk2msftngp13.phx.gbl...
> EM does *not* come with MSDE. You get a database without much interface.
and in addition to Jan answer, including Enterprise Manager component and
related MMC snap-in dependencies in a personal deployment package violates
Microsoft EULA... at least the standard one
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
|||Hello,
There is no Entreprise manager for MSDE (even if a SQL Manager from SQL2000
can work with MSDE). It is one of the differences between SQL Server and
MSDE (no graphical tool).
You can use SQL DMO to make a lot of things (create database, restore a
backup...)
Marc Allard
Allcomp
"Rudolf Hennemuth" <Rudolf.Hennemuth@.diese-gmbh.de> a crit dans le message
de news:ufwZBX4UEHA.2816@.TK2MSFTNGP11.phx.gbl...
> My MSAccess application uses MSDE. For creating the setup, I use
> InstallShield Developer 8, which installs the MSDE. Among the features for
> MSDE, included in the redistributables is the Enterprise Manager.
> But after executing the setup I cannot find the Enterprise Manager.
> I think, I need the Enterprise Manager to connect to the Database to which
> my Access application must be connected.
> Or does there exist another method, to set up the connection?
> Thank for help,
> Rudolf
>
|||There is another way...Microsoft freely distributes a SQl Server Web Data Administrator. See:
http://www.microsoft.com/downloads/d...displaylang=en
Mark Ferguson
"Rudolf Hennemuth" wrote:

> My MSAccess application uses MSDE. For creating the setup, I use
> InstallShield Developer 8, which installs the MSDE. Among the features for
> MSDE, included in the redistributables is the Enterprise Manager.
> But after executing the setup I cannot find the Enterprise Manager.
> I think, I need the Enterprise Manager to connect to the Database to which
> my Access application must be connected.
> Or does there exist another method, to set up the connection?
> Thank for help,
> Rudolf
>
>
|||Thanks,
this was the best hint, which solve my problem.
Rudolf
"Mark Ferguson" <MarkFerguson@.discussions.microsoft.com> schrieb im
Newsbeitrag news:20B68A31-4DA9-4281-AE16-40D8DCFFF9CE@.microsoft.com...
> There is another way...Microsoft freely distributes a SQl Server Web Data
Administrator. See:
>
http://www.microsoft.com/downloads/d...displaylang=en[vbcol=seagreen]
> --
> Mark Ferguson
>
> "Rudolf Hennemuth" wrote:
for[vbcol=seagreen]
which[vbcol=seagreen]