Please could anyone tell me what are the real differences between SQL Server 2005 bundled along with Visual Studio.NET and a standalone one.
Thanks in advance.
Can someone please tell me if i can use SQL Server 2005 on my standalone laptop, and how do i connect, i dont know how to set up the password so i can connect
Many thanks Rob
I want to find whether SQL Server 2005 x86 is installed or SQL Server 2005 x64 is installed programatically(Any API would do.) If anyone can recommend a registry key that I can rely on find whether it is a 32 bit or 64 bit SQL Server that would suffice.
View 5 Replies View RelatedI have attached the SAN, configured the Windows Clustering and I'm ready for SQL. SQL Server 2005 was already on this machine as a stand alone. I removed all of the software and I'm reinstalling SQL. The cluster option is not enabled. Any ideas why?
View 1 Replies View RelatedI just want to run a webiste off my home computer with a dynamic address.It seems I can do all I want with the SQL that comes with vs2005 except being able to backup the DBIs the SQL 2005 that comes with vs2005 good enoh for everything I should want to do?? Is there some chart somewhere that explains the differences ?
View 4 Replies View RelatedI 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
I have never installed sql server before and I didnt know if I just take the sql server 2005 standard edition media and boot off it and do a fresh install that way or do I have to install Windows server
View 3 Replies View RelatedHi,
Can we install reporting services 2005 in a machine in which is not installed SQL server 2005.?
Thanks
Help!!!
I want to install SQLExp2K5 with Advanced Services on a standalone basis on my Dell Inspiron XPS laptop (Win XP sp2, .NET 2.0; 2gb RAM; 8mb broadband; hardware firewall/router) so that I can learn SQL/VB/VWD, and want to use SQL E 2K5 without internet connectivity (at least until I know what the hell I'm doing!)
Really confused as to what component(s), and services I should/should not install - so I've listed my questions below:
1. Service Account: As I'm not on / dont have a domain, i presume using a domain user account is not an option for me. Should I use the Local Service account ? If so, what are/can be the issues in doing so?
2. Authentication Mode: Is Windows Authentication the one to use for a standalone install?; how would I enable the "sa" account and set an "sa" password? In fact, do I even need an"sa" account / password for a standalone, non internet connected install?
3. Components at install: Is it OK to install all components first off?
4. IIS: Is it possible to install IIS and not allow it access to the internet (or is this a stupid question -bearing in mind I dont really know what IIS is/does)
5: Business Intelligence Development Suite: How do I add BIDS once (IF) I manage to install SQLExp2K5-Adv.Ser,?
6. SQLExp2K5 Books on-line: Am I right in thinking that I should install this after installing SQLExp2K5?
7: Visual Basic Express/Visual Web Developer Express: Do these need to be configured seperately to work with SQLExp2K5?
Sorry about the length of this post, but have tried to be as clear as possible. Also apologise in advance for silly/stupid questions :)
All help and advice greatly appreciated.
Thanks,
sqlexpressbeginner
hi !!I have just downloaded 180 days trial version....It is not getting installed by me...It shows : minimum hardware requirement does not match. .... I have computer with 512MB RAM and 1.60 Ghz process with XP professional installed on it with SP2.I have just formated my pc and trying to install SQL2005...i have already VS2005 installed in my PC..Any idea???
View 2 Replies View RelatedHello,
I've installed the MS SQL Server 2005, and when I click on Start->Programs-> MS SQL Server 2005->Configuration Tools, there are 3 options given:
1.SQL Server Error and Usage Reporting
2.SQL Server Configuration Manager
3.SQL Server Surface Area Configuration
My objective is to have a database where I can play and refresh my skills in T-SQL. I would want to create or view tables and data. I've already downloaded CodePlex's sample database and installed it, but it is not showing. How can I configure these server to show tables and stuff?
I'm not a DBA but a programmer, and don't have the luxury of going through tons of documentation for this thing to get going. Any help would be appreciated.
Thanks
I am interested in installing both SQL Server 2005 Express and SQL Server2005 b2 on the same machine. Can they both be installed on the same machinewithout conflicts? As in two different instances?John Dalberg
View 1 Replies View RelatedI've just installed Visual Web Developer Express and SQL Server 2005. I'm running thru the painfully slow video tutorials from Microsoft (see here).
I've open Web Dev and tried to create a new SQL Database Item, only to receive this error:
"Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL http://microsoft.com"
I'm totally new to this, but this still makes no sense.
My company wants to combine our SQL2000 and SQL2005 severs onto one server. If I install SQL2000 and 2005 on one server and migrate the data bases will I have any performance issues? Is there any issues or conflicts known by putting them both on the same server?
View 4 Replies View RelatedI want to find whether SQL Server 2005 x86 is installed or SQL Server 2005 x64 is installed programatically(Any API would do.) If anyone can recommend a registry key that I can rely on find whether it is a 32 bit or 64 bit SQL Server that would suffice.
I am building an installer. Based on the version I need to code my install script.
Thanks in advance,
I am in the process of installing SQL 2005 on a new server that is also going to have MS CRM 3.0 installed
CRM needs the .net 1.1 which has you run "cscript %SystemDrive%inetpubAdminScriptsadsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1"
I installed .net 1.1 32-Bit and 2.0 64-Bit on the server. Then cscript %SystemDrive%inetpubAdminScriptsadsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1
During the initial stages of the SQL install I receive the foloowing warning:
- ASP.Net Version Registration Requirement (Warning)
Messages
ASP.Net Version Registration Requirement
32-bit ASP.Net is Registered. Required 64-bit ASP.Net to install Microsoft Reporting Services 2005(64-bit).
Do I need to run cscript %SystemDrive%inetpubAdminScriptsadsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 0 before the install of SQL and then cscript %SystemDrive%inetpubAdminScriptsadsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1 after?
Or do I need to install SQL 2005 64-bit without reporting services and then install SQL 2005 32-bit reporting services on the same server?
I need to be able to programmatically detect whether or not SQL Server 2005, anything from Express on up to the full package with all the bells and whistles, is installed on the computer regardless of which service pack (if any) is installed. I found a forum article that provides a Registry setting that I could look at, but in the reply to the original post, it recommends using WMI instead of Registry keys. Also, I don't know whether or not the Registry key given for SQL Server 2005 would be present for even the minimal package. (Our requirements are for at least the Express package, and I understand that there's an even more basic package than that.) I'm maintaining a couple of installers that use 5-year old InstallShield technology (and Visual Studio 6 for any C/C++ code that I have to create) that have to check whether or not SQL Server 2005 Express (or a fuller package) is installed. I have done no SQL Server programming, so I've never even heard of WMI. Also, because these are installers, they have to work out of the box with no requirements to install anything beforehand to allow the installer to work. (We are working on an MSI-based installer with a bootstrap executable (the latter built using Visual Studio 2005) that will replace the older installers in the next version of our software, but we still need to support the older installers for now. Therefore, an out of the box solution that works with the older technology that we are still using for the older software is imperative. As the older software supports Win2k, the SQL Server detection solution must do so, too.)
View 8 Replies View RelatedYesterday I asked question to make a copy of the server but actually I want to make a Standalone server 6.5.
Please Advise.
How to create the DB and How to restore. Even I want to restore master but for restoring master how to start sql server in single user mode. If any body has document please post me.
Thank you very much!!!!!!!!!
Joe
I am installing Sql Server 2005 on top of WindowsSBS 2003 and VS 2005. After I finish installing it I cannot see where the enterprise manager is. Basically I only get Microsoft Sql Server COnfiguration tools. Am I doing something wrong or this is the way it is suppose to be? I had installed all the features from SQL Server 2005.
I appreciate any help!
I created a mdf file but couldnt for the life of me install it into SQL Sever Express [and when I say install i mean attach]. When I used SQL Server Ent, I had no issues. The only warning I got was that my mdf file was used by another process when I tried to attach with VS 2005 [ which is correct because ent had it]. I think mdf files are pretty touchy. Does anyone have any good articles on best practices? It seems you cant have a db with the same name as your attachment [ which would make sense] or have mdf files in the Data directory of your SQL Server instance you are trying to attach to. You will get the unc share error if you do. I think I need to start using user Instances but I could be wrong. You cant use them in ent but maybe i will solve my issue with attaching db files to express. I noticed that by default express doesnt install in mix auth mode and there might be some issues with access. How does everyone else normally install their mdf files for quick deployment [ say you want to deploy your db with your app so that users can quickly get started] ?
View 1 Replies View RelatedI installed sql server 2005, but the installed program report error.
I copy it at the line below.
And I have use strong password, and I have installed the .net framework 2.0 before I installed sql server 2005.
But the error is the same.
title: Microsoft SQL Server Setup
------------------------------
SQL Server Setup failed to obtain system account information for the ASPNET account. To proceed, reinstall the .NET Framework, and then run SQL Server Setup again.
help info: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=SQLSetup90&EvtType=28126
I'm planning an SQL 2005 deployment and would like to know if an SQL server should be kept as dedicated as possible. Should apps that access SQL be kept on other servers? What are the do's and don't's along these lines? The plan here is to install everything that accesses SQL on the same server with the database, but this seems like a bad move to me. Am I right?
Thanks!
Gregg
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?
When trying to install SQL 2005, the installation halts at "Detecting Installed IIS". From a previous forum discussion I tried disabling Norton Anti-Virus and Firewall, but the install still does not get past this point.
Please help.
The prerequire componets for my program are:
1.sql server 2005 engine
2.sql server 2005 reporting services
3.sql server 2005 analysis services
4.sql server 2005 integreted services.
so how can i detect wheter the destination computer has installed the above components or not?
I have a need to demonstrate an application I built in ASP.NET with SQL Server as the back-end database. The problem is when I don't have a network connection, I get an exception thrown..."SQL Server does not exist or access denied." This is the connection string I use (via ASP.NET/ADO.NET): "server=localhost; uid=xxxx; pwd=xxxx; database=mydb"
I've tried Query Analyzer and it too, doesn't work - I get an error message that reads: "[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied." However, via SQL Server Enterprise Manager, I can connect and do what I want to the database.
As soon as I connect my laptop to any network, the web application works fine (no errors), as well as the Query Analyzer.
Any insights are greatly appreciated. Thanks.
Here is my Question...
I have 3 server hardware and the whole purpose is to make one as a web server and another one a SQL server. The purpose of the 3rd server is purely a backup server, what that means is, in case if my web server nor my database server fails, I should be able to use the 3rd server as a backup. How do I achive this without using MS cluster service.
I can use NLB for Web, but what about SQL server ??
All I need to know is ,other than MS cluster service, is there any way I can create a backup SQL database server ( secondary database server) in case the primary fails with very minimal down time? I need my secondary ( backup) server up and running when the primary fails. I don't want to use Cluster service because of the cost for storage and license.
Any idea will be welcomed. I could have used the datamirroring option of the 2005 , but this is for a production deployment and is not recomended by microsoft. also, restore the backup from primary and make it work is not welcomed.
Thanks
Plakeezhu.
Hi,
I am developing a web project in VS 2005 Professional.
The site will be hosted on a machince that does not have an instance of Sql Server Express. Can I still use the standalone sql database file (.mdf) file? Are there drivers in ASP.NET that allow this or do I have to ask that an instance of either Sql Server or Sql Server Express be installed?
Thanks, Mike
I am new to SQL server 2005
Windows 2003 Server and all client PCs are all on the same network. I installed SQL 2005 std version on windows server 2003 and created a database and tables in it.
I have two users, who want to connect to SQL server 2005 from their PCs (they have windows XP):
These are two things that I need to facilitate:
1) They want to be able to write queries using Query Designer and run from their PCs.
2) I created an MS Access database on my PC, I want to use Access database as a front end to the SQL server database. I will create queries, forms in Access DB, and I want to be able to get the data from SQL server Database to do this. I guess I can use ODBC to connect to tables in SQL server database.
3) I want to connect SQL server to Oracle database, and run oracle stored procedures. I want to load the results of oracle stored procedures into SQL server database tables. I guess I will use IIS for this.
Any suggestions are appreciated, especially with item number 1.
Re: Best Practices (security): Should SQL Server (2005) *not* be installed on the same physical HD as the Windows OS (Server 2003 R2) ?
Hi,
We're setting up some new servers, and today I'm looking into best practices for the SQL Server Setup portion of it.
The servers have include 2 x 250G HD, and from what I've read, where IIS is concerned, it should not be installed on the drive that has the OS on it, for security reasons. I was wondering if the installation of SQL Server should be on the non-OS drive as well ?
Thanx,
Barry O'Neill
All --
Please help.
Is it possible to connect to MDF file without having SQL Server 2005 Express installed on the machine?
That is-- can one connect directly to an MDF in the same way and Access MDB file can be used?
If no, then is there any way around this?
If yes, then are there any limitations?
Please advise.
Thank you.
-- Mark Kamoski
Hi All!
In my computer I have Installed MS SQL Server 2005(Default Instance) & MS SQL Server 2000(Duynnh Instance). When I write an ASP.NET app to connect to SQL Server 2005 it's OK but not connect in SQL Server 2000. Please give me the SQL Connection string to connect to SQL Server 2000.
When I open Query analyzer connection is OK for both.
Thanks.
1. So do I use that free tool SQL tool SQL Server Management Studio Express with the real version of SQL 2005? I do not see any program like enterprise manager that sql 2000 came with
2. We use Crystal reports 8.0 now. I noticed a new verison of crystal reports and also SQL reporting tools. But I am confused how the pricing works.. and which would cost more to use on production.. anyone can explain this ?