How to change the instance name?

SQL Server Setup & Upgrade

Index ‹ SQL Server

- Previous
  - 1
    - Non-additive measures Thanks Mosha. I prefer to leave the rates in the same measure group for usability reasons and I think I have a workaround by setting the Account All member to NULL and the measure aggregate function to SUM. Let me ask a more general question. If I have an aggregate function of None, is it possible to bring up the measure leaves to the dimension leaves I haven't been successful doing so. At the same time, this is what BOL states for the None aggregate function: "No aggregation is performed, and all values for leaf and nonleaf members in a dimension are supplied directly from the fact table for the measure group that contains the measure." Why I don't see the non-additive measure values when browsing at the Account leaves then Tag: How to change the instance name?
  - 2
    - Reporting errors & output from SQL Agent I'm scheduling a T-SQL job with SQL Agent. The job uses PRINT to write out various progress and status messages as it runs. I created an Operator, and set a Notification when the job fails -- will that send me the entire output of the job, or just the error message Tag: How to change the instance name?
  - 3
    - MSSQLServer logging many missing stored procedure messages Hello, I am getting many of these messages in my server's event log (approximately 13 every 5 seconds or so). I have tried clearing the queue with "END CONVERSATION @ConvHandle WITH CLEANUP;" but the event log keeps getting messages. I have attached an example below. Type: Information Event Source: MSSQLSERVER Event Category: (2) Event ID: 9724 Date: 7/10/2007 Time: 3:52:37 PM Description: The activated proc [dbo].[SqlQueryNotificationStoredProcedure-32e779eb-edcb-44d1-ba30-93f46ef9d9f8] running on queue HoudiniPlatform.dbo.SqlQueryNotificationService-32e779eb-edcb-44d1-ba30-93f46ef9d9f8 output the following: 'Could not find stored procedure 'dbo.SqlQueryNotificationStoredProcedure-32e779eb-edcb-44d1-ba30-93f46ef9d9f8'.' Tag: How to change the instance name?
  - 4
    - VERY slow stored procedure performance on datetime parameter This is a plan related problem. See the link below for more details: http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx It has information on how parameter sniffing works, how plans are generated, how parameter values are used in the plans etc. Tag: How to change the instance name?
  - 5
    - search for last non-null field in a row? Here an idea: Code Snippet select id, date, case when c4 is not null then 'c4' when c3 is not null then 'c3' when c2 is not null then 'c2' when c1 is not null then 'c1' else null end as last_nonnull_column, coalesce(c4, c3, c2, c1) as column_value from Legacy_Table Steve Kass Drew University www.stevekass.com Tag: How to change the instance name?
  - 6
    - Help with query I'm not sure if this is the right forum but here goes: I want to make a query that selects data from multiple tables and joins it all together. I have that but what i want to do is only select the data I need. at the moment it is returning columns that are not necessary. I'm trying to do something like this: Code Snippet SELECT sysdba.OPPORTUNITY.OPPORTUNITYID AS OPPID FROM sysdba.OPPORTUNITY INNER JOIN sysdba.C_OPPTYINFO ON sysdba.OPPORTUNITY.OPPORTUNITYID = sysdba.C_OPPTYINFO.OPPORTUNITYID For some reason the Inner Join is not joining the two tables. Any one have any suggestions Thanks in advance for the help. Tag: How to change the instance name?
  - 7
    - Can't install sql server 2005 The message Rahul.Net reported is actually a different problem than what started this thread. "Please go to Control panel to install and configure system components" is usually caused by having remnants of a previous SQL Server installation. This could be the same or an earlier version of SQL Server. It could even be a client only installation - and that is what can make it particularly difficult to troubleshoot. Any number of third party applications could install SQL client software to connect with a remote SQL Server. The presence of these items can confuse the SQL Server 2005 installer and prevent it from working. You may very well find yourself needing to uninstall third party software, install SQL Server 2005, then reinstall the third party software. Tag: How to change the instance name?
  - 8
    - ReportServicesConfigUI.WMIProvider.WMIProviderException: System.Runtime.InteropServices.COMException (0x8000000A) Hi there! I installed the Sql Reporting Services under Vista Business. When i run de configuration tool, i have to select yhe machine name and instance name... then when i press connect this exception is thrown ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has occurred and no additional error information is available. ---> System.Runtime.InteropServices.COMException (0x8000000A) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options) at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus() --- End of inner exception stack trace --- at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus() at ReportServicesConfigUI.WMIProvider.RSInstance.get_DelayLoadConfiguration() at ReportServicesConfigUI.WMIProvider.RSInstance.get_Item(ConfigurationItemNames itemName) at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus() at ReportServicesConfigUI.ConfigurationManager.ChangeMachine() at ReportServicesConfigUI.ConfigurationManager.LaunchDialog() at ReportServicesConfigUI.ConfigurationManager.tsbConnect_Click(Object sender, EventArgs e) at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e) at System.Windows.Forms.ToolStripButton.OnClick(EventArgs e) at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e) at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e) at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met) at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met) at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.ToolStrip.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) Can anyone help me with this. it's Urgent Thanks Rui Fernandes Tag: How to change the instance name?
  - 9
    - Creating a Sum for the Year WHERE {what} BETWEEN @StartDate AND @EndDate Tag: How to change the instance name?
  - 10
    - New User - Unable to connect Hello, Im new to SQL Server so please forgive me if I seem a tad ignorant. Any help is much appreciated. I have just installed SQL Server 2005 CTP on my machine at home in order to learn more about it. The istallation completed successfully on my home pc under XP Pro w SP2. I use the machine with Administration priveliges. There is also a local account on the machine I could use, but I never do. No password entry is required. When I launch Management Studio it gives me the option to connect to a server and lists myself as the only option. When I select this account (the same one that has administration privelidges) it attempts to connects but times out. I receive an error message saying the server actively refused the connection. I am a little confused as to the architecture of SQL Server I suspect. I have installed SQL Server on the machine, but it seems to be behaving like a client installation. If anyone knows of any articles that may help me, or if there is a simple explanation to help get me connected, I would be most greatful. Cheers Tim Tag: How to change the instance name?
  - 11
    - problem deploying SSIS to another server. Hello, I am trying to deploy a SSIS package (using deployment utility create at build time) to a different server and ran into problem wonder if someone and direct me to the right path. development environment: WIN XP, SQL 2005. package is built using server buisiness intelligence. Package content: connect to a "target"SQL2005server using OLE DB using SQL Login authentication to process data. The SQL 2005 DB is on a Win 2003 server (R2) as OS platform. The package was built, install ( SQL not file system)and ran fine on the development environement; when attempt to deploy the package to the SQL 2005 server where data reside and should be processed (also install to SQL), I receive error " 0x80004005 ...description TCP Provider: No connection could be made because the target machine activily refuse it". which is an odd error since the package is on the server that it try to connect to the data base on it. If anyone can give me some hint at what cause this problem, appreciate the help. Tag: How to change the instance name?
  - 12
    - Check remotely if Reporting Services exist yeah... but how can i check it programatically Tag: How to change the instance name?
  - 13
    - File Move Component Error Setting Overwrite to true will not solve this. The source file is in use, that is what your errors says. John offered one option as to why it could be "in use", so if that is not your problem, you need to find out what really has it open. Overwrite will allow you to overwrite a closed file, but not one that is still open. From your description it is actually the source file that is still in use, as you said the Delete failed. Using Handle will help identify what process has it open so you can then start to work out why it has. Tag: How to change the instance name?
  - 14
    - Error deploying large Report Model Hi there, Not sure if this will be of any help, or wether I've just mis-understood, but I found this post via search and have solved this exception. However, in your post, where you quote the location (the .net2 framework dir), surely this isn't where the web.config was FWIW, I changed the web.config in the [SQL Server Directory]/[MSSQL RS Instance]/Reporting Services/ReportServer directory. That seemed to do it for me. I only changed the MaxRequestLength. My model is 4mb. -tom Tag: How to change the instance name?
  - 15
    - Barcode doesn't print from reports server Hi, I am trying to display the barcode on a webfor for a tracking number, How do I display it. I am new to asp.net, but i have to get this done. Thank you, Tag: How to change the instance name?
  - 16
    - Copy cube from a DB to another one You can take a look at the following link for "synchronize". http://msdn2.microsoft.com/en-us/library/ms174928.aspx Yes. It supports xmla script. The easy way is to generate the script using the synchronize wizard. Tag: How to change the instance name?
- Next
  - 1
    - Database size allocation - where other than tables, logs, etc ???? I have a Db that is 1.7 gigs. The table data takes approximately 200megs. The transaction logs were truncated. Where else can this large size be coming from and how can I confirm DB is generally small. ~25 tables, 100 SPs, 10 views, etc. Note: I have 4 queues using SQL Notifications, but when selecting from them results in no data. Thanks Scott Tag: How to change the instance name?
  - 2
    - SSAS 2005 Connection Hi Darren, Thanks. I was thinking use linked server to execute mdx query on SQL server 2005 database engine. Anyone could help on this. BTW my Sample script would be USE master GO /* Add new linked server */ EXEC sp_addlinkedserver @server = 'LINKED_OLAP' , -- local SQL name given to the linked server @srvproduct = '' , -- not used @provider = 'MSOLAP.3' , -- OLE DB provider (the .2 means the SQL2K version) @datasrc = 'localhost' , -- analysis server name (machine name) @catalog = 'Adventure Works' -- default catalog/database GO SELECT * FROM OPENQUERY ( LINKED_OLAP , 'SELECT { [Measures].[Sales Amount], [Measures].[Tax Amount] } ON 0,{ [Date].[Fiscal].[Fiscal Year].&[2002], [Date].[Fiscal].[Fiscal Year].&[2003] } ON 1 FROM [Adventure Works] WHERE ( [Sales Territory].[Southwest] )' ) /* Remove any previous references to the linked server */ EXEC sp_dropserver 'LINKED_OLAP' I had the error OLE DB provider "MSOLAP.3" for linked server "LINKED_OLAP" returned message "The following system error occurred: No connection could be made because the target machine actively refused it. .". Msg 7303, Level 16, State 1, Line 2 Cannot initialize the data source object of OLE DB provider "MSOLAP.3" for linked server "LINKED_OLAP". Tag: How to change the instance name?
  - 3
    - How to run DTS package/upgrade in SQL 2005. Dough, How do I install 'Legacy componenets' . I don't remember seeing this option. Thx, Satish Patil Tag: How to change the instance name?
  - 4
    - TSQL Challenge I think creating a view is very expensive here. BTW, if you want to create the view you have to use the following tasks. - Create a calendar table - Update the data on calendar table periodically - Join with the original tables Code Block Create table MyCalendar ( Date Datetime ) Declare @date as Datetime Set @date = '2007-01-01' While @date <= '2007-12-31' Begin Insert Into MyCalendar Select @date where not exists( select 1 from MyCalendar where date = @date ) Set @date = dateadd ( dd , 1 , @date ) End Code Block create view myview as select ContractID , lastName , Firstname , date , Sum ( case when aefd <= date then v end ) as ContractValue from ( select C . ContractID , C . lastName , C . Firstname , a . EffectivityDate aefd , a . ContractValue v from contracts c left outer Join amendments a on a . ContractID = c . ContractID Union All select C . ContractID , C . lastName , C . Firstname , c . [DateCreated] aefd , c . ContractValue v from contracts c ) as D cross join MyCalendar group By ContractID , lastName , Firstname , date Tag: How to change the instance name?
  - 5
    - Accesing offline cubes with MS Excel 2003 Hi, I created offline cube (.cub file) with SQL Server 2005 Analysis Services. Accessing the offline cube with MS Excel 2003 I get an error message: "Unable to obtain list of tables from the data source". I can access the offline cube with MS Excel 2003 only when MS Excel 2007 is instaled. After uninstaling MS Excel 2007 the same error ocures. I have MS Excel 2003 (11.8146.6568) SP2, Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider, Microsoft Core XML Services (MSXML) 6.0 instaled. Thanks for help, Martin Tag: How to change the instance name?
  - 6
    - Disaster Recovery - How to verify my 2005 standard databases using 2005 express In addition to Bucks comments refer these articles, www.msdn2.microsoft.com/en-us/library/ms175475.aspx http://sql-articles.com/articles.php pageNum_alltop=1&totalRows_alltop=13 http://sql-articles.com/articles.php pageNum_alltop=0&totalRows_alltop=13 http://deepakinsql.blogspot.com/2007/08/moving-system-databases-in-sql-2005.html Thanxx Deepak Tag: How to change the instance name?
  - 7
    - How can we create cubs in sql server 2005 BI How can we create cubs in sql server 2005 BI Tag: How to change the instance name?
  - 8
    - Can't Get SQL Authentication to work With XP Pro SP2 in very simple test case Similar grief here http://www.mcse.ms/message2347651.html Tag: How to change the instance name?
  - 9
    - Using Array Variable in ForEach Loop Container Hi Rafael, I've already used the method that you've explained but I can't control the datatype for each column, so I want to explore using Script Component. How can I get the sample for it, since Script Component have two method when we using it (Synchronous and Asynchronous). Thanks in advance. Tag: How to change the instance name?
  - 10
    - Database corrupt on power loss Hold on, not just yet�� You have to use transactions for all changes to the database to engage ACID and it looks like you��re not using them. Please see this on how to use transactions. Tag: How to change the instance name?
  - 11
    - tfs installation issue !!!!!!!!1 i had SP1 of visual studio and TFS installed on my server but it didnt work and i had a server failure, so i removed the SP1 after doing this i had this error: " Team Foundation Server does not exist or is not accessible at this time. Technical information (for administrator): HTTP code 503: TF30059: Fatal error while initializing web service " after searching on line i found that there is problem in version number of Microsoft.TeamFoundation.VersionControl.Server.dll file so i changed it to be compatible with TFS version number. by dowing this the following erro appeared " Please contact your administrator. There was an error contacting the server. Technical information (for administrator): HTTP code 500: Internal Server Error " after that i removed the TFS and tried to reinstall it on the same server, here i had the following error: "Error 28922.TFServerStatusValidator: ErrorConnectingToDatabaseWhenImpersonated - Most likely the service account doesn't have permission to access TFS database (because the tool succeeded connecting to the TFS database as the current user - user running setup)" and here im totaly stuck , coz the user of services can connect to sql server , i used the sevice account to connect to sql server and connection was established successfully. Tag: How to change the instance name?
  - 12
    - Connection Error from ASP.Net under IIS: provider: Named Pipes Provider, error: 40 We experience the 40 error when our Asp.net code runs under IIS and uses named pipes to a sql server 2005 named instance. We've tried all suggestions found on blogs and KB articles such as making sure the named pipes protocol is enabled, making sure the Browser service is started, making sure Allow Remote Connections is enabled, making sure we're not using Asp.Net 2.0 membership providers, and the list goes on and on. We boiled it down to a simple test scenario. We open a SqlConnection to the sql 2005 box in the code with the intention of binding a datareader to a gridview, but it never gets that far because the connection.Open() fails. If we run this test application as a virtual directory in IIS and Asp.Net 2.0, the connection.Open() fails. If we run this test application from Visual Studio .Net using Cassini (PWS), the connection.Open() succeeds and binds to the gridview. What could be causing the connection to fail under IIS but succeed under Cassini We've tried setting IIS to run as a domain user and with digest authentication enabled. That made no difference. Any help or insight is appreciated! Tag: How to change the instance name?
  - 13
    - Cant restore the database backup in SQL server 2005? Hi, System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'C:\' to create the database. The database requires 83679641600 additional free bytes, while only 46151348224 bytes are available. (Microsoft.SqlServer.Smo) Thanks, S.Shyam. Tag: How to change the instance name?
  - 14
    - How to move Full Text Catalog SQL 2005??? Jens K. Suessmeyer wrote: As far as I can remeber it is the same procedure as for previous versions. Here is the article for how to do it in previous versions: http://support.microsoft.com/kb/240867 However, this will not work in SQL Server 2005, because the instructions involve manually updating system tables, which is not allowed in SQL Server 2005. Tag: How to change the instance name?
  - 15
    - How to programmatically set column mappings of a simple data flow task? Thanks for the clarification about not being able to self-modify a package. I am following Kirk's example of loading a package and then trying to set its properties. I'm now running into the problem that "Mainpipe" is not a recognized type. I have the imports statements from the help link you gave me earlier. Is there something else I am missing We're getting closer to the answer, and thanks for your help! Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Runtime Imports Microsoft.SqlServer.Dts.Pipeline Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper Public Class ScriptMain ' Public Sub Main() ' ' Dim app As Microsoft.SqlServer.Dts.Runtime.Application = New Application() Dim package As Microsoft.SqlServer.Dts.Runtime.Package = _ app.LoadPackage( "c:\systime\ExcelOut\ExcelOut\ExcelOutDo.dtsx" , Nothing ) Dim e As Executable = package.Executables(0) Dim thMainPipe As Microsoft.SqlServer.Dts.Runtime.TaskHost = _ CType (e, Microsoft.SqlServer.Dts.Runtime.TaskHost) Dim dataFlowTask As MainPipe = CType (thMainPipe.InnerObject, MainPipe) Console.WriteLine(dataFlowTask.pathcollection.count) Dts.TaskResult = Dts.Results.Success End Sub End Class Tag: How to change the instance name?
  - 16
    - suggestions Sorry for that...what i mean by set based is i dont want the data to be transfered row by row (one at a time)instead a group of records at one time. hope you get it Tag: How to change the instance name?

satya.krishna

Hello DBA's

I have installed SQL Server 2005 on a machine with named instance, but later I noticed that I created it with the wrong name than desired. Now I need to change the instace name of the SQL Server that I have installed. How can I do that

Thanks

Satya

Top

Re: How to change the instance name?

Peter Saddow MSFT

There is not a supported way to rename an instance. You need to uninstall and then reinstall.

Thanks,

Peter Saddow

Top

Re: How to change the instance name?

satya.sqldba

Thanks Peter

Satya

Top