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
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 RelatedWe are currently migrating our sequel 6.5 databases to sequel 2005
We have a handful of vb6 apps that connect to the current 6.5 database.
Can anyone recommend the "best practice" for connecting vb6 apps to sequel 2005 databases ?
Thanks in advance.
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
I have a Windows 2003 Server running IIS 6.0 and SQL Server 2005. I have just (Today) deployed the first ASP.NET application (developed in Visual Studio 2003 and, as such, dependent on .NET Framework 1.1) on this server and am getting HTTP Error 403 (You are not authorized to view this page). This ASP.NET application runs fine on another server that is configured with the OS=Windows Server 2003, IIS=6.0 but without SQL Server 2005 and without the .NET Framework version 2.0. I found in the IIS Application configuration (on the troublesome site) that my app (in the Default Web Site folder) was pointing to the version 2.0 aspnet_isapi.dll. All efforts to use aspnet_regiis to "re-align" my app with version 1.1 have been fruitless to eliminate the HTTP Error 403. I granted the NETWORK SERVICE account privledges to the wwwroot folder. At this point, I don't know if I have a Framework error or a privileges problem.
Please help.
Thanks,
Rob
Hi,
Can we install reporting services 2005 in a machine in which is not installed SQL server 2005.?
Thanks
I have a server that i would like to use as a dedicated DB Server. It is running Win Server 2k3 and SQL Server 2005. The typical upstream bandwidth is anywhere from 384Kb/s to 700Kb/s. Is this enough to host multiple SQL Server 2005 DB's?
The DB's will be used for database driven websites.
Please let me know what your thoughts are.
Thanks,
i'm building apps using sql server express and I want to deploy to servers that have the 2.0 .net framework but have sql server 2000 database.
Can this be done, and if so, how?
Observing God€™s Holy Spirit, I see God saying that The Lord Jesus influences every natural occurrence of kindness, righteousness, and judgment (Jeremiah 9:23-24). I believe God, so I thank The Lord Jesus for your grace in these matters.
Hi all:
Give me some feedback.
In my company, we have 10+ sql servers and many sql jobs running on every SQl server.
What about the idea that running all jobs on a dedicated sql servers?
at least 2 advantages
1.easy to managment
2.if agent server down, we restart the server not to impact the downtime of the production server.
any suggestion is welcome.
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'm thinking of using SQL Server Agent Service for my PDA app. But, I want to use different accounts for SQL Server and SQL Server Agent Service. How can we do this in SQL Server 2005? Do we do this when installing it? Thanks
View 3 Replies View RelatedIn VS 2005, using the ReportViewer control on a form in a Windows app, I've created an Object Data Source for the report by following the walkthrough in the documentation, it works.
View 4 Replies View RelatedI 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 RelatedI 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
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.
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 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 ?
I am about to work on a SQL server 2005 migration and I have no clue what SQL server 2005 is as I have been working on 2K all along.
Fist of all I am not sure if the given box is having 64bit or 32 bit Operationg System?
Second of all I am trying to find if the SQL server 2005 installed on this box is 32bit or 64bit?
Thanks in advance,
sk
hi there,
we have sql server 2000 installed on win server 2003 and now i want to install a fresh copy of sql server 2005 on the same machine without disturbing the existing state.
is it possible or is there any chance of system/sql server malfunction
suggestions please..
..gcnivas