During customer engagement, I was told that there are Microsoft add-on to be installed on SQL 2005 and the SQL 2005 can be simulated as SQL 2000, SQL 2000 SP4, SQL 7.0 in different SQL instances.
Is this true? Are there URLs about this topic?
Thanks a lot.
Po-Shan.
My client has a server running MS 2003 Server for Smal Business Server, and it has SQL Server Express 2005 installed (I believe it is installed 3 times, as part of SharePoint, Veritas Backup Exec and ACT! applications).
I am trying to implement an application that uses SQL Server 2000, but the Server 2003 SBS does not support that version. So I need to launch an additional instance of SQL Server Exp 2005.
To do so, do I need to download and install SQL Server Express 2005 software again? Or can I just run SQLSVR.exe from an existing instance, but with a different instance name (sqlservr.exe -s<InstanceName>?
The reason I need another instance is that these existing instances limit DDL statements.
I am new to this and compare it to launching MS Word multiple times - you don't need to reinstall Word to run it multiple times.
Is launching from the command line a bad idea - and if it is, what is the better way to ensure that it launches under the local system context a service?
Thanks in advance for any help and insights. It is much appreciated.
Hi all,
Since some analysis services features are only available in Enterprise version , I have to upgrade my SQL 2005 server from standard edition to enterpise edition.
So I uninstall originial standard version of analysis service and install a Enterprise version. However, the analysis service is still a standard version after installation.
Is it possible to keep data engine as standard version and install a enterprise version of analysis service?
Thank you very much
Tony
i am working on upgrading the clients and server computers from 2000 MSDE to 2005 SQL Express Adv. Plan to upgrade using the template.ini.
i can find the version of sql server running on th server by @@version but how do i find the version of client connctivity components the computer has installed in order to ugrade?
1. somehow i need to know whether to upgrade a client computer CONNECTIVITY COMPONENTS from 2000 to 2005?
2. is there a way to enable tcp/ip in installation script of SQL Express?
THANKS
Can multiple instances of SQL 2005 Express attach to the same database files on a network share? I have seen this done before with MSDE where the database files are stored on the server, but instead of having a SQL server running on the network and then connecting to it, only the database files exist on the network share and the users connect through MSDE running on the local machine. Is this possible with SQL2005Express? I do not have the ability to share an SQL instance from one workstation to another nor do I have the ability to install an instance on the corporate server. Is it as simple as creating the database and storing the files on the share then attaching the database to the SQL Instance on each workstation?
View 3 Replies View RelatedWe have a 64bit os machine that we accidently loaded the 32 bit version of sql server on. We now want to upgrade it to 64 bit sql server, but we now have a production database on it. My understanding is that all I have to do is detach the production database, upgrade to 64bit sql server, then reattach the database. Is this really all I have to do?
View 4 Replies View RelatedTwo Questions.
1.) I have developed some SSIS packages that are currently out in production. We are on to the next phase of development and enhancments to the packages are being developed as a phase 2 release. I can push these changes to a QA setup for testing. But I also need to do fixes to the existing packages out in production and run them through testing. Unfortunatly I do not have an extra server to have a QA and a QA Current Production setup for seperate testing. So is there any way to run two versions of the same package on one (the same) server? I presently store the packages in the MSDB. Can I have or specify which version of package to run?
2.) Additionally, can you run multiple configurations for a single version of a package but only call one of them? For example can I create two configurations and then specify which one to use when calling the package to run? So that I could have code pass which configuration to load which would change connection strings and such. Any examples would be awesome.
Thanks.
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?
Chuck
Want to upgrade Evaluation version of SQL 2005 to full retail version. How would I do that. Thanks very much for your hel
Sam Commar
When I installed VS 2005, it installed the default version of SQL Server 2005 Express that ships with Visual Studio 2005 installer media.
How can apply SQL Server 2005 Express SP1 to update this existing instance?
Currently, if I run this query:
SELECT @@version
I get the following:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
After applying SP1, I should get 9.00.2047.00.
Should I just go to this link and download & install the SQL Server 2005 Express Edition SP1:
http://msdn.microsoft.com/vstudio/express/sql/download/
Thank you,
Bashman
hi peter... i have a question about, how i can see if my sql server is the version 2005 sp2 and, what is the diference with server and server agent... i've checked the updates and the machine says i have up to date... but i dont know witch is.
thank you for your help
I am writing a client application that offers an UI that allows an administrator to remotely add/delete/update user accounts accross many different SQL Servers running on XP and up.
When the operating system is W2K3 or higher I want to take advantage of the "check_expiration, check_policy, must_change' arguments to create login and exclude those features when the host OS does not support them.
Is there an easy way to determine if those arguments are supported?
Thanks
Mark
I recently upgraded to SQL Server 2005. My databases are stable and functioning perfectly. However, these databases are using the 32-bit version of SQL Server. The servers are going to be upgraded to 64-bit processors and new Server 2003 64-bit OS's.
Everything I have been able to find says that it is a simple process of backing up the databases in the 32-bit environment and restoring them in the 64-bit environment.
Could it really be that easy? I am looking for someone who has done this to provide any "heads up" commentary on what to look out for during that process. Can anyone provide some information on this process?
Thanks.
I have a basic question to ask:
I have two server both showing SQL server 2005 installed. One of them is a licensed SQL server 2005 and the other is a express edition.
I am trying to find out which one in is express and which is the full licensed version.
I checked at the control pane and they both show up as SQL server 2005. The directory structure at Program Files looks the same.
Please help me.
Thanks,
Karthik
We are consolidating some old SQL server-environments from 'OLD' to 'NEW' and one of our vendors is protesting on behalve of the collation we use on our 'NEW' SQL server.
Our old server (SQL 2005) contains databases with collation SQL_Latin1_General_CP1_CI_AS
Our new server (2014) has the standard collation Latin1_General_CI_AS
Both collations have CI and AS
From experience I know different databases can reside next to eachother on the same Instance.
The only problem could be ('could be !!') the use of TempDB with a high volume of transaction to be executured in TempDB and choosing for Snapshot Isolation Level ....
The application the databases belong to is very static, hardly updated, and questioned only several time per hour (so no TempDB issue I guess).
using different databases using a different collation running on the same instance?
Are the install files for the 64 bit version on the same cd/dvd as the 32 bit version?
View 1 Replies View RelatedHi,
I m using Windows 2003 Server. I installed SQL Server2005 and now i want to apply CTP service pack on it. I downloaded all the SP2 patches available on the site http://www.microsoft.com/downloads/details.aspx?FamilyID=D2DA6579-D49C-4B25-8F8A-79D14145500D&displaylang=en . Each of them is giving an error and it is not getting installed on SQLServer 2005; Is it a problem with my hardware? or the version of Windows? or the version of SQLServer 2005?
Can anyone help me with this problem ?
THanks,
Srividya
I have run exec xp_msver on the sql server management studio
please can anybody tell me which edition of sql server 2005 i am using...
is it ENTERPRISE EDITION or EXPRESS edition.
thanks in advance
regards,
pranav
1 ProductName NULL Microsoft SQL Server
2 ProductVersion 589824 9.00.1399.06
3 Language 1033 English (United States)
4 Platform NULL NT INTEL X86
5 Comments NULL NT INTEL X86
6 CompanyName NULL Microsoft Corporation
7 FileDescription NULL SQL Server Windows NT
8 FileVersion NULL 2005.090.1399.00
9 InternalName NULL SQLSERVR
10 LegalCopyright NULL © Microsoft Corp. All rights reserved.
11 LegalTrademarks NULL Microsoft® is a registered trademark of Microsoft Corporation. Windows(TM) is a trademark of Microsoft Corporation
12 OriginalFilename NULL SQLSERVR.EXE
13 PrivateBuild NULL NULL
14 SpecialBuild 91684864 NULL
15 WindowsVersion 170393861 5.1 (2600)
16 ProcessorCount 1 1
17 ProcessorActiveMask 1 00000001
18 ProcessorType 586 PROCESSOR_INTEL_PENTIUM
19 PhysicalMemory 510 510 (534757376)
Hi,
is it possible to change the installed version on a server from SQL 2000 Standard Edition to SQL 2000 Developer Edition?
The server has been a production server and is now only used for testing by development, not from end users.
Best regards, Stefoon
I have the following:
(a) One Dynamic SQL Query that takes 37 ms when run as a single query or in an SP.
(b) Three SQL Indexed View queries that take 0 ms when run together.
When i add (a) + (b) in the same SP, i should get 37 ms + 0 ms = 37ms, but NO it takes 400 ms.
What is causing the extra 363 ms of latency.
I have a website running under Windows Server 2003 which I am trying to deploy Reportin Services to using a custom security extension using Forms authentication. There is also another website which is just a Report Server running on this IIS 6.
On my development machine, XP with IIS 5.1, the Website with Reporting Services using forms authentication works fine, shares cookies for authentication and all that jazz. but trying to configure a second instance of Reporting Services on Server 2003 is not behaving.
Is there some trickery or details involved with running two instances of Reporting Services?
Also in the Configure Report Server tool it is failing and so not initializing on the last step of the Database Setup
Setting Connection Info for Reporting Server
ReportServicesConfigUI.WMIProvider.WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is running, and then retry the operation.
---> System.Runtime.InteropServices.COMException (0x800706B3): The RPC server is not listening. (Exception from HRESULT: 0x800706B3)
--- End of inner exception stack trace ---
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ListReportServersInDatabase(RSReportServerInfo[]& serverInfos)
I am going to install SQL server 2005 for my company. Can someone tell me which version should I install between the 32-bit and 64-bit?
Thank you for the help in advance!
Suin
I have sql server 2005 - version 9.00.3054.00 -SP2 - Enterprise Edition. Is there any latest version than this to upgrade. I am having lot of troubles on the server these days. Whenever Analysis server cube is processed, the server is going really slow and before the cube process analysis service is stopping. I don't understand what the problem is? Analysis services is getting stopped whenever a cube is processed and server performance is getting really slower.
Please let me know how to trouble shoot this.
Thanks in advance.
Hi everyone
I've just installed the microsoft's evaluation version of sql 2005 at my home computer.
Now i'm trying to connect ("sql sever management studio") but i dont know the server's name nor user name. I dont rememeber ever asked to produce any during the installation.
Bottom line- the evaluation version of sql server 2005 is installed but i cannot log in. How do i get to know my user name ? server name ? What ever i try i'm announced that the present version is not working for remote connections. I try to connect from the same very machine of the sql server. What is wrong ?
Thanks
I would like to know if it's possible to embed a SQL Server 2000/2005 DBwithin a desktop application so that the end users cannot view the DB.Also, this will prevent them from copying the database on to their otherSQL Servers.Also, what are the options to load SQL Server 2005 on Win 98*** Sent via Developersdex http://www.developersdex.com ***
View 2 Replies View RelatedI have Windows Vista Ultimate 64 installed on my computer, along with IIS 7 and the required IIS 6 components for SQL Server 2005. I also have Visual Studio 2005 Pro installed, but I have uninstalled SQL Server 2005 Express.
When I try to install SQL Server 2005 Pro, with all features, the 32 bit version always wants to install. I can't find a way to get the x64 version of SQL Server to install.
What am I doing wrong?
I'm looking at installing 2008R2 and 2014 side by side, then using Mirroring to provide HA for the 2008R2 instance and AoHA for the 2014 instance. I'd be using the same two physical servers for both the Mirroring pair and the AoHA pair.
View 2 Replies View RelatedI have been running SQL Server 2005 Express with the Management Studio Express. I just downloaded and installed the Eval (Trial) version of SQL Server 2005 but have not been able to get it working. Here are a couple of questions:1. Is there a potential confict with having both versions on my machine. I don't want to uninstall express since I may have to do back to it in 180 days.2. Is there a program comparable to the Management Studio for the Eval version of SQL Server 2005?3. How do I access the Eval version? I found the folder where it installed on my C drive but don't know what to do with it.Thanks for any help you can provide.
View 3 Replies View RelatedIs there any way to get the version of a database without attaching it to the server. Or can I attach a database without converting from SQL Server 2000 to SQL Server 2005.
The reason is that I have to ask the user before a convert the database from SQL Server 2000 to 2005.
Hi,
We have our SQL databases clustered using MSCS on X64 servers and are planning to apply SP2. During initial tests, we find that around 20-25% queries perform slow after applying SP2 compared to SP1. Just wanted to know if anyone else has found the same behavior and if there are any known patterns / issues with respect to performance for Sp2
I'm trying toinstall sql server 2005 trial version on my vista operating system. which extraction excutablile I should select from the following x85 excutable, x64excutable?
View 4 Replies View Related
Hello!
I hope somebody can solve my question, now my workstation PC is install with Sql Server 2005 Evalution Version, I need to view sys.sysobjvalues, and after i check online, it need i logon using Dedicated Administarator Connection (DAC), but I failed to do that! Is it the Evaluation version not have this feature?
When I ran @@version I get this:
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
I assume this is a licensed version because the std edition does not have a trial license? Can someone confirm this?
If this were a trial version, what could I expect to see?