Custom Installation Of Sql Std 2005.. What Are Most Doing?
Dec 28, 2007
I've configured a min. of two drives.. C and D.. we typically install
the database files on d.. ie: d:datasql databasesinstancenameshere
When i run setup.. i let it pick the defaults.. then afterwards i
change the default database path to D:
Is there any reason NOT to do this..
IE: choose this path d:...sql when i click advanced during setup..
and have the program files placed there too.. IE: master db's etc
too..
(does having a seperate backup of the master database files even matter, ie: if reinstalling say on a different box or even the same box, dont these need to be recreated from scratch anyway?)
What are most doing.. with multi logical drive letter installs?
I'd like to install SQL SERVER 2005 Express Edition ,I begin to install it from DVD but during the installation it dosn't ask me about any instance and after installation there isn't SQLExpress service and I can't use sql server .(there are not MSSQL and Binn directory in sql server 2005) but when I install visual studio 2005 and after that I install sql server 2005 it ask me for name of instance and with this way every thing is ok and I use sql server completely.
I 'd like to know the complete installation of sql server 2005 is depend on installation of visual studio 2005 befor it ?if not how can I introduce any instance after installation of sel server 2005 .
Hi all, How to package sql server database as part of our custom application (VB application) using install shield or any software. That setup should detect the presence of sql server. If sql server is not present in the client machine, then our set up should install the sql server and deploy our database. If sql server is present in the client machine, then our set up should install our database alone. How to do that. Please help me. Regards, S.Sevugan.
I am creating a custom transformation component, and a custom user interface for that component.
In my custom UI, I want to show the custom properties, and allow users to edit these properties similar to how the advanced editor shows the properties.
I know in my UI I need to create a "Property Grid". In the properties of this grid, I can select the object I want to display data for, however, the only objects that appear are the objects that I have already created within this UI, and not the actual component object with the custom properties.
How do I go about getting the properties for my transformation component listed in this property grid?
Even though I am not "new to SQL Server", my experience in working with it has ebbed and flowed, and working with SQL Server is not something that happens for me even on a monthly basis.
I work as an in-house programmer for a financial investment company and I have been asked to work on a database that is to hold financial data.
One of the requirements for the tables has been that the Primary Key should be [name_of_the_table] + [Identity].
So, for example, for table "tblEquities", the values of the Primary Key would be:
My questions are: 1) Is it possible to achieve this by using just one column, as in defining a formula for the "Computed Column Specification" , something that would look like "'tblEquities' + Identity()"? 2) If the above is not possible, I assume it's much easier to just define a column as being Identity column and then create a 2nd computed column that would aggregate the name of the table with the value in the Identity column, so that I end up with a column holding the desired values? (I guess it would look something like "'tblEquities' + [Identity]")
Also, I have been asked to find out what SQL 2005 have/offers, in term of guaranteeing referential integrity. Are the "Database Diagram", as well as the "Relationships" dialog box, the tools that would meet that criteria or does SQL 2005 contain other tools that would help in this regard?
I'm having a lot of trouble trying to set up a custom security extension with Reporting Services 2005. Following the VB example from McGraw Hill Osborne (http://www.mhprofessional.com/product.php?cat=112&isbn=0072262397&cat=112), I've compiled the .dll for the extension and made the changes to the ReportManager and ReportServer .config files. After I reset IIS and return to the RS website, it displays "The report server has encountered a configuration error..." and I get a message in my System Event log:
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {BA126AD1-2166-11D1-B1D0-00805FC1270E} to the user MYMACHINEASPNET SID (S-1-5-21-1708537768-839522115-1343024091-1005). This security permission can be modified using the Component Services administrative tool.
Wondering if anyone else has had similar trouble and how did they get around it?
Hello to everyone, I've a question about UDTs and the way I can use them to access tables and columns where they are applied in a SQL Server 2005 DB. I've already spent 2 days googling and MSDN reading but nothing helped me to solve my problem, thats why I'm posting it here (this is the second post, maybe the last one was in the wrong Forum).
The scenario follows:
I've created a UDT called MyUDT that exposes 2 properties MyTable, MyColumn, here its the code:
[Serializable] [SqlUserDefinedType(Format.UserDefined, IsByteOrdered = true, MaxByteSize = 8000, Name = "MyUDT")] public class MyUDT : INullable, IBinarySerialize {
/// <summary> /// Set or Get the Table Name where the UDT is applied. /// </summary> public string MyTable { get { return this._myTable; } set { this._myTable = value; } }
/// <summary> /// Set or Get the Table's Column Name where the UDT is applied. /// </summary> public string MyColumn { get { return this._myColumn; } set { this._myColumn = value; } }
....
}
And here it's my question/s:
How can I expose the defined Properties (MyTable, MyColumn) in order to be directly used from SQL Server Management Studio within the Column Properties Panel?
If it is not possible, is there a way for any UDT to get back from the sql server execution context the table and the column where it is applied/used?
I need to solve that in order to later retrieve via SQL the Extended Table Properties where the UDT is used and make some work on presented MetaData. Thanks in advance, every answer/help will be very much appreciated.
I installed Visual Studio 2005 Professional then after that was installed and running, I tried to install the the SQL Server 2005 Developer's Edition which installed but I do not get the SQL Server 2005 Studio Manager. I have remove and reinstalled but it never gets installed. Any ideas?
I currently have a website which is using ASP.NET 2.0, C#, and SQLServer 2005. The website will be used to enter grants for auniversity. When a new grant is entered, I need to generate a primarykey. The primary key will need to follow the format: Two digit forfiscal year, then number of the grant for that year. Example:Year 08 and 14th grant of the year would be: 0814How can I implement this. Right now, I have a "New Grant.aspx" pagewith a Submit button. I am guessing the date is going to be formattedin C#. How can I check what the last primary key in the database is?Also, it seems to me that SQL Server insists that the primary key be32 bits long, however my primary key will only be 4. How can Ioverride this? Thanks.
I designed dll file to get data from sql server, i am calling the dll from ssrs 2005 in preview , everything is ok but after deploying and put the dll file in C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerin and add this to rssrvpolicy.config
<CodeGroup class="SqlClientPermission" version="1" Name="MySecurityExtensionCodeGroup" Description="Code Group for Don's test security extension" PermissionSetName="FullTrust"> <IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:Program FilesMicrosoft SQL ServerMSSQLReporting ServicesReportServerinMyAssembly.dll" /> </CodeGroup>
I want to integrate SQL Server 2005 setup into my Testproject Configurator setup. SQL Server 2005 install files should not be included in TestProject setup. If SQL Server 2005 is not installed on the target computer and install files are available then TestProject setup will install SQL Server 2005 with myProjectInstance instance name.
how the setup can install the custom instance name.?
I have two Win 2003 r2 servers. These are not production servers. They are very lightweight boxes for testing apps. Everything worked find when all was on one svr01 except ... too slow.
- I installed svr02 as member of Domain svc01 ... should I make svr02 a child Domain svr01?
- Currently, I cannot add any kind of data connection via Visual Studio..
hi whenever i install ms sql 2005 express edition, only the configuration manager gets installed. but i need sql query analyzer. can anyyone tell me why it doesnt get installed. also plz let me the what should i do to get query analyzer installed..
How to Protect From SQL Injection in ASP.NET and SQL 2005 for custom query expression?In my project, I allow user to custom query expression through UI, such asstring queryCondition=' sale>20 and sale <100'string queryCondition=' createDate>"10/10/2005"'string queryCondition='Fullname like "%Paul%" '...I construct SQL based the queryCondition string, such as string mysql='select * from mytable where '+queryConditionI know it's very dangerous because of SQL Injection, but it's very convenient for user to custom query expressionCould you tell me how to do? many thanks!
I have been struggling to deploy a custom rendering extension onto Reporting services 2005. I have followed all the steps given in the MSDN article http://msdn.microsoft.com/msdnmag/issues/05/02/customrenderers/defaul...
Especially -
1. Copied the dll generated to the reporting service bin folder.
2. Made the entry in C:Program FilesMicrosoft SQL ServerMSSQL. 3Reporting ServicesReportServer sreportserver.config file as <Extension Name="CUSTOM_RENDERER" Type="MSDNMagazine.CustomRSRenderer.Renderer,MSDNMagazine.CustomRSRenderer"/
3. Made an entry in C:Program FilesMicrosoft SQL ServerMSSQL. 3Reporting ServicesReportServer ssrvpolicy.config file as
<CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="Custom Render Extension" Description="This code group grants data extensions full trust."> <IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting Services ReportServerinMSDNMagazine.CustomRSRenderer.dll"/> </CodeGroup>
I am able to see the extension being listed in the Report manager list of available rendering options, But I get the following error from the report server when I try exporting to the custom rendering extension
An attempt has been made to use a rendering extension that is not registered for this report server. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Exception: An attempt has been made to use a rendering extension that is not registered for this report server.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[Exception: An attempt has been made to use a rendering extension that is not registered for this report server.] Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +489 Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +958
Looking at the logs of the report server at Max trace level, gives me the following dump
w3wp!processing!b!03/01/2007-22:35:22:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An attempt has been made to use a rendering extension that is not registered for this report server., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An attempt has been made to use a rendering extension that is not registered for this report server. w3wp!chunks!b!03/01/2007-22:35:22:: v VERBOSE: ### ID=3f94a6f1-8ff7-448c-8cf3-494ab8fe4837, Length=0, CompressedLength=0, TimeCompressing=0, TimeUncompressing=0, Ratio=0, Buffering=0, Permanent=False w3wp!library!b!03/01/2007-22:35:22:: v VERBOSE: Transaction rollback. w3wp!webserver!b!03/01/2007-22:35:22:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An attempt has been made to use a rendering extension that is not registered for this report server. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An attempt has been made to use a rendering extension that is not registered for this report server. at Microsoft.ReportingServices.ReportProcessing.ReportRendererFactory.GetRenderer(String format, IReportServerInformation serverInfo) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CreateRenderer(String format) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback) at Microsoft.ReportingServices.Library.RenderSnapshotAction.Render() at Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext reportContext, ClientRequest session, RenderingResult& result) at Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters) at Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effecectiveParameters, String[]& secondaryStreamNames) at Microsoft.ReportingServices.Library.RenderNextCancelableStep.Execute() at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() --- End of inner exception stack trace --- at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() at Microsoft.ReportingServices.Library.RenderNextCancelableStep.RenderNext(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage() w3wp!dbcleanup!9!3/1/2007-22:35:41:: v VERBOSE: Starting database cleanup. w3wp!library!9!3/1/2007-22:35:41:: v VERBOSE: Call to CleanBatch() w3wp!dbcleanup!9!3/1/2007-22:35:41:: v VERBOSE: Cleaning expired sessions from DB w3wp!library!9!3/1/2007-22:35:41:: v VERBOSE: Transaction begin. w3wp!library!9!3/1/2007-22:35:41:: v VERBOSE: Transaction commit. w3wp!dbcleanup!9!3/1/2007-22:35:41:: v VERBOSE: Cleaning expired cache from DB w3wp!library!9!3/1/2007-22:35:41:: v VERBOSE: Transaction begin. w3wp!library!9!3/1/2007-22:35:41:: v VERBOSE: Transaction commit. w3wp!dbcleanup!9!3/1/2007-22:35:41:: v VERBOSE: Cleaning orphaned snapshots from DB w3wp!library!9!3/1/2007-22:35:41:: v VERBOSE: Transaction begin. w3wp!library!9!3/1/2007-22:35:41:: v VERBOSE: Transaction commit. w3wp!library!9!3/1/2007-22:35:41:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams w3wp!dbcleanup!9!3/1/2007-22:35:41:: v VERBOSE: Database cleanup executed.
Hello all, I´m a beginner on AS2005 (but I know pretty well AS2000), I migrated a cube from AS2000 to AS2005 but in this cube I have a Custom Rollup Formula on two levels of my Time dimension (month and week), an example of the week level formula is the next: iif( [Time].CurrentMember.Name = [Time].CurrentMember.NextMember.Name, null, iif( [Time].CurrentMember.Name = [Time].CurrentMember.PrevMember.Name, Sum({[Time].CurrentMember.Children,[Time].CurrentMember.PrevMember.Children}), Sum([Time].CurrentMember.Children) ) ) <<this formula overrides the week aggregations>>
and I really need this but I cannot find on AS2005 where to do the same thing, someone can tell me where can I define Custom Rollup Formulas and how?. Thanks in advance!
Hi: I try to install SQL Server 2005 but it gives warning message. My computer configuration is Pentium III 900 HZ, 512 RAM with operating system windows 2000 Pro and service pack 4 and 10 GB free space. It gives warning on operating system. Also Visual Studio. Net 2005 is already installed on my comupter.
- SQL Server Edition Operating System Compatibility (Warning) Messages * SQL Server Edition Operating System Compatibility
* Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online.
- Operating System Minimum Level Requirement (Success) Messages * Operating System Minimum Level Requirement
* Check Passed
- Operating System Service Pack Level Requirement. (Success) Messages * Operating System Service Pack Level Requirement.
This is my first task of installing sqlserver 2005 on 64 bit machine in windows 2003 environment. As a DBA what are the thnigs i need to know for the successful installation of sqlserver 2005 and what the things that are need to be installed along with sqlserver, and what are the accounts to be created like all the things i need to know..
I have to install SQL Server 2005 on SBS Standard 2003. I am already running Sql Server Desktop Engine with three instances: MSSQL$SHAREPOINT, MSSQL$SBSMONITORING, MSSQL$BLUECOAT. I am wondering how the installation is gonna affect my system. I do need SQL Server 2005 for the new financial software which is intalled 2morrow. What shall I put as the instance during the installation. Is Sql Server Desktop Engine gonna be replaced by SQL Server 2005?
i had downloaded .Net and SQL Server 2005 from microsoft site. In SQL Server 2005 after installation i get only Configuration Tools and 3 subtopics. I am able to create table only through . NET but am not able to work independantly with SQL Server 2005. Can anyone advice me!!
I want to install a new SQL 2005 server. i looked on MSDN, it says to create one or more domain user accounts. That means to create a windows domain. Is it neccessary? All I want is a stand-alone SQL server. right now we are working with SQL 2000 and we want to build a new server with SQL 2005.
I trying to Install on Windows XP with Service pack 4, OS.
I am trying to install the Developer Edition of SQL Server 2005 version for which it is not able to load many packages as it says IIS services, Integration Services Etc,. were not installed and if they were ignored then rest will be loaded and thereafter I could not either login or invoke either any.
Can anyone suggest me where it went wrong and what I need to do with instructions.
Unfortunately for me, I am not a DBA - even though I have always filled that role where ever I have been. That being said, I have always been fortunate enough to have someone else more knowledgeable than I to perform the initial build of the SQL Servers I have used and managed. So, I have the following question...
I just finished installing and configuring a new dedicated SQL Server (it is nice too). One of the included discs it he MSDN Library. Do I need to install that too? Is there any reason to or not to install it? I would appreciate any feedback.
At stage: Visual Studio Integrated Development Environment 2005
Coping new files dv_commoner.hxs Directory....... 89818
Last lines in SQLSetup0001_ADH1_PPESku_1.log:
........
MSI (s) (40:C8) [10:32:18:640]: Executing op: ChangeMedia(MediaVolumeLabel=SQLDEV,MediaPrompt=Please insert the disk: Microsoft Visual Studio 2005 Premier Partner Edition - ENU Disk 1,MediaCabinet=1\_1519_RTL_x86_enu_VSCC_Help_Collection.cab,BytesPerTick=32768,CopierType=1,,,SignatureRequired=0,,,IsFirstPhysicalMedia=1) MSI (s) (40:C8) [10:32:18:656]: Executing op: FileCopy(SourceName=92310|dv_commoner.hxs,SourceCabKey=commoner_hxs_8_ENU____.3643236F_FC70_11D3_A536_0090278A1BB8,DestName=dv_commoner.hxs,Attributes=16384,FileSize=89818,PerTick=32768,,VerifyMedia=1,,,,,CheckCRC=0,Version=8.0.50730.10000,Language=1033,InstallMode=58982400,,,,,,,) MSI (s) (40:C8) [10:32:18:656]: File: C:Program FilesCommon FilesMicrosoft SharedDevHelpVSCCv8.0dv_commoner.hxs; To be installed; Won't patch; No existing file MSI (s) (40:C8) [10:32:18:656]: Source for file 'commoner_hxs_8_ENU____.3643236F_FC70_11D3_A536_0090278A1BB8' is compressed
