The machine originally had SQL express successfully installed but had been removed moths ago.
After trying to re-install I'm getting SQL won't start, but it can't the installation isn't there. I go to microsoft sql server folder, both folders 80 and 90 are there but no MSSQL folder
Hello. I see a lot of threads re this but I havent seem an answer. Please help. I have Win xp pro SP2 with msde, IIS 5.1 and Web Data Administrator on two separate machines.
With one machine everything works great. On the other, When I hit the Web Data Administrator Login button (windows integrated or SQL) it just shows the hour glass and doesnt do anything.
On the one that works, I can change the server to one on our lan with sqlserver and it will link in fine. However with the other, the same hourglass shows.
IIS and msde are both running and seem to work fine. I can browse to localhost virtual directories (I have dotnetnuke running using msde on localhost) and access the database from dotnetnuke and visual studios.
I have made sure my localhost is a "Trusted site" und ie browser and I have enable windows integrated authentication for the default web site and the webadmin virtual directory.
Ok so every week I have to download a file containing in excess of 40000 products. I then have to change the category ids to suit my system. Is there a script or something that I could create so I just run it each week to do a search and replace and then loop until all category ids have been changed.
Table = ecommstore Column = section
I would need to change say from 84 to 1 then 86 to 2, 87 to 3 etc etc
I was using access with visual studio express but issues and advice steered me to server express
However I cannot seem to pass the first hurdle
I have created a table and relevant dataset.
I have created a form to hold to view, update, insert and delete i.e. the form has a database strip at the top.
But when I try to add, update or delete records, the database does not reflect the changes.
I saw a forum that stated that changing the database property to "copy if newer", i did this but still no effect.
Is VB really this difficult. I thought with my experience of access and vba I would learn quickly but it seems that I have to take 4 steps back to take one forward.
My intention is ti build quite an indepth application that generates reports and some advanced stuff. But I am wondering if it is worth it as after three weeks I haven't been able to create an application that can communicate with a database then add, delete and update some info. At this rate I might be able to sum a set of records after a year.
I really am thinking of going to a php/mysql application. Is VB really worth it after three weeks of trawling the internet for help, not finding it, coming up with a new idea, trying to find info on the internet, not finding it and so on...
To make matters worse when I wrote this post earlier and tried to post it, something failed and I have had to type it again. Perhaps a higher being is steering me away.
Anyway I imagine people will probably ignore this as in early post but if someone knows what I am doing wrong then please help.
SQL Server 2000 - Backend Access 2000 Runtime - Front End Connecting via ODBC
I have read loads and loads of examples and looked at other sources of info for help on this but am struggleing big time.
I have multiple users working in the same database table. The problem is they often get an error message about the record has been changed and would they like to save the changes to clipboard etc etc.
I basicly want to implement pessimistic locking for my tables. So once a user has started to edit that record nobody else can get to it.
I am the only DBA for a company of about 200 employees which makes about 100 million a year; I have 8 SQL servers some with over 70 databases on them that feed our web sites and educational web sites. I also have a few databases that are between 75 and 120 Gig that is for our circulation system. I am the Systems admin for all of the systems that run of my SQL server, so that makes our circ system, tradeshow system, accounting system, web sites there are about 90 of them or so. I also do programming for our IT department and some web site stuff as well as for our tradeshow dept. I am the answer man for our sales people and programmers, I also have the knowledge to build by own servers and run a network. So that€™s over 200 databases plus all the other *** that I do. Oh and by the way I'm supposed to help out and cover for our Tec support guys, witch there are 2 of them by the way. I can never take any more than 3 days off at a time; I have a month€™s vacation. I do all this for under $55,000 a year. I am never included in any decisions on software that runs on SQL nor am I consulted on any thing having to do with SQL. I work for a director who knows nothing about SQL server. There are 2 JR data guys and they do just data queries and deal with the day to day circ requests. These guys both have an office not to mention the tech guys have an office and guess what I am in a cube. I asked my boss for a laptop with a Verizon air card so when I€™m not at work if something happens that needs my attention I do have to drive to work or go home and remote in, here is the best part he looked at me and asked if I was high. I am on call 24/7 365. I have over 10 years experience working with SQL. I€™m I crazy for staying? I have been with this company for almost 8 years; I am the one who started them out on SQL server. I have converted every thing over to SQL 98.5% of all the company data I am in charge of. What would you do?
Hi all - I receive the error below at the end of one of my DTS packages. All steps in the package actually complete successfully but right at the end I get a Microsoft Visual C++ Debug Library pop-up with the following:
1) When I run this, etch time I keep getting the error saying that constraint isn't found when I try to drop because my creation of the constraint at the end for some reason isn't creating it or being run
2) The first insert doesn't insert anything, although I get no errors
ALTER PROCEDURE Categories_I
3) I also get this when trying to run just the first 2 insert statements together
Msg 2627, Level 14, State 1, Line 7 Violation of PRIMARY KEY constraint 'Category_PK'. Cannot insert duplicate key in object 'Category'
ALTER PROCEDURE [domainnamemyaccountname].[Categories_I]
AS BEGIN
/* delete contents from Category table and reseed Cannot use truncate on a table which contains constraints therefore use DBCC to reset the seed and DELETE to clear the records */
ALTER TABLE dbo.Category DROP CONSTRAINT Category_Category_FK1 PRINT 'Dropped FK' SET IDENTITY_INSERT Category ON
INSERT INTO dbo.Category (CategoryId, ParentCategoryID, [Name], [Description], DisplayOrder, DisplayInExplorer, Keywords, Active, CreateDate, CreateUserID) SELECT 1, 1, CategoryName, '', 1, 1, '', 1, GETDATE(), 1 FROM CategoriesStaging WHERE CategoryName = 'All'
PRINT 'Inserted All Record'
INSERT INTO dbo.Category (CategoryID, ParentCategoryID, [Name], [Description], DisplayOrder, DisplayInExplorer, Keywords, Active, CreateDate, CreateUserID) SELECT 2, 1, CategoryName, '', 1, 1, '', 1, GETDATE(), 1 FROM CategoriesStaging WHERE CategoryName = 'Store'
PRINT 'Inserted Store Record'
SET IDENTITY_INSERT Category OFF
/* Finally, insert the rest and match on the Parent Category Name based on the CategoryStaging table */
WHILE (@@ROWCOUNT <> 0) BEGIN INSERT INTO dbo.Category (ParentCategoryID, [Name], [Description], DisplayOrder, DisplayInExplorer, Keywords, Active, CreateDate, CreateUserID, UpdateDate, UpdateUserID) SELECT c.CategoryID, s.CategoryName, '', 1, 1, '', 1, GETDATE(), 1, GETDATE(), 1 FROM Category c INNER JOIN CategoriesStaging s ON c.[Name] = s.ParentCategoryName WHERE NOT EXISTS (SELECT 1 FROM Category c WHERE s.[CategoryName] = c.[Name]) END PRINT 'Inserted Rest of Category Records'
PRINT 're-create FK Call' ALTER TABLE dbo.Category ADD CONSTRAINT Category_Category_FK1 FOREIGN KEY ( ParentCategoryID ) REFERENCES Category ( CategoryID ) PRINT 'create FK2' END
Other errors:
(1 row(s) affected) Checking identity information: current identity value '2', current column value '0'. DBCC execution completed. If DBCC printed error messages, contact your system administrator. Msg 3728, Level 16, State 1, Line 6 'Category_Category_FK1' is not a constraint. Msg 3727, Level 16, State 0, Line 6 Could not drop constraint. See previous errors. ALTER TABLE statement conflicted with COLUMN FOREIGN KEY SAME TABLE constraint 'Category_Category_FK1'. The conflict occurred in database 'Chefs2', table 'Category', column 'CategoryID'.
I'm not at all comfortable with SSIS so please forgive me if I overload you all with information here:
I need to create a data table using SSIS which does not delete the previous days data. So far all the data tables we use to write reports in Visual Studio are constructed in SSIS as follows.
1 - Excecute SQL Task - DELETE FROM STOCK 2 - Data Flow Task 3 - Data Reader Source - SELECT * FROM ODBCDATASOURCE 4 - OLE DB Destination (Creates table STOCK)
The data tables which are created this way are stored in a data warehouse and scheduled to refresh once a day, which means that any data from yesterday is lost when the updates run. So, I tried to create a table which never has its previous days' data deleted by using just the last three steps above - and it worked great in Visual Studio, no problem at all. However, when I added this SSIS Package to the Update Job in SQL Server Management Studio, the job totally rejected the packed with the message: "The command line parameters are invalid. The step failed".
I thought I could work around this problem by asking the job step to excecute a simple SQL query to insert the data from table1 into table2 (and would thus negate the need for a SSIS Packege at all), but it threw me a curve ball with some message about not being able to use proxy accounts to run T-SQL Scripts.
If anyone knows how to create a SSIS package in which the data never expires please could you impart some wisdom my way. I only need to do this once for a specific report.
Please, when answering, bear in mind that I'm a simple fellow with little understanding of the inner workings of SQL Server and its various components, so please use short sentences and simple words.
The 6:th of march Sql server data tools for Visual Studio 2012 was released.
[URL]
I seem to be unable to install this using the link provided on the blog page. I'm getting a "Same architecture installation" error. Running on the machine is Visual Studio 2012 Premium & Sql Server 2012 (64bit).
I am trying to install SQL Server 2000 on a Win2K OS machine but Iget this error message:"A previous program installation created pending file operations onthe installation machine. You must restart the computer before runningsetup."I see others have had this problem but have fixed it using the solutionin:http://support.microsoft.com/defaul...kb;en-us;312995I have tried the solution but to no avail. The registry key:HKEY_LOCAL_MACHINESYSTEMCurrentControlSetContro lSessionManagerPendingFileRenameOperations keeps reappearing as soon as Iclose RegEdit.Any ideas?Thanks,lq
Please help,I am trying to install MSDE 2000 so that Backup exec will run on thisserver. I have gotten so far as to find an entry in my SQLSTP.TXT filethat says that c:mssql7 was detected so the install fails.Now, to start with there is no directory called C:mssql7 on thisserver. I have gone through all MS articles on manual removal of SQLserver and instances. I have searched the registry for mssql7 andremoved any keys that matched, as per MS article I have searched onSQLBOOT.dll and it is not present anywhere on my system and I still getthe same results.2:07:44 Begin Action: Detection12:07:44 SQL Server version already installed: 7.00.62312:07:44 Previous Install SQL Path: C:MSSQL712:07:44 Previous Install SQL Data Path: C:MSSQL712:07:44 End Action Detection12:07:44 Begin Action: ODBCLocked12:07:44 End Action ODBCLocked12:07:44 GetDefinition returned: 112:07:44 Previous SQL Server ProductType: MSDE [0x4]12:07:44 This combination of Package and Operating System allows a fullproduct install.can anyone think of anything here..what else could be causing the server to think there is a previousversion of SQL 7 on this box!!!?
I get an error when trying to install the SQL Native Client. It says it cannot find the installation package and to use a valid copy of 'sqlncli.msi'. I've downloaded the Express setup twice and get the same error from both of them.
I'm attempting this in a VMWare session setup for Windows 2K, Advanced Server. I am trying to test my installation and setup procedures. This is not a production setup, just install testing and documentation. I have allocated only 272MB to the VMWare session, which is why the system doesn't meet the recommended settings.
Any help would be greatly appreciated.
Below is the Summary.txt output file.
Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows 2000 Advanced Server Service Pack 4 (Build 2195)
Time : Wed May 03 09:54:23 2006
CPCWIN2KVM1 : The current system does not meet recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
Machine : CPCWIN2KVM1
Product : Microsoft SQL Server Setup Support Files (English)
Error : An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'.
Error String : An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'.
I'd like to install SQL SERVER 2005 Express Edition ,I begin to install it from DVD but during the installation it dosn't ask me about any instance and after installation there isn't SQLExpress service and I can't use sql server .(there are not MSSQL and Binn directory in sql server 2005) but when I install visual studio 2005 and after that I install sql server 2005 it ask me for name of instance and with this way every thing is ok and I use sql server completely.
I 'd like to know the complete installation of sql server 2005 is depend on installation of visual studio 2005 befor it ?if not how can I introduce any instance after installation of sel server 2005 .
Hello, Yesterday, to start SQLServer, I have used the DOS Command setup SAPWD=xxx from C:sql2ksp3MSDE. I think tne mix mode of authentification is correct. But when I want to connect to the database by SQLEntMan, it doesn't work ... How can I connect to SQLServer ? Server adress = name of the computer Username = ? Password = password of windows ? password of of SAPWD ? Thank you any help Ben
Hi, I ama trying to install SQL Server Express 2005, when the setup.exe does an anlysis of the machine configuration it tellme that out of 10 checks one has failed, and that the machine needs tobe rebooted in order to fulfill a requirment from a previous installation, I did this and went to start the installation process again only ot be told that this check failure still exists, unfortunately I cannot progress, has anybody experienced this, I am using Windows XP Hone, with ASP.NET 2.0 installed and Web Dev Express 2005 Beta 2Looking forward to hearing fom you
I am trying the SQL 7 STANDARD installation on WIN`98. However, it creates the directory structure on the hard-disk alonwith files but on connecting to server it comes out with a VC++ assertion failed message.
The TCP/IP sockets are being used and the TCP/IP port (local ping) is working fine. Windows 98 was installed again and there are no prequisites for SQL 7 on 98 but the problem persists !
We ran SQL Replication in Production SQL 7.0 with SP1. We encountered some problems. We ran the same tests in QA which used SQL 7.0 with SP1. The problems were gone.
Both Production and QA used SQL 7.0 with SP1 but they came from different resource CDs. Production one was installed from Microsoft Select CD in 1998. I did not recall the CD which was used for QA.
It indicated those two SQL 7.0 functioned differently and Production on had a bug in it. Can somebody to share with me a detecting tool and a criteria to find out where is wrong in the Production SQL 7.0?
Hi, I am having pentium 3 with windows 98 I had Sql Server 7 installed But due to some problem i uninstalled it. I am having difficulty in reinstalling the same i uninstalled completely and even removed entries in registry and tried to install But i am getting the same error always.
1)Acmsetup failed 2)setup failed to configure the server Refer to the server error logs and cnfgsvr,out for more information There is nothing in server error logs
cnfgsvr.out file looks like this Starting Service ...
An error occurred while attempting to start the service (1460)
SQL Server configuration failed.
What is ACMSETUP what it does how i can prevent its failure is the failure of ACMSETUP a reason for sqlserver set up failure
I have installed sqlserver 2000 (desktop edition) on my pc at home. I am running windows xp home edition. what i am finding is i am not able to log in to either Enterprise Manager or Query Analyzer. I have tried using different accounts during installation. The service has started and the server seems to be running, but I cannot make a connection.
We have installed SQL Server 6.5 in an NT system. We are able to start and stop the server from a client enterprise manager, but unable to connect to the databases there(ie., we are able to right-click on the server and start and stop the server but unable to right-click and connect to the server). Can anyone help us out with this?
Hey guys, I'm new to this and had some general questions. I'm currently running windows xp pro with sql server 2005 tools installed. However I cannot deploy any of the reports due to not having IIS installed. I've now installed IIS however, do I need to completely uninstall SQL Server 2005 tools and is there a particular order to uninstall it in order to get everything to work?
I tried to install sql server 2005 professional Edition in my machine.While doing the step by step installation, it was not showing the " Instance name " and " server accounts" ( i.e whether it is built-in system account or domain user account) slides and so finally i am not able to complete the installation. Kindly help me to rectify this. Thanks in advance.
Hey Guys,Im going to install the SQL Server 2005,can any one tell me what are the things do i need to know before the installation.Its 64 bit and clustered.Active/passive
I am new with SQL and have a question regarding SQL Connections. I have 2 Win2003 Servers(tom and Jerry) setup with Microsoft Cluster installed in Active-->Active Mode. Also, on both of these servers, I have SQL 2000 installed in Active-->Active mode as well. So I installed SQL2000 on Tom first and gave the SQL server name of Dog1 which has and IP assigned to it, at the same time I gave an instance name of D1. So now my SQL on Tom server reads Dog1D1. I did another installation on Tom and gave it Dog2D2. Than I went and installed SQL again on Jerry, this time and gave name of CatC3, and CatC4.
Now in my DNS, I have Dog1, Dog2, Cat3, Cat4 defined with an IP I assigned.
Problem I am running into is I cannot connect my application or make and ODBC connection to Dog1D1, Dog2D2, Cat3C3 or Cat4C4. I am getting Server not found message.
Can anyone help me and tell me where I am going wrong, as I need to get this app up ASAP.
Hi guys, i am new to the forum. i got sql server 2000 and i wanted to install it on my home pc. i am able to do that.
But when i create a database out of it and then take it out of the SQl folder and put it in some other folder in my C: drive and then if i try to link it to my program it gives me a error stating that it is not accessible.
MY QUESTION : Am i doing something wrong ? Do i have to set some properties on the database i create?if yes how to do it?
Hi, SQL Server 2005 has been installed on windows server 2003 machine by the support team. Microsoft SQL Server Management Studio9.00.3042.00 Now this machine has been passed on to me to create databases, tables, etc... On this server, I open the management studio and I get the connect to server windows. What should the entries in the connect to server window be for me to get to the next stage where I can start building databases. At present, I tried local or localhost and windows/sql authentication. Still can not get to the management studio window. Any thoughts please? Thanks
Hi experts, I have installed SQL server 2005 Standard edition and SP2 in production box, after completion of installation the perticual production server is not connecting, but every other servers are getting connect through that instance, and one more main issue is i could not able to see this instance in SERVICES.MSC, I was wondered, how come it is not showing!!!!!!!!!!!!!!!!
i m trying installing sqlserver 2000 in my PC(WIN XP). all the process are happening properly.. but while starting SQL and Configuring the database the setup exists and throws the message to check sqlstp.log.
HiWe have the following setupW2k server with IIS 5.0Asus P4P800E Deluxe MoboP4 2,8 Mhz - 1 Gb Ram3 sata harddisks1 hd = 2 partitionsc: boot/systemf: backup2 hd's in a raid 1 (mirror) Promise controllere: webrootWhere would be the best partition to install a MS SQL2000 databas?It's possible to install a 4th ide harddiskKitty
I had SQL Mobile installed on my XP PC. As I wanted to use INSERT IDENTITY, I uninstalled SQL Mobile from my Pc. Now I see two problems: 1. Even after uninstalling SQL Mobile and rebooting my PC, I still see SQL Mobile option when I start SQL Server Mgmt Studio. Any reason why?
2. I then installed SQL CE desktop runtime (nearly 1.8 MB) and rebooted my Pc. Now when I go to Query Analyzer, I still cannot use IDENTITY Insert.
3. There seems to be two versions of CE download: one for desktop and one for mobile. Can anyone let me know which one I should download for desktop? And for deployment on device which version I need to download?
I started migrating from C++ and want to use C# with an embedded database in my application. My search pointed to MS SQL Server 2005 compact edition. I go to download it and seems like there are two versions to choose from:
MS SQL Server Compact Edition 3.5 Can't use it because it requires Visual Studio 2008. I have VS 2005 and don't want to spend another chuck of money just to work around this one problem.
MS SQL Server Compact Edition 2005 Can't use it because Vista is not a supported operating system for development and it requires Active Sync 4.0 which also will not install on Vista.
I am just screwed because I am using Vista as my development machine, even when I am not targeting Vista for my applications?
Is there anything I can use for a simple embedded data storage solution with VS 2005 and Vista, using C#?