Answer Questions

• Khenat.Ram SQl 2005 Setup failure for cluster

  Installing SQl2005 into on Win2003 2 node cluster, at the very end of the setup receive a message 'Remote Setup failed'. Referred to some sql logs and found this; Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run: "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 1603 Aborting queue processing as nested installer has completed Message pump returning: 1603 I've seen some similar errors on the web and suggestions about the Task Scheduler being started on both nodes, but I ensured these were both started before the install. SQL2005 does seem to be ok on the node1 where the install was made, but ...Show All

• jdang Running SSIS package from SQL Job

  I'm trying to run a SSIS package (dtsx) from inside an sql job (SQL Server agent). This works fine if the user running (run as) the step is a local admin on the server. If it's not, I get the error message "The package could not be loaded. The step failed". This happens even if the user has all possible serverroles such as "sysadmin" etc in SQL. So, my question is, is there any way to load an SSIS package without being local admin on the machine In case it is, what is needed regards Andreas I'm not sure that this will solve the problem, but have a look at PROXY and CREDENTIALS - I was able to invoke a sample package using them, using a user that was only a member of the USERS ...Show All

• ZopoStyle Navigation buttons

  Is there a way to add the navigation bar with next page, previous page etc buttons at the bottom of the report. If the report is long the users dont want to scoll up to click on next page. Thank you Daniel. There is no easy way to accomplish this. It can not be done in Report Manager. If you are writing your own web app you could do this by writing your own tool bar, but it would require quite a bit of code. ...Show All

• tonyerfer data mining

  Hi to all, Wat is data mining what is the use of data mining in SQL wat is the difference between SQL 2005 and sql2000 Thanks & Regards Mani A good place to start is http://www.microsoft.com/sql/technologies/dm/default.mspx http://www.sqlserverdatamining.com ...Show All

• Samant B Jain SQL BACKUP ERROR

  I upgraded from SQL 2000 to SQL 2005. All is working fine except when I try to backup the DB, where I get the following error: " The backup of the file or filegroup "sysft_TestCatalog" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. " Any suggestions My problem is that I do not know what filegoup "sysft_TestCatalog" the server is claiming. I never used this name "sysft_TestCatalog" and I do not even have an idea what it might be. Have you checked to ensure that all filegroups for the database are online ...Show All

• rdleeper Rename SQL 2005 Instance

  Hi, I have a SQL Server 2005 installation, running under the instance of MyServer\SQL2005. So I have 1 instance called 'SQL 2005'. I would like to rename the instance back to the default instance. So afterwards, the server instance should just be called 'MyServer'. Does anyone know if this is possible without loosing any data Thank you Jeremy Jeremy, You can rename a default instance of the database engine just by renaming the computer. See the topic "How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server 2005" in BOL. You cannot rename the instance part of a named instance. Ron http://groups.google.com/group/micros ...Show All

• dragoncells OLEDB Destination Error in SSIS Package not returning error column/desc

  I have a SSIS package that reads data from a dump table, runs a custom script that takes date data and converts it to the correct format or nulls and formats amt fields to currency, then inserts it to a new table. The new table redirects insert errors. This process worked fine until about 3 weeks ago. I am processing just under 6 million rows, with 460,000 or so insert errors that did give error column and code. Now, I am getting 1.5 million errors. and nothing has changed, to my knowledge. I receive the following information. Error Code -1071607685 Error Column 0 Error Desc No status is available. The only thing I can find for the above error code is DTS_E_OLEDBDESTINATIONADAPTERSTATIC_UNAVAILABLE To add to the confus ...Show All

• Damien fromOZ Export to excel button

  Hi, I would like to have a button on my report to export it to excel (instead of having to choose the format from the toolbar and then press "export"). Is there a way to do it I know that there is a parameter that I can add to the url for this but i don't know exactly how to add it to the current url from my report). Thanks. I didn't get how this help me i need to get the full url in order to add my EXPORT parameter to it. I'm also working with oracle and the command "select @@servername as 'a'" did dont worked. thanks Parameters can simply be added after the report name as the following: ReportName ParameterName=SomeValue AnotherParameterName=Anot ...Show All

• Jawad Naeem How can I connect to a remote sql server using windows authentication?

  It is simple   1- I open the Sql Server 2005 Management Studio 2- I select Windows Authentication from the drop down. 3- I cannot write the user name and password, it chooses the default once, the one I am logged in with!   But I am in a virtual machine outside the domain controller, I can access shares on machines that are on the domain controller, thanks to the file sharing of windows, but I cannot login to sql server, thanks to a meaningless restriction on that dialog :-)   Now, how can I still use the Windows Authentication and login, how can I avoid the sql server authentication     The reason for the textbox is just to let you know which Wind ...Show All

• PeterVrenken Bulk insert and splitting content into collumns

  Hi, when i try to load XML file into a table with bulk insert, i get bunch of errors: Msg 4864, Level 16, State 1, Line 2 Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 1 (cislo_subjektu). My guess it is, that it has something to do with 11 different collumns defined in dbo table and this command's lack of some specification about where to put which value. BULK INSERT pokus.dbo.organiz FROM 'D:\organizace.xml' /* my file */ WITH (FORMATFILE = 'D:\organiz-x-c.xml'); /* formatfile*/ GO Is there a way to split content of loaded file into correct collumn in dbo table what's the bcp command of the above script ...Show All

• Greg Y Unable to save query

  Hello and thanks in advance for any advice. I have an application being written in C#, the forms and such are used to show, input or otherwise manipulate data within the tables of the connected database. The database is an SQL Database File (.mdf) and has been created within the project. The problem is I need to create a form which uses the data of a query but when I create the query (right-clicking in the 'Server Explorer' and selecting 'Add Query') and after configuring it how it should be I choose save all and nothin happens, the query is nowhere in my DB or project and it wont even let me rename it in the properties window, before or after I save it. Basically this application is a replica of one I have written for college in Access(vb ...Show All

• Heino Enable and disable websync.log

  Hi, is there a way how to enable / disable logging on web merge synchronization into the file websync.log The file exists in the ISAPI folder, on some machines there are some messages, on others there is nothing. There are Timeout messages on the client during synchronization and we need to find where is the problem, if it is on the server side or if it is a network error or something else. Thanks, Pavel Yes, I have tried to create virtual directory few times and nothing has changed. I can't realize any change on the server, which could switch off logging. Another thing is, that we need to monitor production system in which we cannot change virtual directory. In the test enviroment we have not any pro ...Show All

• n0n4m3 The Cross Join Operator (*) Can be Very Slow

  Has anybody else seen cases where replacing the * operator with the CrossJoin() function will dramatically improves performance In a support case I have open with MS, they asked me to change my syntax in that way and I was very surprised by the improvement. I was also surprised because previously I've heard that CrossJoin() and the * operator " are completely equivalent from the functional and performance standpoint". The kicker is that the time intelligence wizard uses the * operater by default. Operator * can mean not only CrossJoin but also scalar multiplication. Therefore is the context is ambigious, the decision whether it is CrossJoin or multiplication must be done dynamically, and therefore static optimi ...Show All

• CiNN Web Synchronisation Using RMO

  hi every body please help me out on this issue , since i am at final stage in finishing up the module. Previously i had done web synchronisation using RMO it is working fine at my office where i have an 2003 server which is an domain controller , publisher i have configured on the 2003 server , and i had subscribers on xp Machines where it was well working fine, clients were not on the domain , it is an independent Machine. we had an security error which was resolve by this same forum, ie the client windows login id should exists on the server too. only then synchronisation is happening at our office, Now the problem is i have an same setup , but the server 2003 is hosted at a remote place , which is not an domain controller, n ...Show All

• BarataMota SSIS problem after installing 2153 hotfix

  The Kb article says to install all component patches, even if you are not running them, to avoid errors...the reporting services hotfix would not install(obviously since reporting svcs is not installed).....now I get the following erro, when trying to connect to the SSIS on my sql server...oh, I am trying to connect locally on the server it self too.... Cannot connect to CRP-DAY1-SQLs1. =================================== Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) ------------------------------ For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ Program Location: at Microsoft.SqlServer.Management.Smo.Enumerator.Process( ...Show All