Hi All
I am trying to install sql server on my xp machine. When I run the install it says it can't validate the product key. I have all legit copies of the software. I did a search on the web and i found something about problems in NT, but nothing for XP. Any ideas?
thanks!
I have tried many times to install Microsoft's SQL Express Server 2005 whenever I try to install the server it says that setup has unexpectedly failed and tells me to reveiw the set up summery log file, I looked at the log file and it did not have much inside of it I would like help in getting the SQL Server to work so if some one could kindly help me that would be great.
Thank You
Anonymous
Hi,
I had installed the Visual Studio 2005 successfully but i try to install the sqlserver2005 the following error would occurred.
SQL Server Setup failed to obtain system account information for the ASPNET account. To proceed, reinstall the .NET Framework, and then run SQL Server Setup again.
Again i was reinstalled .NET Framework the same problem would occurred plz anyone help to
me.
regards
kumar
I'll installing update http://support.microsoft.com/?kbid=899761 to correct memory usage. When installation process started I recieved this error - "An error in updating your system is occured." and installation failed. What I must doing to correct this issue?
Hello,
i am trying to install mssql 2000 virtual server for failover clustering on windows server 2003.
i have downloaded the evalution edition for mssql 2000. "the problem i am facing during installation that when i start installation, the virtual server option is disabled for computer name (on what computer mssql server is to install, as i want to install it on virtual ip)."
could you someone help in this matter, "how to enable virtual server option and how to do the complete installation on windows server 2003".
thanks.
kamran
Hi all,
I think most of the visitors here are experts of SQL 7.0. But I am a absolutely new one. So I may ask some very foolish questions.
I plan to learn how to use MS SQL 7.0 recently, but I don't know how to begin, can anybody here give me some good experience or material(websites) on learning SQL 7.0?
Also, I want to install SQL 7.0 in my home PC. should I install it with Win 2000 professional or Server version?
Thank you.
Henry
Which Edition of SQL SERVER 7 and SQL SERVER 2000 can be run on Windows XP Professional? I'm talking about the server itself not the client tools.
Thank you for any help.
Hi All, I have read MANY posts on how to track changes to data overtimeIt appears there are two points of view1. Each record supports a Change Indicator flag toindicate the current record(would this be EVERY table?)2. Each table is duplicated as an archive table andtriggers are used to update archiveCan someone give me some guidance based on REAL world experiencewhich works best for them?My scenario - I have insurance policies and must track history aspolicies are updated by customer service reps.Imagine many tables Policy>LifePol>LifePolRiders[color=blue]>AccidentPol >etc...>DIPol>DIPolRiders[/color]To me the archive table scenario does not seem scalable at all....someguidance on design would be aprreciated...Thanks!!!
View 2 Replies View RelatedDear all,I have XP pro as Operating system.I installed Webmatrix, downloaded SQL 2000 desktop (sql2ksp3), run the command prompt in the directory where dir MSDE of sql2ksp3 was as so: setup.exe SAPWD=hello INSTANCENAME=RMSI lat the installation ran and I got msg that installation ran successfully. So far, so good. From WebMatrix, I tried to add a database connection within a project. When I select SQL-database and click on OK, I get the error message that SQL server administration requires SQL client installed on my machine. In Control Panel - AddRemove Programs, I see indeed that there is no MSSQLserver or client mentionned.I check also the services. The only one I have is SQLADHelper that starts manually. I must have to do with XP security, right... Can someone please please help me. I am a newbie and only want to learn ASP and VB programming via Matrix and Visual Studio IDE.Thanks in advance!Christiane
View 1 Replies View RelatedHi,
I am looking at installing SQL Server 7 on my PC which runs Windows 2000 Professional. Can anyone give me some advice before I do the installation of SQL Server 7. Any tips or any problems I might encounter.
Regards
Guy
Currently, I have the client side of SQL Server 6.5 (Enteprise Manager, Security Manager, Books Online, etc.) installed and running under Windows NT 4.0 Workstation. When I attempt to install the same package under Windows 2000 Professional I get the following message - This program does not run correctly on this version of windows. To continue, click Run Program. Has anyone sucessfully installed this under Windows 2000 Professional? Are there any patches or service packs to apply? Thanks.
View 1 Replies View RelatedHi there,
We are currently developing a E-Com research site where subscribed members can conduct market research. The web site is developed and ready to go, however we are undecided what is required on the Database side and could do with some of your expert help.
Users will be conducting research on our MS SQL database. The database holds every product sale made by a select number of consumer good companies. The database holds 12 million records at any one time, however overall the database is very static and is not updated online. We intend to only store 1 months data, therefore on a weekly basis we delete old & add new records.
We are offering three categories of searches on the DB.
1. By Seller
2. By Category (i.e. Hair Care, Laundry etc)
3. By Sale.
The first two searches are not performance intensive as they are compiled and stored in the database - therefore no need for calculation online. Our main concern is the 3rd report. This report is where we allow the user to search for a specified search string. Therefore in the main table that holds all the sales, we have a full-text index for the field "Product Description".
What we are unclear on is the Capacity requirements regarding providing such functionality. I.e What server do we require?
We have researched many articles and have absorbed all the information regarding multiple disk controllers, lots of memory etc.. etc.. However we still have not been able to obtain an idea on what Server would serve our purposes. For example: would the following server do the job?
2 x 2.4Ghz Hyper-threading Xeon CPUs with 512Kb Cache and 400MHz System Bus
2GB Samsung RAMBUS 800-45 Memory (RIMMS / RDRAM)
A lot is determined by the usage, i.e. how many queries are executed per minute etc. At present we do not have a clear idea on the number of users. However we are not truely concerned about this as the 3rd report needs to execute and return within a short period of time. That is our main concern.
Therefore our question is as follows: If you were going to host a database that consisted of 12 million records & full-text indexing which had to be queried in a few seconds, what would you purchase?
We ask you to consider that funds are extremely tight and although the new latest server may do the job, it is most likely out of our budget. We are looking for the most cost effective solution but still statisfying the purpose.
Kind regards
Angus
I'm sure this problem borders on retarded for most readers of this form, but here it is:
I have table with contest and another table with user ratings on those contests.
Contests: ContestID, CreatorUserID, Title
Ratings: ContestID, UserID, Rating
If I
SELECT Contests.*, Ratings.*
FROM Contests INNER JOIN Ratings ON Contests.ContestID = Ratings.ContestID
WHERE (Ratings.UserID = '1')
This only returns the contests that User 1 has rated. But I need all contests. If the user hasn't rated one, I want the result set to show Rating = NULL. The problem is that if a user hasn't rated a contest, that ContestID does not exist in the Ratings table.
Can someone please show me how to solve this?
Thanks!
Gavin
Occasionally, when I try to edit a package I get an error. Visual studio is busy found VS hanged.
It is specific to my machine or a common problem.
I have a copy of MS Visual Studio 2002 Professional ACADEMIC which Iunderstand is the same as the regular Professional version with theaddition of a student CDROM. The installation program on the firstCDROM only copies the MSDE to the harddrive and the copied setup filehas to then be manually executed to complete the installation.Are the SQL tools such the SQL Enterprise Manager and MS Queryincluded in the professional version? If so, how can I install thesetools? The course that I am taking uses these tools to study SQL. Ifnot, how is the MSDE to be used?
View 4 Replies View RelatedJust curious if anyone out there has had success running a Distributed Transaction on Windows 2000 Professional SP4 lately?
I have come to the conclusion that is is virutally impossible. I am running MSDE on a Win2k Pro machine and trying to run a distributed transaction via linked server and am getting the
"The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction."
error. Yes I have been scouring the web looking for answers and have implemented pretty much everything I have run accross... and Yes the MSDTC service is started on both machines... BTW: If I run the procedure on XP it works great!!!
I am wondering if anyone even uses Win2k Pro anymore let alone trying to run a distributed tarnsaction on the darn thing.
If anyone out there has it running let me know I would love to chat with you for a minute or two.
Hello all,
This is my first time posting, so be gentle as I'm not exactly sure what the protocol here is regarding posting errors.
I'm encountering an issue with an installation of SQL 2005 Express (SQLEXPR_ADV.EXE) on a Windows 2000 Professional SP4 machine (Intel P4 1.8 Ghz). The following error is what I receive:
Setup.exe - Entry point not found:
The procedure entry point _create_local could not be located in the dynamic link library mscvr80.dll
< OK >
The following is what I see in the error log (C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFiles):
SQLSetup0007_SQL2005TEST_Core.log
Microsoft SQL Server 2005 Setup beginning at Wed Dec 06 11:28:08 2006
Process ID : 452
c:98b179fcf692887ac3setup.exe Version: 2005.90.2047.0
Running: LoadResourcesAction at: 2006/11/6 11:28:7
Complete: LoadResourcesAction at: 2006/11/6 11:28:7, returned true
Running: ParseBootstrapOptionsAction at: 2006/11/6 11:28:7
Loaded DLL:c:98b179fcf692887ac3xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2006/11/6 11:28:8, returned true
Running: ValidateWinNTAction at: 2006/11/6 11:28:8
Complete: ValidateWinNTAction at: 2006/11/6 11:28:8, returned true
Running: ValidateMinOSAction at: 2006/11/6 11:28:8
Complete: ValidateMinOSAction at: 2006/11/6 11:28:8, returned true
Running: PerformSCCAction at: 2006/11/6 11:28:8
Complete: PerformSCCAction at: 2006/11/6 11:28:8, returned true
Running: ActivateLoggingAction at: 2006/11/6 11:28:8
Complete: ActivateLoggingAction at: 2006/11/6 11:28:8, returned true
Running: DetectPatchedBootstrapAction at: 2006/11/6 11:28:8
Complete: DetectPatchedBootstrapAction at: 2006/11/6 11:28:8, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__452" returned false.
Running: PerformSCCAction2 at: 2006/11/6 11:28:8
Loaded DLL:C:WINNTsystem32msi.dll Version:3.1.4000.2435
Loaded DLL:C:WINNTsystem32msi.dll Version:3.1.4000.2435
Complete: PerformSCCAction2 at: 2006/11/6 11:28:8, returned true
Running: PerformDotNetCheck at: 2006/11/6 11:28:8
Complete: PerformDotNetCheck at: 2006/11/6 11:28:8, returned true
Running: ComponentUpdateAction at: 2006/11/6 11:28:8
Complete: ComponentUpdateAction at: 2006/11/6 11:45:55, returned true
Running: DetectLocalBootstrapAction at: 2006/11/6 11:45:55
Complete: DetectLocalBootstrapAction at: 2006/11/6 11:45:55, returned true
Running: LaunchLocalBootstrapAction at: 2006/11/6 11:45:55
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 128
Aborting queue processing as nested installer has completed
Message pump returning: 128
Notice the time jump; I did this to make sure I was looking at the right log file.
Any help is greatly appreciated as I'll be monitoring this thread closely. Searches of my error show that other people have received it as well, although no resolution has ever been forthcoming. Thanks in advance.
We are looking for some professional, low-cost, and easily configurable CMS tools that work hand-in-hand with SQL Server Express. Any come to mind?
View 1 Replies View RelatedHi Everyone,Can you please kindly tell me how to create a new user on the MS SQL 2005 Professional edition for accessing the existing database called VCalendar?thanks for your time and help!Jiimmy
View 13 Replies View RelatedI try to install MSDE as a new instance (SQL2) on my computer with Windows 2000 Professional, but a problem occurs and instalaltion does not complete successfully. I am an administrator of the computer. The application log contains the following errors descriptions:
"The SYSTEMCurrentControlSetServicesMSSQL$SQL2Perfo rmance key could not be opened or accessed in order to install counter strings.The Win32 status returned by the call is in the Record Data as DWORD 0. " and
"Installing the performance counter strings for MSSQL$SQL2 failed. The Error code is DWORD 0 of the Record Data. "
Have someone experienced a similar problem?
Hi Every one,
I have installed Visual studio 2005 professional edition.(with SQL Server 2005 expree Component). The Installation was done by Administrator.
I am able to work to access all database servers, Except SQL Server 2005. When I am trying to Add>>New Item>>SQL database in project, I am getting following error.
Login Failed for "XXXYYY"
Please some one help me to short it out.
thanks in Advance
Can you explain please why Extended SP does not work under Vista ?
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.0 (Build 6000: )
UAC turned off. MSQSL runs under Administrator account.
Any call of user esp - and SQL server goes to loop.
If I call system esp - all works fine.
If I try to read properties of ESP from Management Studio - I have the same effect - SQL server is in loop.
select object_id('dbo.xp_mylog')
-- works.
EXEC('sp_helpextendedproc ''xp_mylog''')
xp_mylog c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnLogEsp.dll
exec master..xp_mylog
die forever
Konstantin
The computers here at work run Windows 2000 5.00.2195 SP4. Everything checks out with the minimum requirements at http://msdn.microsoft.com/vstudio/express/support/sqlreadme/#_3462_setup_issues_238p
However, one of the "Reports" from the installation says the machine does not meet the minimum requirements, but provides no details. It installs and I have Admin rights on this machine, but I can't even connect to the Northwind database that I downloaded.
Is this due to our logging process where the "system" is actually in another country? (ie, "CITYNAME/Username"
Any help is appreciated!
Jason
Hi
I am trying to install SQL Server 2005 Standard on my laptop, which has Windows XP Professional with Service Pack 2. I could not able to install properly and i am getting error always. i tried whatever the people mentioned in Google, but I could not able to fix the problem. please some one can help my problem.
Here is the Error I am getting always "The certificate chain was issued by an authority that is not trusted" . I am trying for past few days i could not able to resolve.
please help
Note : I have SQL Server 2000 Client installed in my laptop. this is my development machine
Thanks
Paddy
Here is the Error message from Summary.txt
Product : SQL Server Database Services
Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]SSL Provider: The certificate chain was issued by an authority that is not trusted.
Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
--------------------------------------------------------------------------------
Machine : W4102762
Product : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_w4102762_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}SSL Provider: The certificate chain was issued by an authority that is not trusted.
Error Number : 29515
--------------------------------------------------------------------------------
Machine : W4102762
Product : SQLXML4
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_w4102762_SQLXML4_1.log
--------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Hi, I am trying to open or create a sqlexpress database within Visual Studio 2005 Professional in the App_Data folder. If I attempt either method, I get the following dialog box:Required Components MissingConnections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkID=49251 The link above just takes you to the download page for Sql Server Express 2005. I have both SQL Server 2005 Developer and SQL Server 2005 Expression instances running. The existing database will work properly in my web application, however I cannot access it through Visual Studio.As background, I did have a problem connecting to the database via the web application, receiving a "Failed to generate a User Instance of SQL Server" error. But I was able to fix that by renaming my SQLEXPRESS folder in C:Documents and SettingsuserLocal SettingsApplication DataMicrosoftMicrosoft SQL Server Data. When the web page ran, it created another SQLEXPRESS folder.However, I cannot figure out why I am having the other issue.Thanks in advancePatrick
View 1 Replies View RelatedHi Friends,
I have a question. At my home computer i downloaded and installed VWD. As usual it also installed Sqlexpress as part of the installation(i checked the option). Later on i downloaded Management studio separately so i am fine with my home computer as every thing is free.
But at work we decided to develop application using VS 2005 and Sqlserver 2005. So we bought and installed VS2005 professional edition at work and it also installed Sqlexpress during the installation as a defualt desktop engine. I am fine with that too. But i am not understing where do i get the Management studio? Is it some thing i could get it off the web for free or what? I am not sure we would have an option while installing the VS 2005 professional that also does install management studio and we need to check that option. I am not sure if we could get the management studion off the web for free and and evelop applications.
Please advise. Thanks -L
This may be a stupid question, but can someone from MS SQL Server Team kind enough to confirm it, please?
View 3 Replies View RelatedExcel 2007 Documents Not Displayed in Windows XP Professional sp2
Start Menu's Recent Documents List:
Dear Microsoft Support:
I can't figure out how to get recently used Excel 2007 (new file formats) documents to show up in the Windows XP Professional (sp2) Start Menu's Recent Documents List. I checked the Internet, the knowledgebase, many parts of the MS web site, etc. for an answer but can't find one.
Are Excel 2007 documents supposed to show up in the XP Start Menu's Recent Document List? Is this a bug or do I have to do some sort of configuration to make it do so? If it's a bug, when will a fix be available?
Are these new Excel 2007 files filtered out like EXE files are which will not appear in the Recent Document List?
The Excel 2007 file types are listed in the Registry.
This question is also posted on Experts-Exchange...No solutions yet.
Thanks.
Jim.
Hello,I received the error message below when i'm trying to install SQLServer 2000 standard edition into a Windows 2000 Professionaleworkstation.Error :Microsoft SQL server 2000 Standard Edition server components is notsupported on this operating system. Only client components will beavailable for installation.Any request modification ?Best regards,Thanks
View 1 Replies View RelatedI fail to use project professional 2003 to access to the project server 2003 using MSDE 2000 in local area network, following message was shown,
Connection failed:
SQLState: '01000' SQL Server Error 1326 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())
Connection failed:
SQLState '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
I have seen these pages with similiar cases but can't help.
http://support.microsoft.com/kb/818047/
http://support.microsoft.com/kb/837653/en-us
Can anyone help me?? Thanks a lot!
I am Using Sql Server 2005 and XP OS Can i use sql server as a server by xp, if yes how? pls help
thanks in advance