Is There Any Downside Having The SQL-server Installed On The Main Server?
Mar 13, 2006Is there any downside having the SQL-server installed on the main/domain server? Or should you have a separate server just for SQL?
View 6 Replies
ADVERTISEMENT
Downside Of SQL Server Clusters
Oct 13, 2004Howdy,
We're interested in putting a SQL 2000 cluster together and want to hear from people who have run SQL Server clusters :
(1) Just how reliable are they in the real world?
(2) Which bits break ( i.e. hardware or OS or SQL Server )
(3) What configuration would you suggest and why?
Any help much appreciated
SG.
To Find Whether Sql Server 2005 X86 Is Installed Or X64 Is Installed?
Jul 20, 2007I 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 RelatedData Trasfer Between Host Server And Main Server
Jan 18, 2007bab writes "My company is going to host our web application in a host server with the sql server DB needed for the application. what is the best way to transfer the data between host server and main server.
Any thought."
Replicate To Other Server If Replication With Main Server Failed ...
Aug 16, 2007
Let say I've 4 server with MS SQL 2000 installed and I want all of them having the same data. So I'm using merge replication by assign one of them as publisher/distributor.
The problem is when ( let say ) server that have been assign as publisher/distributor down then all the other server cannot make replication.
My idea was to make it replicate to other available server ( among them ) if replication to main server failed.
Is it possible ?
If possible how to do it ?
Thanks.
SQL Server To Main Frame
Jun 23, 2004I'm trying to send data from a table on SQL server to a DB2 table on the Main Frame and I get this error. Any ideas?
[IBM][CLI Driver][DB2]SQL0904N Unsuccessful execution caused by an unavailable resource. Reason code: "UPDATABLE WORKFILE", type of resource: "100", and resource name: "TEMP DATABASE". SQLSTATE=57011
Deploying A Report To The Main Server
Oct 5, 2007
I have created several reports using SSRS which is installed in my local machine. But source data base is in the main server. Data source connection works properly. Report manager is also configured to local machine.
Now I tried to deploy these reports to main server. So I changed the target URL to http://mainservername/reportsserver in the internal report property change box. But it was not succeeded. I get a error message like this.
------ Build started: Project: Partner Reports -Internal, Configuration: Production ------
Build complete -- 0 errors, 0 warnings
------ Deploy started: Project: Partner Reports -Internal, Configuration: Production ------
Deploying to http://derby/ReportServer
Error rsRPCError : The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled)
Deploy complete -- 1 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========
Reporting services was already installed in main server. Do I have to change settings of report configuration manager in my local machine?
Data Migration From MAIN FRAMES To SQL Server 200
Oct 19, 2001What are the tools available in MS SQL Server 2000 migrate data from Main Frames. Can we do with DTS if so are drivers available to connect to sql servers.
Can you let me the technies and tools available ?
Thanks in Advance
Multiple Stores Orders To Sink Up With Main Server
May 4, 2007Hello,
Say there are 10 retail store locations that need to push their daily sales to the main server at the head office.
What techniques are used to accomplish this? I'd imagine the transaction rows would have to be some sort of a GUID.
What options are there? What techniques are used to ensure each stores orders have indeed been pushed to the main server?
How Do I Connect Client Machines To SQL Server 2005 Installed On A Windows 2003 Server
Apr 11, 2008I 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.
Best Practices (set-up): Should SQL Server (2005) *not* Be Installed On The Same Physical HD As The Windows OS (Server 2003 R2
May 22, 2008Re: 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
How To Deploy Reports To Production Server, Do I Need To Have Sql Server Reporting Services Installed Or Just Runtime Files Ok
Apr 23, 2008
I would like to deploy several reports to production server, Do i need to install reporting services entire software in order to run the reports or is it possible to just have runtime files installed on it to run the reports.
please help, i have almost 100 reports to be deployed on this server which is located in other country.
Thanks for the helpful information.
(i am using SQL server 2005 / reporting services 2005.)
SQL Server Admin 2014 :: Can Use Different Index On Main DB And Mirror Database
Oct 31, 2015We use SQL server always on feather on my database and we distribute statement on main database server and mirror database server for raise performance.
My police for split statement is DML (insert, update and delete) statement go to main DB and Read Data (select) statement go to mirror DB.
I want know can I use different index on main DB and mirror Database?
Because some index are used in mirror DB not used in main database.
Do I HAVE To Have IIS Installed To Use SQL Server Express 2005? And Do I Have To Install SQLE2K5 On A Server?
Feb 19, 2007Hi,
I'm an absolute beginner trying to learn SQL and Visual Basic/Visual Web developer.
I've downloaded SQL Express 2005 and want to install it on my laptop (Dell XPS, 2gb Ram) so that I can start doing the tutorials (for SQL and VB/VWS). I dont want any connection to the internet - i only want to have it on my local pc.
I'm confused as I 'm sure I read that I dont need to have the IIS service running, and that it wont require a server...however, I keep reading that IIS, and a server is a MUST, and for installing SQLE2005.
I'm so confused, and frustrated that I dare'nt install SQLE2005...
...Can anyone put me out of my misery???
All advice greatly appreciated.
SQLEB
Cant Connect To SQL Server Installed In Windows Server 2003
Feb 11, 2005Hi, im trying to connect to my sql server installed in windows 2003 OS, i always get login failed whenever i run my asp.net application, do i have to setup anything in my local computer to access my database in windows 2003 server? or in IIS maybe? pls help.
View 1 Replies View RelatedSQL Server 2008 :: Creating Multiple Charts Based Off Of Main Chart
Jun 4, 2015I have this main chart setup. It pulls data from a query based on the selected parameters.
I want to create multiple charts for every catagory in the result set.
On the main chart there is a catagory called "Missing".
I want a chart for this category to display when the main chart is loaded. So below the main chart it would show a chart for each of the categories on the main chart.
Basically this report returns information on a certain part number displaying its problem types. Then I want it to create other charts for each problem type displaying the problem sub-types.
Downside Of Multiple Primary Keys
Oct 11, 2006Hi, from the "best practice" perspective, how convenient is to use multiple field primary keys in a table, how convenient is it to replace a multifield pk with an autoincrement field to represent such a table?
I tried using a calculated field product of appending the fields that cvompose the primary key, but MySQL for example, does not provide with that functionality, which makes me wonder it doing so in SQL Server is a good practice at all.
Thank you
Find SQL Server Product Key Installed On Server
Sep 26, 2007Hello;
I am trying to get information of SQL Server licensed key which is installed on our servers. I am using SQL Server 2005 standard edition. Is there a way to find out the product key which is installed on servers. I did some searches and found some thirdparty software to get that information but I don't want to use them on production, is there a way which microsoft recommends.
Thanks
SQL Server 2005 Developer's Version Installation Problem -- No SQL Server 2005 Studio Manager Gets Installed.
Sep 3, 2007I 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
Can I Run DTS On Server Doesn't Have SQL Server Installed?
Nov 16, 2001Can I write DTS package to be used in VB app (NT service) that will be taking some text files, checking business rules on client, then inserting records to SQL server on remote server (via TCP/IP)?
If so, what licence/software requirements? Security concerns?
Thanks,
Michael
Which SQL Server Is Installed?
Jul 24, 2000Hi,
I am wondering how I can check which type of SQL Server 7 I have installed. (ie Standard/Enterprise etc) If I use @@version the following is returned:
Microsoft SQL Server 7.00 - 7.00.699 (Intel X86)
I know that the service pack number is incorporated into the version number above but I want to know the type of server I have running.
Any ideas on how I can get this information?
Cheers
Jan
Can SQL Server 7 Be Installed On NT 4 Sp 5?
Sep 14, 1999I'm unable to install SQL Server 7 on Windows NT with SP5. I get
this error message:
Based on your selections setup has determined the following system
requirements are not met. Exit setup and install the missing requirements
from the CD or change your selections.
Windows NT 4.0 Service Pack 4 - needs to be reinstalled
Just Installed SQL SERVER And Need Help
Dec 23, 2005Please forgive me if this sounds so silly, but I am a complete newbie on SQL SERVER (the only think I ve worked on so far is Access) and I need help.
I ve just installed the SQL Server 2005 and the things I have are about configuation, such as:
-sql server configuration manager
-sql server error and usage reporting
-sql server surface area configuration
-notification services command prompt
-reporting services configuration
Is that all? Did I miss anything? How am I supposed to create databases? How can I connect remotely to another server (database)?
I know I may sound stupid but Im on the beginning and I would so much appreciate any kind of help.
Thanks in advance,
Martha
SQL Server Installed, Now What?
Oct 14, 2007After the long winded process of installing SQL Server 2005 - Developer Edition...
I am currently in the process of starting to use the program... Been looking all over the Internet (Google Video/YouTube) for the setting up my database, checking connections etc...
Can someone go through the process... of setting up all the checks and using SQL,,,, I want to start creating simple select queries for Northwind...
Thanks in advance
SQL Server Installed?
Feb 16, 2004Does anyone know how i can find out if SQL Server is installed on the current machine, and the version that is installed?
Thank you in advance.
Does Sql Server Come Installed With Vs?
Oct 19, 2007hi! i d like to ask the following:
can i create a database through visual studio?
or i need to have sql server seperately installed on my computer and do it from there?
Sql 2k5 INSTALLED ON THE SERVER
Oct 13, 2006Hi All,
My program is written in VB.NET and the DB is SQL 2005 Ex Ed.
I have installed both, the SQL SERVER 2005 and my program on the SERVER.
But when I try to run my program I get the following error mssg:
The application attempted to perform an operation not allowed by the security policy.
The operation required the SecurityExceptio. To grant this application the required permission please contact your Systems administrator, or use the Microsoft .Net security policy administration tool.
If you click continue......
Request for the permission of type
System.Data.SqlClient.SqlClientPermission. System Data,
Version = 1.0.5000.0 = neutral.
PublicKey Token = b77a5c561934e089 failed.
My Systems administrator says I have got full control of the Folder that was created on the SERVER.
So what could be wrong?
Tnx
SQL Server 2K5 - Is SP2 Installed?
Oct 4, 2007
How do I find out if SP 2 has been installed on my server?
SQL Server Installed, Now What?
Oct 14, 2007After the long winded process of installing SQL Server 2005 - Developer Edition...
I am currently in the process of starting to use the program... Been looking all over the Internet (Google Video/YouTube) for the setting up my database, checking connections etc...
Can someone go through the process... of setting up all the checks and using SQL,,,, I want to start creating simple select queries for Northwind...
Thanks in advance
SQL Server 2005 Not Getting Installed...
Oct 4, 2006hi !!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 RelatedSQL Server Agent Not Installed?
Aug 16, 2000I installed SQL Server 7.0 Desktop and SP2 on Windows 2000 Pro. When I tried to start the SQLServer Agent from the MMC, I get an error as follows:
Service Control Failure
An error 1060 - (The specified service does not exist as an installed
service) occurred while performing this service operation on the SQL Server
Agent.
The Server Agent does not show up in the Service Manager.
Does the Destop version include the Server Agent?
What do I need to do to make the Server Agent Work?
What Needs To Be Installed To Access SQL Server
Aug 12, 2007Hi,
I'm working on a project that's going to require me to connect to an instance of SQL Server installed on a machine other than my development machine (i.e. not localhost). I don't know as yet whether the machine i'm going to be connecting to is within the company's LAN or otherwise.
What do i need to ask IT support to install on my development box? I guess i'll need the .NET framework and either Enterprise Manager & Query Analyzer or SQL Server Management Studio but what else, if anything is required? A suite of client tools or something along those lines?
Thanks
Mat
SQL Server 2000 Installed ?
Mar 28, 2008Hi,
How can I tell if SQL Server 2000 is installed on my local machine ? I have Enterprise Manager and Query Analyzer installed, are they part of the server install ?
Thanks,
J.