Another Enterprise Manager Question

I used to do all my MSDE dev in MS Acc2K. As I was converting a friend to
developing SQL Dbs rather than Access mdb one, he discovered and downloaded
from the MS Site a util called client tools which turned out to be Enterprise
Manager.
Is this no longer available for download? If so can anyone point me to it?
I'm about to try out the web based item that I've just downloaded but I'm so
used to EM I'd prefer it if possible.
Regards,
Mr. Smith
The new SQL 2005 Express has some tools like that available. For MSDE 2K,
you'd have to either use EM off a SQL 2K CD, locate a third-party app, or
use an ASP/ASP.NET version.
"Mr. Smith" <MrSmith@.discussions.microsoft.com> wrote in message
news:8AAA465B-8043-4924-A13F-728968BDB246@.microsoft.com...
> I used to do all my MSDE dev in MS Acc2K. As I was converting a friend to
> developing SQL Dbs rather than Access mdb one, he discovered and
> downloaded
> from the MS Site a util called client tools which turned out to be
> Enterprise
> Manager.
> Is this no longer available for download? If so can anyone point me to
> it?
> I'm about to try out the web based item that I've just downloaded but I'm
> so
> used to EM I'd prefer it if possible.
> Regards,
> Mr. Smith
|||Thanks for that. I had a feeling. The Web based offering from MS is
useless, Acc2K has far better tools to admin MSDE than that. I've gotten
hold of EMS MS SQL Lite which is OK in the interim but I'm gonna have to get
hold on an SQL2K disc
Regs,
Mr. Smith
"Michael C#" wrote:

> The new SQL 2005 Express has some tools like that available. For MSDE 2K,
> you'd have to either use EM off a SQL 2K CD, locate a third-party app, or
> use an ASP/ASP.NET version.
> "Mr. Smith" <MrSmith@.discussions.microsoft.com> wrote in message
> news:8AAA465B-8043-4924-A13F-728968BDB246@.microsoft.com...
>
>

Another Connection Problem

Hi all,
I am starting to work with MSDE. I have no problem connecting to the Northwind db, but every time I create a new database, I can't open it.
I have used ...
"Data Source=MyTestDb;Initial Catalog=mytable;Integrated Security=SSPI;"
the error I receive is:
Exception Details: System.Data.SqlClient.SqlException: Cannot open database requested in login 'MyTestDb'. Login fails. Login failed for user 'HOODWKOTC124874\ASPNET'.

I have also used...
what I thought was the default user id =sa; password =;

I can make a winform and drop sql objcets on the page and connect to the db that I created, just not through asp.net

FYI- I do not have Enterprise manager.

Any help would be appreciated.

ThanksOpen Enterprise manager and create a login for ASPNET and grant it perms on the MyTable db.

Hope that helps
Kashif|||I don't have enterprise manager. I am using the MSDE.|||You can use OSQL, included with MSDE. You need to have the folder that OSQL is in on your path, or be in that folder.

Using the command prompt, type the following, substituting your COMPUTERNAME and databasename:

osql -S servername\instancename -E -q
 --Line numbers will appear
EXEC sp_grantlogin 'COMPUTERNAME\ASPNET'
go
use <databasename>
go
EXEC sp_grantdbaccess 'COMPUTERNAME\ASPNET'
go
EXEC sp_addrolemember 'db_owner', 'COMPUTERNAME\ASPNET'
go

anonymous pull replication problem - Logon failure: unknown user name or bad password.

I have setup a replication sandbox with the following:
server: SQL-Server 2k
workstation: MSDE 2000 (A)
I have setup a replication database on my server and configured it for
anonymous pull subscriptions. I am running this inside my LAN.
I run the following code in an Access 2000 module:
With SQLMerge
.Publisher = "SERVER"
.PublisherAddress = "SERVER"
.PublisherSecurityMode = DB_AUTHENTICATION
.PublisherLogin = "sa"
.PublisherPassword = "nnnn"
.PublisherDatabase = "mydb"
.Publication = "publ_mydb"
.PublisherNetwork = TCPIP_SOCKETS
.Subscriber = "HOME\myapp"
.SubscriberSecurityMode = DB_AUTHENTICATION
.SubscriberLogin = "sa"
.SubscriberPassword = "nnnn"
.SubscriptionType = PULL
.SubscriptionType = ANONYMOUS
.ExchangeType = BIDIRECTIONAL
.FileTransferType = FILETRANSFERUNC
.AddSubscription CREATE_DATABASE, NONE
.Initialize
.Run
.Terminate
End With
The sub runs up to the ".run" command where the logon failure occurs.
I have cut/pasted the login information into QueryAnalyser and am able to
log into the local Server.
I have noticed that the mdf & ldf files are transfered to the workstation
and the database is visible after running this code (without system tables
only).
I have to manually remove the 'mydb' database from EM before trying again.
Is this a security issue? What steps can I take to troubleshoot this?
Thanks very much.
You have to also specify DistrutionNetwork, DistributorLogin,
DistributorPassword and Distributor
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
"astro" <astro@.bcmn.com> wrote in message
news:updsbFFGFHA.2824@.tk2msftngp13.phx.gbl...
> I have setup a replication sandbox with the following:
> server: SQL-Server 2k
> workstation: MSDE 2000 (A)
> I have setup a replication database on my server and configured it for
> anonymous pull subscriptions. I am running this inside my LAN.
> I run the following code in an Access 2000 module:
> With SQLMerge
> .Publisher = "SERVER"
> .PublisherAddress = "SERVER"
> .PublisherSecurityMode = DB_AUTHENTICATION
> .PublisherLogin = "sa"
> .PublisherPassword = "nnnn"
> .PublisherDatabase = "mydb"
> .Publication = "publ_mydb"
> .PublisherNetwork = TCPIP_SOCKETS
> .Subscriber = "HOME\myapp"
> .SubscriberSecurityMode = DB_AUTHENTICATION
> .SubscriberLogin = "sa"
> .SubscriberPassword = "nnnn"
> .SubscriptionType = PULL
> .SubscriptionType = ANONYMOUS
> .ExchangeType = BIDIRECTIONAL
> .FileTransferType = FILETRANSFERUNC
> .AddSubscription CREATE_DATABASE, NONE
> .Initialize
> .Run
> .Terminate
> End With
>
> The sub runs up to the ".run" command where the logon failure occurs.
> I have cut/pasted the login information into QueryAnalyser and am able to
> log into the local Server.
> I have noticed that the mdf & ldf files are transfered to the workstation
> and the database is visible after running this code (without system tables
> only).
> I have to manually remove the 'mydb' database from EM before trying again.
> Is this a security issue? What steps can I take to troubleshoot this?
> Thanks very much.
>
|||oops!
Thanks Hilary
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ertlFqOGFHA.936@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> You have to also specify DistrutionNetwork, DistributorLogin,
> DistributorPassword and Distributor
> --
> 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
> "astro" <astro@.bcmn.com> wrote in message
> news:updsbFFGFHA.2824@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
workstation[vbcol=seagreen]
tables[vbcol=seagreen]
again.
>

Anonymous MSDE?

Is it possible for MSDE to be installed but to have no
identifying name? I have installed MSDE on a system but I
am getting no indication of the installtion when my app
tries to access it. There is some code I have used which
basically uses SQLBrowseConnect() to determine if it is
installed. It comes back with no server in the list.
Steve
What is more likely is that network protocols are currently disabled. Run
svrnetcn.exe and check that appropriate protocols are enabled.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"steve" <steven.dahlin@.gmail.com> wrote in message
news:95b801c496e6$c7d70ae0$a301280a@.phx.gbl...
> Is it possible for MSDE to be installed but to have no
> identifying name? I have installed MSDE on a system but I
> am getting no indication of the installtion when my app
> tries to access it. There is some code I have used which
> basically uses SQLBrowseConnect() to determine if it is
> installed. It comes back with no server in the list.
> Steve
|||What would be the best way to verify that a local server is
up and running programmatically from an application?
Steve

>--Original Message--
>What is more likely is that network protocols are
currently disabled. Run
>svrnetcn.exe and check that appropriate protocols are
enabled.[vbcol=seagreen]
>HTH,
>--
>Greg Low [MVP]
>MSDE Manager SQL Tools
>www.whitebearconsulting.com
>"steve" <steven.dahlin@.gmail.com> wrote in message
>news:95b801c496e6$c7d70ae0$a301280a@.phx.gbl...
I[vbcol=seagreen]
which
>
>.
>
|||No really good way currently except via the scripting interface into the
operating system and checking for SQL Server services and then checking
their states.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
<anonymous@.discussions.microsoft.com> wrote in message
news:013901c49761$e875e980$a401280a@.phx.gbl...[vbcol=seagreen]
> What would be the best way to verify that a local server is
> up and running programmatically from an application?
> Steve
> currently disabled. Run
> enabled.
> I
> which
|||Is there any article that touches upon the details of how
to accomplish this?
Steve

>--Original Message--
>No really good way currently except via the scripting
interface into the
>operating system and checking for SQL Server services and
then checking
>their states.
>HTH,
>--
>Greg Low [MVP]
>MSDE Manager SQL Tools
>www.whitebearconsulting.com
><anonymous@.discussions.microsoft.com> wrote in message
>news:013901c49761$e875e980$a401280a@.phx.gbl...
>
>.
>
|||Hi Steve,
I wrote some courseware a few years ago that covered scripting. This is an
excerpt from some VBScript code that checks for services that should start
automatically but haven't:
Set objWMI = GetObject("winmgmts:")
Set objServices = objWMI.InstancesOf("Win32_Service")
strList = ""
For Each objService In objServices
If (objService.StartMode = "Auto")
and (objService.State = "Stopped") Then
strList = strList & objService.DisplayName & strCRLF
End If
Next
wscript.echo strlist
Modifying it for to find any sql server services that have started would be
something like:
Set objWMI = GetObject("winmgmts:")
Set objServices = objWMI.InstancesOf("Win32_Service")
strList = ""
For Each objService In objServices
if Left(objService.DisplayName,5) = "MSSQL" Then
if objService.State = "Running" Then
strlist = strlist & objservice.DisplayName & chr(13) & chr(10)
End If
End If
Next
wscript.echo strlist
If you translate that to whichever language you're using, you should be
close.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"steve" <steven.dahlin@.gmail.com> wrote in message
news:a08101c497c5$4b56d5b0$a601280a@.phx.gbl...[vbcol=seagreen]
> Is there any article that touches upon the details of how
> to accomplish this?
> Steve
> interface into the
> then checking

Andrea ... MSDE Error ! ... Contd ...

Hi,
I checked the links, you suggested me to research on this error “Unknown
token received from SQL Server”.
I am trying to insert 8-10 million rows in the table. I am using a while
loop to insert the row into a single table and not using cursor (Website
suggested to use LOCAL FAST FORWARD). The process was running smooth for 4.3
million rows inserted.
I am using a field VARBINARY(20) and the other fields are VARCHAR, TINYINT &
DATETIME if that helps.
Please advice,
David
hi David,
"David" <David@.discussions.microsoft.com> ha scritto nel messaggio
news:DBFF3C8B-81F2-4655-B645-3CD21B679B84@.microsoft.com
> Hi,
> I checked the links, you suggested me to research on this error
> “Unknown token received from SQL Server”.
> I am trying to insert 8-10 million rows in the table. I am using a
> while loop to insert the row into a single table and not using cursor
> (Website suggested to use LOCAL FAST FORWARD). The process was
> running smooth for 4.3 million rows inserted.
> I am using a field VARBINARY(20) and the other fields are VARCHAR,
> TINYINT & DATETIME if that helps.
> Please advice,
> David
perhaps break your transaction in smaller transactions every n rows you have
to insert...
say every 50,000 rows...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply