all groups > sql server msde > september 2005 > threads for september 15 - 21, 2005
Filter by week: 1 2 3 4 5
Optimizing
Posted by JeffH at 9/21/2005 12:33:36 PM
Hi,
Are there any optimizing utilities for MSDE that can cleanup and reclaim
space?
Thanks in advance,
JeffH
... more >>
VBScript MSDE connectivity
Posted by Aarthi via SQLMonster.com at 9/21/2005 10:09:01 AM
What are the options to be given while coding in VBScript when connecting it
to MSDE?... more >>
MSDE 2000 an 64 Bit CPU?
Posted by Sven Behrend at 9/20/2005 7:56:09 AM
Does it make sense to use a 64 bit CPU with MSDE 2000? Or better: does MSDE
user it? I can´t find any hints.... more >>
Does MSDE listen on 1433 by default?
Posted by sparky62 at 9/20/2005 4:50:03 AM
Does a default installation of MSDE listen for connections on TCP/IP port
1433 by default or do I need to explicitly turn the TCP/IP listener on using
svrnetcn.exe?
(I'm using W2kR4 (v5.00.2195) and MSDE v8.000.761)... more >>
MSDE install - problem
Posted by Zabby at 9/20/2005 2:25:03 AM
hi,
i want to install MSDE (comes with windows embedded designer)
install stops with following event:
ERROR:
event 19011 source MSSQLServer
FillAddress(MSAFD Tcpip [TCP/IPv6]) : Error 0.
WARNING:
event 19011 source MSSQLServer
(SpnRegister) : Error 1355.
any suggestions?
... more >>
Help Starting MSDE and creating a db + a log in problem!!!! HELP!
Posted by Chris Allison at 9/20/2005 1:33:03 AM
Hello,
I downloaded MSDE from microsoft yesterday but I have been having alot of
problems setting it up. I started the install process with the following code
from te MSDN site:
Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD=<my
password>
The instalation was to... more >>
WMSDE Installation Failed (Error 0x80070643: Fatal error during in
Posted by jani at 9/20/2005 12:29:03 AM
Hi
I have Windows 2003 Enterprise server with SP1, and try install WSUS server.
Problem is it can't install WMSDE (SQL Server 2000 Desktop Engine)
http://www.team-novel.com/~zoner/errorlog1.txt
http://www.team-novel.com/~zoner/errorlog2.txt
http://www.team-novel.com/~zoner/errorlog3.txt ... more >>
Support for FTS - Full text search in MSDE 2000
Posted by Murli Tirumala at 9/19/2005 3:59:03 AM
Dear Sir
I am using the Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), i would
like to know if the search feature MS Search is supported.
Thanks in Advance
Murlidhar
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
MSDE BUILTIN\Administrator lock down
Posted by Sam at 9/18/2005 6:21:45 PM
After purposefully removing the builtin\administrator from sql server on my
msde (msm based) installation I get the following error:
SQLServerAgent could not be started (reason: Unable to connect to server
'SERVER\INSTANCENAME'; SQLServerAgent cannot start).
Everything goes through well wi... more >>
Backup to Network Drive
Posted by Kevin at 9/17/2005 1:05:45 PM
Am trying to backup to a network drive as the other machine has loads of
space.
Am using:-
BACKUP database TO DISK='\\myserver\backup\database.bak'
Keep getting backup device not available, when can see it via Network Places
etc.
Am using Windows 2000 Pro on both machines.
... more >>
SQL Server 7 with ADO Query Help
Posted by Evan Dobkin at 9/16/2005 1:49:21 PM
When running the following query against MS SQL Server 7.0:
SELECT
documentitems.manufacturerpartnumber,documentitems.customnumber01,documenthe
aders.customnumber01,documentit
ems.description,documentheaders.projectno FROM DocumentHeaders INNER JOIN
DocumentItems ON
DocumentHeaders.ID ... more >>
DISABLENETWORKPROTOCOLS and named instance
Posted by Graham Morris at 9/16/2005 10:58:14 AM
Is it true that I need to enable network protocols to communicate with a
named instance of MSDE SP4 locally?
Installing a named instance with DISABLENETWORKPROTOCOLS=0 seems to prevent
osql connecting to it. I don't want remote access - only local access (so
it would be nice not to load th... more >>
How do I set permissions on SQL Desktop Engine
Posted by XxLicherxX at 9/16/2005 5:59:43 AM
Hello everyone,
I hope this is the right group for this, if not let me know which one
is.
I have the Microsoft SQL Server Desktop Engine installed and I am
getting the following error:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied. (Error code: 17).
... more >>
Invalid Connection message
Posted by June Macleod at 9/16/2005 12:00:00 AM
I have a database running under MSDE 2000 to which I can connect either
through MS Access or Coldfusion. However, I wanted to run a script at the
command prompt to try and have an automatic backup.
I typed OSQL -Usa -P at the command prompt and supplied a valid password but
after a few moment... more >>
Cannot reinstall MSDE on XP after uninstall it
Posted by KC at 9/15/2005 11:44:11 AM
I have trouble reinstalling MSDE 2000 on a XP machine after uninstalled it. I
did apply SP3a to the previous install of MSDE 2000 on the same XP machine.
Some of the component in an application did not work well so I had to
uninstall the MSDE 2000 SP3a completely. I removed all folders and eve... more >>
Connecting to a default installation of MSDE on XP
Posted by mark NO[at]SPAM sherwood.org.uk at 9/15/2005 3:50:09 AM
On PC that has a default installation of MSDE and XP SP2, what ports
need to be open to allow remote connection to the MSDE?
... more >>
The Future of IIS and MSDE
Posted by phil1bruening NO[at]SPAM web.de at 9/15/2005 2:23:37 AM
Now it's possible to access data on MSDE with only one user (IIS). I
want to make a web application that gets the data from a MSDE database.
In this mode more then one users can access to the data but in reality
only one user even the IIS have access to the database. Ist this way in
the future o... more >>
Database protection
Posted by Rene at 9/15/2005 12:58:20 AM
Is there a way to prevent users from logging into an MSDE database instance?
I created an MSDE instance using a strong SA password but I was still able
to logging to the database using Windows Authentication.
The reason I don't want the user to see the database is because the database
struc... more >>
|