Microsoft SQL Server Hosting Knowledge Base
RAID 1 disk while using Microsoft SQL server 2005? Our system at work is planning to use a RAID 1 disk system for redundant storage. The server PC will host Microsoft SQL server 2005. Are there any known incompatibilities with RAID in this configuration? How about RAID 1 on a client PC hosted by XP?
What is a Microsoft SQL database useful for? Hi My internet server hosting package says I have a 150mb 'Free' Microsoft SQL database if I install it. I cannot think what is would be useful for! An online forum maybe like Vbulletin? Is this the only use an SQL database is for? Thanks!
How to access SQL Server 2005 with VB.net? I have a database in Microsoft's SQL Server 2005. It is hosted on the school's... wherever they host these things. I decided to make the front end in Visual Basic .net because I didn't want to spend forever making the GUI. But I can't figure out how to access the database through VB, and I have not found any sites with good information. How do I connect to the database through VB.net? Or what are some good sites where I can learn about how to do this? I will need to run stored procedures and such. Thanks much.
Where can I get my MySQL server host address? I have a Microsoft access database and I want to convert it to a MySQL table, but Microsoft access is asking me for the SQL server host, username and Password.. which ones should I use and what's the server address? my website is : gerard.xxxxxxxxx.net and it uses cpanel manager and it has phpMyAdmin to manage the databases also.
Managing SQL Server online. Is there a tool out there? Hello, On a web site I manage I have a Microsoft SQL database. As administrator I would like to easily edit, access, delete, add any record in the database tables while the database is on the server where the site is hosted. Is there any software to do this? I dont have Enterprise Manager or any fancy tool ... Sure I could create an administration section on the web site but it would be a lost of time since I am the only one which has access to the database. Thanks ...
To Connect to CRYSTAL REPORT PROBLEM :(? I am trying to connect to Web Hosting SQL SERVER via CRYSTAL REPORT. I am chosing Microsoft Ole Db provider for Sql Server. And i am writing my Server information same as IP number.(For example 123.456.789.012) and i am writing my user name , password and also database_name. But i have a error (SQL State:08001,ConnectionOpen(Invalid Instance) ). But i can connect easly from my Microsoft Sql Server Management Studio. Why Crystal Report can not connect?
Where do I purchase SQL? What do I need to buy? I have been using Microsoft SQL enterprise manager at work to do updates to a website. I can openteh program up and change data but I have never built anything from scratch. Though I do have a mySQL book I would like to hear from someone more about this program. I don't even know if microsoft SQL is the same as mySQL. I would like to have this program on my computer at home to build database driven websites. Where should I start? Where could I buy it at? How much will it cost? Is it hard to build SQL stuff from scratch (its easy to update it). Do I need to make sure my host has SQL on their servers just like cold fusion? A designer who is starting to get into databases is looking for a little help with questions I can't find answers to!
5 CAL? SQL Server 2005 -- means only 5 users are legally access my website? This may be a stupid question, I understand Microsoft product is always got to be expensive, but this seems ridiculously expensive. I have a server running windows server 2003 with a couple of websites hosting on it. Now I need a SQL Server 2005 in order to get my database working. But suddenly I found I can't afford the license cost. I'm still new on this, can anybody tell me does '5 CAL' means that if there are 10 users viewing my website, I have to pay ‘10 CAL'?!
WHY WONT ANYONE ANSWER THIS QURSTION OR help me!!??!!? I need 2 start fresh I HAD a website ran on yahoo. I took a template and re-wrote the code to suite my needs(iam new 2 playing with html) it worked fine and I could have used it.however I didnt like the look(it was a generic template)and I found one better.I also learned about ASP.NET and its use w/ members websites databases SQL servers.I then switched web hosting to godaddy yahoo doesnt support ASP I am using Visual Web Developer Express edition, I also have Microsoft SQL server 2005. I have set up a database on my webhosting, I have enabled TCP/IP in the SQL server configuration manager, yet I cannot connect 2 my database when I run aspnet_regsql.exe program.. right now this is all that is in my web.config file: <?xml version="1.0" encoding="utf-8"?> <configuration> <system.web> <authorization> <allow roles="users" /> </authorization> <roleManager enabled="true" /> <authentication mode="Forms" /> </system.web> </configuration> I know the connection strings info just not where it go Continued:I know the connection strings info just not where it goes in the web.config file and how it is supposed to be place... if someone can PLEASE walk me through it from the begining to see what went wrong and so I can learn I would really apreciate it. Alot of people have given me advice but it has lead no where. I think its is best to start fresh and from the begining with someone who knows what they are doing so it is done right... Please HELP me, I am begging you out of the kindness of my heart! PLEASE! I cannot connect 2 my database when I run aspnet_regsql.exe program..how do i do it??? Also how to i add the database string into my web.config file???? And for you rude people who want to be smart asses FUCK OFF!!
What do I need to learn to have a database update automatically from my site into a database program.? I am ok with HTML and CSS. I have Microsoft Professional (w/ Access and Excel). Are either of these possible to integrate with a website. What do I need (software-wise) and need to learn to be able to build a database and have it update automatically when a person signs up on my website. Also, I would like the database to update info on my site and have a member login available. I also need to know how to host my own site (does SQL server allow me to host my own website). Thanks for the help!
help! I have a trojan virus which shows a red circle with a white x in it. getting "download" alerts. help! Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 2:54:54 PM, on 3/16/2008 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Boot mode: Normal Running processes: C:\WINNT\System32\smss.exe C:\WINNT\system32\winlogon.exe C:\WINNT\system32\services.exe C:\WINNT\system32\lsass.exe C:\WINNT\system32\svchost.exe C:\WINNT\System32\svchost.exe C:\WINNT\system32\spoolsv.exe C:\WINNT\system32\crypserv.exe C:\Program Files\Google\Common\Google Updater\GoogleUpdaterService.exe C:\Program Files\iPass\iPassConnect\iPCAgent.exe c:\sots\KMService.exe C:\Program Files\Marimba\Castanet Tuner\Tuner.exe C:\Program Files\Network Associates\Common Framework\FrameworkService.exe C:\Program Files\Network Associates\VirusScan\mcshield.exe C:\Program Files\Network Associates\VirusScan\vstskmgr.exe C:\Program Files\Common Files\Microsoft Shared\VS7Debug\mdm.exe c:\progra~1\Metlife\MediaManager\MediaManager.exe c:\MetLife\MetTask\METTASK.EXE C:\Lotus\Notes\ntmulti.exe C:\WINNT\system32\Prot_srv.exe C:\WINNT\system32\pstartSr.exe c:\winnt\system32\rcmdsvc.exe c:\Program Files\Microsoft SQL Server\90\Shared\sqlwriter.exe C:\Program Files\CheckPoint\SecuRemote\bin\SR_Service.exe C:\Program Files\CheckPoint\SecuRemote\bin\SR_WatchDog.exe C:\WINNT\system32\svchost.exe C:\WINNT\Explorer.EXE C:\Program Files\CheckPoint\SecuRemote\bin\SR_GUI.Exe C:\WINNT\system32\hkcmd.exe C:\WINNT\system32\igfxpers.exe C:\Program Files\Apoint\Apoint.exe C:\WINNT\system32\igfxsrvc.exe C:\WINNT\stsystra.exe C:\Program Files\Common Files\Network Associates\TalkBack\tbmon.exe C:\Program Files\Network Associates\Common Framework\UpdaterUI.exe C:\Program Files\Network Associates\VirusScan\SHSTAT.EXE C:\sots\detectVPN.exe C:\Program Files\Apoint\HidFind.exe C:\Program Files\Pinpoint Global\Media Room\MediaRoomClientApp.exe C:\PROGRA~1\Lavasoft\AD-AWA~1\Ad-Watch.exe C:\Program Files\Apoint\Apntex.exe C:\Program Files\Pointsec\Pointsec for PC\P95Tray.exe C:\Program Files\Common Files\Real\Update_OB\realsched.exe C:\Program Files\Websense\WDC\WsUIMgr.exe C:\WINNT\system32\braviax.exe C:\WINNT\system32\ctfmon.exe C:\PROGRA~1\MYWEBS~1\bar\1.bin\mwsoemon.exe C:\Program Files\METLIFE\LSMS3\lsms3.exe C:\Program Files\Google\Google Updater\GoogleUpdater.exe C:\Program Files\Kodak\Kodak EasyShare software\bin\EasyShare.exe C:\Program Files\iPass\iPassConnect\downloader\ipccheck.exe C:\Program Files\Marimba\Castanet Tuner\lib\minituner.exe C:\Program Files\Network Associates\VirusScan\SCAN32.EXE C:\Program Files\Internet Explorer\iexplore.exe C:\Program Files\Trend Micro\HijackThis\HijackThis.exe R0 - HKCU\Software\Microsoft\Internet Explorer\Main,Start Page = https://imetlife.metlife.com/siteminderagent/forms/singlesignon/signon.html R1 - HKLM\Software\Microsoft\Internet Explorer\Main,Default_Page_URL = http://exwintp019.metlife.com/login.asp R1 - HKCU\Software\Microsoft\Internet Explorer\Main,Window Title = Microsoft Internet Explorer provided by Metropolitan Life R3 - URLSearchHook: (no name) - {00A6FAF6-072E-44cf-8957-5838F569A31D} - C:\Program Files\MyWebSearch\SrchAstt\1.bin\MWSSRCAS.DLL O3 - Toolbar: &Google - {2318C2B1-4965-11d4-9B18-009027A5CD4F} - c:\program files\google\googletoolbar1.dll O4 - HKLM\..\Run: [igfxtray] C:\WINNT\system32\igfxtray.exe O4 - HKLM\..\Run: [igfxhkcmd] C:\WINNT\system32\hkcmd.exe O4 - HKLM\..\Run: [igfxpers] C:\WINNT\system32\igfxpers.exe O4 - HKLM\..\Run: [Apoint] C:\Program Files\Apoint\Apoint.exe O4 - HKLM\..\Run: [SigmatelSysTrayApp] stsystra.exe O4 - HKLM\..\Run: [Network Associates Error Reporting Service] "C:\Program Files\Common Files\Network Associates\TalkBack\tbmon.exe" O4 - HKLM\..\Run: [SET_PLAYER] regedit /s c:\systemp\mp3\mp3assoc.reg O4 - HKLM\..\Run: [RoamingUser] "C:\Program Files\Marimba\Castanet Tuner\tuner.exe" -start http://as_risccast00:5282/ENT/Castanet/RoamingUser?start 1 O4 - HKLM\..\Run: [McAfeeUpdaterUI] C:\Program Files\Network Associates\Common Framework\UpdaterUI.exe /StartedFromRunKey O4 - HKLM\..\Run: [ShStatEXE] C:\Program Files\Network Associates\VirusScan\SHSTAT.EXE /STANDALONE O4 - HKLM\..\Run: [DetectVPN] c:\sots\detectVPN.exe O4 - HKLM\..\Run: [LSMS3] C:\Program Files\MetLife\LSMS3\LSMS.BAT O4 - HKLM\..\Run: [LSMS] C:\Program Files\MetLife\LSMS3\OldLSM.BAT O4 - HKLM\..\Run: [MediaRoomApp] C:\Program Files\Pinpoint Global\Media Room\MediaRoomClientApp.exe O4 - HKLM\..\Run: [AWMON] C:\PROGRA~1\Lavasoft\AD-AWA~1\Ad-Watch.exe /custom +prefs:"C:\PROGRA~1\Lavasoft\AD-AWA~1\awsettings.awc" O4 - HKLM\..\Run: [Pointsec Tray] C:\Program Files\Pointsec\Pointsec for PC\P95Tray.exe O4 - HKLM\..\Run: [sp2cfg] C:\WINNT\system32\mrmbtemp\xpsp2\wkix32.exe C:\WINNT\system32\mrmbtemp\xpsp2\popup.kix /i O4 - HKLM\..\Run: [TkBellExe] "C:\Program Files\Common Files\Real\Update_OB\realsched.exe" -osboot O4 - HKLM\..\Run: [WsUiMgr] C:\Program Files\Websense\WDC\WsUIMgr.exe O4 - HKLM\..\Run: [braviax] C:\WINNT\system32\braviax.exe O4 - HKCU\..\Run: [ctfmon.exe] C:\WINNT\system32\ctfmon.exe O4 - HKCU\..\Run: [swg] C:\Program Files\Google\GoogleToolbarNotifier\GoogleToolbarNotifier.exe O4 - HKCU\..\Run: [MyWebSearch Email Plugin] C:\PROGRA~1\MYWEBS~1\bar\1.bin\mwsoemon.exe O4 - HKCU\..\Run: [braviax] C:\WINNT\system32\braviax.exe O4 - Global Startup: ADAWARE.LNK = C:\WINNT\runonce.bat O4 - Global Startup: Adobe Reader Speed Launch.lnk = C:\Program Files\Adobe\Acrobat 7.0\Reader\reader_sl.exe O4 - Global Startup: CENSUSNT.LNK = C:\METLIFE\dlm\censusnt.bat O4 - Global Startup: Google Updater.lnk = C:\Program Files\Google\Google Updater\GoogleUpdater.exe O4 - Global Startup: Kodak EasyShare software.lnk = C:\Program Files\Kodak\Kodak EasyShare software\bin\EasyShare.exe O4 - Global Startup: Microsoft Office.lnk = C:\Program Files\Microsoft Office\Office10\OSA.EXE O4 - Global Startup: NTCONECT.LNK = C:\Security\NtConect.exe O4 - Global Startup: systray.exe O6 - HKCU\Software\Policies\Microsoft\Internet Explorer\Restrictions present O8 - Extra context menu item: &Search - http://edits.mywebsearch.com/toolbaredits/menusearch.jhtml?p=ZKxdm021YYUS O8 - Extra context menu item: E&xport to Microsoft Excel - res://C:\PROGRA~1\MICROS~2\Office10\EXCEL.EXE/3000 O9 - Extra button: (no name) - {08B0E5C0-4FCB-11CF-AAA5-00401C608501} - C:\Program Files\Java\jre1.6.0_03\bin\ssv.dll O9 - Extra 'Tools' menuitem: Sun Java Console - {08B0E5C0-4FCB-11CF-AAA5-00401C608501} - C:\Program Files\Java\jre1.6.0_03\bin\ssv.dll O9 - Extra button: Messenger - {FB5F1910-F110-11d2-BB9E-00C04F795683} - C:\Program Files\Messenger\msmsgs.exe O9 - Extra 'Tools' menuitem: Windows Messenger - {FB5F1910-F110-11d2-BB9E-00C04F795683} - C:\Program Files\Messenger\msmsgs.exe O10 - Unknown file in Winsock LSP: c:\winnt\system32\nwprovau.dll O14 - IERESET.INF: START_PAGE_URL=http://exwintp019.metlife.com/login.asp O15 - Trusted Zone: *.metlife.com O15 - Trusted Zone: *.metlife.com (HKLM) O16 - DPF: {10B05D6E-5BFB-11D4-8920-00C04F57BB26} (KMReader Class) - https://imetlife.metlife.com/siteminderagent/forms/singlesignon/KeyMasterObj.cab O16 - DPF: {1D4DB7D2-6EC9-47A3-BD87-1E41684E07BB} - http://ak.exe.imgfarm.com/images/nocache/funwebproducts/ei/WebfettiInitialSetup1.0.0.15-3.cab O16 - DPF: {48DD0448-9209-4F81-9F6D-D83562940134} (MySpace Uploader Control) - http://lads.myspace.com/upload/MySpaceUploader1006.cab O17 - HKLM\System\CCS\Services\Tcpip\Parameters: Domain = metlife.com O17 - HKLM\Software\..\Telephony: DomainName = metlife.com O17 - HKLM\System\CS1\Services\Tcpip\Parameters: Domain = metlife.com O17 - HKLM\System\CS2\Services\Tcpip\Parameters: Domain = metlife.com O17 - HKLM\System\CS3\Services\Tcpip\Parameters: Domain = metlife.com O18 - Protocol hijack: flowto - {C7101FB0-28FB-11D5-883A-204C4F4F5021} O23 - Service: pcAnywhere Host Service (awhost32) - Symantec Corporation - C:\program files\symantec\pcanywhere\awhost32.exe O23 - Service: Crypkey License - CrypKey (Canada) Ltd. - C:\WINNT\SYSTEM32\crypserv.exe O23 - Service: Google Updater Service (gusvc) - Google - C:\Program Files\Google\Common\Google Updater\GoogleUpdaterService.exe O23 - Service: InstallDriver Table Manager (IDriverT) - Macrovision Corporation - C:\Program Files\Common Files\InstallShield\Driver\11\Intel 32\IDriverT.exe O23 - Service: iPassConnectEngine - iPass - C:\Program Files\iPass\iPassConnect\iPassConnectEngine.exe O23 - Service: iPCAgent - iPass, Inc. - C:\Program Files\iPass\iPassConnect\iPCAgent.exe O23 - Service: KMService - Unknown owner - c:\sots\KMService.exe O23 - Service: Marimba - BMC Software, Inc. - C:\Program Files\Marimba\Castanet Tuner\Tuner.exe O23 - Service: McAfee Framework Service (McAfeeFramework) - Network Associates, Inc. - C:\Program Files\Network Associates\Common Framework\FrameworkService.exe O23 - Service: Network Associates McShield (McShield) - Network Associates, Inc. - C:\Program Files\Network Associates\VirusScan\mcshield.exe O23 - Service: Network Associates Task Manager (McTaskManager) - Network Associates, Inc. - C:\Program Files\Network Associates\VirusScan\vstskmgr.exe O23 - Service: MediaManager - Unknown owner - c:\progra~1\Metlife\MediaManager\MediaManager.exe O23 - Service: MetLife® Task List (MetLifeTaskList) - MetLife® - c:\MetLife\MetTask\METTASK.EXE O23 - Service: Multi-user Cleanup Service - IBM Corp - C:\Lotus\Notes\ntmulti.exe O23 - Service: Pointsec - Unknown owner - C:\WINNT\system32\Prot_srv.exe O23 - Service: Pointsec Service Start (Pointsec_start) - Unknown owner - C:\WINNT\system32\pstartSr.exe O23 - Service: Check Point SecuRemote Service (SR_Service) - Check Point Software Technologies - C:\Program Files\CheckPoint\SecuRemote\bin\SR_Service.exe O23 - Service: Check Point SecuRemote WatchDog (SR_WatchDog) - Check Point Software Technologies - C:\Program Files\CheckPoint\SecuRemote\bin\SR_WatchDog.exe O23 - Service: Websense Desktop Client (WebsenseDesktopClient) - Websense - C:\Program Files\Websense\WDC\WDC.exe -- End of file - 10095 bytes
Does Microsoft have a "hosted beta" program where they just? give you a username and password where you can login to the hosted beta site for 120 minutes and test out "Vista" before it is sold in the market? They had something like this for testing SQL Server 2005 before? Why waste money on distributing DVDs? Use http://demoservers.com/ This is what they had used before for SQLServer 2005. "If you dont have it, buy it or steal it and say it was yours in the first place." This is Technet Virtual Labs but you have to do what they tell you to: http://www.microsoft.com/technet/traincert/virtuallab/default.mspx
Reporting Services 2000 ( not the 2005 )? I was looking at this site. http://www.microsoft.com/technet/community/chats/trans/sql/SQL0128.mspx and this sentences exactly. Host: Bruce (Microsoft) A: There is a sample report posted on the public newsgroup that shows how to sort columns. Host: Bruce (Microsoft) Q: How do I find the sample report that shows how to sort columns? A: In the microsoft.public.sqlserver.reportingsvcs newsgroup search for the Sorting thread posted on 1/27/2004. but here in news group, I can only find upto 3rd month of 2004. Can any one help by letting me know how to access this article or give an example of enabling the option of user clicking on column header/button to sort the records by column. This I only want in sql server reporting services 2000. Not in 2005. Thanks in advance. http://msdn.microsoft.com/newsgroups/default.aspx?pg=109&cat=&lang=&cr=&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&fltr=
How do I get Windows Vista for Enterprises? I couldn't find it. We will use the following features: 1. Mail server (not included but purchasable from MicroSoft themselves). 2. Web server (IIS7) with PHP and ASP.NET (yes, I can I get it compatible). 3. FTP Server (FTP6) - Installable. 4. Reception. 5. MySQL, MS SQL, MSQL, MS Access database(s) server(s). 6. Work desks. 7. Administration. All numbers will have different amounts of computers and we are hoping to have 34 computers. We have Windows Server 2008, but we want some machines running Vista for easier and administration and development. We have $1,000,000 to spare. The servers are in California (preferred not to say where they are, but they will be highly secure). We will also be hosting as a provider to commerce and advertise our corporation. We will have three DNS servers to divide the IP address into a commemorative name (our own TLDs). But we do not want to purchase online, if we have to we will, anyone know where (a place) we can buy the disc? Thanks!! Unavailable in stores due to license reasons. That link doesn't tell me exactly how and where to get it.
What is a Microsoft SQL database useful for? Hi My internet server hosting package says I have a 150mb 'Free' Microsoft SQL database if I install it. I cannot think what is would be useful for! An online forum maybe like Vbulletin? Is this the only use an SQL database is for? Thanks!
Powered by Yahoo! Answers