Installing Sql Server 2005 Enterprise on Windows XP pro

SQL Server Documentation

Index ‹ SQL Server

- Previous
  - 1
    - processing cube not pumping data You seem to have checked everything that I could see as causes for the problem. 10 M fact rows is not that much that will create problems for a standard server. It is also very hard to see why the named query will not execute without a filter clause. I have searched for file limits of the SSAS2005 data files but I have not found anything this far. What hardware are you using(32bit/64bit, no of CPU:s, RAM) . Are you using the standard or enterprise version of SSAS2005 SP1 Why are you not able to create a view of the three fact tables With that large data set a named query is not the best choice, for performance reasons. Any messages in the eventlog when you process without the filter clause Have you also started a trace with SQL server profiler when you process the cube Regards Thomas Ivarsson Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 2
    - Trouble Installing Reporting Add-In for Microsoft Visual Web Developer 2005 Express Hi Folks I've downloaded & installed Visual Web developer Express and SQL Server Express and now I'm trying to install the Reporting Add-In available here: http://msdn.microsoft.com/vstudio/express/downloads/default.aspx It downloads just fine and, just as the installation progress bar is almost done and the status text says 'Registering Product', I get the following error message: "There is a problem with this windows installer package. A program run as part of the setup did not finish as expected. Contact your support personell or package vendor" Running VWD shows the ReportViewer control now appears in the 'data' group. I can add it to a form, but I cannot create a new report, as clicking on 'Design a new report' under the ReportView Tasks popup menu does nothing. Any ideas, please Thanks Andrew Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 3
    - xquery query path without elements The Demographics xml data type column in AdventureWorks. Sales . Store contains the row sample below. How would I write the path for Demographics.query() to retun all rows with AnnualSales >=300000 I'm using variations of this statement but can't find an example of a path without elements. SELECT demographics . query ( 'declare namespace AWMI="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/StoreSurvey"; / ' ) as Result FROM Sales . Store < StoreSurvey xmlns = " http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/StoreSurvey " > < AnnualSales > 300000 </ AnnualSales > < AnnualRevenue > 30000 </ AnnualRevenue > < BankName > International Bank </ BankName > < BusinessType > BM </ BusinessType > < YearOpened > 1970 </ YearOpened > < Specialty > Road </ Specialty > < SquareFeet > 7000 </ SquareFeet > < Brands > AW </ Brands > < Internet > T1 </ Internet > < NumberEmployees > 2 </ NumberEmployees > </ StoreSurvey > Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 4
    - Hotfix for Bug # 473675 (SQL Server could not spawn process_loginread thread) Hi, I get " SQL Server could not spawn process_loginread thread." errors. This is related to a bug in SQL 2000 and there is a hotfix for SP3a. I am running SQL2000 with SP4. I checked the fix list of SP4 & this bug is not fixed in this SP4. Can I apply the hotfix to resolve this problem on my server tia. Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 5
    - EXEC in WHERE clause I wanted to have something like SELECT * FROM refs1 WHERE (EXEC ref_id) = this.id Should I turn the SP into a function Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 6
    - Linkserver connection fails between SqlServer 2005 and Oracle 10g Hi, Jay87, try to use the sp_setnetname stotred procedure to link the name of your linked server to the correct name of your oracle server machine sp_setnetname @server = ' server ', @netname = ' network_name ' Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 7
    - OUTPUT - help with please @SQL is my stored procedure name @Param_List is the list of enumerated parameters SET @SQL = @SQL + IsNull ( @Param_List , '' ); EXECUTE sp_executesql @SQL ; Worked like a charm. Thanks! Sandy Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 8
    - problem with Stored procedure hi everyone... Iam new with stored procedure in Sql 2005 so iam facing a problem which i need to get the result of query to store in an sql output parameter here is my SP : ALTER PROCEDURE [dbo].[CheckUser] ( @Id nvarchar(50) , @Pass nvarchar(50) , @Exist int output , @Type char(1) output ) AS BEGIN SET NOCOUNT ON; -- Insert statements for procedure here declare @tt int declare @char char select @tt=count(*) from Users where Id=@Id and Password=@Pass select @char=users.Type from users where Id=@Id and password=@Pass set @Type=@char set @Exist=@tt END so i would to retrieve the results of the 2 queries & store them in @Exist & @Type.. how can i do that Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 9
    - Creating an Windows Rdl on the fly using .net programming You are welcome and I hope that the Report Build is what you are looking for. Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 10
    - XML columns failing to Replicate I case it has some effect on this issue, I should let you know that the tables I am seeing this issue with are linked with a logical relationship filter (sp_addmergefilter @filter_type = 2). I have not done any work to reproduce this problem in other tables that do not have this type of filter relationship. Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 11
    - distinct query for table containing records more than 69347 What would be the best way to avoid distinct clause in query to get the result.My Query looks like select distinct Col1 ,col2,col3,col4 from ABC where (1=1) group by Col1 ,col2,col3,col4 order by col1 ABC Contains records like Col1 col2 col3 col4 a 1 1 1 a 2 1 1 B 2 2 2 B 1 1 1 ; ; ; how is the performance of disticnt query on Number of Rows HOw can i Improve my query performance if want to use distinct in my query will adding indexes help to boost performance Thanks Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 12
    - Checking for records where One value is NOT in the other? I am trying to display results in which a value in my first result table is NOT contained in the second result table. Any idea on how to do this . SELECT CUSTOMERID, CUSTOMER FROM TABLE1 WHERE CUSTOMERID NOT IN TABLE2 Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 13
    - Property IsLocked is not available Works great... Except now I still can't log in with the sa account that I just unlocked from any machine. TITLE: Connect to Server ------------------------------ Cannot connect to ANGEL. ------------------------------ ADDITIONAL INFORMATION: Cannot open user default database. Login failed. Login failed for user 'sa'. (Microsoft SQL Server, Error: 4064) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=4064&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 14
    - Store currency and volume in database We are creating an enterprise application for fuel, and I am fighting with my DBA about the proper way to store volume and currency in the database. We have 2 main arguments. The first argument is whether we should store costs in the database in $ and convert in the presentation layer, or to store the amount and currency in the database. We sell product from the US in dollar but depending on the customer we may invoice in Euro. Our second argument is the same, execept with volume and UOM. We often purchase product by BBL but sell/transfer by gallon, or Ton. please tell us the best practice for our d ilemma. Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 15
    - Deploy Reports via Visual Studio 2005 try opening a command window and running "tracert <reportserver ip>" this will show you how requests are being routed to your report server. If the ip address of the report server isn't the first on the list, you are using some kind of proxy or gateway to get to the report server. Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 16
    - Question on Row Count Transformation minority80 wrote: opss.... ya.... it's Row Number Transformation.. sorry for the mistake... thanks for the replies.... in this Row Number Transformation package, start number(seed) cannot be filled with expression... so can i say that this package can only be used to generate surrogate key if it's run only once thanks again... Right click on the transformation and select properties. In that window you will find the "Expressions" box. Expand that and go from there. Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
- Next
  - 1
    - Need hand holding Hi - Is there a resource I can go to that lists people who I pay to talk me through stuff like getting SQL Server Express installed, get some sample data input and then get that data into Excel I just cannot seem to get any help that works for me to learn SQL Server; the books are obtuse, the online help too indirect. Once I get something working I hope to enhance it on my own, but I have been stuck at the start for a very long time. There is stuff for me to do that is not getting done. Doug Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 2
    - When to use a Nested Table? Why would someone choose to model a problem with a case and nested table versus just using a case tables with multiple rows For example, a simple customer and product scenario where you could say: Mining Model DT_CustProd ( [Id] , [Gender] , [Age] [Products] Predict ( [ProductName] , [Quantity] ) ) But you could also model as: Mining Model DT_CustProd ( [Id] , [Gender] , [Age] [ProductName] Predict, [Quantity] Predict ) and just insert multiple rows per Id/Gender/Age Is there any rule of thumb to use here when deciding to model with a nested table I understand that a nested table essentially pivots the data ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=408840&SiteID=1 ) and the data becomes an attribute, but how do you know if you want that, or you want the data as a value of an attribute Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 3
    - SQL Server 2005 Install fails on Vista I am encountering the same exact issue. Can't uninstall or re-install as the same message states that it is part of OS. Need to install SQL 2005 standard for demo purposes. SQL Express alone fails also. I have tried to work around this for an entire day, but nothing will allow SQL 2005 to detect the .net 2.0 framework. Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 4
    - error Are you using any UNION on your query.. Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 5
    - Sub_Report on field details Table Hello, I'm French, so sorry for the faults. I want to make a report with a table who gives some figures of a family and elements of her subfamily. For example, for the Fruit family I have like subfamily the apple, the pear, the banana. I tried to make a table with a group but to aggregate some figures of the subfamily dataset, calculations are complicated. So I make two report: - one for a dataset for the subfamily with a parameter (the family). - one for the dataset of the family. In the second, I want to put the under-report (the first) in the details of the table while passing in parameter the family. But, I have an error when I want to see the result:" Error: Impossible to post the under-report." If you can help me that would be sympathetic! Thanks Mickael Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 6
    - Few questions on INDEXES. Dear Experts, I have few questions on SQL Server indexes. Example : There is a table Table1 with columns col1,col2,col3,col4,col5. Q#1 There are below non clustered indexes on the table Table1 1. IDX1 ON (Col1, Col2, Col3) 2. IDX2 ON (Col2, Col3) 3. IDX3 ON (Col2) 4. IDX4 ON (Col3, Col4, Col5) 5. IDX5 ON (col5) 6. IDX_PK ON (col1) is Primary key and IDENTITY. Does these indexes makes sense That is , do we need IDX3 when IDX2 could be used for searching col2 do we need IDX5 when IDX4 could be used for searching col5 Q#2 In case if I need to make the fill factor to 90 % , should I do it on all the indexes or only on the PK IDX_PK Q#3 Assume this table is write intensive. As the column col1 is Primary Key with IDENTITY property , should I still have the fill factor made as 90% changed from the default 100%. That is, does the fill factor comes to help even if there is an IDENTITY column. Thanks for your time & responses in advance. DBLearner Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 7
    - Not able to sort UDTs in DatadridView Control. Hi All, I have deployed UDTS in SQLserver and i am dsplaying data in datagridview control of the table which contains columns of UDTs. Till time everthing is ok. But problem is All other columns sorting is working properly but UDTS column sorting by doing Columnheader click is not working and firing an exception like System.Data.DataException occurred Message="Type 'MCSTypes.AlarmState, MCSTypes, Version=5.5.5.5, Culture=neutral, PublicKeyToken=null' does not implement IComparable interface. Comparison cannot be done." Source="System.Data" StackTrace: at System.Data.Common.SqlUdtStorage.CompareValueTo(Int32 recordNo1, Object value) Efforts I made :- I have implemented IComparable interface but still its not working. even i have tried my own sorting on datagridview but It is required that DatagridControl should not contains any data source and i have table as datasource. so that is not helpful. Problem Prediction: I think the problem is with UDTS as they are not using IComparable for Comparison. UDTS are using some sqlserver native comparison and thats the problem. All suggestions and workarounds are welcomed. Thanks in Advance. Manoj Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 8
    - how to use non-basic AscII character in Stored procedure parameter hi all, I have a stored procedure with a input parameter ( xml block). sp: spGetAddr @xmlText the style of parameter @xmlText looks like <Param RestricBy="UserName IN ('May a ', 'Bob')"/> If I use non-basic ASCII character, just like ' a ' in the parameter, the execution fails and I get 'The error description is 'An invalid character was found in text content.'' But this kind of special characters should be allowed in the name column of the database table. If I use the htlm code '&#xE1" to replace ' a ' in the parameter, then the execution of the stored procedure is fine. but how can I change all of the possible sepcial characters If somebody knows how to handle this issue, please help me. I'm pre-appreciated for all the idea and suggestion! Thanks, Jone Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 9
    - What version: Enterprise manager or Management Studio Express This may be a dumb question but I have searched and haven't found an answer to it here yet. We are planing to get SQL Server 2005 for a specific purpose.We have several existing stand alone SQL Server 2000 database servers already. I have Enterprise Manager (2000) client installed on my PC. I recently installed SQL Server Express (2005) on my PC to get to know about new features. I have run into problems (BCP specifically) with having two versions of C:\Program Files\Microsoft SQL Server\80\... and C:\Program Files\Microsoft SQL Server\90\... on my PC. Is there any point before or after we purchase Standard version of SQL Server 2005 when I can do away with C:\Program Files\Microsoft SQL Server\80... and/or uninstall Enterprise manager In other words can I manage SQL Server 2000 databases using only Management Studio(SQL Server 2005 client) If not, how do I manage the two different versions of the client software on a single PC. Thanks, Dave K. Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 10
    - Semantic Model Can you be a little more specific on what you mean by "relating the month to the first day of the month in the Time table." I believe I have this exact problem in generating a model, and I can't seem to identify a work around. Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 11
    - SP2 installation problem when mssqlsystemresource has moved Hello. I recently moved all the system databases from their default location to different drives. I keep my .mdf files in E:\SQL MDF\ and .ldf files in F:\SQL LDF\ and all has been running fine until SP2 came along. I Installed SP2 and the database services part failed. All other parts were sucessful but I could not re-start SQLServer. On examination of the event log the reason why it wouldn't start is because the mssqlsystemresource .ldf did not match the .mdf file. This is strange I thought because I had sucessfully altered the paths for the mssqlsystemresource database and re-started SQL many times to test that the new paths were correct. However, when I checked the contents of both the SQL MDF and SQL LDF file folders i discovered something interesting. In the SQL MDF folder, there was now a mssqlsystemresource.ldf file and it had the same modified date as the mssqlsystemresource.mdf file. In the SQL LDF folder there was also a mssqlsystemresource.ldf (which there should be, because this is the original .ldf file which SQL had been using ) although the modified date was earlier than the one contained in the SQL MDF. This has made sense of the error messages in the event log because it looks as though something in SP2 alters the mssqlsystemresource database but it is not putting the .ldf file in to the folder I specified so SQL wouldn't start. Now the obvious question would be had I actually got the paths right! So to prove this I copied the updated .ldf file from the SQL MDF to the SQL LDF folder and SQL started sucessfully, thus proving the path was correct. I have now replicated this problem on another server aswell. My next question is, can the service pack now be classed as having installed correctly as the build number of the database engine is now 9.0.3042 even though the installer "failed" I'd appreciate any comments or thoughts on this as I have 5 production servers to apply SP2 to and I'm pretty sure I'm going to get the same problem and even though I know how to fix it, it would for once, be nice to have one installation of SP2 run from start to finish with no errors. Thanks Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 12
    - Use Sql To Run Export Wizard?? Ah, I see... have you checked this blog entry by Brett Kaiser http://weblogs.sqlteam.com/brettk/archive/2005/04/13/4395.aspx I've not tried it, but it looks like it's along the lines of what you're after. Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 13
    - Upgrade from SQL CE 2.0 to 3.1 We have numerous clients that have been using 2.0. And we are now planning to upgrade everything to 3.1. Of all the 3.1 dll files, which ones do we need to have on the device And does anyone know of any problems with doing such an upgrade -Thanks, Kris Kline kris_kline@hotmail.com Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 14
    - sometime ADODB return No result to Excel Hi all, I have a strange situation. I use VBA to call a MSSQL server 2000 to get data from one of the DB inside, using ADODB. My problem is, the DB is around 20GB, and if we get data from it for few days, say 7 days, is fine. When I come to trying get more data like 1 month, the excel returns no data after waiting for about 30 sec. The query is actually calling a stored procedure on the server side to return data. I have add connectiontimeout=10000 to my connection string but still not working... I run the same execute statement in query analyzer on the same machine using the Excel and it is fine. Around 2 minute waiting I can see my data. But in Excel, never. Anyone can offer some helps to me Thanks alot. Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 15
    - Flat file source not communicating with script component properly Would it be possible for you to isolate a few rows that fail, create another simple file with only those two rows, obfuscate your data and post your file here Just make sure the newly created file still fails the same way as the original one. Thanks, Bob Tag: Installing Sql Server 2005 Enterprise on Windows XP pro
  - 16
    - constrains on table subsets Hmm, trigger... Now I have an stored proc that returns me the group number (i). If list (j's) already exists then I got existing, otherwise new rows will be added. I know I can use triggers, but I just want some other ideas, don't think too much about the showed problem. Just think about: how to enforce multiple row constraints... Best Regards Tag: Installing Sql Server 2005 Enterprise on Windows XP pro

Rog123456888

I am trying to install 2005 sql server enterprise edition on windows xp pro, When I get to the part where you pick which components to add, they are all grayed out except for workstation components and books. What did I do wrong

Top

Re: Installing Sql Server 2005 Enterprise on Windows XP pro

georg.thomas

You cant install enterprise edition on XP Pro (or 2000 Pro), it must be installed on Windows Server.

If you want the features of Enterprise Edition for R&D, you need to install Developer Edition. Otherwise Express Edition or MSDE will also work on workstation platforms.

You can view system requirements here:

http://www.microsoft.com/sql/prodinfo/sysreqs/default.mspx

The reason the workstation components are available, is that XP Pro (like Windows 2000 Pro) is a workstation, and this option will allow you to install tools such as the SQL Management Studio, Books Online etc.

Good Luck!

Top