I have spent megabucks buying a book called MSDE Bible and they have started the book by not telling how you create a database (with all the exact steps required so you can actually work with it. I find this highly unprofessional, and wonder if the authors David C Walls and Denise M Gosnell actually know anything about teaching. (One enormally teaches step 1 before step 2 where I come from - obviously not in some places). Anyway, later on in the book there is an example on creating a database.
My problem is that it does not work because I do not understand what is required in terms of security clearance / user names / passwords / user authority. (They also assume you know all about that too).
All I have done is installed MSDE 2000 Rel A and am now trying to use it. The only question I was asked during the install was to define a "Strong Password" and thats all.
I am now attempting to
1) Create a Database
2) Create a table with some fields
3) See if I can access the database
Now is that too much to ask ?
Here is the code that supposedly creates the database:
The problem is in the connect - something to do with security of some sort that is completely overlooked.
dim oMSDEserver
dim oDatabase
dim oDataFile
dim oLogFile
set oMSDEserver = CreateObject("SQLDMO.SQLServer")
set oDatabase = CreateObject("SQLDMO.Database")
set oDataFile = CreateObject("SQLDMO.DBFile")
set oLogFile = CreateObject("SQLDMO.LogFile")
After installing WebMatrix on my computer, I installed Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) in my computer, but I can't see MSDE on my Start menu. I am really new to this and don't know how to open MSDE, so I could work with it. Nothing displayed after I installed MSDE, such as the typical "Installation is complete."
Sorry for such a silly question, but please help me. How can I open MSDE from the Start menu. I have windows XP Home.
While installing the MSDE I get the folowing error: A storng SA password is required forsecurity reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit.
Hi, I have installed the MSDE and use mixed mode authenticaton. The SQL Server Agent will not start due to login failures. Normally, I would use the Enterprise Manager Managment wizard to correct the System Account and Connection Credentials.
Can anyone tell me how to achieve this using OSQL?
Hi, I am a VB programmer and we have a VB application that uses Access as its db (~500MB mdb file) using DAO. We want to upgrade to MSDE/Sql Server because we have clients that will use around 5 connections to the db and others with no more then 20 users. I was asked to build a simple test program in Vb under MSDE that will enable us to test few clients working simultaneously (I have few days for that). There is so much material on MSDE and we just ordered an MSDE Developer guide book from the Amazon that will arrive in a few days. The amount of material is confusing like hell and I didn't work with ADO before, I don't even know if to work with Access 2000 or with a different db, can you advice ? Do you know of a good sample that show a beginner like me how to access MSDE from VB using ADO? If you do please please advice it will ease the pressure and the days are numbered. Thanks a lot.
the service is already automatic, but when starting Windows XP MSDE "asks" to be installed correctly, run setup again and as you can imagine i did so. I can't find the answer
how i can do it?Under Xp/2000, i write a application that stop/start this serices, butunder Win98, how i do it?Exists a method via SqlServer or a dos command to stop/start the MSDEprogram?Thanks a lotTomas--Questa è una firma automatica di MesNews.Sito: http://mesnews.no-ip.com
I'm not sure if it's the setup I did wrong, but I can't seem to get my text datatype in my database to store more than 900 characters. I'm trying to setup a news database for my website, which will populate the information into a datagrid. To test, I manually added a news item in the database through the visual studio 2003 gui. I immediately noticed a problem as the I was getting an error after a long news item saying:
"The value you entered is not consistent with the data type or length of the column, or over grid buffer limit."
I couldn't find anthing to set the buffer limit and the datatype is "text" filled with simple text in the column. As a further test, I simply entered 12334567890123... up to 900 characters and still recevied the error.
I would appreciate someone leading me in the right direction on this one.
I am trying to change the computer name of a machine running MSDE but I get an error when SQL Server starts. With regular SQL when I change the name of a computer I re-run setup and setup fixes this problem. MSDE can only be installed from unattended mode so I can’t rerun setup and fix the problem.
My question is "How do I change the name of a computer running MSDE with out reinstalling MSDE"
We currently have the problem, that all our machines are produced with the same name and afterwards the name is changed. So we have the problem that the checksum key for the MSDE isn't valid anymore. As MSDE can only be installed from unattended mode so I can’t rerun setup and fix the problem. Does anyone know a solution for this problem ?? A program recalculating the cheksum ??
I'm not sure if this is the correct forum for this this question but I'll give it a shot.
The only db development that I have ever done is in MS Access. I have a project at work that is being accomplished in VB and I need a db engine to use as the back end. Visual studio came with a copy of MSDE. Is this tool worth using or should I invest in mySQL? Are there any advantages to using MSDE over mySQL?
I am experiencing a big problem with my SQL Server- it won't start. Every time I attempt to start it I get an error "Error 1069 (The service did not start due to logon failure) occurred while performing this service operation on the MSSQLService service. " sa will not work either. I have not made any system changes recently. I tried to use regrbld but nothing happened. Is there anything else I can do short of reinstalling SQL7?
...So glad there are still folks out there running 6.5! We've been running 6.5 and 7.0 for the last year or so (one of our apps required 6.5). SQL 6.5 is running on an Alpha box, and SQL 7.0 is running on an Intel box. I want to install 6.5 on yet another Intel box, then install 7.0 on that SAME box so that I can perform the DTS. (Doing DTS across different CPU types failed to transfer application objects.) After that is successful, I will uninstall the 6.5 on the Intel box and no longer use the Alpha box for SQL. Both the Alpha and Intel boxes are on the same Windows NT domain.
Here is the issue. After performing the CD install of 6.5 on the Intel box, I get a message that the install could not be performed successfully because the MSSQL service could not be started. When I attempt to start it manually from Control Panel, I get an NT Error 3 - that the path cannot be found. (And the errorlog says that the server is unnamed.) So the MSSQL folder exists, the MSSQL Server and SQL Exec services are visible in Control Panel (unstarted), the registry contains SQL Server info, but the only way I've been able to start SQL Server at all is by using the Net Start MSSQLserv command.
I have repeated this step a few times - by deleting the MSSQL folder and re-running SETUP. At no point does NT remove the MSSQL services or the registry entries. In the end, NT or MSSQL still cannot find the "path" needed to start up SQL Server.
What do I need to do to "reset the clock" so that NT knows where to find these services?
I was trying to restore a master database. This is what I did: 1. rebuild the master database and it was successful 2. restart server in single mode with sqlservr.exe -c -m and I got the following window:
************************************************** ******** 2006-01-27 10:30:01.49 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X 86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
2006-01-27 10:30:01.52 server Copyright (C) 1988-2002 Microsoft Corporation.
2006-01-27 10:30:01.52 server All rights reserved. 2006-01-27 10:30:01.52 server Server Process ID is 600. 2006-01-27 10:30:01.52 server Logging SQL Server messages in file 'e:Microso ft SQL ServerMSSQLlogERRORLOG'. 2006-01-27 10:30:01.54 server SQL Server is starting at priority class 'norma l'(4 CPUs detected). 2006-01-27 10:30:01.71 server SQL Server configured for thread mode processin g. 2006-01-27 10:30:01.74 server Using dynamic lock allocation. [2500] Lock Bloc ks, [5000] Lock Owner Blocks. 2006-01-27 10:30:01.99 server Attempting to initialize Distributed Transactio n Coordinator. 2006-01-27 10:30:04.04 spid3 Warning ****************** 2006-01-27 10:30:04.04 spid3 SQL Server started in single user mode. Updates allowed to system catalogs. 2006-01-27 10:30:04.04 spid3 Starting up database 'master'. 2006-01-27 10:30:04.29 server Using 'SSNETLIB.DLL' version '8.0.2039'. 2006-01-27 10:30:04.29 spid5 Starting up database 'model'. 2006-01-27 10:30:04.29 spid3 Server name is 'SQLTEST1'. 2006-01-27 10:30:04.31 spid7 Starting up database 'msdb'. 2006-01-27 10:30:04.31 spid8 Starting up database 'pubs'. 2006-01-27 10:30:04.31 spid9 Starting up database 'Northwind'. 2006-01-27 10:30:04.31 server SQL server listening on 10.10.4.17: 1433. 2006-01-27 10:30:04.33 server SQL server listening on 127.0.0.1: 1433. 2006-01-27 10:30:04.34 server SQL server listening on TCP, Shared Memory, Nam ed Pipes. 2006-01-27 10:30:04.36 server SQL Server is ready for client connections 2006-01-27 10:30:04.67 spid5 Clearing tempdb database. 2006-01-27 10:30:05.54 spid5 Starting up database 'tempdb'. 2006-01-27 10:30:05.70 spid3 Recovery complete. 2006-01-27 10:30:05.70 spid3 SQL global counter collection task is created.
Now an hour passed and the window is still there. The SSQL service manager on the toolbars still has a red icon but not green. My questions are how do I know the process is done? What is the next step after SQL global counter collection task? Where can I find more information?
I have recently invested in a new server that is running SBS premium, this come with SQL server and as a result of which I feel its time for me to start getting to grips with it.
I have reasonable knowledge of database design and SQL, extensive experience with access and some with Oracle. I have however never dealt with SQL server.
I generally don't have too much trouble picking up new technologies, and was wondering if anyone can point me in the right direction for learning SQL server from scratch? Is it realistic to be able to achieve this without doing a formal course? I intend to start using it to develop data-driven websites and applications.
Any help, advice and/or pointers are greatly appreciated.
Getdate() will get me the date, but how I can calculate two other datetime values corresponding to the very first second and the very last second of the current day?
Eg.
Today is 2008-04-09 <whatever time> Startdate should be 2008-04-09 00:00:01 Enddate should be 2008-04-09 23:59:59
Ram writes "Hi mate, I am New in this forum. I am working as developer in C++ and .net ( 4 Years). I plan to do the SQL SERVER 2005 and do some Microsoft certification. I really don't know where I can start and which source is suitable for me. I already download the express edition and I play arround that.
could you all please help me for this. I am awaiting your good response.
hi how to get the start day end day one row for each employee like this ID fname start day end day val_holiday -------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------- this is my table ID fname new_date val_holiday ----------------------------------------------------
Where would be a good place to start learning SQL? I know all the links in the e-mail that I got sent when I registered....but there not very help full.
I'm new in the field of Microsoft products and particularly with the Microsoft SQL Server. So in the beginning I would like to ask some questions and to understand the base lines. First thing is, I heard that there are several editions of Microsoft SQL Server 2005 : standard, workgroup, express, developer. I would like to know what is the difference between each of them. I suppose that developer means that it should be good for a developers to use this edition, but compared to the Standard edition or to the Express edition what are the main differences. In my case I'll use the server for a little, not complicated, database and may be there will be a migration to do from some old Access database to the new one (under SQL Server). Is the edition of the SQL Server important for doing that ? And my last question is about the compatibility between the SQL Server 2000 and 2005. In fact the server that is in use currently is version 2000 but in the future months the administrator plans to upgrade the software to the 2005 version. So I'm asking myself, if I start to develop for directly for 2005 version, is the product will be entirely compatible with the current version (2000)? That's all I think for now.
I had a small power outage and after that, SQL Server (2000) is not starting. I press the start button, it looks like it tries to do something (since all the buttons get disabled) and then its back to square one. I tried this from command line: sqlservr.exe -c -f but it does not help either. I checked the SQL Server logs and this is what I found: 2007-08-08 10:05:09.63 spid3 Starting up database 'master'. 2007-08-08 10:05:09.63 spid3 Error: 823, Severity: 24, State: 6. 2007-08-08 10:05:09.63 spid3 08/08/07 10:05:09 Stack Overflow Dump not possible - Exception c00000fd E at 0x004436DD 2007-08-08 10:05:09.63 spid3 Address=4436dd Exception Code = c00000fd I tried to google but could not find a solid solution.
Dear Friends,I cannot start my SQL Server 2005. When I'm trying to conect to local database it's showing me error:TITLE: Connect to Server------------------------------Cannot connect to WIN2006.------------------------------ADDITIONAL INFORMATION:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)This error mean that server not started.When I read more details (error log in SQL Configuration Manager) I found that the source of the problem - "master" table was compressed. It should be decompressed to start server. What's this? I'm seeing this kind of error first time. Need your advise guys!
I've just installed VS.NET and have installed MSDE. All has gone well so far. I followed the instructions for setting a db password during install and the installer seemed to do its job. The SQL Server Service Manager runs in the taskbar when I reboot but the status icon is a white circle... The status bar indicates that it is not connected.
I have the following error when trying to test EMail from SQL.
I have logged onto the server and sent EMail using the SQLServer Service Account and the Profile is correct. This tells me that Outlook is working OK and the Exchange Server is sending OK. However, lookin on TechNet Q274330 mentions the error number but it's description is about Emailing an open file. I am not Emailing an open file.
Here's the error message.
xp_startmail 'eweb02mail'
Server: Msg 18025, Level 16, State 1, Line 0 xp_startmail: failed with mail error 0x80040106