SQL Server 2005 Standard will not install MSSQL default instance

SQL Server Setup & Upgrade

Index ‹ SQL Server

- Previous
  - 1
    - Incorrect Totals Do you have the option of moving Price to a dimension This is often how price is recorded if it is describing something like a product. Barring this, I would recommend calculating Units * Price in your DSV and then simply recording it in a new measure in your MG1 measure group using an additive function. Good luck, Bryan Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 2
    - Error: Subreport could not be shown. I do not see any "sql server" or "reporting services" connections programs to which I can log a bug. Is there any other way to get assistance on this issue BizTalk Server 2006 R2 Business Desktop Deployment 2007 (Beta) for Windows Vista and the 2007 Microsoft Office system Configuration Manager 2007 (SMSv4) Open Beta Customer and Partner Advisory Group for next version of Business Scorecard Manager 2005 Enterprise GO - Partner Program exFAT Feedback Tool for Expression Graphic Designer Feedback tool for Expression Web Designer CTP Feedback Tool for Interactive Designer Public CTP Host Integration Server 2006 Public Beta Program Internet Explorer Feedback Microsoft Application Compatibility Toolkit 5.0 - Beta Microsoft Dynamics Product Feedback Microsoft iSCSI Software Initiator (Boot Version) Microsoft Managed Services Solution Public Beta Microsoft Phonetic Input Tool Microsoft Robotics Studio Beta (CTP) Microsoft SMS 2003 Desired Configuration Monitoring: Configuration Manifest Program Microsoft Windows Driver Kit (WDK) Beta Program Microsoft Wireless LAN API for Windows XP SP2 beta OneNote 2003 OneNote 2007 Beta 2 OpsMgr 2007 Public Beta (MOMv3) Phoenix RDK Publisher Beta Program SCCM2007 (SMSv4) Desired Configuration Management (DCM) Nomination Survey for Partners SMS 2003 OSD Feature Pack Update - Open Beta Speech Server 2007 Beta Program SSMA V2 System Center Essentials Beta System Center Virtual Machine Manager Beta 1 Program USMT 3.0 Beta Virtual Machine Additions for Linux Virtual Server 2005 R2 SP1 Beta 1 Windows "Monad" Shell Windows Live General Beta Tester Community Windows Live Messenger + Yahoo! Messenger with Voice Beta Windows Network Developer Platform Windows Workflow Foundation technology feedback Windows XP Embedded SP2 Feature Pack 2007 Community Tech Preview Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 3
    - Converting XML Datetime to SQL Datetime Hi Konstantin Kosinsky It is not working at my machine as well, the "-" is the culprit still. Style 127 is for ISO8601 with time zone Z: yyyy-mm-ddThh:mm:ss.mmmZ It does not like the hyphen "-" Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 4
    - how to get YYYYMMDD formate I use substring(cast(x+100 as varchar(3),2,2) to change 1 to 01 for month and day and year. Then use convert(char(8),'20060101',112) to change it to datetime data type. Thank you! Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 5
    - Comparison of SQL Server Reporting Services to Access Reports, Crystal Reports, Cognos or other options Thank you, you are correct there are several comparisons already on the web of which the below text is one of them from which I extracted and pasted here. Comparison of reporting solutions: Crystal Reports vs MS SQL 2000 Reporting Services Lately, I’ve been working on generating reports for a few projects. This post is an initial impression/comparison of my experiences with Crystal Reports and MS SQL 2000 Reporting Services. First, I began using Crystal Reports , the free reporting package included with Visual Studio .Net. Before I started using it, I had heard that it was an unpleasant piece of software to use. This is sort of a general overview of the process that I went through: I created an xml schema to define the fields that I would retrieve from the db. After the schema was complete, I got into starting to generate the report template using the Crystal Reports GUI designer integrated into VS.Net. The first annoyance popped up; the registration dialog that bugs the *** out of you. The designer was fairly straightforward and I have little issues with that. You can right-click on the report and select ”view source,” to see the generated c# code representing the report template. After the initial template was created, I created a class to generate a dataset based on user input. The class calls a stored procedure which then returns fields in the same format as those specified in my xml schema. The dataset is then created with these fields and used as the data source for the report. At this point, I built an .aspx page with a CrystalReportViewer object. After binding the dataset to the report object and the report object to the viewer object, you finally can view the report from a browser. To me, this seems like a hell of a lot of work for generating reports. Next, I got into a project that didn’t have a reporting solution. For this project, I chose to use MS SQL Reporting Services to generate the reports. SQL Reporting Services integrates nicely with Visual Studio .Net and best of all... no annoying registration dialog! One of the differences in VS.Net that initially threw me off was that I had to create a separate project to house Reporting Services reports. This is different than Crystal Reports, which just lets you add a report (.rpt) to any project in the solution. The point behind having a separate Reporting type project is mainly for deployment issues (I think) and it is a nice way to keep the reports organized. The two main parts of the report project are shared data sources and reports. As the name implies, you can setup one or many data sources to be shared between reports. Generating reports seems to have a little learning curve, but overall is a pretty easy procedure. There are wizards to drive you through the initial process, if that is your thing. Once again, the GUI editor for reports is friendly and done pretty well, but it contains some very cool features that Crystal Reports does not. First, it uses tabbed views to switch between modifying the data source, layout, and dun dun dah.... preview. The layout view is where you are able to modify the look and feel of the report. You can then view the expected result (using real data from the data store) by clicking the preview tab. Right-clicking on the report and selecting “view source,” presents the underlying xml used to represent the report . My initial thought is that it’ll be really nice and easy to generate my own XML representation, if the need arises. Now, rather than having to generate a separate .aspx page to view the report results, you can deploy the report to the reporting server. The reporting server is basically a server that has the reporting services web service installed. Reporting services uses this web service as their front end to reports too. So, you can just go to the web service and navigate to your report, to view it. If you need to specify parameters to limit the query, the web service will auto generate a framed webpage to do this for you. This is all well and good, but exposing the reports via a web service also allows you to build your own front end, if desired. Now there are many other cool features that I’m finding with SQL Reporting Services (drill down and access to any .Net class within the expression syntax, to name a few) and I’ll try to write about those in other posts. For both solutions, the documentation is pretty minimal. I have to give the edge to MS SQL Reporting Services, since they do have a section on MSDN devoted to reporting services . Also, Reporting Services provides a sample solution with multiple reports, showing what is possible. Even though the reports are different, the performance seemed to be pretty much the same for both reports. I’m not saying that I benchmarked the report performance, but visually I didn’t notice that one reporting package was faster than the other. Also, both reporting packages allow for reports to be exported to a variety of formats (Excel, PDF, Word, etc..) which is nice. All in all, I will choose to go with MS Reporting Services for any future reporting needs... Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 6
    - Changing the default database files path fails hi Jenz thanks for your reply. the code posted earlier worked smoothly just after a computer restart.the error message was either "Create failed for Database 'SMO_TEST'." or "Drop failed for Database 'SMO_TEST'." with whatever mistake i made, which provided no help in correcting the problem. however another issue arised when i tried to use a transaction using either method connection.BeginTransaction(); or server.ConnectionContext.BeginTransaction(); (1) how to correct this problem and (2) what kind of transaction occures here is it a distributed transaction also i would like to ask (3)if there is any way to diable full text indexing other than using connection.ExecuteNonQuery(databaseName + ".dbo.sp_fulltext_database @action = 'disable'" ); (see the code below) . sql server management studio creates the database with full text indexing disabled by default. but when using smo it is enabled by default and the documentation claims the opposite. (4) so where does smo take its default values from string sqlServerInstance = "localhost" ; string databaseName = "SMO_TEST" ; string dataFileLogicalName = databaseName + "_Data" ; string logFileLogicalName = databaseName + "_Log" ; string dataFilePhysicalName = dataFileLogicalName + ".mdf" ; string logFilePhysicalName = logFileLogicalName + ".ldf" ; string dataFilePath = "D:\\TEST_DIR\\" ; string logFilePath = "D:\\TEST_DIR\\" ; if (! Directory .Exists(dataFilePath)) { Directory .CreateDirectory(dataFilePath); //throw new DirectoryNotFoundException("The data file directory " + dataFilePath + " does not exists."); } if (! Directory .Exists(logFilePath)) { Directory .CreateDirectory(logFilePath); //throw new DirectoryNotFoundException("The log file directory " + logFilePath + " does not exists."); } string defaultFileGroupName = "PRIMARY" ; ServerConnection connection; connection = new ServerConnection (sqlServerInstance); Server server = new Server (connection); try { //connection.BeginTransaction(); server.ConnectionContext.BeginTransaction(); if (server.Databases.Contains(databaseName)) { server.Databases[databaseName].Drop(); server.Alter(); } Database database = new Database (server, databaseName); FileGroup fileGroup = new FileGroup (database, defaultFileGroupName); database.FileGroups.Add(fileGroup); DataFile dataFile = new DataFile (fileGroup, dataFileLogicalName); dataFile.FileName = dataFilePath + dataFilePhysicalName; dataFile.GrowthType = FileGrowthType .KB; dataFile.Growth = 1024d; fileGroup.Files.Add(dataFile); LogFile logFile = new LogFile (database, logFileLogicalName); logFile.FileName = logFilePath + logFilePhysicalName; logFile.GrowthType = FileGrowthType .Percent; logFile.MaxSize = 2147483648d; database.LogFiles.Add(logFile); database.Create(); // disable full text indexing connection.ExecuteNonQuery(databaseName + ".dbo.sp_fulltext_database @action = 'disable'" ); //connection.CommitTransaction(); server.ConnectionContext.CommitTransaction(); } catch ( FailedOperationException ex) { //connection.RollBackTransaction(); server.ConnectionContext.RollBackTransaction(); Console .WriteLine(ex.Message); } finally { if (connection != null ) { if (connection.IsOpen) { connection.Disconnect(); } connection = null ; } } thanks again Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 7
    - SSRS in Sharepoint, WrapperReportRenderingException/JobCanceledException for large Matrix (OLAP) reports You seem to be running into a problem by using HTML renderer in SharePoint mode. However, we are not aware of any such problem with large matrix reports in the HTML renderer. Can you send us the contents of your report rdl file thanx, Prash Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 8
    - AMO:Can any one knows hoe to rename a role and permissions to that role Thanks Darren. Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 9
    - RDA - multi table error for tracking You could make a single table view and pull this instead (but the view must reference only ONE table). A primary is required if using RDA tracking. See http://msdn2.microsoft.com/en-us/library/ms172971.aspx "A primary key must be defined on the updatable recordset returned by the SELECT statement. " Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 10
    - What is the easy way to do this?. Data is present in the table...i can do this with data present . [status] AS CAST (( CASE WHEN enddt <= GETDATE () THEN 'live' ELSE 'expired' END ) AS VARCHAR ( 20 )) Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 11
    - Add SQL database - "login failed for user" error I think I may have a similiar problem. When you say you 'run as administrator' is that the vista setting or is there a setting in c# express when i'm trying to connect to a database from within c# viz studio express i'm getting 'you don't have permission contact file owner or obtain administrator permission' thing is i'm 99% sure i'm an administrator on vista already and i've changed the db owner to me as well. Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 12
    - MULTIPLE COLUMNS using and GROUP BY If you want to show the multiple postal codes as single row then you can use the following query.. One row per city with out data loose.. Code Snippet Create Table #cities ( [City_name] Varchar ( 100 ) , [Province_ID] Varchar ( 100 ) , [City_PostCode] Varchar ( 100 ) ); Insert Into #cities Values ( 'Los Angeles' , 'CA' , '90150' ); Insert Into #cities Values ( 'Los Angeles' , 'CA' , '90151' ); Insert Into #cities Values ( 'Austin' , 'TX' , '73301' ); Select Distinct Main . City_name , Main . Province_ID , Substring (( Select ',' + City_PostCode as [text()] From #cities Sub Where Sub . City_name = Main . City_name And Sub . Province_ID = Main . Province_ID For XML Path ( '' )), 2 , 8000 ) as [City_PostCodes] From #cities as Main Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 13
    - Service Pack Does this mean the we can have instances where the SP levels are different for SQL Server and Reporting services I thought when a SP is applied on a server it is applied to all the services Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 14
    - copying a DB from one server to another If your SQL Server 2005 machine is running Standard Edition or higher, you can create a package in SQL Server Integration Services to automate moving data. You can schedule running the package using SQL Server Agent. Database replication (publisher/subscriber) requires higher SKUs (Workgroup and up) for the publisher. SQL Server 2005 Express can be a subscriber though. You can see a comparison of features here: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx Hope this helps, Steve Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 15
    - Default message for data unavailability Charts also have the NoRows property, but I have not been able to get it to work. I have a report with approximately 10 charts (all of which use the same data set), and when the result set is empty, I get an error - An unexpected error occurred in Report Processing. Object reference not set to an instance of an object. Any ideas Thanks, Marianne Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 16
    - Schema use in SQL2005 Certainly...Se my Comments below in bold red.... The problem is how the EXEC statement resolves to the default schema. I'd like to know if this is a bug or expected behaviour or can it be resolved /****** Object: StoredProcedure [myschema].[dnn_Forum_StatisticsGet] Script Date: 09/29/2007 08:53:05 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [myschema . [dnn_Forum_StatisticsGet] / *SCHEMA SPECIFIED is DEFAULT FOR THE USER*/ ( @ModuleID int , @UpdateWindow int = 12 , @TabId int ) AS -- Do we need to update the statistics DECLARE @LastUpdate datetime DECLARE @DateWindow datetime SET @LastUpdate = ISNULL (( SELECT MAX ( CreatedDate ) FROM dnn_Forum_Statistics_Site ), '1/1/1797' ) SET @DateWindow = DATEADD ( hh , - @UpdateWindow , GetDate ()) if ( @LastUpdate < @DateWindow ) BEGIN EXEC dnn_Forum_AA_StatisticsSiteUpdate 0 , 0 , @ModuleID , @TabId / *THIS COMMAND FAILS AS SCHEMA NOT SPECIFIED - SQL2000 this would resolve to the default owner*/ END -- SELECT current statistics SELECT TOP 1 S .*, MostReadSubject = ( SELECT Subject FROM dnn_Forum_Posts ( nolock ) WHERE PostID = S . MostReadThreadID ), MostViewsSubject = ( SELECT Subject FROM dnn_Forum_Posts ( nolock ) WHERE PostID = S . MostViewsThreadID ), MostViewsThreadForumID = ( SELECT ForumID FROM dnn_Forum_Threads ( nolock ) WHERE ThreadID = S . MostViewsThreadID ), MostActiveSubject = ( SELECT Subject FROM dnn_Forum_Posts ( nolock ) WHERE PostID = S . MostActiveThreadID ), MostActiveThreadForumID = ( SELECT ForumID FROM dnn_Forum_Threads ( nolock ) WHERE ThreadID = S . MostActiveThreadID ), MostActiveUserAlias = ( SELECT Alias FROM dnn_Forum_Users ( nolock ) WHERE UserID = S . MostActiveUserID ) FROM dnn_Forum_Statistics_Site S ( nolock ) / *THIS WILL RESOLVE CORRECTLY TO THE DEFAULT SCHEMA*/ WHERE ModuleID = @ModuleID ORDER BY CreatedDate DESC -- SELECT TOP 10 Users SELECT DISTINCT TOP 10 U .*, FUR . Alias , FUR . IsTrusted , FUR . PostCount , FUR . EnableOnlineStatus FROM dnn_Forum_Users FUR ( nolock ), dnn_Users U ( nolock ), dnn_UserPortals UP ( nolock ), dnn_Tabs DT ( nolock ), dnn_TabModules TM ( nolock ), dnn_Modules DM ( nolock ) WHERE FUR . UserID = U . UserID AND U . UserID = UP . UserID AND UP . PortalID = DT . PortalID AND DT . TabID = TM . TabID AND TM . ModuleID = DM . ModuleID AND DM . ModuleID = @ModuleID AND U . UserName <> 'NNTP_NEWSGROUP_USER' AND FUR . PostCount > 0 ORDER BY FUR . PostCount DESC -- SELECT top 10 Moderators SELECT TOP 10 U .*, FUR . Alias , FUR . IsTrusted , FUR . PostCount , M . PostsModerated FROM dnn_Users U ( nolock ), dnn_UserPortals UP ( nolock ), dnn_Forum_Users FUR ( nolock ), dnn_Forum_Moderators M ( nolock ), dnn_Tabs DT ( nolock ), dnn_TabModules TM ( nolock ), dnn_Modules DM ( nolock ) WHERE U . UserID = FUR . UserID AND FUR . UserID = M . UserID AND U . UserID = UP . UserID AND UP . PortalID = DT . PortalID AND DT . TabID = TM . TabID AND TM . TabID = DM . ModuleID AND DM . ModuleID = @ModuleID AND M . PostsModerated > 0 ORDER BY PostsModerated DESC -- SELECT Moderator actions SELECT Description , TotalActions FROM dnn_Forum_ModerationAction ( nolock ) ORDER BY TotalActions DESC Tag: SQL Server 2005 Standard will not install MSSQL default instance
- Next
  - 1
    - Limited Remote Login db access I don't even know what those things mean. How would I go about doing this with SQL logins Rob Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 2
    - Dynamically display/hide the parameter input I am using Report Manager. Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 3
    - Shredding XML to Relational Data: Query Processor Out of Resources I have found the solution. It was given to me by Andre on www.sqlpass.nl . the weird omega columns should be replaced with [1] Declare @xml xml Set @xml = XML doc here!!! Select tab . col . value ( '@num ]' , 'int' ) RowNumber , tab . col . value ( 'vhe ]' , 'varchar(50)' ) VHE , tab . col . value ( 'cv_aanwezig ]' , 'varchar(50)' ) cv_aanwezig , tab . col . value ( 'bouwjaar ]' , 'varchar(50)' ) bouwjaar From @xml . nodes ( 'vheupdate/WSDLWoning/woning/row' ) as tab ( col ) Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 4
    - How do I stop replicating deletes without a Snaphot? drop the article from the subscription, drop the article from the publication, add it back in to the publication with the change, and then add it back to the subscription - here is the code to do it. Here I am dropping the authors table from the publication pubs and then adding it back in again. sp_dropsubscription 'pubs','authors','MySubscriber','MySubscriptionDatabase' GO sp_droparticle 'Pubs','authors' GO sp_addarticle 'pubs','authors','authors' GO sp_addsubscription 'pubs','authors','MySubscriber','MySubscriptionDatabase' GO Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 5
    - Sql Express Vista trouble #2 Suprotim Agarwal wrote: Dear AlexBB, Do this : sp_configure 'user instances enabled', 1; RECONFIGURE and then restart Sql Server. http://msdn2.microsoft.com/en-us/library/ms254504(VS.80).aspx HTH, Suprotim Agarwal ----- http://www.dotnetcurry.com ----- Hi Suprotim, many many thanks, but the road to complete comprehension is still very very long. I ran your statement in a query and got this result: Configuration option 'user instances enabled' changed from 1 to 1. Run the RECONFIGURE statement to install. Two questions: (1) What does it mean that I have to run a "RECONFIGURE to Install " Install what To reconfigure what I think the statement I ran was supposed to reconfigure everything. (2) Why was I getting an error in my Visual Development Studio that the user instances were not enabled sincee the result of the query seems to indicate that they have been enabled all along as I suspected I have another question, number 3: I actually somehow configured my connections after all that bedlam in such a way that user instance = false was the preferred option. On the surface this problem has taken care of itself in a way. But want to undertstand any possible implications of my changing the user instances from 1 to 3 (provided you will explain to me how I can "install" something after that). I've read on user instances in MSDN and without claiming that I understood everything I got an idea that it is a preferred (security wise) use of Sql Server instances. My thinking is that one of the user instances will be the connection in VS, another one is my singing in as a user into SSMS if I want to make any visual inspection of databases during execution of my C# app and one instance will be spare. Thanks. Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 6
    - Deploying reports/TargetServerURL - beginner question I am trying to figure out Reporting Services and to to deploy results -- and really don't know what I'm doing. I'm going through some books and it looks like our TargetServerURL would either be http://SERVER NAME/reports or http://SERVER NAME/reports erver. Either one will give me a prompt for user & pswd. When I enter my network user & password, I get this message: "You are not authorized to view this page" (It's set up for Windows authentication.) Any suggestions Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 7
    - LastNonempty return null when filter time hierarchy Hello Puri, Let me describe the scenario I created from AdventureWorkDW. I have four dimension tables: DimGeography, DimCustomer, DimTime, DimProduct. And only one fact table: FactInternetSales. After the cube was created, I set the aggregatefunction of the measure "Freight" to "LastNonempty". Besides, I create a time hierarchy in the dimension "Due Date". The hierarchy has two levels, namely "Calender Year" and "English Month Name". Then I deploy the created cube. I brow it via BIStudio. I drag and drop freight to the measure part and time hierarchy to the upper dimension part. Everything works fine. It can show data of 2001 to 2004 and I can drilldown to show months belong to specific year. Howerver, if I set the filter to the time hierarchy and only show data of "April and August" in 2003, then I can't drilldown to the month level. It will show null if I click the "+" sign next to the "2003". Best Regardly Tom Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 8
    - I have been told to run the following SQL script against the database Here is a good set of introductory on-line tutorial videos. Hopefully, they will help you 'get a leg up' on the product. http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 9
    - How do I supress duplicate data 1) sort by the column in which you want to supress duplicate data. 2) use the following expression in that text box which contains the column field =iif( column1.previous = column1.value,"blank",column1.value) there is a "previous" function available, this willhelp u th suppress if data duplicates Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 10
    - Project 2007 Server Cube Build Fails Connecting To Another SQL 2005 Analysis Server thanks, yeah I followed that page completly. What other possible users aside from the SPPAdmin user could it possibly be trying to use. The project server and the sql server are on the same domain. Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 11
    - Passing multi value parameters to CreateSubscription Hello Lukasz, Thanks a lot for your reply. I am indeed passing the params as an array of ParameterValue: it is called parametrosRpt in the code that I show. To further clarify my problem, let's say I have to pass the subscription 2 parameters: 1) CustomerID = 123 2) ProductTypes = 'A', 'B', 'C' (multi value) I would do this: Dim parameter1 As New ReportService2005.ParameterValue() parameter.Name = 'CustomerID' parameter.Value = '123' parameter.Label = Nothing parametrosRpt(0) = parameter Dim parameter2 As New ReportService2005.ParameterValue() parameter.Name = 'ProductTypes' parameter.Value = ''A','B','C'' parameter.Label = Nothing parametrosRpt(1) = parameter RS.CreateNewSubscription( "Report Name" , "Some description", scheduleXml, txtTo.Text, _ txtCopia.Text, txtCopiaOculta.Text, txtAsunto.Text, comboFormato.SelectedValue, memoCuerpo.Text, _ parametrosRpt) <---- here is my array of 2 ParameterValue What am I missing Again, any help will be greatly appreciated. Thanks again Lukasz. Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 12
    - Data Flow Task - Conditions to add value for a field. Phil is spot on as usual. Here is the BOL topic devoted to it: : (Conditional) (SSIS) ( http://msdn2.microsoft.com/en-us/library/ms141680.aspx ) -Jamie Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 13
    - Search by multiple date range options after reading the above link in detail...I got it working...thanks!!!! Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 14
    - MSSQL Select commands to FTP Thank you very much for the reply. I know this sounds simple, but do you know any tutorial out there that shows how to do this Thanks again in advance. Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 15
    - VS.NET debug website gives connection error to SQL Database What is your connection string Is this a local or remote connection any firewall issue What are the protocols enabled on your server Thanks, Tag: SQL Server 2005 Standard will not install MSSQL default instance
  - 16
    - Passing Parameters thru a Link On your textbox, you have an action property you can utilize. From there, choose jump to report and click on the parameters button, sending in the current value (DataSetName!FieldName.Value) Tag: SQL Server 2005 Standard will not install MSSQL default instance

fbellay

I installed SQL Server 2005 flawlessly yesterday. When login as "sa" through SQL Server Management Studio, I get an error message saying it cannot connect to my PC.

I checked the MSSQL Server Service. It is not started and cannot be started because it's looking for a path that does not exist!.

The folder in question is missing.

C:\Program Files\Microsoft SQL Server\MSSQL\

The following folders do exist:

C:\Program Files\Microsoft SQL Server\MSSQL.1

C:\Program Files\Microsoft SQL Server\MSSQL.2

I initially suspected this problem was cause by a previous MSDE 2000 installation.

I uninstalled SQL Server 2005 & MSDE 2000.

I re-installed SQL Server 2005. Same problem.

I executed

http://support.microsoft.com/default.aspx/kb/320873

to make sure all registries are removed and manually deleted C:\Program Files\Microsoft SQL Server\’s content

Re-installed SQL Server 2005. Same problem.

I do not know what do in order to get SQL Server 2005 up & running.

All help is greatly appreciated.

Frank

Re: SQL Server 2005 Standard will not install MSSQL default instance

Jens K. Suessmeyer

That sounds strange. WHat does the event log tell you exactly. You could change the following keys to help SQL server service to find the necessary paths.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\Parameters

Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

Re: SQL Server 2005 Standard will not install MSSQL default instance

fbellay

Jens,

The MSSQLSERVER service is ultimately looking for :

"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER

I just checked and sqlserver.exe is nowehere to be found under C:\Program Files\Microsoft SQL Server\

Question: Can you tell me where the eventlog is located exactly

Thanks for your help,

Frank