Is there 1 default instance per OS Server or per SQL Server?

SQL Server Setup & Upgrade

Index ‹ SQL Server

- Previous
  - 1
    - Display Analysis Services Server-Based Formatting in RS 2005 Report I'm looking for a new way to publish reports based on OLAP data and was very disappointed to find that Reporting Services does not natively support displaying MDX query results in a matrix. While it is possible to assign an MDX query to the matrix control in Reporting Services, the two main problems are that the columns of the query must be measures (not dimensions), and it does not support display of server based formatting (fore color, back color, and font flags). Does anyone know of any custom control that properly deals with Analysis Services data Thanks for any info you have! Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 2
    - Connection Error: (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe. Hello, Please bear with me as I am no Sql Server guru, but am getting this error that is preventing me from continuing with my development work. I am the only developer on my team running Sql Server 2005 and it has been working just fine for the last week. I opened the Management Studio this morning, just like every other morning and got this error: TITLE: Connect to Server ------------------------------ Cannot connect to (local). ------------------------------ ADDITIONAL INFORMATION: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233) Of course the help page says no help is available. I have googled myself sick and still have not found a way so resolve this...has anyone else had this error and/or a fix I am using XP Pro SP2...any help would be greatly appreciated! Thanks! Steph Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 3
    - Security required to run deployment utility I would like to have my developers responsible for deploying their SSIS packages to the Test/QA environment. I tried granting access to several of the stored procedures in msdb and the sysdtspackages90 table. The only thing that seems to work is granting sysadmin priviliges. Is there a server or database role that will grant the appropriate access thanks Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 4
    - sql query I am using the following ; { fn HOUR(DateTime) } and receive the following data; 0,1,2,3...etc Is there a way to use the above statement and have the following 12:00 AM, 1:00 AM, 2:00 AM.......etc. Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 5
    - Debug tsql I tried to debug a procedure from query analyzer, but i could not able to step in or step out. only few actions i could able to perform on the code,like execution,set break points. step in and step out is not enabled.Is there any option to enable it.. Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 6
    - Calling a package at Runtime I am working on a package that will sense a text file in a folder. From this text file I will be extracting the file name which will tell me what task I need to run. How can I create a package that, depending upon what the file name is, call a specific package. To be more clear, I will have 3 different flat files that is each in a standard form. Their names will be unique. To transform their data will require different ETL logic. I will be using a loop to constantly check to see if a file has been put into the directory. I just need to know how I can direct the input file to the proper ETL task. Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 7
    - define a default value ?? hallo i am on the very beginning with sql.s, how can i define a default value for the table field like its possible in access, for example: the if the user not gonna enter a val so there is a default val predefined in the table field, for example i would like to predefine the date now on the smalldate field.... thanks Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 8
    - Irritating issue in Reporting Services 2005 SP2. We don't face this problem in SP1. When we have a matrix and want to freeze some row-groups(columns), it does so. But when we drag the horizontal scroll bar of IE, the alignment of the row is completely screwed up. The text in the columns which are set to float, either shifts up or down. I guess this has to do with the wraping of the text in the row group cells. This is a great irritant and is stopping us from moving to SP2. Please let me know if this has been fixed or there is a workaround. Thanks Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 9
    - Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen Yesterday and today, the Process Info screen in Enterprise Manager indicates that the "Host", a single workstation on our network, is generating around 50 connections to the database. This particular application is well-behaved and typically generates only 2 to 5 connections per instance. Furthermore, we cannot find this particular workstation/host on our network because we retired it off the network some time ago. Anyone know of the accuracy of the Hosts column on this Enterprise Manager screen We're suspecting that the network address column is correct but the Hosts column is incorrect. There are about 10 different network addresses pertaining to this particular Host (1-5 connections per network address). Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 10
    - Way to find registered classes/functions for the Assemblies added in Analysis Service. Hi, Is there some way through which we can find the classes and function registered with Analysis Services, when we add Assembly code for Stored procedures Thanks, Santosh. Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 11
    - Problem with AuthenticationExtension Hi, I got SSRS2005 with FormsAuthentication working for a while now without any problems. I decided to create some kind of 'Account Enabled' functionality and therefore I modified my AuthenticationExtension.cs. But what happened, the new functionality does not work. After adding some logging stuff to this file nothing changed. So it looks as if AuthenticationExtension.css is not being used at all in my security extension. I verified this by removing the file from the project and still...no changes! Other files in my security extension module are being used however. When I make a change to AuthenticationUtilities I can see it in my results. Does anyone know how this can happen Why is my extended IAuthenticationExtension not been used Thanks, Hans Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 12
    - Help with finding last record! I have two columns - code (nvchar) and date (datetime) within an sql 2005 table. The code contains a list where the items are duplicated and I need to search for each item for the newest date and if the date is older than 180 days to display that record. Was relatively easy using the Last function but this does not exist now. Any help would be appreciated. TIA Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 13
    - SAC Command Line utility doesn't start SQLBrowser Service I've exported surface area configuration settings from a server and tried importing them onto another server. The remote connection settings are imported but the SQLBrowser service remains Disabled. Am I doing something wrong The command line command I ran (in the C:\Program Files\Microsoft SQL Server\90\Shared directory) is "sac.exe in sacconfig.xml". The following is my config file: < xml version="1.0" encoding="utf-8" > <CommandArguments xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance " xmlns:xsd=" http://www.w3.org/2001/XMLSchema "> <Components> <anyType xsi:type="Component"> <Type>SqlServer</Type> <InternalType>DatabaseEngine</InternalType> <Instances> <anyType xsi:type="Instance"> <Name>SQLEXPRESS</Name> <Service> <Name>MSSQL$SQLEXPRESS</Name> <StartMode>Auto</StartMode> <ServiceState>Running</ServiceState> </Service> <Features> <anyType xsi:type="Pair"> <Key>AdhocRemoteQueries</Key> <Value xsi:type="xsd:int">0</Value> </anyType> <anyType xsi:type="Pair"> <Key>CLRIntegration</Key> <Value xsi:type="xsd:int">0</Value> </anyType> <anyType xsi:type="Pair"> <Key>DedicatedAdministrator</Key> <Value xsi:type="xsd:int">0</Value> </anyType> <anyType xsi:type="Pair"> <Key>DatabaseMail</Key> <Value xsi:type="xsd:int">0</Value> </anyType> <anyType xsi:type="Pair"> <Key>HTTPAccess</Key> <Value xsi:type="ArrayOfAnyType" /> </anyType> <anyType xsi:type="Pair"> <Key>OLEAutomation</Key> <Value xsi:type="xsd:int">0</Value> </anyType> <anyType xsi:type="Pair"> <Key>ServiceBroker</Key> <Value xsi:type="ArrayOfAnyType" /> </anyType> <anyType xsi:type="Pair"> <Key>SQLMail</Key> <Value xsi:type="xsd:int">0</Value> </anyType> <anyType xsi:type="Pair"> <Key>WebAssistant</Key> <Value xsi:type="xsd:int">0</Value> </anyType> <anyType xsi:type="Pair"> <Key>XP_cmdshell</Key> <Value xsi:type="xsd:int">0</Value> </anyType> </Features> <Protocol> <anyType xsi:type="Pair"> <Key>NamedPipes</Key> <Value xsi:type="xsd:boolean">true</Value> </anyType> <anyType xsi:type="Pair"> <Key>TCPIP</Key> <Value xsi:type="xsd:boolean">true</Value> </anyType> </Protocol> </anyType> </Instances> </anyType> <anyType xsi:type="Component"> <Type>SqlBrowser</Type> <InternalType>SqlBrowserService</InternalType> <Service> <Name>SQLBrowser</Name> <StartMode>Auto</StartMode> <ServiceState>Running</ServiceState> </Service> </anyType> </Components> <Version>9.0.242.0</Version> </CommandArguments> Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 14
    - Which Data Flow task to use? I have a table which has been loaded from various source feeds. The SourceId relates to the source name and the SourceCompanyId is the sources primary key for the company. I am basically trying to create one row with all the SourceCompanyIds in my column headers. What data flow tasks would be necessary in SSIS The structure of the final table is: CREATE TABLE [dbo] . [Company] ( [CompanyId] [int] IDENTITY ( 1 , 1 ) NOT NULL, [CompanyName] [varchar] ( 75 ), [CIK] [varchar] ( 10 ), [Ticker] [varchar] ( 10 ), [Source1CompanyId] [int] NULL, [Source2CompanyId] [int] NULL, [Source3CompanyId] [int] NULL, [Source4CompanyId] [int] NULL, [Source5CompanyId] [int] NULL, [Source6CompanyId] [int] NULL, CONSTRAINT [PK_Company] PRIMARY KEY CLUSTERED ( [CompanyId] ASC ) WITH ( IGNORE_DUP_KEY = OFF ) ON [PRIMARY] ) ON [PRIMARY] ================================= The table in which contains all the company data CREATE TABLE [dbo] . [SourceCompany] ( [SourceId] [int] NOT NULL, [SourceCompanyId] [varchar] ( 10 ) , [SourceCompanyName] [varchar] ( 75 ) , [CIK] [varchar] ( 10 ) , [Ticker] [varchar] ( 10 ) , CONSTRAINT [PK_SourceCompany] PRIMARY KEY CLUSTERED ( [SourceId] ASC , [SourceCompanyId] ASC ) WITH ( IGNORE_DUP_KEY = OFF ) ON [PRIMARY] ) ON [PRIMARY] Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 15
    - Reporting Services 2000 Installation Problems. Hello every1. I have been trying to install Reporting Services 2000 on a Windows Server 2003 machine with SQL Server 2000 and Framework 2.x for a couple of days now. When i run Reporting Services setup it tells me that Asp.Net is not installed or is not running, i know this could be caused becouse i have Asp.Net 2.x running instead of 1.x, but what ever i do, changing all IIS settings and website settings so the server uses Asp.Net 1.x the problem still exists, is there any solution besides a reinstallition and installing RS2000 be4 the Framework 2.0 Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 16
    - 64-bit Separate Install?? I want to know if 64-bit SQL Server 2005 is a separate install. I have been provided with SQL Server 2005 enterprise CD. I tried browsing through the folder but could not find 64-bit install. I am assuming the CD I have is 32-bit because the system configuration check report had this message "64-bit ASP.NET is registered. Required 32-bit ASP.NET to install Microsoft Reporting service 2005(32 bit)" The windows server I am trying to install is Windows Server 2003 Standard x64 Edition. I uninstalled the all the client and SQL Server 2005 install. Since my windows server 2003 hardware requirements are compatible for 64-bit SQL server 2005, I want to go ahead and install 64-bit SQL server 2005. Any help will be greatly appreciated. Tag: Is there 1 default instance per OS Server or per SQL Server?
- Next
  - 1
    - SSMS Help Hi, I'm not sure this is the right discussion room that I'm looking for my problem. In fact, the problem is very simple though I don't know how to deal with it. I accidentatly clicked some buttons on my SSMS IDE. And, my IDE seems bad. I uncheck 'Dockable' click box of SSMS's Object Explorer. And, is there anybody who know how to put that back to the original format Thanks. Myo Zaw Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 2
    - Creating an Windows Rdl on the fly using .net programming Hi, I would like to know that can I create an .rdl file programmatically based on the user selection (USING .Net programming) . Please help with some link / examples. P.S: I am giving very less number of static reports to the client. I want to give a more of a dynamic report , wherein in each case, I will give the user a selection criteria to select the fields from the front end (say ASP.Net page) and those fields along with the relevant data will be generated in the report and will be displayed on the user��s screen. IS THAT POSSIBLE WITH MSSQL 2005 AND .NET 2005 Kind Regards Pratik Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 3
    - Datamigration to MS CRM Hi all, I have some questions responding to Datamigration to MSCRM. Does someone have experience with that procedure My question is related especially to the SSIS. Thx Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 4
    - SQL server replication connection problem Hi I have a problem when trying to setup replication between two SQL servers on different networks. My publication server is SQL Server 2005 Standard Edition. My subscription server is SQL server 2005 Express Edition I have setup the publication no problem but am now trying to create my subscriber. However, when trying to connect to the server, I receive the following error: SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'W2M-RDC-01'. (Microsoft.SqlServer. However, because the servers are not on the same network, I cannot use the server name. Why does it not allow you to connect to an IP Is there a way to create an alias I have read that you can but am unsure how to do this. Do I need to change the hosts file If so, where can I find this and what exactly do I need to change Kind Regards Dan Rostron Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 5
    - Aggregation Types Can anyone briefly describe all aggregation types available in SQL Server Analysis Services Thanks, Shyam Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 6
    - the procedure 'sp_addrolemember' cannot be executed within a transaction I use sp_addrolemember inside a DML trigger and every thing goes well in my computer; I can insert or update into my table and sp_addrolemember is executed successfully, but my customer get this error every time he tries to insert or update into the table. "the procedure 'sp_addrolemember' cannot be executed within a transaction" Can anybody help me solve this funny error. Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 7
    - Get Culture for Multilanguage in Reporting Service Hi.. I have a windows application that can change the language of the application depends on the language preference of the user. My application can switch between chinese(zh-CHS) and english(en-US). I also have a report that also can change the language (hopefully) if user change their language preference in the framework of my application. I already follow the step provided in this link. http://technet.microsoft.com/en-us/library/aa964130.aspx While the code is at http://mhprofessional.com/product.php isbn=0072262397&cat=112&promocode = Since I want to apply it in windows application and C#, i already modified to make it suitable with my application. I can successfully deploy and view my report if user key in (for testing purpose) the language they want in the report interface. My problem is, I actually want to retrieve the value automatically from the framework. I try to retrieve the current language from thread. namespace Mynamespace.RSLanguage.MultiLanguage { public class MyReports { private static ResourceManager LocalizeRM; static MyReports() { LocalizeRM = new ResourceManager ( " Mynamespace.RSLanguage.MultiLanguage.MyReports " , System.Reflection. Assembly .GetExecutingAssembly()); } [System.Security.Permissions. PermissionSetAttribute (System.Security.Permissions. SecurityAction .Assert, Name = "FullTrust" )] public static string LocalizedString( string stringIdentifier, string language) { string getLanguage = "" ; try { if (language != "" ) { getLanguage = language; } else { getLanguage = Thread .CurrentThread.CurrentUICulture.ToString().Trim(); } CultureInfo currentCulture = new CultureInfo (getLanguage); return LocalizeRM.GetString(stringIdentifier, currentCulture); } catch (System. Exception ex) { return ex.Message; } } :::: } :::: } But, the getLanguage value still get the "en-US" from the thread even though user change their language preference to chinese. So, it still deploy the report in english. But if user key in "zh-CHS" into the interface, the report will display the report like correctly. How can I actually retrieve the current value for the language Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 8
    - using case statement to determine Order by field and direction (asc or desc) when using Row_number I am trying to order by the field and direction as provided by input parameters @COLTOSORTBY and @DIR while using a CTE and assigning Row_Number, but am running into syntax errors. Say I have a table called myTable with columns col1,col2,col3, Here's what I'm trying to do with myCTE AS ( Select col1 ,col2 ,col3 ,row_number() over (order by case when(@DIR = 'ASC') then case when @COLTOSORTBY='col1' then col1 asc when @COLTOSORTBY='col2' then col2 asc else col3 asc end else case when @COLTOSORTBY='col1' then col1 desc when @COLTOSORTBY='col2' then col2 desc else col3 desc end end from myTable ) Please let me know what i can do with minimal code repetition and achive my goal of dynamically sorting column and direction. I do not want to use dynamic SQL under any circumstance. Thanks. Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 9
    - Reporting Services 2005 with SQL 2000 Database Hi friends, i have some questions about Reporting Services 2005: Can i use RS 2005 with a SQL 2000 Database Can i create a report with RS 2005 (with a SQL 2K Database) a show it in a webform What do i need to install (in the webserver and in the Database server) in order to start designing reports in RS 2005 against a SQL 2K DB Thanks in advance. Regards Eduardo Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 10
    - Deleting data bloats log file When I delete substantial amounts of data using the SQL DELETE command, the database size apparently remains the same (702 mb) and the log file goes from about 17 mb to over 1 gig. I was expecting for the overall size to decrease drastically, but got just the opposite. Is this typical Can I do something to slim it down As I am just trying to decrease the overall size to make it easier to work with when creating my application in VB, I am not worried about restoring the db (I have secure copies). Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 11
    - Could not find "Standby" in sysservers. Run "sp_addlinkedserver" to add the server to sysservers" a different scenario leads to the same problem, the error message: Could not find "Standby" in sysservers. Run "sp_addlinkedserver" to add the server to sysservers" I browsed the thread for the same error message and the solution doesn't applies to me. Here is my system settings. we have a kind of backup system. a primary server is set up to copy the database files to a standby server. when the primary is off, the standby server will take over primary's name and ip. and our application runs on the standby as if in the primary. in both machine the odbc connection are set to point the primary server. this setup works well in SQL server 2000 for both primary and standby servers, but it gives the error message on SQL 2005 in the standby server. I noticed that this is because the application opens an empty table. after inserting a record by hand, the error has gone away. I know it doesn't make too much sense, but it 's what I observed. Could anyone give me some input how could this happens and what' s the solution Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 12
    - running ssis package with ssis run time compoenents and sql server 2000... Hi Jamie, thanks. I have similar concerns. Do you have any links or infromation pages that we can read through and provide it to our DBAs. Thanks, $wapnil Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 13
    - export table to excel how should I go about exporting a couple of columns of data from a specific database table to an excel spreadsheet stored locally on a client machine (the one the script is being executed from). I am using SQL server 2000 SP3. I'm fairly new to using SQL server, and not experienced at all with Transact-SQL. Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 14
    - CTE behaviour in SQL 2005 I were trying to achive paging through using a CTE etc, but ran into the following weither thing happening. The CTE allows me to use avariable as the ORder By field, although the CTE do not care at all what is in there Have any one seen this or maybe can explain this USE AdventureWorks ; GO DECLARE @SortExpression Varchar ( 50 ) Set @SortExpression = 'SalesPersonID ASC' ; WITH Sales_CTE ( RowNumber , SalesPersonID , NumberOfOrders , MaxDate ) AS ( SELECT ROW_NUMBER () OVER ( Order by @SortExpression ) RowNumber , SalesPersonID , COUNT (*), MAX ( OrderDate ) FROM Sales . SalesOrderHeader GROUP BY SalesPersonID ) Select * From Sales_CTE ; WITH Sales_CTE1 ( RowNumber , SalesPersonID , NumberOfOrders , MaxDate ) AS ( SELECT ROW_NUMBER () OVER ( Order by SalesPersonID ASC ) RowNumber , SalesPersonID , COUNT (*), MAX ( OrderDate ) FROM Sales . SalesOrderHeader GROUP BY SalesPersonID ) Select * From Sales_CTE1 Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 15
    - Dynamically determine Linked Servers In our system, we need to execute queries using linked servers. However, the linked server name is not well known, it is a value stored in the system. Is there a way this can be done CREATE FUNCTION dbo . stfGetSupervisorOrgUnitAssignments ( @SupervisorID INT ) RETURNS @ReturnTable TABLE ( Org_Unit INT PRIMARY KEY ) AS BEGIN DECLARE @Server VARCHAR ( 100 ) SELECT @Server = dbo . stfGetLinkedServerName () INSERT INTO @ReturnTable ( Org_Unit ) SELECT ReplicationID FROM OPENQUERY ( @Server , '....' ) END Any help would be greatly appreciated. Tag: Is there 1 default instance per OS Server or per SQL Server?
  - 16
    - SQL Problems 1. now i'm using bulk insert command to read sales data form text file into posmaster table in databases. the problem is this bulk command only read from single text file. what command should i use if i want to read sales data from multiple text file. this is the sample of bulk insert command for single text file. BULK INSERT posmaster FROM 'c:\SALE\010407_S13101.txt' WITH ( FIRSTROW =1, FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) 2. what command should i use if i want the directory for each text file generate automatically when the sales text file transfer into SALE folder so that the user doesn't need to specify the directory manually. this is the sample of directory for text file. c:\SALE\010407_S13101.txt c:\SALE\010407_S13102.txt c:\SALE\010407_S13103.txt i want the program can call the directory first and then insert the sales data from text files into posmaster table in databases. this is the sample of sales text file : 010407_S13101.txt 1511950000008395A,10-04-200711:30:08.000,CLOSED,-0000000000060,00.00,+0000000000.00,00.00,+0000000000.00,-0000000000060 1511950000008395A,10-04-200711:30:09.000,CLOSED,+0000000000050,00.00,+0000000000.00,00.00,+0000000000.00,+0000000000050 1511950000008395A,10/04/200711:30:10.000,CLOSED,+0000000000010,00.00,+0000000000.00,00.00,+0000000000.00,+0000000000010 1511950000008396A,10-04-200711:30:35.000,CLOSED,+0000000000020,00.00,+0000000000.00,00.00,+0000000000.00,+0000000000020 1511950000008396A,10-04-200711:30:35.000,CLOSED,+0000000000090,00.00,+0000000000.00,00.00,+0000000000.00,+0000000000090 1511950000008396A,10-04-200711:30:35.000,CLOSED,+0000000000025,00.00,+0000000000.00,00.00,+0000000000.00,+0000000000025 1511950000008397A,10-04-200711:31:10.000,CLOSED,+0000000000010,00.00,+0000000000.00,00.00,+0000000000.00,+0000000000010 1511950000008397A,10-04-200711:31:10.000,CLOSED,+0000000000060,00.00,+0000000000.00,00.00,+0000000000.00,+0000000000060 1511950000008397A,10-04-200711:31:10.000,CLOSED,+0000000000090,00.00,+0000000000.00,00.00,+0000000000.00,+0000000000090 1511950000008397A,10-04-200711:31:10.000,CLOSED,+0000000000025,00.00,+0000000000.00,00.00,+0000000000.00,+0000000000025 1511950000008397A,10-04-200711:31:10.000,CLOSED,-0000000000020,00.00,+0000000000.00,00.00,+0000000000.00,-0000000000020 010407_S13102.txt 1311010000012598A002,2007-04-01:13:36.000,CLOSED,-0000000005.00,00.00,+0000000000.00,00.00,+0000000000.00,-0000000005.00 after each text file sucessfully insert into posmaster table in databases, i need the file that hold the directory deleted. Tag: Is there 1 default instance per OS Server or per SQL Server?

On a Server 2k3 x64, I've installed SQL Server 2000 x32 SP4 and SQL Server 2005 x64. When installing both SQL Server 2000 and 2005 on the same server, does each SQL Server have it's own "default instance" or there can only be one "default instance" per server TIA, Gary.

Top

Re: Is there 1 default instance per OS Server or per SQL Server?

mrdenny

There can only be one default instance per OS.

Be carefull when installing SQL 2005 on a SQL 2000 machine. It's very easy to upgrade the existing instance without releasing it.

Top

Re: Is there 1 default instance per OS Server or per SQL Server?

Gary Fuhr

Well that explains what happened. I noticed SQL Server 2005 was showing SQL Server 2000 databases. The good thing is it only the test server, not production. But since SQL Server 2000 instance has been updated, I'm assuming I'll have to uninstall both SQL Server 2000 and 2005 in order to set both up correctly Is there a shortcut to fix this

Top

Re: Is there 1 default instance per OS Server or per SQL Server?

Sam Lester - MSFT

Correct, there is no way to revert to DB's back to SQL 2000. The default instance naming is the same in both products to make upgrade easier. You can always supply a different instance name with the second install to run both editions side by side.

Thanks,
Sam Lester (MSFT)

Top