I am using MSDE2000 on my local machine. I have a Script generated by MS SQL Server 2000 when I try to execute it on my local machine having MSDE2000 installed on it - by using MSDE Manager by Vale - I continuously receive errors like Though I have Set 'GO' as Command Terminator in the Serve...more >>

I am new to msde for I have done all my develpment work with the Developer edition of SQL. The hosting service I am using has MSDE 2000 installed on my Windows 2000 Server. I have installed the application DBAMGR to provide a tool for working with the database. Using DBAMGR, I was able to c...more >>

I used the Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR SA PASSWORD> command to install MSDE on my windows XP professional machine. Even though the setup kicks off without a problem, towards the end it fails and says 'Setup was unable to configure the server'. It...more >>

Hej, Is there a physical limit to how many simultaneous users MSDE can have. I have read 25... and i have heard 10... what are the limits? /Richard ...more >>

Hej, I have just downloaded and installed MSDE on a computer that has XP Pro SP2. If I remove the filewall completely, (just for a test), should I be able to connect to MSDE from another machine that is running SQL Server Enterprise? /Richard ...more >>

What's the SQL or is there a stored procedure to replace the DEFAULT value of a COLUMN? Dropping and re-adding the column seems overkill to me. thanks in advance ...more >>

Hi, I don't know if this is the right newsgroup or not, but I couldn't find another even remotely appropriate. I am trying to create a new sql database using the Web Data Administrator Tool, but whenever I try to "Log in", Internet Explorer hangs. My computer does not stop reacting, I can...more >>

Please help! I have changed the name of my Win2KAS Server box and cannot find out how to get the MSDE MSSQLServer Service to start back up. MSDE was installed as part of Crystal Enterprise, so I do not have ANY source CD's to use. I cannot find a "setup.exe" file to re-run either. Any ...more >>

A PC at work was renamed recently and now our website doesn't work anymore. I think the problem is due to the Login for ASPNET. Which reads: <oldpcname>\ASPNET I'm using Web Data Administrator but I don't see anyway to rename the login or delete it. When I try to add <newpcname>\ASPNET, ...more >>

Hello, Impossible to setup MSDE release A (with sp3a) on a windows 2003 standard, with TS in application mode installed. Event ID : 11708 Setup SQL Server failed Anyone an idea ? Thanks a lot...more >>

I have installed msde 2000 but my application cannot recognize it. Does msde require that iis be installed and running on the hosting machine? Does the hosting machine have to be setup as a server or can msde just be used as a local database for a single computer application without iis. ...more >>

I am trying to backup WMSDE from Sequel Server tools and keep receiving the following error. "sequel server does not exist or access denied". I also noticed that when i log onto the server and the system tray application does not even recognize the services on the server, but sharepoint works...more >>

As part of a data center migration, I am going to be changing the name of several servers that are running MSDE. Does MSDE have the same issues with changing the name of the system it runs on as SQL Server does? thanks, Jason ...more >>

I have establlished a MSDE server. I know how to check the TCP port at the server. But, I also want to know if it is possible to check the TCP port from other workstation? Please advise. Thanks....more >>

Hi , Can anyone please give me some thoughts on how to achieve the following:- I have a SCADA system updating an SQL database using MSDE on a PC. I have an analysis tool from which I want to access the same database with also using MSDE via ADO from a second machine (here the updates won...more >>

I have a licensed copy of SQL Server 2000 and am trying to load the database from the MS Desktop Engine edition. Is this possible. I have tried simply attaching the MDF file and get the following message. Error 5105: Device activation error. The physical file name '[' may be incorrect....more >>

I have downloaded msde 2000. I have edited and saved the setup.ini file for a sa password. [Options] SAPWD="cfm56z" Setup appears to run and install msde. However when I try to access it with DbatMGR, I get SQL Server does not exist or access is denied Any suggestions would be hel...more >>

Hi Group, I've installed msde already about 20times and they all went ok, except one but that had to do with file and printer sharing. Now I'm trying to install it on win 2000 sp4 like all the others, but I can't get it to install, the pc has got file and printer sharing enabled, it has got in...more >>

I am new to msde but have worked with management tools that comes with sql server. Can someone recommend a good third party tool for manageing a msde database? Thanks, Fred Herring...more >>

hi i am trying to install a software package called arrayinformatics. this comes along with msde as part of it. when i run the setup for arrayinformatics, as admin, after sometime, the status of the installshield wizard shows that... generating script operations for action:....... and thats ...more >>

Hi, I'm a newcomer to MSDE and I need to copy data to my PC from another installation. What is the correct way of doing this ? Can I simply copy the .mdf file or do you need to detach/attach it ? Or is there some other way I havn't come across yet ? Assistance would be greatly appreciated...more >>

What are the prerequisites for Win2K and WinXP Clients to connect to a MSDE server? I have installed MDAC2.8, is there anything else they need?...more >>