Hi Jason, Hi all, I have been having an error installing MSDE and discovered a thread in this newsgroup, which appears to handle the same error. Specifically, the post http://tinyurl.com/2vtzv by Jason Howell seemed relevant. Interestingly, setting BLANKSAPWD=1 did get the installation to...more >>

I'm MSDE 2000a on Win XP (sp1) with the following in setup.ini: [Options] SAPWD=sa SECURITYMODE=SQL The install runs just fine. At the end of the install, I'm able to launch the MSSQLSERVER service without a problem. The problem is that after I reboot, it appears that MSIExec starts a ...more >>

Having a problem understanding datetime field query. When I do the following, I don't get the correct data. What am I doing wrong? this gives me everything in the table regardless of the query expression.. SELECT MyField FROM MyTable WHERE MyDateTimeField >= '6/1/2004' AND MyDateTimeField <...more >>

Are there any known issues with installing MSDE 2000 on a computer that already has Access 2000 installed? ...more >>

Hi, I cant get my parameterized insert to work. I've created a large table in VB.NET and since I want to insert a lot of rows into it I thought parameterized insert would be a good solution. ..CommandText = "INSERT INTO TmpTable (C1,C2) VALUES (?, ?)" ..Parameters.Add("C1", SqlDbType....more >>

Is anyone aware if we are allowed to purchase the Enterprise Manager that comes with the developer kit and then use it as a graphical management tool for the MSDE version of SQL? Microsoft list that MSDE does not come with a graphical management tool, I don't want to break licenses. http:/...more >>

Is anyone aware of any functionally exceptions of the MSDE version of SQL, other than Microsoft's listed ones, I have read in user forums that there are also perfomance knobbling. http://www.microsoft.com/sql/evaluation/overview/default.as p We have the choice of buying a multi-user data...more >>

I (actually one of our clients) is receiving an InstallSQLAgentSecurity failed error in the msde install log. ************************************* Starting custom action InstallSQLAgentSecurity InstallSQLAgentSecurity failed (LORIH,LocalSystem,87). Action ended 14:11:24: InstallFinalize. Ret...more >>

SQL Server 2005 Express Technical Preview http://www.microsoft.com/downloads/details.aspx?familyid=2ccf2ab6-bfd9-4ac8-b31d-ddbad7d532a2 Download: http://download.microsoft.com/download/c/f/8/cf872b5a-509b-44ce-b5ac-e693f7aec971/SQLEXPR.EXE Web: http://msdn.microsoft.com/sql/ex...more >>

Hi All, This is my 2nd posing. I need this very urgently. I have been trying to install MSDE silently. I know, I have to use setupsql.exe with command line parameter -s to attain the unattended installation. But unfortunately, after I extract the self extracting files for MSDE (MSDE2000A...more >>

Hi All, If we change the System settings to Swedish(Finland), the decimal space is a Comma "," instead of a Dot "." Now the problem is SQL Server does not recognize this and gives error. We can not do collation setting for numeric fields also. Any help on the same will be highly appreciated...more >>

I am install the msde in a pc with xp professional with this command: setup INSTANCENAME="InstanceName" SAPWD="AStrongSAPwd" DISABLENETWORKPROTOCOLS=0 from the dos prompt. But it's not install and show me a message: For install and setup the system components use the control panel. Please, ...more >>

Trying to figure out when clients need to purchase a full SQL Svr license. How is the number of concurrent users/transactions determined? SQL stmts are quickly executed so how long is a MSDE user deemed current? Same as IIS server?...more >>

I am just starting with MSDE switching from access2002. The installation was done on a server pc with: password="sa", Authentication Mode = SQL, and DisableNetworkProtocols=0 On the server, I can connect to it fine, both via my app and the configure wiz'd in the SYSTEM-DSNs list (off of cont...more >>

I like to thanks all of you helps. but I still can't find information I need among sysprotects, sp_helpprotect, INFORMATION_SCHEMA.table_priviledges, and INFORMATION_SCHEMA.column_priviledges. What I need to know is if a user don't have certain priviledge, was it been revoked or denied...more >>

Thanks Hari, That helps a lot. Do I have a way to know previlage details about an Object? such as is the SELECT on a table been Granted, revoked or denied? Greg Chang Subject: Re: Questions about syspermissions From: "Hari" <hari_prasad_k@hotmail.com> Sent: 6/24/2004 9:29:17 PM...more >>

In trying to get around the current Jet hang problem people are seeing under Windows 2003 and the jet oledb provider, we have ended up having to convert many existing MS Access web site projects to MSDE. The clients don't have the budgets to license full sql server, and don't need the full per...more >>

Hi I'm working in visual C++ and through it I start MSDE setup.exe. I have to wait in my VC++ code before the MSDE installer is finished totally. The problem i'm having is that as soon as I initiate the process of MSDE setup.exe, i get its finished status in my VC waiting code, though the insta...more >>

I'm getting ready to start the setup project for my product. I've read through some messageboards and I'm getting the impression that there are problems with the current version of this toolkit. I'd appreciate any advice about using it or any "gotcha's" that I should be aware of. Also, any info ...more >>

How I can copy a database from MSDE to another computer with MSDE? Thanks Damiano ...more >>

Hi, I have the following problem : when I launch a query in the query analyzer I have my results within 3 seconds, and when I monitor the MSDE through the Profiler I see that he does some 8000 reads to get his results. When I launch the same query in a Delphi application using ADO (it's even ...more >>

I'm executing the following block of SQLDMO code : if (this.sqlServer.Status == SQLDMO.SQLDMO_SVCSTATUS_TYPE.SQLDMOSvc_Running) { this.sqlServer.LoginSecure = true; this.sqlServer.Connect(this.strDatabaseName, optional, optional); this.sqlServer.AutoStart = true; this.sqlSer...more >>

Mary, Further to your reply... I assume you mean that using MS Access isn't good for designing the tables in the database. But what about for creating the GUI and programmatic aspects of the database? What other tools would you recommend? Something at a minimal cost would be appreciated, sicn...more >>

I've installed MSDE w/no problem - but what username & password do I use (well, I know what password since I specified it in the *.ini file before install) - but username? Cassinni or IIS web server - I can't log on and do anything w/MSDE. Do I have to edit something w/a username, make one up, u...more >>

I can't log in with osql. My setup config file is as below. [Options] INSTANCENAME=NetSDK SECURITYMODE=SQL SAPWD=mypassword It seems to install and run (green arrow in service bar after giving it myservername\NetSDK). Then I try this: osql -U sa Password: 'I give mypassword here [Sha...more >>

I'm developing a C# application that runs against MSDE. How can I programatically check whether MSDE is running and, if not, start it up and set it to "auto-start"? Thanks in advance!...more >>

Hi All, I have been trying to install MSDE silently. I know, I have to use setupsql.ex with command line parameter -s to attain the unattended installation. But unfortunately, after I extract the self extracting files for MSDE (MSDE2000A.exe or sql2kdesksp3.exe) from Microsoft site, I don'...more >>

is it possible to add new columns to an existing MSDE table using Access? If not what is the best practices modify a table schema without loosing data? Thanks for any suggestions....more >>

I used to have an icon on then notification area of the taskbar which I could use to start and stop MSDE. It has recently disappeard and I don't have a clue how to restore it to the taskbar. Can anyone give me a hint what this little utility is and how to make it appear on the taskbar. ...more >>

I have installed MSDEa on a remote Windows 2003 Web Edition server according to the following: setup.exe SAPWD=******* DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL I connect to this server using remote desktop and I can use osql to login. I cannot get to it using Query Analyzer or osql from my...more >>

is syspermissions table contains the Permissions of delete, select, insert, update, execute and DRI on all the objects? how do I use this syspermissions table? For example, which column stored the INSERT Privileges? thanks Greg Chang...more >>

Hello, We get these events logged every night, apparently when the SQLAGENT tries to do it's backup. I'm afraid I didn't configure MSDE on this particular server, and I don't have any Enterprise Mgr functions on the desktop, so I'm slightly at a loss as to how to go about resolving thi...more >>

I use an application that stores all its information in an msde database and i would like to replicate the details in the live system to a backup system. Any idea which files i need to copy?...more >>

I am attempting to create a View from MS Access 2000 SR-1 to an MSDE 2000 (SQL Server 2000 Desktop Engine) database . I accessed with exclusive rights but I get the following error when trying to create a view: "You do not have exclusive access to the database at this time. Your design changes...more >>

Dear all, I would like to know how can I restore the MSSQL database? I copied the abc.mdf and abc.ldf files from another computer. I want to know how can I restore the data in my computer just using these 2 files. Thank you for all of your help. Alex ...more >>

I installed MSDE on a Window 2000 machine while logged on as Administrator. When I logoff the Admin acct and log on as another user, the SQL Server Service Manager can't find the SQL server. The service manager icon is blank. But if I type in the name of the instance in the service mgr it...more >>

Thanks Andrea Montanari, are there a way to query the Password for each users? Greg Chang -----Original Message----- From: "Andrea Montanari" <andrea.sqlDMO@virgilio.it> Sent: 6/14/2004 12:28:20 PM Subject: Re: User Accounts hi Greg, "Greg Chang" <anonymous@discussions.microsoft....more >>

How can we replicate data in one MSDE to the other MSDE without having to pay for MSSQL2000 full version to use the sql enterprise manager? It seems that Enterprise Manager or SQL-DMO based programs rely on system-provided stored procedures to do replication. So why not run sp thru osql? I...more >>

Hello, I have SQLServer 2000 installed on a PC and I want to install MSDE as well. The attempted MSDE installation immediately fails with the message: "The instance name specified is invalid" I looked at the autorun.inf file and I see that there is no name specified for the new MSDE ...more >>

Hello to all of you, I have a question relating to large objects. It is possible to store large objects in the Sql Server 2000 Desktop Engine when using this database system as a local store on a pc. Thank you in advance for your answer...more >>

Error message during install: Instance is invalid. Just installed SP3a sql2kdesksp3.exe...more >>

Need some help. Install says my instance is invalid. What does this mean? I also installed sql2kdesksp3.exe...more >>

I need to the best way to make a copy(Backup/export) of the data base put in on a CD or e-mail it. Have instructions to import or restore the database onto another PC. Also in the C:\Program Files\Microsoft SQL Server\80\Tools\Binn> What and how does dtsrun.exe work? Thanks...more >>

I need to the best way to make a copy(Backup/export) of the data base put in on a CD or e-mail it. Have instructions to import or restore the database onto another PC. Also in the C:\Program Files\Microsoft SQL Server\80\Tools\Binn> What and how does dtsrun.exe work? Thanks...more >>

I have a problem when I connect MSDE located in another domain. I have one MSDE and one SQL Server in DomainA, My PC is located in DaminB. The error message is "SQL Server does not exist or access denied. ConnectionOpen(Connect())" was prompted when I try to use my Enterprise Manager to connec...more >>

Can I connect the DB from another domain?? If so, is there any parameter changing in order to connect it? Million Thanks ...more >>

from the command window, i run the installation by switch to the setup dir and type setup sapwd="SYSDBA" the setup begin to execute the configure process. but when the process proceed to about 80% percent, an error occurs : 'configuration failure. please refer to the server log for de...more >>

I have installed an MSDE instance on my PC. I have used both the setup.exe program and installed MSDE with the merge modules. Everything works fine - I am able to programmatically connect to the database and execute all of my statements. However, when I try to register the database with Enterprise M...more >>

Hello: I'm running the following command to install the Northwind database: "osql -S home-j68asj7mhu\VSDOTNET -i instnwnd.sql -U sa -P sapwd" I'm getting the following error: "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection." I can see SQL Server in...more >>

Hi all I am experiencing a problem comming to grip[s with MSDE and what it does. I need to develop an SQL Server Database but i only have a Windos XP OS and not a server type system. From what i understand i should be able to use msde as the engine and utilsie the tools that i can instal...more >>