Cannot Configure SQL 2000 Over 3gb
Mar 16, 2007
We have an 8gb SQL server running Windows Server 2003 Enterprise Edition that simply will not get above 3gb of memory usage. We are using SQL 2000 Enterprise edition, version 2040 - SP4. My boot.ini has been configured with /3gb /PAE. System Properties does list Physical Address Extension as being enabled. AWE is enabled, and has been verified in the SQL server logs. Lock pages in memory access has been given to the account SQL is started under. Under task manager, the process sqlservr.exe does not grow above 2,762,428 ish. Does anyone know why this is occuring?
View 4 Replies
ADVERTISEMENT
Nov 23, 2006
Hi, I got a website and everything works fine with SQL Server 2000, but now I modified the way of authentication using Forms and when I enter in a protected area I got this error:
An error has occurred while establishing a connection to the server.When connecting to SQL Server 2005, this failure may be caused by thefact that under the default settings SQL Server does not allow remoteconnections. (provider: Named Pipes Provider, error: 40 - Could notopen a connection to SQL Server)
The problem is that I don´t have SQL Server 2005 installed so I don´t know why my webapp is trying to contact it, where I can configure this settings so it will look for the Server that exists?
Thanks.
View 2 Replies
View Related
Nov 28, 2003
Our company is going to use SAN (HP or EMC or Fuji) for SQL Server failover rather than MSCS. So far, DBA has no knowledge of SAN.
Would you please to tell me, how does SAN depend on SQL Server? I assume SAN software can make disk failover if there is a network, disk or OS failure in primary node. If SQL Server or SQL Agent is failure, can SAN software detect it? (or can SAN disk failover depend on SQL Server or SQL Agent services?)
Please let me know where can I find any configuration document regarding SAN for SQL Server failure. I had spent 2 days in HP and EMC wrbsite and found nothing.
Happy Thanksgiving.
Mary
View 5 Replies
View Related
Feb 13, 2004
Hi all,
Please, tell me how to configure database SQL server 2000 for a large system, and make it uninterrupted run.
Thanks
View 6 Replies
View Related
Jul 19, 2002
We just got a new server. We are running Windows 2000 with Office 2000 and SQL Server 2000 (Standard Edition).
To set up the mail for SQL 2000 it says to use Outlook client in "corporate" mode. This mode doesn't have the IMAP option on internet Mail only POP3.
Did I miss an option while installing Outlook?
I've only been able to find a third party vendor that has a solution but our IS/IT people are not in favour of going this route.
Any thoughts on how to get around this?
Thanks for your time.
View 1 Replies
View Related
Jul 19, 2007
Hi,
I've a SQL Server 2000 (SP4) installed on Windows 2000 Server.
The system has 4GB RAM.
SQL Server not using more than 2GB RAM even I set the following.
AWE enabled.
Max server Memory (MB) : 3GB
SQLService account is enabled for "Lock Pages in Memory"
Can you please help what I'm missing here?
Thanks in advance.
Regards,
Mkarumuru
View 3 Replies
View Related
Nov 14, 2006
I have searched and could not find an answer for this one I read log and it said
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=KENSHIN;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
driver={sql server};server=KENSHIN;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
driver={sql server};server=KENSHIN;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
SQL Server configuration failed.
how do I fix this?
View 7 Replies
View Related
Aug 3, 2007
I recently had configured my Web Server based on Windows 2003 Server and IIS 5x. I'd also installed SQL Server 2005 into this. Now I want toc onfigure this SQL Server, so that my client can access their database through a DNS name. I request you all for your kind support in this regard. Thanks in advance.
View 5 Replies
View Related
Aug 3, 2007
I recently have configured my Web Server based on Windows 2003 Server and IIS 5x. I'd also installed SQL Server 2005 into this. Now I want toc onfigure this SQL Server, so that my client can access their database through a DNS name. I request you all for your kind support in this regard. Thanks in advance.
View 1 Replies
View Related
Aug 3, 2007
I have recently configured a Web Server based on Windows 2003 Server and IIS 5x. I'd also installed SQL Server 2005 into this. Now I want toc onfigure this SQL Server, so that my client can access their database through a DNS name. I request you all for your kind support in this regard. Thanks in advance.
View 1 Replies
View Related
Oct 29, 2007
Guys , I have a dedicated server ... I've installed SQL SERVER 2005 and I have a problem to connect to SQL from local machines in the office ... Remote connections are on , server BRowser starts automatically ... for example from remote machinne I mean from Server where SQL is installed I can connect to SQL ... FireWall i've turned off.... What can be the problem ????
View 3 Replies
View Related
Mar 13, 2008
In my DAL, I have 3 tables -
Footballer (FootballerID = Primary Key)
Aspnet Membership Table (UserID=Primary Key)
Favourite Footballers (Junction Table with 2 Primary Keys FootballerID and UserID - both with foreign relationships to their respective data table)
On my sports site, visitors can view various footballers and store their favourites in th FavouriteFootballers Table by clicking on a button.
This stores the Logged in UserID and FootballerID in the junction table.
I now need to write a select query that allows users to click a link and view their favourites which they stored - lets say in a data list on another aspx page.
This would include other columns from the Footballer Table such as Name, Age, Profile ect
I think I am right in that I need to use a Select clause as I am using SQl data adapters in the DAL.
Be very pleased if someone knows how to contruct the query and give me an example how to code a method in the BLL
Some code is below
Method that Stores FootballerID and UserIDprotected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
// Assuming only have one button in the item templateInt32 fid = Int32.Parse(e.CommandArgument.ToString());Guid userid = (Guid)Membership.GetUser().ProviderUserKey;
// Connect to the db and insert the recordusing (SqlConnection con = new SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MyDatabase.mdf;Integrated Security=True;User Instance=True"))
{
string query = string.Format("INSERT INTO FavouriteFootballer(UserID, ArtistID) VALUES('{0}',{1})", userid, fid);
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
Code in FavouriteFootballersBLL
Its not complete -withotu parameter - i think maybe I also need to reference the Footballer Table and not the Junction one
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]public DataSet1.FavouriteFootballerDataTable GetFootballerFavourites()
{
return Adapter.GetFootballerFavourites();
}
View 2 Replies
View Related
May 14, 2008
Hi,
I am really having a hard time creating a parameter for the RadioButtonList radSearchField. I want to type 's' in the text the choose the column for the query to execute the Select statement. I was able to create a parameter for the txtSearchText but can't get the radSearchField working.
My form contains four objects.
Textbox to perform the query. (name: txtSearchText)
View 5 Replies
View Related
Apr 8, 2005
Is there a way to automate backup? Like it has a schedule. Is this in standard edition.?
Please help a newbie.
View 5 Replies
View Related
May 17, 2006
I have configured SQL XML Support in IIS but still i am not able to Use
http://localhost/ss?Sql=select+*+from+users+for+xml+auto
I am getting Internal Server Error
View 1 Replies
View Related
Mar 19, 2001
Hello All,
We've A2k db which we plan to migrate to SQL 7.0 very soon. Though am familiar with upsizing wizard BUT don't know how to configure Access forms, reports etc. to talk to SQL back end tables. So that information entered via Access forms can be stored in sql and reports can be generated using sql tables..
Thanks in advance..
View 1 Replies
View Related
May 18, 2001
Hi,
I want to send a email after completion of DTS package.
How can I configure SQL Mail??
bye
K.R.Kanth
View 1 Replies
View Related
Sep 2, 2000
hi
Can anyone help me in configuring Sql mail in SQL server 7.0
View 2 Replies
View Related
Jul 30, 2003
Hi,
I'm using Exchange server for our mail communication. If wanted to config SQL Mail in SQL Server 2000 is Ok
1. Insall outlook in sql server
2. US Exchange mail server name in sql mail or any procedure I need to do?
Thanks,
Ravi
View 3 Replies
View Related
Oct 27, 1998
What are the steps in configuring sql server 6.5 to have excellent performance?
what are the items that I should think of and based on what condition I can set up the configuration?
Ahmed
View 1 Replies
View Related
Mar 17, 2004
Hello,
I run a small homw office. I am planning to purchase a dell powerdge 1750 server to install SQL server on that.
I am confused here about which RAID should I install on this server RAID 1 or RAID 5.
The dell customer rep could not tell me the advantages of installing only RAID 1 or only RAID 5 or installing both RAID 1 and RAID 5
View 7 Replies
View Related
Jan 28, 2008
Forum,
I cannot create a Distribution Server on SQL Server 2005 SP1. When I right click on Replication and click "Configure Distribution" and hour glass appears for a minute, and then nothing happens.
I get the same result if I try to create a publication.
Any suggestions on what to do?
Thank you!
View 4 Replies
View Related
Jul 20, 2005
Hi All,Here is my questionWhat might you configure on a SQL Server so that a Web server runningon the same machine, with limited memory, will continue to performoptimally?Thank youRaju
View 1 Replies
View Related
Feb 22, 2007
I have installed SP2 on my SQL 2005 instance which also houses RS of course. Additionally I installed WSS3.0 without configuring it so it has the Object Model installed (should be enough?)
I am running WSS 3.0 on a seperate Server and have the Add-in installed on there.
Following the installation instructions I am going to Application Management to configure WSS, but there is no section called "Reporting Services". Looking on the Report Server, in the Configuration I see the following error under the SharePoint Integration Setting:
The report server cannot access settings in the SharePoint configuration database. Most likely, the Windows SharePoint Services object model is not installed or the Report Server Web Service and Windows service accounts do not have access to SharePoint databases. To configure service account access, use SharePoint Central Administration.
In my SharePoint Site I do see a SharePoint section under the "Site Settings" for managing shared schedules but I think the main issue is, that I don't see that section in Central Administration.
Any help is greatly appreciated.
View 3 Replies
View Related
Mar 25, 2007
Hi every1,
I have problem about configuration in Merge Replication.
First, I configure for SQL Server 2000, expand Replication> Publication>New Publication>Choose Publication Database, I choose pubs>Select Publication Type, choose Merge Replication>Specify Subscribers Type, choose Servers running SQL Server 2000 and Devices running SQL Server CE>Specify article (ex. authors)€¦>Finish. I configure succeeded (A snapshot of 1 article(s) is generated).
Snapshot folder reference to path: \server_nameC$Program FilesMicrosoft SQL Server 2005 Mobile EditionServerReplication
Next, I configure for SQL Server Mobile Agent, Subscriber Type, choose SQL Server Mobile Edition>Web server, choose Create a new virtual directory>Alias: Replication (reference to the path: C:Program FilesMicrosoft SQL Server 2005 Mobile EditionServerReplication)..>Client Authentication, choose Client will connect anonymously€¦.>Snapshot share access, enter \server_nameReplication =>error: The share '\server_nameReplication' cannot be accessed. Please specify a new share. Why that?
I want to ask u I configure that correctly? If Subscriber is Pocket PC Emulator, what is subscriber €™s property of SqlCeReplication (Windows PocketPC Emulator?)?
Plz help me. Thanks so much.
View 3 Replies
View Related
Oct 27, 2015
I've been working on a WinForm application (C#) that connects to a database on an external server. My connection string has always been the following and has always worked:
string strCon = "Data Source=static_ip_address;Initial Catalog=someDatabase;User Id=admin;Password=*****";
The specified credentials are actually the physical server's only and local windows account - admin. Contrary to the fact that specifying a user id and password in the connection string uses SQL Authentication, this is practically Windows Authentication as I haven't configured any roles, logins or users in the database or SQL server instance.
Recently there was a power outage and the server was offline. After going back online, my application can no longer communicate with the server. I even modified the connection string to the following and ran the application on the server itself and it still
won't work:
string strCon = "Data Source=localhost;Initial Catalog=someDatabase;Integrated Security = True";
There's obviously something wrong with the server that prevents it from accepting any incoming SQL connections; even those originating from it. I am able to ping the server and even remotely access it from a different network but no SQL connections are being established.
View 8 Replies
View Related
Nov 8, 2006
hi,
First, sorry for my english, I'm french
When i try to configure web synchronization, I get the following err " success Hresult 0x8007000"(!!!) for the step : setting the snapshot share permission
I really don't understand : my folder have all the rights for the user agent...
I don't know what to do.
Config . SQL Server SP4,Microsoft SQL Server 2005 Mobile Edition
It had worked but I had to reinstall the system and now, it does not work anymore
Thans for your help,
Eric
View 18 Replies
View Related
Nov 8, 2007
.. the Membership ProviderUserKey value as the parameter of a stored procedure ?It seems obvious to me that you would want to do this, but I can only see that it allows you to pass Profile parameters.
View 2 Replies
View Related
May 15, 2006
When configuring the SqlDataSource, what source do I need to specify
for getting the ID passing through the URL? I tried Form but it's not
getting the ID through the URL. Help is appreciated.
View 2 Replies
View Related
May 14, 2002
I had a SQL server 7.0 with 1 gb of RAM.
I just added more memory and now I have 4 gb of RAM. How can I canfigure SQL to take advantage of this.
View 2 Replies
View Related
Jun 7, 2000
Hi all,
I'm having a problem configuring one of my SQL servers
as a distributor. I've done it successfully on another
server, so I know that it's nothing procedural and there
must be an issue with the way the server is set up.
When I click 'finish' on the Configure Publication and
Distribution Wizard, I get the following error message:
Enterprise Manager could not configure 'ABEL' as the
distributor for 'ABEL'.
Error 20017: Cannot add the remote distributor at this time.
Make sure that the local server is configured as a Distribution
Publisher at the Distributor.
Can anyone point me in the right direction? I'm fairly new
to SQL Server, so feel free to explain things in a
condescending manner. ;-)
View 1 Replies
View Related
Mar 19, 2003
I have a SQL Server version 7.0 and want to configure IBM DB2 on OS 390 as a linked server on it . I installed DB2 clients on the SQL Server and thru DB2 Connect ,I am able to access the mainframe data using the clients . However I am having problems configuting the Mainframe server using IBM DB2 OLE DB Driver .I am not sure if we need to use Microsoft OLE DB Driver .
View 3 Replies
View Related
May 23, 2002
Hello all,
I have a Production server which has 2gb of memory. SQL server memory is set to configure dynamically.
The Server also has a third party application on it. The third party application was running poorly, and the software vendors recommended running the following sql on a job every hour:-
exec sp_configue 'max server memory(MB)',500
reconfigure
exec sp_configure 'max server memory(MB)'1400
reconfigure
The hourly job has the effect of flushing out sql server memory every hour and setting the max amount down to 500mb and back up to 1400mb. SQL server still manages memory dynamically, so within the hour before the next time the job runs, sql server could use more than 1400mb.
I' feel that this job will degrade sql server performance because it will empty the buffer cache and procedure cache. My approach would be to select the 'use a fixed memory' option and set it to 1400mb, and not use their recommendation.
Does anybody have experience of this, and perhaps explain the consequence of running the recommended job every hour.
Any advice would be great.
Pargat
View 2 Replies
View Related
