Hi, all.
I'm setting up a SQL 2000 install on a Windows 2K3 server box.
When I launch setup, I get a warning screen that the software is not
supported.
But the install works, I can create databases, and all seems okay.
What's up with this? Would I not get MS Support with this
configuration?
Thanks,
BD
Hi All,
I have installed a dual node active passive W2K3 Clusters with SQL 2K.
The cluster has RAID10 for data and RAID1 for Quorum and Transaction Logs.
How do I put the Transaction logs on the RAID1 disk as at install SQL2K only asks where you would like to put the SQL data ?
Any tips appreciated.
Hello,
We're planning to upgrade our OS from Windows2000Svr to Windows2003,my question is,will there be problem on my SQL2000 installed? is there patch needed for the SQL2000 to run in Windows2003 environment?
thanks®ards,
jerico
Maybe this is a stupid question, but we're ordering a new server, and we get our choice of OS with it. So I'd like to have 64-bit OS if I can.
In the larger plan, is there any problem upgrading from 32-bit SQL2000 to 64-bit SQL2005?
Thanks!!
Hi.
I've been having a problem with SQL Server 2005 installation.
I get these errors:
- SQL Server Edition Operating System Compatibility (Warning)
Messages
* SQL Server Edition Operating System Compatibility
* Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online.
- Minimum Hardware Requirement (Warning)
Messages
* Minimum Hardware Requirement
* The current system does not meet the recommended hardware requirements for this SQL Server release. For detailed hardware and software requirements, see the readme file or SQL Server Books Online.
I can't install server services --> see here http://img221.imageshack.us/my.php?image=sqlinstalacjase9.jpg
-I'm trying to install SQL Server 2005 Standard edition on Virtual PC (host Windows XP Pro SP2, virtual system: Windows 2003 Server)
-I've been trying assigning from 512 to 750 Mb of RAM to virtual system
-I can install it on host (xp pro) without any problem
-I'm installing it from iso files - so it's not possible something is wrong with cd
-I'm using laptop Lenovo - Core 2 Duo 1,5 Ghz | 1 Gb ram
-I have plenty of space and checked option that says the disk is "dynamically expanding"
Any pointers? [Don't give me those http://fun.noshit.pl/DIR-2007.11.08/pointerstb1.png]
I'm the developper of a web application that uses in production environment a SQL Server 2000 db engine.
My devel. environment uses a MSDE.
In order to debug some strange problems, I need to backup the production environment and restore it in MSDE.
The environments doesn't have network connectivity between them.
Somebody can suggest any workaround?
Many thanks!
Reader Community
I've just started hosting my newly created Microsoft Visual Web Developer 2005 Express Edition web site. Unfortunately the Login group membership functions will not function correctly. Having contacted the web service hosting provider, They replied: "We do not support SQL express2005. The only way to use the extra functions of ASP.NET2 such as group membership is if it is using an SQL 2000 database to connect to. "
Is it possible to design web sites with Microsoft Visual Web Developer 2005 Express Edition that store membership details on an SQL 2000 database?
I've just paid £88 approx. $140 for a years subscription, have I chosen the wrong web service hosting provider?
Should I have designed the web site with a better web site design software tool that also makes designing membership login functionality easy, just as Microsoft Visual Web developer 2005 express edition?
Look forward to all comments?
Regards
Philip
Hello,We are using SQL server 2000 on W2k Server and MS Access 2000 ADP(like front-end). Now we try to change operating system for SQL Server2000 from W2k to W2k3 and we found problem with date format - wereceive error: "Cannot convert date type varchar to datetime".Datetime used in application are sent to SQL Server 2000 in formatYYYY-MM-DD as varchar. (in Query Analyzer all view/query works finebut when application sends it as record source of any forms or storedprocedures it causes error). Moreover if we send date in formatYYYYMMDD it works OK, the same in case when we change FORMATDATEbefore each SQL connection made by application (SET DATEFORMAT YMD)What has happened after changing operating system?thx for help
View 1 Replies View Related Hey Folks -
I'm setting up a new production SQL 2005 64-bit server running on a dedicated Windows 2003 R2 Standard system w/8GB of RAM.
I've enabled the "Lock Pages in Memory" option (http://msdn2.microsoft.com/en-us/library/ms190730.aspx) but when I run dbcc memorystatus all of my AWE counters show 0.
According to http://blogs.msdn.com/sqlprogrammability/:
"On 64 bit machines, execute 'dbcc memorystatus'. If the AWE Allocated memory is 0 then lock pages in memory privilege has not been granted to the service account or it has not taken effect. "
Does the "Lock Pages in Memory" option work on W2K3 R2 Standard? Just searching across the web I find different answers. In some places it clearly says that Lock Pages in Memory only works on W2K3 Enterprise systems. In other places it says that it should work on any Windows 2003 64-bit OS.
Does anyone have any ideas? Assuming we cannot "lock pages in memory" due to the Windows 2003 Standard OS, are there any other memory management recommendations out there?
thanks!
I have DBA that is convinced that they need domain admin rights to install SQL 2005 into an existing cluster. The domain groups and service accounts for SQL have been created already. Is having domain admin rights required during the install of SQL 2005 in a cluster?
View 1 Replies View RelatedIs the correct procedure for SUS patches to a server running SQL Server 2005, to set the client to download only and then manually shutdown SQL Server, apply patches, reboot, and restart SQL Server?
Do SQL Server 2005 patches download through SUS or is it manual SP only, except for hotfixes?
Thanks, Tom
MS states that CE does not work with ASP.Net applications 'by default'. What is needed to change this default?
Bascially, my desktop app. is configured from a browser app. (ASP.Net 2.0) and I want to use CE as the datastore for the application.
Thanks.
My documentation tells me that SQL Server Express only supports 1 gigabyte of RAM.
My computer can take 2 gigs, but I presently only have half a gig.
If I install 2 gigs on my machine, will that cause SQL Server Express to malfunction?
Or does it just mean that the extra gig will not be utilized?
Any advice would be much appreciated.
Dear friends
I am a new developer. I need some SQL Language examples to write some quaries.
Ex.
how you collect last record that relevent for the last record updated for a relevent employee in a record table which includes RecordNo and EmployeeNo, salses
Thanks
Any help is greatly apprciated
Amila
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
I understand the SANs are only Supported by SQL Server 2000 Enterprise and no other versions of SQL, can anyone supply information to the contrary please?
View 2 Replies View RelatedHas anybody heard or know anything about discontinued support for SQL Server 6.5?
I heard something about maybe 6 months after the release of SS 7.5.
Thanks in advance.
Do SQL 7 support row lock?
View 1 Replies View RelatedDoes anyone know when Microsoft is due to end support for 6.5?
View 1 Replies View RelatedHi everyone,
I have several SQL Server 6.5 machines. I would like to see what network support each server uses and change it if possible through the Enterprise Manager.
Thanks...Binh
I'm looking at an MS SQL server database and it stores city namesacross the world. All aarabic , chinese etc names are converted to the latin alphabet.I feel it is probably critical we support accents as a means todistinguish between cities that would be converted to the same Latinalphabet representation otherwise and as a matter of culturalpoliteness.Now ...... how do we do this?Use varchar? which character code page do we use?Use nvarchar? I heard a rumour that SQL server pads unused characterswith blanks and hence will use space unnecessarily.The data will be presented on sheets and emailed around the world - itwill also appear on a website.Any advice greatly appreciated - thanksOliver
View 1 Replies View RelatedAn update was supposed to be released for SQL Server Mobile which enabled support for CE 4.2. This was supposed to be released around the time of CF 2.0 sp1. SP1 came out over a month ago and there is still no sign of the SQL Mobile update. Does anyone have any information on a release date ?
View 6 Replies View RelatedI am trying to work a statement like the below - but am getting an error - I assume that @@ROWCOUNT is not supported?
UPDATE MobileInvoiceImport SET OrderDetailID = '123', QuantityReceived = '66' WHERE OrderDetailID = '123'
IF @@ROWCOUNT = 0
INSERT INTO MobileInvoiceImport (OrderDetailID, QuantityReceived) VALUES('123','1')
Hi,
Pardon me if this is not the right forum.
Is SQL Mobile supporting OMAP850 ?
If yes what cab should I use to manually instal sql mobile on the device, OMAP850 is not listed in compact framework nor sql mobile folders
if no is there a plan to support OMAP850 one day?
Thanks,
Philippe
SQL CE does not seem to support WITH NOCHECK constraint when altering the table to add a foreign key. How can I work around this?
View 3 Replies View RelatedDoes anybody know when Microsoft is planning to cut support for SQL 2000? Just recently we have learned that 7.0 is no longer supported.
Thank you in advance,
Leon Shargorodsky
How could i do if i need to use another language, unavailabel in collation such as laos, burma ?
View 2 Replies View RelatedCan CE be called from an app. that makes ODBC calls?
Thanks.
Hi, I need to get help for a SQL issue from Microsoft. On the website there seem to be two options--one is email support for $99 and another is "online" support for $259. What's the difference? Does the $259 option mean that Microsoft will remote log into my SQL Server and fix the issue while I watch? This is what I need done. Does this $259 pay for the whole issue, until it is resolved?
I am a Microsoft Certified Professional (MCSA)--do I get any discounts or is there any other avenues I should take to get remote support for SQL Server 2005? I wasn't sure where to ask this question, if it is more appropriate elsewhere then let me know.
Thanks!
Has anybody heard that Microsft is dropping support for servers running SQL Server 2000 SP3?
View 1 Replies View RelatedHi All.
What can we do to let the power that be know that there are many of us that want Dlinq to support SQL ev?
They say they are considering it, how can we help them deside?
Mike Greenway
I built a bulk Destination component for Oracle using lastest ODP.NET drivers. I was disapointed when I relised that SSIS does not support DTC (Distributed Transactional Coordinator) for ADO.NET connections, just for OLE DB ones. I do not see the reason for it as ADO.NET connection can enlist to a transaction in DTC (if provider supports it).
Is it possible somehow to change this default behaviour and have ADO.NET connection supporting DTC?
Thank you very much in advance
Vladimir
Hi friends,
I thinks this is not right place to post this question, but i don't know where can i post this one. I hope i will get reply. Actually our application is in two languages English & Spanish. We are having data in English in SQL Server 2005.
I need to Insert Spanish data in to tables. What is the way to Insert Spanish data? I need to create new table for inserting Spanish data? OR can i create new columns for spanish in existing table? OR I need to add data in the existing table without creating new table and new columns?
How they query, when they want Spanish data related to English?
Is it possible to get Spanish language words in SQL Server 2005 which is equal to English Words?
How can i write Scripts for retreiving Spanish data?
Could anyone help me to solve this problem. Thanks in Advance
Thanks
San