;quot; SECURITYMODE=sql SAPWD="X75_37ABCDEF" /qn MSDE installs fine, no GUI. I then do the following to try to log into the instance osql -S <mymachinename>\<myinstancename> -U sa It then asks me for a password. The only password that works in my windows login password, so I'm thinking the password is not set? Or the security mode is not correct? Am I missing something from my command line? STomhi, the pwd you should provide is X75_37ABCDEF , as this is what you provided for the "sa" login you can check the authentication setting inspecting the Windows registry, HKLM\Software\Microsoft\Microsoft SQL Server\YourInstanceName\MSSQLServer LoginMode key 0 and 2 is for Mixed authentication , 1 is for WinNT
How does the MSDE and SQL Server 2005 Express calculate the database size for the 2GB and 4GB limit respectively? Are they based on database size or just the allocated part of the database size? Does it include log file size? I want to write a script to check whether a database is reaching 90% of the limit. I wonder which function or system stored procedure I should use. Thanks for any help.*Peter* z wysiłkiem wystukał(a) przypadkowy ciąg słów: IMHO they based on allocated database size. It doesn't include log file size.
Hi, I'm trying to install some apps onto one of my server 2003 boxes, on one server it all goes fine, on the other however the msde installations all give up and rollback I just get errors in the event logs that state that the installation failed. Any ideas? It won't even let me install the vanilla MSDE 2000 rel A on with the default options. The only installed version of sql/msde appears to be the default Active Directory stuff. Help! Jonathanhi Jonathan, please add the /L*v "c:\MsdeLog.txt" parameter to your call to the setup.exe boostrap installer of MSDE this will enable verbose logging of the installation process, resulting in an about 2mb text file (for a succesfull installation) you can inspect for RETURN VALUE 3 entries, indicating problems.. about
Can we have MSDE and SQL server on the same machine?hi, yes, up to 16 different instances of SQL Server 2000 and/or MSDE 2000 can be installed on the same pc, at different service pack levels Thanks. I have WSUS installed on with MSDE. I want to install MOM with standalone SQL . So we can install both in different directories. correct? shalinihi Shalini, yep they not only will install on different folders, but they'll have different name as well as one of them (or both) will be a named instance http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_9i5u.asp
MSDE and numerous ways of entering passwords. Could osmeone please just give me a setp by step account of installing MSDE (with all relevant switches and passwords), getting a SQL instance on MSDE running and visible on the manager, upsizing the access database (with all relevant passwords - what the hell is a trusted connection?), and then be able to create a view from the Server Explorer in .NET. I've been slaving over this for the past two days and be installed in Mixed Mode, where the instance supports both Windows Authentication and SQL Authentication logins. DATADIR="data_folder_path" Specifies the folder where Setup installs the system databases, error logs, and installation scripts. The value specified for data_folder_path must end with a
the docs, using the wizard in VS.NET it looks like I was successful in creating an output folder with a "distribution" for MSDE and my application setup. In the directory that contains MSDEBootstrap.exe, I clicked on setup.exe and invoked the Bootstrap dialog. It properly showed the Prerequisite link lit up and my app link greyed out. I am using Windows XP Pro SP1 Problem: If I click on the Prerequisites link in the bootstrap dialog, the dialog immediately mimizes towards the task bar and disappears with no icon showing in the taskbar. Nothing happens after that. The task manager shows the MSDEBootstrap.exe process running and it will continue to run until I kill it. No log files are created anywhere. I am clueless as to how to debug this. Any suggestions
key(s) can I look at to 1) positively identify an install as MSDE and then 2) postively determine the version as 2000 or 2005. I am unable to find any authoritative info on this via books online or Google. Can anyone point me to a document or provide some insight? Pete Zerger, MCSE(Messaging), MVP - MOM URL:http://www.momresources.org BLOG: http://www.it-jedi.net/hi Pete, you can have a look at HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion (for default instance) HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer\CurrentVersion (for named instance) CurrentVersion key this reports 8.00.194 for my SQL Server 2000/MSDE sp4 instances and 9.00.2047.00 for my SQL Server 2005/SQLExpress instances but you can not check this way the edition of a
arrange comments to them. RoccoHi, You can not attach a Access database to SQL Server MSDE. This is due to changes in architecture.Methods to transfer:- 1. SQL Server DTS to copy structure and data 2. Upsizing wizard ( http://www.mssqlcity.com/FAQ/General/MigFromAcc.htm ) Hari SQL Server MVPOK. ANy tutorial for the DTS? I have opened and since anything is labelled in that sort of *MicrosoftCreeepingLanguage* I'm not able to use it. Maybe is not the MicrosoftCreeping thing, but only that I'm not to good at that!Hi, This migration is very simple. Just open the Export and Import utility wizard from SQL Server program group. Select the source as Access and destination as SQL Server MSDE and select dbname. Now select the tables you need to copy. CLick next. This
, I read that the SQL 2005 Management Tools from the Trial version can be used to manage the MSDE. So I installed MSDE and the SQL 2005 management tools on my test server and it seems to work fine. But my question is if the "Microsoft SQL Server Management Studio" will stop running after 180 days or if this only belongs to the SQL 2005 Server itself? Somewhere I read that the tools should still work but I would like to know if this is really confirmed/official? I wouldn't like to get a big surprise after 180 days ;-) /Rayhi Ray, as SQL Server 2000 tools, I do not think SQL Server 2005 tools will expire, but you are not legally allowed to use them against MSDE\SQLExpress instances, and if you do, you are breaking the relative EULA.. for SQLExpress you have to rely on the
a tight loop waiting until then. My assumption thus far is the .NET framework on startup of our application is using up a licence for the MSDE and this is happening because of the licencing CALS on the Server it's installed on. The previous incarnation of our app using MSDE2000 didn't use .NET and we never encountered this issue on 4000 sites. Reason for believing it's .NET is because if you start windows and our application on all workstations (.NET framework is loaded into windows), then close our application on all workstations (.NET remains loaded in windows) and restart the SQL Instance on the server, you can run our app on all the workstations without this crippeling problem until you restart the workstation computers. Admittedly, there is some slowdown due to
installation * If found check if it was done from our software * If not, install a new instance using Microsoft setup * Make sure to use the correct MSI file during install * Make sure to set all install parameters correct * Start the MSDE after install * Connect to MSDE and install database * Make sure it works on all NT platforms (big problems on NT4) * etc etc etc We have probably spent one man-moth on this task alone Bo </quote> http://fox.wikis.com/wc.dll?Wiki~InnoSetupScriptMSDE~VFP Carl KSo, do you have a workable solution for installing an app and MSDE or not? TIA, Paul this? it. IPersonally, no. If the Inno guys say it will fly, I have no reason to doubt them. They aren't trying to sell me something - the beauty of open source software. Carl K
statement). Tables export quickly too. Furthermore, if you copy the select statement (including the joins, the where and order by clauses) and paste it into the query section of the SQL Server Import and Export Wizard, the export processes in under 20 seconds!! Finally, if you copy the database to another SQL Server 2008 SP1 server and run the same combination of tests, the results are the same. All of this suggests to me that the problem lies with SQL Server Import and Export Wizard (in SQL Server 2008) - in the way that it is parsing this particular view when left to it's own devices. Microsoft, can you please explain why the SQL Server Import and Export Wizard in SQL Server 2008 is behaving this way?? Do you have any suggestions as to how I can overcome this problem
in being able set up a user(s) to work with the software without having administrative privileges on the computer. Thank you, Mack HarrisYour MSDE instance is probably setup with Windows authentication and no logins other than the default ones. SQL Server is running it is just that other users besides those in the Administrators group cannot connect to the server. If you want to keep using only Windows authentication you will need to add logins to the server instance for the users or a group that the users are a member of and allow them access to your applications database. You could also switch the instance to use mixed mode authentication and setup some SQL logins for the users.I beleive the instance was installed in mixed mode because SECURITYMODE=SQL is in the setup.ini used
I been trying to read the posts to answer this, but I don't see a straightforward answer. Can MSDE and SQL Express '05 co-exist on the same machine? Wayne P.Yes, because you can both install them as an instance. However, because SQL Express 2005 is only in Beta at the moment, it is not advisable to do this on a production machine, only on a test machine.
for ServerName\Aspnet. If I specify "user=sa;password=*******" in the connection string everything works fine. What am I doing wrong? Funny thing is, when I use the Server Explorer window in Visual Studio, I have a data connection to the database, and checking the properties, it uses the "integrated security=SSPI" syntax.Hi Mike, The "issue" is "who" the web app is running "as". By default, your web apps run as the user domainormachinename\aspnet. This is configured in your maching.config file. If you want to use windows authentication, you'll need to either: 1. Give appropriate permissions to the aspnet user. or 2. Enable impersonation in your web.config file for the application. HTH,Greg, I
Driver][TCP/IP Sockets]ConnectionOpen (Connect) SQL State 8001 SQL Server Error 6 [Microsoft][ODBC SQL Server Driver]The Server could not be found This is what I already tried: - using Named Pipes - using windows authentification - Setting the servers port in the registry (tried port settings 1433, 1000 and 0 which means to randomly set it up) - checked if the db service is running Using NamedPipes, I get a different error number (I think it was 10001 instead of 11001) but the result is the same. It must be some kind of windows user rights problem. So what permissions do I need to connect to the MSDE? Oh, and I'm using WinXP SP2. The Domain is managed by Active Directory. I'd appreciate your hints on this and sorry for any errors in the text - I'm no native speaker
SqlServer in same computer? That doesn't cause any problems?Hi Carlos, you can have up to 16 different instances of SQL Server(in all different versions, and depending from the OS)/MSDE on the same box.. you can only have 1 default instance, known as (Local), LocalHost, "." or ComputerName and all the other have to be named instance, known as (local)\InstanceName , ComputerName\InstanceName, . this will not cause problem as each instance will have it's own separate memory but, more important, it's separate binaries.. if you install them in the default path, \Program Files\ , you'll end up with a hierachy like ..\Program Files\MSSQL ' default instance ..\Program Files\MSSQL$InstanceName 'for InstanceName named instance
I have SQL 2000 with an active database running on a W2K3 server. I have another application I want to install on it since the box is under utilized. The new app wants to install MSDE for its database engine. Is this OK? Can MSDE and SQL 2000 run on the same box? I don't - actually can't take a chance on the install screwing up the running db. TIAYes, they are designed to work side-by-side in separate instances.
, so that I can test my app against both SQL Server and MSDE. Question. Given that the machine is fully licensed for SQL Server, is the MSDE instance actually an MSDE instance (that is constrained by the limitations of MSDE), or is this actually just another SQL Server instance named MSDE? (Frankly, in Enterprise Manager, except for the name of the instance, I'm hard pressed to see any difference between the default SQL Server instance and the MSDE instance.) Thanks for your advice. - Joe Geretz -The SQL Server license is just that, a license. It doesn't provide additional functionality to MSDE. MSDE will still have the same 2GB size limitations etc. However, if you detach a db from MSDE and attach it to the SQL Server Instance (on the same box) you'll not have
I'm using Msde on a PC with XP SP2 acting as "server" and accessing a database on a PC with XP SP2 acting as "client". I can backup my database from the "client" using UNC format "\\client.computer.name\share.name\file.name.bkp" but when trying to restore it from the "client" PC i get errors. Any ideas about how to restore the bkp file to server pc from the client without having to copy the bkp file to thehi, what kind of exception do you get? actually if you can backup on a remote share you should be able to restore from it too.. the account(s) running the SQL Server and SQL Server Agent must have enought privileges on the remote share
39;t heard back since - that was months ago. Kevinhi Kevin, mean, is running a database server on the same machine of a web server always hits some penalty . the Workload Query Governor will hit when more then 8 concurrent batches are run on the very same time, slowing down all active workloads, reverting to normal behaviour when the concurrent batches gets again under 8 batches, but this is not regarding memory usage SQL Server/MSDE is very hungry, regarding memory memory usage is database and application dependent, but usage and workloads dependent too as you know, in few words, SQL Server organize it's memory allocation in two distinct regions, the "buffer pool" (BPool) and the "memory to leave" (MemToLeave) regions. (I'm
. If I stop one of them, the other one still runs. Is this behavior normal? Could I uninstall MSDE and move my databases into MSSQLExpress so I have only one engine running? And if the answer is Yes, how should I do it? And finaly, MSDEManager lets me browse the databases in MSDE but not the ones in MSSQLExpress, how can I create and manage these databases? I hope I have'nt asked too much!! Xavierhi Xavier, yes, SQL Server 2005, and thus SQLExpress, dropped the SQL Server Service Manager, and now you have to rely on the new SQL Server Surface Area Configuration tool (http://msdn2.microsoft.com/en-us/library/ms173748.aspx) and SQL Server Configuration Manager (http://msdn2.microsoft.com/en-us/library(d=robot)/ms188707.aspx) to manage service(s), accounts, some kind
Hi, I have installed 2 Instances of SQL Server 2000 and a MSDE Instance on a Server (only for testing). I have connect the Query Analyzer and the Enterpise Manager with the 3 Instances (always on the server). Then i wanted to connect a client ( the Query Analyzer and the Enterpise Manager of this client) with the Instances. With the instances of SQLServer 2000 it goes but not with the MSDE. Why does it not go withhi, MSDE installs by default disabling network protocols for security reasons you can modify this behaviour both at install time, providing the DISABLENETWORKPROTOCOLS=0 parameter to the setup.exe boostrap installer of MSDE, or later, at "run-time", running the Server Network Utility (svrnetcn.exe) and enabling the required/desired network protocol..Thanks
Hello my DEd win 2003 server, uses MSDE all is ok, the server run, and can create from script Db but if i want login or create connection MSDE say wrong pass i never change the pass or other i have the server complet reinstalled from hoster image what i doing wrong ?hi, assuming you are trying to connect using the standard SQL Server authentication with the "sa" login and you can't remember it's pasword, you can login using integrated security (the Windows authentication) using a local admin member and set the "sa" password to whatever you want via the system stored procedure sp_password, http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_pa-pz_5x44.asp, in the form EXEC sp_password @new = '
Hello All I want to import a XML data stream into MSDE and similarly export a MSDE table into XML output. Can somebody kindly explain how I can do this. Karenhi Karen, I think you can find some usefull information at http://sqlxml.org/default.aspx
Hi! We're having troubles on a Windows 2003 Server. MSDE 1.0 does not install (even though we already have this setup at other customers). So I downloaded MSDE 2000. Unfortunately, somebody else just executed the installation procedure without setup-parameters. I wanted to have an empty password (I know, I know. But it is a closed system) and I need SQL security mode and network protocols. Thus I uninstalled MSDE 2000 again and launched setup.exe this way: setup DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL BLANKSAPWD=1 The installation went fine and I did *no* receive the error about the trusted connections. However, I received "Authentication for user sa failed" when simply doing this osql -Usa -P -dmaster Any clues? StefanThe only thing that I can
How can i purchase this MSDE, and where should i go, Where can i purchase MSDE bakup/restore alone.MSDE is free. u have to use command line utilities for the backup / restore, but thats free too. You can buy third party utilities to simplify your task but is not mandatory. Hope that helps.
answer. I have a web app that is developed to include SQL Server 2000, and one of the functionalities is to send automatic notifications when 'things' go out of date. This is done by a job on the SQL Server that runs once a day that uses SQL Mail to send out notifications. Now, one customer wants to use MSDE and I got everything working except the email thingy, since MSDE doesn't include SQL Mail. So, my question is: Can MSDE send emails at all? Simple Yes or No would be great, so I can start looking for alternatives for my Customer (if 'No'). Thanks in advance, Arnar.Thank you for your reply Andrea, I'll look at that XPSMTP if I can't convince my customer to move to SQL Server. Oh, and the link to www.asql.biz in your signeture seems to be
.asp says the following: Q. Can I use SQL Server tools and services in conjunction with MSDE? A. You can only use SQL Server tools and services in conjunction with MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition, Standard Edition, or Enterprise Edition), and if you are using MSDE in conjunction with a properly licensed copy of SQL Server 2000. Visit the How to Buy page for information on obtaining a valid SQL Server license. Note: The tools and services included with SQL Server Developer Edition may not be used to manage production server environments. The following utilities are installed by the MSDE setup application and are provided without restrictions for use with the copy of MSDE that is installed by your application: bcp.exe
greetings I need to develop an .NET CF application for pocket pc that uses sql server ce to store data. What are the scenarios that SQL Server 2000 and SQL Server CE are free to use and distribute to customers along with applications? What are the restrictions? Where can I find information about licences of this SQL Servers, and distribuitions packages, etc? LumLum, Please see my reply to you on the compactframework newsgroup.
with Visual Studio? I noticed that I could have downloaded a different version of SQL Server. Thanks.-Spencer [email protected]
downloads page. I one of the other pubs database them. Is this must have "full wizards database but you relevant SQLConnection pubs's table and trust" server, you would VS related the server too http://italy.mvps.org MSDE 2000 a visualhi Spencer, MSDE is compatible with VS and you could only have downloaded MSDE and not the full blown SQL Server, as it is available for download only as evaluation MSDE comes in 2 flavours, the MSDE Web Release A you can obtain at http://www.microsoft.com/sql/msde/downloads/download.asp , or http://www.microsoft.com/sql/downloads/2000/sp3.asp but they are technically
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 help would be appreciated. Thanks in advance Hi What does the NT Event log say? It is a login failure, a Crystal failure etc? Mike
Hi, is there a way to change MSDE from Win NT authentication only to Mixed mode authentication without reinstalling and without Enterprice Manager?
I get an error message telling me that "RESTORE DATABASE must be used in single user mode when trying to restore the master database" . I also get a similar message when trying to create and restore a database called 'public'. how do I successfully get into 'single user mode' ?hi, have a look at http://msdn2.microsoft.com/en-us/library/ms180965.aspx .. typically you open a command window, navigate to the \Binn folder of the instance you want to start and execute something like C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\>sqlservr.exe -s InstanceName -m this will start the instance in single user modo, so that you'll be able to restore the master database to restore "normal user's" database(s
JOIN ([tbMenus] INNER JOIN [tbKeymap] ON [tbMenus].[MenuIndex] = [tbKeymap].[MenuIndex]) ON [tbItems].[ItemIndex] = [tbKeymap].[ItemIndex] This query does not work in MSDE 2000. I get the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '.'. I have no idea why this is the case since the MDAC is 2.7 (I'm assuming since this is MSDE 2000). Any ideas or solutions would be appreciated. AliSQL Server (MSDE) and Access use different dialect of SQL language. keyword DISTINCTROW does not exist in SQL Server's T-SQL: it is DISTINCT in SQL Server, while in Access, you have DISTINCTROW and DISTINCT, they do things slightly differentThanks Norman that fixed it. It seems that I will have to compensate for this issue. Ali
Hi, I'm running MSDE right now and I want to move to SQL Server Express 2005 eventually. But in the meantime, can I run both side by side on the same machine? Sung HonYes, you can have an instance of MSDE and of Express 2005 on the same system.