I downloaded VisualBasic 2005 Express Edition recently, and the installation went flawlessly, but when I tried to download the optional component SQL server express, the installation failed. When two subsequent installations failed, I decided I'd get along without it, until such time as I discovered I *needed* it. Well, I'm here, and the installation is still failing. I've tried both installing it though the VBstudio setup, and downloading it separately, but both fail at roughly the same point. The error from the standalone installation is more descriptive:
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=29513&EvtType=sqlca%5csqlmofca.cpp%40Do_sqlMofcomp%40Do_sqlMofcomp%40x80041002
The link leads to an apology - they have no information on this subject. Of the help files, the troubleshooting page contains nothing (noticeably) relevant, and the log files have nothing obvious either, at least as far as I could tell... but then, I have no idea, which is why I'm here
I'm trying to install Microsoft SQL Server 2005 Express Edition (x86) on my laptop when a setup failure message would show up at the end. When I clicked for more details it has the followings:
Product Version 9.00.3042.00 Message Source setup.rll Message ID 50000 EvtType sharedsetupsharedsetupactions.cpp
And later when I tried to uninstall it from Add/Remove Program the screen would simply flash when I click but nothing happens.
Please let me know what do I need to install the piece correctly, thanks!
I successfully installed SQL Server 2005 SP1 on one PC. When I attempt to install it on a second PC, however, I get the following obscure error:
Unexpected Error Occurred The following unexpected error occurred:
That's right, there's nothing else listed, other an OK button. D'oh! When I press the OK button, the following error report dialog box appears:
Hotfix.exe A recently applied update, NULL, failed to install.
There are no pending updates that I'm aware of, as I just booted the PC. I sent the error report.
I notice on this particular PC that the SP1 install EXE is expanding/writing to an external SCSI drive; would that make a difference? I don't see a way to specify a different (i.e., internal ATA drive).
Guys can you help please... At the moment I have an unknwon number of ID's and need their related info in another table (1,2,3,4,5 for example) and I'm looping and merging to get them as one table: For i = 1 to however many... Dataset = Select where ID = array(i) FinalDataset.Merge(Dataset) Next How can I write a stored proceedure or something where the loop is happening at the database end, to avoid going back and forth? I was thinking dynamically generating the sql statement: Select * from table where ID = 1 or ID =2 or ID =3...... But this could become huge if you had a couple of hundred to do...there must be a more efficient way to do it...
I have a date that is entered into the field, 12/17/2004. My client wants the site set up so that when after the date is entered, it automatically updates itself every week. So the date represents an event, and he wants to update the event date automatically instead of having a user login and update the date manually. So 12.17/2004 shoudl turn into 12/24/2004, and then 12/31/2004 and so forth.
One brilliant guy told me that if you entered a start date of and an end date then some how that might me be a little easier.
I have a situation where a common table within multiple databases across multiple servers is randomly getting corrupt. The database schema is identical for each database. There are approx. 200 copies of the database on each server. I am seeing one or two errors per week. There doesn't seem to be any similarities between the databases that are effected... It is always the same table that gets corrupted. The mulitple servers are using a SAN but since it is different databases / common table I have a hard time believing it is hardware related.
The error that the application throws is: Microsoft OLE DB Provider for ODBC Drivers (-2147467259) [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find the index entry for RID '16b700000000000000030002' in index page (1:5366), index ID 0, database 'DISOPT'.
When running a DBCC on the table the following is returned:
Database DISOPT consistency errors in table TF_FILE_METADATA_VALUES fixed no data loss reported. DBCC results for 'TF_FILE_METADATA_VALUES'. The error has been repaired. Clustered index successfully restored for object 'dbo.TF_FILE_METADATA_VALUES' in database 'MUTGEN'. There are 277 rows in 2 pages for object 'TF_FILE_METADATA_VALUES'. CHECKDB found 0 allocation errors and 1 consistency errors in table 'TF_FILE_METADATA_VALUES' (object ID 1332199796). CHECKDB fixed 0 allocation errors and 1 consistency errors in table 'TF_FILE_METADATA_VALUES' (object ID 1332199796).
This corrects the problem and the app functions as normal. The errors are random across databases but ALWAYS the same table.
Hi! My problem/"goal to achieve" is the following.. Users can insert orders in a db-table. The date on which they've been created is stored. I want the server to insert a new record in another table (accounts) for every order which is older than 2 weeks. How should I do that? With a custom action which checks all orders (a customer must press some button every day). Or a static "update-class" with a kind of timer which does the action every 24 hours? Of course an automatic solution will be the best! Another question is: how can i ensure that an instance of this "update-class" will never die? Thanks so far...
I have been asked to add a feature to some software I have written which needs to send reminder emails.
The reminders can have a recurrence, for example it might recur every 3 days or every 2 weeks. The reminders also have a start and end date. I have created a sql table with these fields:
I now need to write a stored procedure that will run every morning and send the reminders. I have no problem with sending emails from sql, the trouble I am having is I cannot figure out how to get the recurrences for the current day.
Hope this makes sense!
Sorry there is no code sample, I have been thinking about this one for a couple of days but I still don't know where to begin!
If anyone could offer any help it would be greatly appreciated!
We have some SSIS packages that are running on a recurring SQL Job. They work and play fine. They ran for about three iterations and then decided to stop....they don't report errors, they just don't do anything. They sit as if they were disabled (but they aren't disabled, I checked the MSDB database).
You can manually execute the packages and they work fine.
I have dumped and reloaded these packages and that hasn't fixed the issue.
If I setup a simple recuring job that executes a sql script every few minutes that works fine and you can see that it executes every few minutes. But these SSIS packages just sit....and do nothing. But they were working for the first few iterations.
I have also redeployed the SSIS packages and that hasn't fixed it either.
Ok, basically, my SSIS flow gets data from different excel worksheets and puts in the db.
For some reason its being very incosistent. I fixed all the problems I was having but one component keeps coming up with the [ component "Excel Source" (1)" failed validation and returned validation status "VS_NEEDSNEWMETADATA" ] error.
So, I click on the component, it asks if i want to fix the metadata stuff, I say yes, it fixes it, I run the app, everything's cool.
The I run the app again and again it comes up with this f** error?
Is there anyway SSIS can't just ignore this metadata stuff??
I have created a SSIS package which calls child packages internally. In other words there is hierarchy of packages. I am using For Loop Container with certain check conditions to execute whole set of packages repeatedly. I have to execute this set for almost 5000 times. But my problem is this set fails after every 50 and sometimes 55 cycles. Can Anybody let me know how to get solution for such a problem?
Hello, This is my first project at the company I recently joined. It is the most challenging project I ever had.
It is a kind of web-scheduler. it let you save appointments which could be one time or periodic. For example, it could be like every monday, every other monday, first tuesday every monday, and so on.
once they are saved, it should be able to display only those appointments the user have on a specific day.
I'd like to know how database has to be designed to meet such a challenging requirement? I'd like to hear anything from you if you have had similar project before.
I am trying to load Project Real. I get warnings when opening the RecurringETL package. However I created the two environment variables it's looking for and have confirmed these variables are functional. I am unsure how to troubleshoot this and am afraid to do anything given these warnings. Where is the configurations collection??????:
Warning 1 Warning loading TestHarness.dtsx: The configuration environment variable was not found. The environment variable was: "REAL_Configuration". This occurs when a package specifies an environment variable for a configuration setting but it cannot be found. Check the configurations collection in the package and verify that the specified environment variable is available and valid. C:Microsoft Project REALETLTestHarness.dtsx 1 1
Warning 2 Warning loading TestHarness.dtsx: The configuration environment variable was not found. The environment variable was: "REAL_Root_Dir". This occurs when a package specifies an environment variable for a configuration setting but it cannot be found. Check the configurations collection in the package and verify that the specified environment variable is available and valid. C:Microsoft Project REALETLTestHarness.dtsx 1 1
Warning 3 Warning loading TestHarness.dtsx: Failed to load at least one of the configuration entries for the package. Check configurations entries and previous warnings to see descriptions of which configuration failed. C:Microsoft Project REALETLTestHarness.dtsx 1 1 Thanks
I have a problem where I want to write a function to remove recurring characters from a string and replace them with a single same character.
For instance I have the string '12333345566689' and the result should be '12345689'. In Oracle I could do this with "regexp_replace('12333345566689', '(.)1+', '1')", but in T-SQL the only solution I could think of is something like this:
DECLARE @code NVARCHAR(255) SET @code = '12333345566689'; SET @code = REPLACE(REPLACE(REPLACE(@Code, '1', '~1'), '1~', ''), '~1', '1');
and repeat this for 2 - 9. But I'm sure there is a more elegant version for this in SQL Server 2012.
I am having a recurring issue that involves a stored proc using OPENROWSET to query an excel file. I used the surface area config to enable this on the server, and made sure that is still set. After an undetermined amount of time, the OPENROWSET query starts failing with this message:
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
I corrected this previously by restarting the SQL server, but not before I checked permissions, the excel file itself, etc, and that was the last thing to try.
I am using SQL 2005 with SP1 installed - my primary approach to tackling this issue is to install the SP2, but I did not find this bug referenced in the fixes, and was wondering if anyone else had further insight.
I Everytimes I run a software I wrote on the server I get the following error:
Process ID %d attempting to unlock unowned resource %.*ls.
Does anybody experienced that type of problems before?
have a copy of the database and of the sfotwqre locally on my win 98 machine where it runs without problem. Once I try on the server it crashes miserably.
In an attempt to 're-cluster' SQL Server 7.0 after re-installing SQL to change Sort Order, I am recieving the following error when I run the Failover Wizard. "Could not update remote nodes in Cluster". And here is the error from the sqlsp.log
13:50:05 Begin Setup 13:50:05 7.00.623 13:50:05 Mode=Silent 13:50:06 ModeType=SecNode 13:50:06 LoadLibrary failed on supporting DLL. 13:50:06 An internal error occurred during install (failed to load package id). Contact Microsoft Technical Support. 13:50:06 Action CleanUpInstall: 13:50:06 Installation Failed.
I am getting the error 'Incorrect syntax near the keyword set' with the following code snippet -
declare @dteTo Date set @dteTo = CONVERT(date, GETDATE())
My intention is to set the variable @dteTo to the current date (no time component). If I run a SELECT CONVERT(date, GETDATE()) command I do get what I want, it is just assigning the value to the variable that isn't working as intended.
I've just installed SQL Server Express and attempted to create my first database and received this error message :-(
Maybe this is a long shot, but can someone tell me what I've done wrong? Do I have a bad install or what?
Essentially I followed the steps below to create the database:
1. Started MS SQL Server Management studio Express 2. Right clicked on the Database folder 3. Selected "New Database..." 4. New Database panel displayed 5. Entered name of database - pip 6. Clicked "OK" 7. Receieved error dialog with followig message:
TITLE: Microsoft SQL Server Management Studio Express ------------------------------
Create failed for Database 'pip'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
Could not obtain exclusive lock on database 'model'. Retry the operation later. CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (Microsoft SQL Server, Error: 1807)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=1807&LinkId=20476
Exception has been thrown by the target of an invocation. (mscorlib)
------------------------------
The connection type "EXCEL" specified for connection manager "{55E5636D-F2A9-48D6-9723-867C9F241F5B}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name. ({F390DBA3-1B52-43F4-A624-9E71D273B4D7})
I really need to get this data into SQL server... why do I have to go through SQL 2000?
I've inherited an application that has a query that typically bombs out due to a deadlock in SQL Server 2005. I know where the resource contention is, and why the deadlock happens, and why SQL picks this query to fail, so that's all cool with me. My problem is that I'm in the process of modifying this query to be a little less resource intensive, and I'm getting two different result sets.
The original query is returning 1234 rows, and my first replacement query attempt is returning 930. My replacement query attempt is using a derived table (subquery) rather than copying into a temp table (as the original query is doing). I understand what the missing rows are and why they are not in the result set, so my question is What is it about my replacement query attempt that is so different from the original query?
I appreciate any advice anyone might have to offer.
Best, B.
/* original query */
Code Block
select * into #response from response where MidEndFlag = 'End'
SELECT COUNT(#response.ResponseID) AS TotalCount, CourseInfo.Subject, CourseInfo.Course, CourseInfo.Sect, CourseInfo.Term, CourseInfo.Enrollment, (COUNT(#response.ResponseID) / (CourseInfo.Enrollment * 1.00))* 100 AS Percentage, #response.MidEndFlag FROM #response FULL OUTER JOIN CourseInfo ON #response.Term = CourseInfo.Term AND #response.Subject = CourseInfo.Subject AND #response.Course = CourseInfo.Course AND #response.Sect = CourseInfo.Sect WHERE (courseinfo.InstructorSelectionEndFlag = 'Y') and CourseInfo.Enrollment > 0 and courseinfo.term = @term GROUP BY CourseInfo.Subject, CourseInfo.Course, CourseInfo.Sect, CourseInfo.Term, CourseInfo.Enrollment, #response.MidEndFlag; /* end original query */
/* my first replacement query attempt */
Code Block
SELECT COUNT(r.ResponseID) AS TotalCount, c.Subject, c.Course, c.Sect, c.Term, c.Enrollment, (COUNT(r.ResponseID) / (c.Enrollment * 1.00))* 100 AS Percentage, r.MidEndFlag FROM (select * from dbo.Response where MidEndFlag = 'End') r full outer join CourseInfo as c ON r.Term = c.Term and r.Subject = c.Subject and r.Course = c.Course and r.Sect = c.Sect WHERE c.InstructorSelectionEndFlag = 'Y' and c.Enrollment > 0 and c.term = @term and r.MidEndFlag = 'End' GROUP BY c.Subject, c.Course, c.Sect, c.Term, c.Enrollment, r.MidEndFlag;
I have a log table with no indexes, triggers, or keys. During the course of development, I will clean out the entries by selecting all the rows (in Database Explorer) and hitting the delete key.
I get the following exception when attemption to create a connection from my i5 to our SQL Server:
Nov 5, 2007 10:09:33 AM com.microsoft.sqlserver.jdbc.TDSChannel enableSSL WARNING: TDSChannel ( ConnectionID:1 TransactionID:0x0000000000000000) SSL handshake failed: null com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: null. at java.lang.Throwable.<init>(Throwable.java:195) at java.lang.Exception.<init>(Exception.java:41) at java.sql.SQLException.<init>(SQLException.java:40) at com.microsoft.sqlserver.jdbc.SQLServerException.<init>(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(Unknown Source) at com.microsoft.sqlserver.jdbc.TDSChannel.throwSSLConnectionFailed(Unknown Source) at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
I am using sqljdbc.jar version 1.2 and the classes load properly during the launch of the JVM.
I put 'encrypt=false' in the connection properties and everything I've looked at on the SQL Server side shows that SSL isn't being used on that end. Is there any diagnostic method I can use to determine why the driver is attempting to use SSL?
I have an application which works with SQL Server. When the application attempts to load a page it needs to run certain queries. When it attempts to run a particular query it fails but I catch the exception and then log it. The following is logged:
System.Data.Ole.Db.OleDbException: Login failed for user 'CWAMB01DWH01ASPENT'.
Now what I don't understand is that this is the work group that ASPNET is run under, and I am running other queries to the database via SQL Server authentication. Why am I getting a failed login for this workgroup? Do I need to create a new Login for the Server in SQL Server, and then create a new user for the database with the same username as the Workgroup name? If so, then how does the password work for the SQL Server as the workgroup (CWAMB01DWH01ASPENT) obviously doesn't have a password.
Thanks, and I hope I have explain my problem clear enough.
We have 2 servers both running sqlexpress2005, both have service pack 1 installed, both have the same db (same tables etc.) both have the same users with the same passwords. Everything is identical.
What I want to do is move the db. I am attempting to do this by making a backup of the db and restoring it into the second machine. (I am not sure of a more practical way to do this without stopping the SQL server).
This is the problem, the backup process works fine, without error, but when restoring the copy to the other server ,it loses the dbowner property and all default users when attempting to connect recieve a 4064 error even though all the password for users are there. Very strange.
I tried to restore the copy to to the same server that I made the copy and everything works, this only happens when attempting to restore the copy on another machine.
Do you know if this is a possible bug? I have tried to do further test on 4 different machines now and the same happens.
The objective is to be able to send the data from sqlexpress server to another by making a backup and without the need t stop the sql server. Any suggestion would be appreciated.
i'm getting the following error message when i attempt to configure my server as a local distributor:
TITLE: Connect to Server
------------------------------
Cannot connect to 9A6375C3046246B.
------------------------------
ADDITIONAL INFORMATION:
Failed to connect to server 9A6375C3046246B. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
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: 53)
this error is occuring despite the fact that i have the server configured to allow remote connections. can someone please help me troubleshoot this error? thanks.
In SQL Server 2005, via the GUI, I wish to backup a database to an additional disk file (there is already an existing backup disk file for this database), so that I can have more than one backup. I've added the new disk file name, highlighted it, and clicked OK.
I get an immediate error (see below). Note, the 2nd error message is specifying the existing backup disk file, not the new one I'm attempting to create.
"Backup failed for Server 'WCS-DEV-TPA'. (Microsoft.SqlServer.Smo)"
"System.Data.SqlClient.SqlError: The volume on device 'D:Program FilesMicrosoft SQL ServerMSSQLBACKUPWCS_ADV_Longmont.bak' is not part of a multiple family media set. BACKUP WITH FORMAT can be used to form a new media set. (Microsoft.SqlServer.Smo)"
Does anyone know what causes this and how to correct it?
I am trying to save user data to a sql table but keep getting the following error; Unable to cast object of type 'System.Boolean' to type 'System.Data.SqlClient.SqlParameter'. I am using VWD Express Edition with .NET 2.0 and a SQL 2000 database. The code that generates the error is as follows; Public Function chkUser(ByVal strUser As String) As Stringdim MyConnection As SqlConnectionDim MyCommand As SqlCommandDim ReturnString As StringDim params As SqlParameterDim SelectCmd As String = "wm_CheckUser"MyConnection = New SqlConnection(myConnectionString)MyCommand = New SqlCommand(SelectCmd, MyConnection)MyCommand.CommandType = CommandType.StoredProcedure Tryparams = MyCommand.Parameters.Add("@parUser", SqlDbType.VarChar, 100).Value = strUserMyCommand.Connection.Open()MyCommand.ExecuteNonQuery()ReturnString = "Record Exists!"Catch Exp As SqlExceptionReturnString = ReturnError(Exp.Number, "Users", Exp.Message)End TryMyCommand.Connection.Close()Return ReturnString End Function Basically, I'm traying to check to see if a user id already exists in the database before saving the data the user entered. If the email address entered by the user is already in the database I want a message to be shown to the user. If the email address does not exist then the data entered by the user is saved and the form goes to step two (2) of the user registration process. Any help with this would be greately appreciated. I can't seem to see what is wrong here. Please someone help. Thanks, Jaime
