Whats The Best Place To Locate A SQL Server

Feb 8, 2004

Hi

Im considering several options as to where to place the SQL Server and the web server in our organization's network I would like to hear your insights about the subject and the following options:

Option 1:
Placing the SQL Server inside the domain while the web servers are outside in the DMZ

Pros: SQL Server is in the domain, its harder to hack and its easier to manage inside the domain

Cons:the DMZ must allow access inside the domain so that the web servers can access the SQL Server this is not very secure.

Option 2:
Placing both SQL Server and the web servers in the DMZ

Pros: Fast access from web servers to the SQL Server. no traffic is allowed from the DMZ into the domain so the domain is completely secured.

Cons: The SQL Server is not very secured, its harder to administer it outside the domain.

I would love to hear of more options suggestions

thanks.

View 1 Replies


ADVERTISEMENT

Is There A Place Where I Can Find The Events That Takes Place In Sql Server?

Jul 20, 2007

Is there a place where i can find events that takes place in the sql server? Like adding data to a database or something like that....



Regards

Karen

View 4 Replies View Related

I Need To Locate The MS SQL Server 7 Resource Kit

Dec 14, 1999

How can I get my hands on the Microsoft SQL Server resource kit?
In particular, I need the "Load Simulator" application.

Any information would be greatly appreciated.

Jim

View 1 Replies View Related

Unable To Locate Security Server

Feb 28, 2007

Dear all,

I have installed JDE E1 Demo to my computer, which use SQL Server 2000. And the OS of my computer is Vista Home Prerium.

When I start the JDE, I met an error message, "Unable to locate security server". Cause this version of JDE could be running on XP, I guess if the problem is because of the combination of Vista+SQLServer2K.

I have checked that IIS is ok installed, the computer services are started automatically. But I have one strange phenomenon that after computer started, it seems that the SQL server service manager couldn't find the right server & service, so that server couldn't been started automatically.

Could you make some sense and show me some hint about this problem? Or could you tell me how the SQL service manager find the the server and service?

I have installed SQL Server 2005 in my computer but in different root, in addition.

Many thanks and Regards,

Viesta

View 2 Replies View Related

SQL Server 2008 :: How To Locate Archived Log Files

Jun 18, 2015

SQL SERVER 2008R2

The number of files to retain for SQL Server Logs is set to 99. When I expand the SQL Server Logs node in SQL Server Mgt Studio it shows the current log file through Archive#49. The oldest archive file is dated 2015/05/26. If I select that archive in SQL Server Mgt Studio it shows me the details and entries of that archive file. Yet when I go to the directory on SQL Server for the log files there are only the 5 most recent files. I have searched for '.trc' files on the entire drive and have found no other files.

How can SQL Server Mgt Studio show archive files that have no corresponding archive file in the directory that is supposed to contain the log files?

View 1 Replies View Related

SQL Server 2008 :: Unable To Shrink Transaction Log - Could Not Locate Files

Jan 10, 2012

I am trying to reorganise the log files on a server, (long story short they are fragmented so I want to shrink and reset the initial size and growth) and I am unable to shrink them. When I run the following:

use test
DBCC SHRINKFILE(test_log, TRUNCATEONLY)
--or
use
DBCC SHRINKFILE(test_log,2, TRUNCATEONLY)

I get the following message:

Msg 8985, Level 16, State 1, Line 1

Could not locate file 'test_log' for database 'test' in sys.database_files. The file either does not exist, or was dropped.

I get this message for every database on the server. I got the logical name of the file using sp_helpfile and have checked it against sys.masterfiles, sys.database_files and sys.sysaltfiles, all match up and confirm the name 'test_log'.

I rebooted the server last night and was able to shrink the first couple of .ldf's I tried so I presumed it was fixed. This morning when I try again i get the sanme error, I don't see anything in the SQL server or system logs that indicates a change.

I am able to add new log files and remove log files, however if I add a new log file (test_log2) and then try and truncate that file I get the same error.

View 9 Replies View Related

Can't Locate Microsoft OLE DB Provider For ODBC Drivers For Win Server 2003 X86

Jan 31, 2008



All,

Been serahcing frantically for this provider: "Microsoft OLE DB Provider for ODBC Drivers" for Windows Server 2003 x86. However I can't seem to find it. Supposedly MDAC 2.8 has it but when I go to install MDAC 2.8, nothing happens (this is acknowledged in fact in the support area on Microsoft and the given reason is that Win2K3 Server is already MDAC 2.8-compliant. So no new stuff needs to be installed. But alas this provider isn't in my list of available drivers).

Attempts to install any part of a lesser version of MDAC that says it has it are met with "Can't do that 'cause your current version of MDAC is higher that that."

I have been searching around all day on Msoft and other sites for such a beastie but like Brigadoon vanishing in the mist, it eludes me. Msoft's main MDAC page is here:

http://msdn2.microsoft.com/en-us/data/aa937729.aspx

We need to use this kind of driver apparently with a certain Crystal Reports report or else it just won't run.


Thanks in advance for any advice/insights/DL links that work, etc...

Matt

View 3 Replies View Related

Whats The Server Name

Jun 23, 2008

Im using windows xp sp2 and MS Sql server 2005 enterprise edition may b and im also havin sql server express
previously when i installed sql server express it took server name on its own and i used to run queries using AdventureWorks database..
Recently i formated my desktop and again installed both the versions im having but neither is taking server name.. and i dint noticed what was the server name before.. im a student home user i just hav to query on adventurework databases on the same computer i cant afford to buy any servers..
so can anyone tell me how can i configure sql so that i can query !

View 1 Replies View Related

Power Point :: Error - Cannot Locate A Server To Load Workbook Data Model

Aug 30, 2014

I get this error when I open powerpivot documents in sharepoint.

"We cannot locate a server to load the workvbook Data Model."

after I've looked into the logs I came up with this:

Check Server Version (SQLSERVER2012POWERPIVOT): Fail (Expected: >=11.0.2800.0, Actual: 11.0.2100.60).

--> Check Deployment Mode (SQLSERVER2012POWERPIVOT): Pass.

MonitorableCheck Server Configuration (SQLSERVER2012POWERPIVOT): Fail (Uninitialized, ConfigurationError, WrongVersion).
SSPM: Initialization failed on server SQLSERVER2012POWERPIVOT: Microsoft.AnalysisServices.Streaming.ServerConfigurationException: Server SQLSERVER2012POWERPIVOT failed configuration checks (Status = Uninitialized, ConfigurationError, WrongVersion). at Microsoft.AnalysisServices.Streaming.OnPremise.Server.AssertServerConfiguration(Server amoServer, CancellationToken ctx) at Microsoft.AnalysisServices.Streaming.OnPremise.Server.Initialize(Guid serviceId, CancellationToken ctx) at Microsoft.AnalysisServices.Streaming.OnPremise.Tasks.InitializationTask.Run(CancellationToken ctx)

how can I update my analysis server version that doesn't affect anything else?

should I install a CU on my SQL or upgrade it?

View 4 Replies View Related

SQL Server 2008 :: Long Text Field - Failed To Locate Ending Boundary Of A Sentence

Apr 23, 2015

I have an very long ntext field, made up of many sentences that I append a full stop to every one, I also strip out any line breaks within the text. However I get this error, when I look it up it comes up with "Failed to locate the ending boundary of a sentence."

View 0 Replies View Related

Whats The Different Between SQL Express && SQL Server 2005?

Feb 12, 2007

Hi,

I'm working in a small company (less than 30 user), we can't buy MSSql Server 2005:

Q1: can we use the Express edtion do access our data? I mean for commersial purpose..

Q2: dose the Express edition stand to (30 connection) at the same time?

Q3: can I add users to it?

 

 

View 3 Replies View Related

Best Place To Deploy Log Shipping Monitor Server

Aug 19, 2003

I have 4 sql 2000 servers. One is a the primary, one is a local stand-by, one a remote standby and one is a training server. WHen configuring which server should monitor log shipping I was torn between the local standby and the training. The training server which only has a few users if ever, might be used for some DTS tasks in the future for some B to B stuff. Based upon this I am leaning on the local standby to monitor. Anyone have an experience or input?
Thanks!
(No I can't buy any more servers)

View 2 Replies View Related

Create Copy Of Database And Place On Different Server

Oct 26, 2004

All,
I am trying to create a copy of an existing database and place on a different sql server for testing purposes. Currently my method of doing this is to create a backup, then restore a database on my new sql server. But here is the problem I am running into. When I look in Enterprise manager I can see all of the stored procedures and tables and data just fine, which is how I would like it. But, when I open up Query Analyzer I am not able to run any queries because it says "invalid object name" error. I know that the object name is correct. I think that I am having a conflict between the users which were carried over from the source backup file and the users that are on my 2 new sql server. If anyone could help, I would really appreciate it. I am stuck at this point. I am guessing it is probably something simple I am just unaware that I need to do.

Thanks,
LinsLo

View 3 Replies View Related

SQL Server 2012 :: While Loop In Place Of Cursor

Feb 16, 2014

I have a table called Table1 where I have five fields like Tableid, Processigndate, Amount, remainingCollectonCount and Frequency. All total I have more than 5Lacs records.

Now I need to fill up another table Called FutuecashFlow taking the records from Table1. There will be also five Columns like FutureCashflowid, Table1id, Processigndate, Amount.

Now the condition is that if the remainingCollectonCount =6 and the frequency is 12 then there will be the 6 entries in the futurecasflow table where the prcessign datae wille be addeed by 1 month.

For example Table1
Tableid, Processigndate Amount remainingCollectonCount Frequency
1 2014-02-15 48 8 12

the future cash flow table the prcessing date column will be shown in the following way

Processigndate
2014-03-15
2014-04-15
2014-05-15
2014-06-15
2014-07-15
2014-09-15
2014-10-15

I do not to want to use cursor....

View 4 Replies View Related

Place The Alerts In Reporting Services/sql Server

Apr 14, 2008

one day Report has not been generated with yday's data. so I want to put the alert at this condition. so please any one can tell me How to put the alerts in place, if the report is not successfully Run in shared SQL Server Reporting Services.(sql server 2005)

View 2 Replies View Related

What To Use In Place Of MS Access To View SQL Server Tables?

Oct 15, 2006

Our business application is running SQL Server in a remote data center and we had been using MS Access from a local PC to occasionally fix data problems in the data base. As the tables continue to grow, it's painfully obvious MS Access just can't handle the volume of data. One of our tables we need to get into is about 200,000 rows, another is over 100,000 rows.

We need to be able to change individual rows, and perform search and replace commands across one or more columns in select tables.

What software can we install on local desktops to allow viewing and editing of SQL table data?

View 6 Replies View Related

Whats The Major Difference Between Sql Server 2005 Standard And Developer Edition?

Feb 25, 2008

Hi,
  I have Sql server 2005 Standard edition on my system and was wondering whats the difference between Standard edition and developer edition which one is better..most of the things that i do on sql server is
 write sprocs, create table etc...
any ideas will be appreciated..
regards
Karen

View 13 Replies View Related

In The Server Explorer Generate Create Script Is Greyed Out, Whats Wrong?

Jan 14, 2005

In the server explorer "generate create script" is greyed out, what am I doing wrong?

I want to generate a script that will re-create my DB schema on another machine.

Any help would be appreciated.
Thanks

View 3 Replies View Related

Whats Does This Mean ??? --- SQL Server Has Encountered 1964 Occurrence(s) Of IO Requests Taking Longer Than 15 Seconds

Sep 13, 2007

Hello,

I see the following error on the sql server log of one of our sql servers running sql 2000 with sp4.
SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [h: empdb.mdf] in database [tempdb] (2). The OS file handle is 0x00000534. The offset of the latest long IO is: 0x0000002b09e000


Any idea as to what might be causing this error. Appreciate any comments.

Thanks!

View 3 Replies View Related

Is There Any Method To Back Up The Database To Place Outside Of The Local Server System?

May 17, 2007

Hi, all experts here,

Thank you very much for your kind attention.

I am wondering if we could back up the databases to any place outside of the local server system? As I found, we can only back up the database to the local server system, so we have needs to share databases on network places. Is there any method to back up the database on network place rather than first of all I have to back up the database on a local server system, then copy it to the network place, that just sounds really inconvenient.

Thanks a lot in advance for your help and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,



View 5 Replies View Related

Northwind Database In SQL Server Management Studio Express Is Lost Or Used/processed By VB 2005 Express:How To Locate/return It

Dec 3, 2007

Hi all,

In the last one and half years, I used the Northwind Database in SQL Server Management Studio Express (SSMSE) to learn the programming of SqlConnections, Data sources, Database Exploere, ADO.NET 2.0, etc. via VB 2005 Express.

The Northwind Database in my SSMSE got lost very often, but I was not aware of it. How can I know where the Northwind Database is used or processed by my VB 2005 Express projects that were the examples of some tutorial books or my trial projects? How can I release the Northwind Database back to my SSMSE from the VB 2005 Express projects? Please help and advise.

Thanks in advance,
Scott Chang

View 2 Replies View Related

Recovery :: Where To Place Witness Server For Mirroring Using High-safety And Auto-failover

Apr 9, 2015

We have 2 data centers, site 1 and site 2.  Site 1 is generally our primary, and site 2 is our Disaster Recovery (DR) site.  I want to setup a SQL instance to have extremely high availability.  Therefore I was looking at using DB mirroring, with synchronous data writing, high-safety and auto-failover.  This requires the usage of a witness server.My problem with this setup, is that if the witness and principal are both at site 1, if site 1 goes away (power failure, asteroid impact, lol, anything else that would be a *true* DR scenario), then there is no failover to the mirror server at site 2.   However, if you put the witness at site 2, anytime the WAN link between site 1 and site 2 has an issue, the DB will auto-failover to site 2.  Is the reason for the recommendation of the witness being at the primary site because the thinking is that WAN link failure is likely more common than a *true* DR scenario that takes out all of site 1?

View 3 Replies View Related

How To Locate A Column

Aug 21, 2014

I have just loaded some tables to our main db.there is a col in one table called MAPCONCEPTID.I want to know how to find where MAPCONCEPTID field in one of the table is mapped to.

View 3 Replies View Related

Can Not Locate Other Drives

Nov 13, 2007

Hi,

Can someone help me, I installed SQL 2005 Enterpirse Editon on windows clustered servers. Then after the installation
I want to change the path of my DB logs but the problem was, I can not see the other drives. I can see only the drive where the DB was located. Is there any special configurations that should be done.

Thanks.

Russell

View 1 Replies View Related

Unable To Locate Table

Feb 27, 2006

I am creating a table on the fly and then trying to associated the table
inside of a cube, using vbs script. For some reason I get a table not found
error when I try and open the cube, but when I look at the SQL server I am
able to see the table and I can insert the table via analysis manager, but I
get Unable to retrieve the list of columns for the <table name> table.

Any Ideas why I am not able to add the table from the analyzer?

View 10 Replies View Related

Could Not Locate Entry In Sysdatabases

Feb 7, 2004

Hey there, could someone please help me!!
I had created a database in sql server but since then installed windows xp pro and now when i go through the microsoft sql server dsn configuration the database is not valid and therefore i cannot change the default database as it says it doesn't exist.
So then when i type in command prompt use 'db' it says it doesn't exist but when i try to create 'db' it says that the database already exists.
I get the error message, could not locate entry in sysdatabases for 'cti' (database name).
When i look in mysql - data - along with master etc there is my cti.mdf and log files??
I'm stuck???
Is it that the files just aren't registering through sql server???
Please help!

View 2 Replies View Related

Search To Locate A Table

Sep 22, 2014

Is there a query that I can run in SQL to find all the table names? I have a certain table I am trying to locate.

View 1 Replies View Related

Locate Table To Filegroup

Sep 18, 2005

I have created a new filegroup,and i want to add existing table to the file group.
I don't have the appropriate syntax for this.

Please Help.

Regards Mr. Mumin
Thanks All,

View 1 Replies View Related

Locate Item In A Table

Aug 2, 2006

I have a sql table containing names of departments. Is there a way after a user has typed a department in a textbox on a web page I can search for it in the sql table and if it isn't there then add it. I am using asp.net for the web page.

View 3 Replies View Related

How Do We Locate Exactly The Line Number Of The Er

Sep 1, 2006

when we get something like this in QA:
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near ','.

I only have 3 lines inclusing only one insert. How do I know what value or keyword is wrong from the error message above.

Thanks

View 4 Replies View Related

Locate SSRS Log Files

Feb 5, 2008

Hi,

I am trying to locate my SSRS log files to troubleshoot some report problems.

I run Microsoft Visual Studio when designing reports using Report Designer, from a local installation of MSSQL Developer Edition on my notebook. The data source I work on is on a remote SQL Server.

I expect to find the SSRS Log Files on my local installation but I am having trouble locating it.

Please help.

Thanks in advance.


regards,
Kenny

View 14 Replies View Related

How To Locate The SSIS Installation?

Oct 15, 2007

Part of our product will be using several SSIS packages. One of our installers wants to be able to create a .cmd file that will run DTEXEC against one of the packages, with the correct config file specified. It had been assuming that SQL Server was installed in the Program Files special directory, but that's not always the case.

What is the correct way to locate the installation of SSIS? In fact:



What is the correct way to determine whether SSIS is installed?

What is the correct way to determine the version and SP that is installed (I want to require SP2)
I had been using the values under HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90DTSSetup until I found an SP2 machine with SSIS installed which did not have these keys. Where's the right place to look?

View 6 Replies View Related

Full-Text Catalogs, Where To Locate?

Dec 8, 2004

Hi All,

looking for some views about where to place these catalogs. The manual says they work more effiecntly on a different drive to the database, which is understandable.

I'm in the processes of designing a new database application which is to be avaiable via the internet, and extranet app. But as I'm planning to host the app and the main database on a shared server but to have the catalogs on another server held in house. The app will have search facilities as its main use. They will obviously be some performace issues, but is this a good idea?

Thanks for any comments..

Regards
Davej

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved