Win98, MSDE2000, Connection Problems
Oct 12, 2004
hi there,
i have following system:
the MSDN is running on a win98 machine,
the client-applications, which uses the DB are running on winXP.
there are (SOMETIME!) connection problems to the DB, i guess because of
connection timeouts.
unfortunately i can not change the system, i only can change some setting
or install additionally components such as MDAC.
what can i do,
please help me, it is a support case for a customer.
thank you very much.
mik
View 1 Replies
ADVERTISEMENT
Jul 23, 2005
I attempted to install MSDE on a WinXP machine(server) today. I installedfrom the command prompt as follows:-[color=blue]>setup INSTANCENAME="NetSDK" SECURITYMODE=SQL BLANKSAPWD=1[/color]Before I get 'blasted', I know that I 'really shouldn't' use a blank sa pswdbut.......I did :-)I then detached (sp_detachdb) an existing db from another machine. Moved itonto the new instance and reattached it.Finally, I executed the following scripts:-sp_addlogin @loginame = 'name', @passwd = 'password', @defdb = 'dbName'sp_grantdbaccess 'name'sp_addrolemember 'db_owner', 'name'So, this was fine and I could connect to the new db using either windowsintegrated security or 'name'/'password' BUT..BIG BUT, only at the server.When I tried to connect from a client I received an error message, 'SQLServer Does Not Exist or Access Denied'.I am assuming that all is well with the db and that it is something I havedone...or more probably not done with the sql server instance (as the errorsuggests:-). Can anyone please suggest my error?Thanks
View 3 Replies
View Related
May 4, 2000
I've tried to install the server part of SQL Server 7 under both win 98 and w2k professional, but both times i get an error message telling me that "The Enterprise Edition server component cannot be installed on the_name_of_the_os using this cd. Only client components will be available for installation."
Anyone got a quick and easy solution to this problem?
Thanks in advance
/Jimmy
View 1 Replies
View Related
Apr 13, 1999
Hello,
I recently received my free evaluation to SQL Server 7. I installed it on my windows 98 computer and I am able to
start the services to SQL server. However, when I go into enterprise manager I am unable to get connected to be able to
begin creation on a database. I am also unable to create a proper DSN connection to the SQL server database. I am doing
all of this on my local computer and I am unable to get it working I just need to be able to connect to SQL on my local computer.
Please help. I am not a beginner to creating databases I have done numerous Access databases and know how to
create DSN's but I have never done one for SQL Server 7. If any one knows how to do this please let me know or if their is
a good tutorial on how to do that.
Thank you, in advanced.
Joey
View 3 Replies
View Related
Aug 24, 1998
Hi all!
When installing SQL6.5 on a Win98 client, I get an error:
"A critical error has occurred. The INF SETUP has a badly formed file description line in section [UtilDLLs]. This error prevents setup from continuing."
I can use the same CD to load to any 95 or NT machine, but it chokes on 98.
Any assistance is greatly appreciated.
Thanks,
Tony Vinson
View 1 Replies
View Related
Sep 24, 2001
Hi!
I have tried installing SQL Server 7.0 on my Win 98 machine. My machine has all the latest service packs and I think it is reasonably up to date. I've tried installing from the disc 3 times and it fails to install:
the Server Network Utility and Service Manager.
As a result, I am unable to register my local machine as a SQL server.
Any ways around this? Quick fixes?
Thanks!
--Michelle
View 4 Replies
View Related
Apr 27, 2004
I have tried everything that me and the net guys could come with and still no luck. All the WinXP Pro boxes see the server, can talk to it, the whole nine yards. All the Win98 boxes simply won't. I've checked the SQL Server instance. It appears ok. I've checked my application code to be sure I was using the IP address instead of the actual server name to avoid DNS problems. Downloaded and installed the latest SQL server drivers on all but one of the Win98 machines. Same with the latest Novell drivers. Everything worked Friday (no changes to application or DB between then and now).
What else can it be?
System specs:
Novell backbone (5.x and 6.x)
Win2000 Server with multiple SQL Server 2000 instances running (including the one I'm trying to connect to)
Mix of WinXPPro and Win 98 on desktops
Win98 running Novell 3.4 client
WinXP Pro running Novel 4.9 client
Application is VFP 8 SP1
Latest MDAC (2.8) on two Win98 and 2.5 on another
Thanks for any help provided.
Richard
View 1 Replies
View Related
Aug 23, 2006
Wilson writes "Hi, I have Sql Server 2000 on win98, i can't retrieve any data. Instead, it shows an error, says that some files is missing or is not registered.
the mssql was reinstalled and it's goin then same.
what could be the problem? what could be the solution?"
View 1 Replies
View Related
Apr 13, 2007
Hi allIs it possible to install MS SQL Client 2005 on Windows 98 ? I tried to dothis today but I got error with informations about rejects in libraries.What should I do to install it ?Thanks for your answer
View 1 Replies
View Related
Nov 18, 2005
Quick Question: It does not appear that SQL Server Express supports Win98.
View 4 Replies
View Related
Mar 16, 2004
I am developing a project in Vb.net
using MSDE 2000 as backend.
I want to deployment my project in win98 OS PCs.
is it possible to install msde 2000 in win98
bye
S.Muhilan
View 2 Replies
View Related
Oct 19, 2001
dear all,
i try to install sql 7.o std version on my developement win98 computer but
setup will give me option to create only "Program Files" folder but not "Data"
base folders(Grayed). i did it b4 on my notebook & another desktop(as i change my computer, i did not have problem.) Can some one help or suggess me what i should do?? thanks.
javid
View 2 Replies
View Related
Nov 25, 2006
I have some bookkeeping files that were saved using win98 backup that i need to restore to my accounting program on my winxp computer.. i have no idea how to do that. The files that are backed up belong to the same program on both the win98 and winxp.
View 1 Replies
View Related
Aug 26, 2004
Hi,
I've been trying to follow Microsoft's instructions on installing MSDE2000 for Visual Studio. I do instancename=VSDOTNET SECURITY=SQL SAPWD=XXXX and all that. When I reboot, I notice that I have no services in the SQL Service Manager, nor can it find my computername.
Anybody know why this is?
View 1 Replies
View Related
May 23, 2005
hey guys heres my problem iam trying to install SQL server2000 but i keep on running into problems....??
here is what iam having problems with
setup SAPWD="AStrongSAPwd" SECURITYMODE=SQL
it keeps saying the instance name specified is invalid there has to be an easyer way to run the program...??
i have all ready set up an instance name and the SAPWD.
any suggestions?? please help
View 2 Replies
View Related
Sep 11, 2005
Hi,
I have a problem with the database that I created using MSDE 2000 SP4. I tried to attached the database into the new SQL Express using the sp_attach_db and it worked. The message mentioned is that the DB has been upgraded. When I tried to attach back the DB back to my MSDE, it can't be done.
My PC is XP pro SP2. Before I reattach the DB back to MSDE, I detach the DB from my SQL express.
Is it because once the SQL express upgraded the DB, it cannot be supported by MSDE or SQL 2000 ?
Thanks. Any help is greatly appreciated.
View 1 Replies
View Related
Jan 23, 2007
Hi
Im installing MSDE2000 on new Machine Pentium IV LGA Processor HT technology; OS Windows 2000 Professional. Its getting roll Back after some installation.
The same setup if im installing on my other new Machine With Scoket 478 Processor OS Windows2000 Professional. Its installing completly.
Is there any compatibilty problem.
Please Advice me what to do. Thanks In advance
View 2 Replies
View Related
Oct 23, 2006
Ii have installed msde 2000 now all my Access files are in 2000 format how do i change back to 2003?
View 1 Replies
View Related
Apr 20, 2004
looks like a noob question but how can i manage msde2000...i can see sql is runnin but how can i create database , attach/detach database, write functions and so on...
thanx alot for the reply :)
View 2 Replies
View Related
Feb 25, 2008
Hi there,
I'm having some trouble with my MSDE2000 (version 8.00.194) and I'd appreciate any insight you could provide...
Long story short, I'm not sure what went wrong, but after stopping my SQL server to change DBs, it wouldn't start again. On the server, it showed no errors. In my services list, it said something along the lines of 'This service has no actions to perform, and so will not start'. It was a few days back, so I forget the exact message...
After restarting my PC, the service started without any errors, but my ODBC Connections will not find my SQL server. I get the following messages with the following scenarios:
Server: (local) : SQL server does not exist or access denied.
Server: . : Specified SQL server not found.
Server: 127.0.0.1 : Login failed for user <username>.
Server: <PC name> : Login failed for user <username>.
I have come across a similar issue before, where re-installing the MSDE sorted it out, this time however, I cannot uninstall the desktop engine: simply shows 'An error has occured during the installation' and nothing else after that. I also cannot apply any service packs, I get the same message as above. I have also tried upgrading to MSDE2005 (using company CDs on my PC at work), to be told that the installation has been blocked due to the following software: 'MSDE2000 8.00.194'.
For the record, I have also installed SP3 for Win XP... Not sure if that might be the issue? I somehow doubt it though. I tried a system restore to the day before the problem started, and it is still doing the same after a successful restore.
Help?!? Please? I need an SQL server for my work software to function correctly, I work in a busy call centre and I cannot get this fixed myself. I'm on the brink of formatting with a fresh install if XP.
Regards,
Andre.
View 6 Replies
View Related
Jun 19, 2007
I have side by side msde2000 and sqlexpress installed. I need to move a db that has been detached from msde2000 and where it works perfectly fine into sql express. After I select the .mdf file to attach I get this error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'LTBAHIASQLEXPRESS'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x55555555; actual signature: 0x55555551). It occurred during a read of page (1:97) in database ID 6 at offset 0x000000000c2000 in file 'C:Memo2005DiaryMEMOinMEMOsql.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
Converting database 'MEMOsql' from version 539 to the current version 611.
Database 'MEMOsql' running the upgrade step from version 539 to version 551. (Microsoft SQL Server, Error: 824)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=824&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Thanks for any help,
Luis
View 6 Replies
View Related
Jan 30, 2004
I just downloaded and installed MSDE2000 sp3a for winform and asp.net
quickstart tutorial. But I found it has no sample database such as pubs
and northwind. It used to have these databases. At least in last September
when .Net web Matrix came out.
If this is the case, can someone tell me where to get the sql scripts
to create Northwind database in MSDE?
Becasue the winform tutorial uses this database.
Thanks in advance!
Lei Xu
View 1 Replies
View Related
Mar 12, 2008
Hello !
I have installed msde2000A , but wanted to use Adventure Works database for which I am trying to install sql server express edition 2005 ,
But I want to install it w/o removing earlier msde2000A .
Is it possible.. I was guessing I could install 2 instances .
1st of mase200A and 2nd that of sql express edition 2005.
If it is poss , how to do that ? any other particular procedure / or normal install procedure .
Any one can help ?
Thanks
Bobo
View 2 Replies
View Related
Feb 28, 2008
Hi,
i have a problem when i try to do an inplace update of msde2000 to SQLServer2005Express (adv.).
The following error message is displayed:
SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft]
[SQL Native Client][SQL Server]Incorrect syntax near '='..Refer to the server error logs and Setup logs for detailed error information
Has anyone a suggestion to solve the problem ?
thank you in forward.
BR
Jürgen
View 4 Replies
View Related
Aug 24, 2006
Hi,
Recently when i try to upgrade my current MSDE 2000 (SP3a) to SP4, the system just keep on failing me. Here is the scenario:
1. Download the MSDE2000 SP4 from microsoft
2. Extract the SP4
3. Run the following command in either the command prompt or via a batch file:
echo off
echo "Start to Upgrade MSDE SP4 ... "
setup.exe /UPGRADESP SQLRUN INSTANCENAME=JSNG SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=Th3B3st /L*v c:MSDE_Log.log
echo "SP4 Upgrade Process completed!"
4. Once the above batch file was runned, the standard SQL configuration screen (gathering information) will be triggered.
5. However after a while the installation will just stopped.
6. When i checked on the log, i have found out that the failure of installation is due to the system has failed to configure the server. PFB for the last few rows of the verbose log:
=== Logging stopped: 8/22/2006 17:36:49 ===
MSI (c) (90:88) [17:36:49:865]: Note: 1: 1729
MSI (c) (90:88) [17:36:49:865]: Product: Microsoft SQL Server Desktop Engine -- Configuration failed.
MSI (c) (90:88) [17:36:49:865]: Grabbed execution mutex.
MSI (c) (90:88) [17:36:49:865]: Cleaning up uninstalled install packages, if any exist
MSI (c) (90:88) [17:36:49:865]: MainEngineThread is returning 1603
=== Verbose logging stopped: 8/22/2006 17:36:49 ===
7. When i check the MSI Installer Event ID at Microsoft site, it just said that this is the server configuration problem and i cant find any solution.
Any forumers here experience the above before? Mind to share some thoughts?
FYI, my current MSDE configuration is as follow:
- MSDE 2000 Release A (SP3a - 8.00.760)
- Installed Instance = JSNG
Thanks.
regards,
JS
View 1 Replies
View Related
May 19, 2006
Has any one had experience with upgrading MSDE2000 with no instance to SQL2005 Express?
Thanks
ZS
View 1 Replies
View Related
Mar 3, 2004
Hi
I am using MS Access project as a frontend and MSDE 2000 as a backend database. I have few users and i want to give every one restricted access to database based on their use.
How can i create user accounts. I checked tools-->Security--> but workgroup admin option is not active. How to solve this puzzle
Thanks in advance
Neha
View 1 Replies
View Related
Mar 12, 2004
Can't connect from Win XPpro to named instance nor default instance on server running MSDE2000 SP3 via LAN (WORKGROUP). Works fine from Win 2K in the same network. Attached screen shot of error message. Osql gives the same response.
View 2 Replies
View Related
Jul 26, 2006
I am aware that instances of both can exist on the same machine.
But I assume that is when a different instance of SQL Server Express is installed with an existing instance of MSDE2000
Many moons ago, when the various flavours and betas of SQL Express became available, I upgraded from MSDE2000 - didn't think I would need it again.
I now have an application, Sony Vegas 6, which uses MSDE2000 for it's Media Manager. According to their support it won't install to SQL Server Express 2005.
When I try to install MSDE2000, it always fails with "Setup failerd to configure server..." and rolls back.
In the event log, there is an entry
The description for Event ID ( 19011 ) in Source ( MSSQL$SONY_MEDIAMGR )
cannot be found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote
computer. You may be able to use the /AUXSOURCE= flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: (SpnRegister) : Error 1355.
I have down all the usual things like uninstalling SQL Server Express 2005 (using control panel and msiexec /x {GUID}), patching the registry etc etc
The result is always the same.
The Sony Media Manager is not important and I probably won't use it but it's annoying the hell out of me - I've always claimed, over a good few years, that there was no computer problem that I couldn't finally solve, but presently this has got me beat and I feel undone!!!!!!! :-)
regards
Stuart
www.mckears.com
View 3 Replies
View Related
Oct 11, 2006
I'm trying to install the MSDE2000 on window xp, sp2. During the installing, apperance the percent bar is rolling back, which is not even completed install. I had read the issue from microsoft to restart the server service, and...but no luck. Is there anyone has an ideas.
View 1 Replies
View Related
Apr 12, 2005
My Problems & Situation:Hi! I am a ASP.NET starter. My platform is WinXP Home Edition and I haven't installed any version of SQL server before.I download different version of MSDE and extracted in my C drive separately, including: 1. Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A 2. Microsoft SQL Server 2000 Service Pack 3a (contained MSDE 2000) 3. MSDE 2000 for Developers Using Visual Studio .NETsince all of the above versions have the same problem when I try to install it.
The problem is that when I double click each of the setup.exe, it will show a pop up error:[A strong SA password is requires for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit.]
Then I found a solution from Microsoft, it told me that: 1. Run the setup in the command prompt 2. Locate in the extracted path 3. type --> "Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=<pwd>"
p.s. I have changed the <pwd> to 123abc
However....another Error Occur:1st pop up --> [Unable to determine system default collation.]2nd pop up --> [Microsoft SQL Server Desktop Engine Setup failed.]
My Question:1. Why the error still occour when I type that command to setup? (Solution from Microsoft)2. How can I fix it and complete the installation?3. How many users(maximum) can be created in a MSDE database?
Greateful if anyone can give me hand.
View 3 Replies
View Related
Sep 21, 2004
How do I add login user ASPNET to my SQL 2000 Desktop Engine Server?. I can not find the "Server Manager" in the Start - Programs. Is there any other way to get around adding ASPNET login to the SQL server so I can test my VB program. I got the error: Login failed for user 'com_nameASPNET'.
View 1 Replies
View Related
Aug 23, 2006
I added a connection (ADO.NET) object by name testCon in the connection manager - I wanted to programmatically supply the connection string. So I used the "Expressions" property of the connection object and set the connectionstring to one DTS variable. The idea is to supply the connection string value to the variable - so that the connection object uses my connection string.
Then I added a "Backup Database Task" to my package with the name BkpTask. Now whenever I try to set the connection property of BkpTask to the testCon connection object, by typing testCon, it automatically gets cleared. I am not able to set the connection value.
Then after spending several hours I found that this is because I have customized the connection string in testCon. If I don't customize the connection string, I am able to enter the "testCon" value in the connection property of the BkpTask.
Is this an intrinsic issue?
View 2 Replies
View Related
