I'm trying to run a copy of Enterprise Manager at home. I have a small wireless network and would like to install it on either one machine (stand-alone) or run it on my network.
The machine it is installed on is running Windows 2000 and the remote machine is running Windows XP Home <<< not sure if SQL Server will run on this.
I tried installing it previously as stand-alone on the Win2K machine, but kept getting a "Server not found or access denied" message whenever I tried to register or connect.
Any ideas on how best to set it up at home would be greatly appreciated.
Here is the problem, i'm sure there is quite a bit on google but i'm not sure what to search for. I want to know how to connect to a sql server from my home machine using the localhost for testing asp.net files out. At work the machines will connect fine using localhost. The server we connect to is in another location. If someone could get me started on what to search for i would appreciate it.
How can I practice the use of SQL server without changing mygirlfriends laptop to XP Pro (which anyway I dont have)?Using (unfortunately) Windows XP Home not Pro, Visual Studio 2005.Trying to learn SQL server with asp, javascript, vbsrcipt and HTML-new to this.Headbutted the wall for a few hours trying to install SQL Serverproperly. The long and short is no IIS with Win XP Home so doesnt seemto work properly. I did manage to connect to Northwinds and publs DBso can use them to learn but I need to be able to ceate own database.Ie 3 tables.For the moment I have created a table in Northwind which I will try tofill with datafrom a notepad file I have...Dan
I am new to SQL / SQL Server and have downloaded SQL Server 2005 Express.
I also appear to have an existing SQL Server program on my PC which includes Query Analyzer. I wish to use Query Analyzer. Is this compatible with SQL Express?
When I try to open Query Analyzer using Windows Authentication I get the error msg:
'Unable to connect to server HOME-DHGV3DIC8N:
Server: msg 17, level 16, state 1
[Microsoft] [ODBC SQL Server Driver] [Shared memory] SQL Server does not exist or access denied.'
I am guessing that I need to create some sort of server which I can use to run SQL server.
Could anyone let me know how I do this? And also if I will be able to run Query analyzer on SQL Express edition.
I am new to servers and when I try to learn about them I get confused, because the information does not list a server in XP, but they keep it separate from Microsoft SQL Server, like XP has it's own server. Can someone help clarify for me what the versions of SQL servers are?
i have copied a project from work i am working on and have created the same project at home in visual studio.net - everything is the same as it is at my work - for some reason though i cannot connect to the servers from my home project
can anyone help me with this - i get the message "SQL Server does not exist or access denied"
my web config has exactly the same set up with a key in appSettings as
Hi I have problems to find the Reporting Services in the MSSQL Server Express adv. Services. Is it because I have onlx the Windows Home installed? And the IIS is missing? I hope not! I also work with C# Express and now I really need to produce some reports and graphics...
Ive seen several sellers, both retail and on ebay, who say that sql server2000 developeredition will run on windows xp home edition. Is this true? Some articlesI've seen imply yeswhile other articles imply no. I'm trying to learn sql server and a lot ofbooks I've purchaseoffer a 120 day evaluation. I'd prefer to buy an edition that I can affordand will give me boththe server and tools.A seller on ebay is selling the developer edition and it's price is withinmy budget. I don't wantto buy it if it won't install on windows xp home.Any help would be great. Thanks
I installed SQL Server 2005 Enterprise trial on Vista Home Premium. In the process of trying to get SQL Server Management Studio installed I ended up removing everything. Now when I try to install any tool, service, or database of SQL Server 2005 (Enterprise or SQLExpress) the install fails and says that a newer version is already installed but nothing is installed. Rollback my restore points fails too. Seems like I need to clean up the registry somehow????
I have windows vista home with IIS installed in it. In microsoft download website I found 5 related links. I downloaded all of them. none of them says it is compatible with vista. and accordingly none of them after installing worked properly.
I have my SQL Server installation on drive c: and the databases on anotherdrive. My c drive got corrupted and I am planning to restore it from an oldbackup. This means drive c will not be up to date.Is there anything that SQL Server saves in the registry or in its homefolder that changes frequently? I am hoping that nothing does which meansthe old backup will be good enough.Although I think the default databases are in the c drive, I will try toget them back from a recent backup.John Dalberg
hi i have windows vista home basic.I am trying to install sql server 2005. I have two issue: 1)Its always throwing a popup window saying sql server has a know issue and do you want to continue. 2)I am not able to connect to any database engine.
My target market includes Micro-SMEs (i.e. 1 to 2 person business). This users often have multiple computers, but tend to run XP Home edition. Hence I need to set up a SQL Server Express on one of the machines and allow the other machines to access it.
So far I realise:
XP machines must be SP2ed (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=379560&SiteID=1) XP Home machines need to be in the same work group (am I right?) I have to Open up the MS Firewall on each of the machines for TCP ports 1433 and 1434 (see http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=511441&SiteID=1) On the machine hosting the SQL Server Express instance, start the "Browser" Service (again http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=511441&SiteID=1)
I have several questions surrounding this.....
If I package SQL Express with my application is there away I can get the Browser to be started automatically? Do I need to write some custom code using the Microsoft.SqlServer.Management namespace? My understanding of the SQL Server security model is that ideally I should ideally use Windows Authenticated users connections - how do I set up the remote XP Home user on the XP Home machine which is hosting the SQL Server Instance? I'm thing I may have to used Mixed Mode and pass the SQL Server username and password in the connection string. Am I right or can I use Windows Authenticated? Are there any more resources other than http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/emsqlexcustapp.asp which I should look at for help on installing an app bound to SQL Server Express?
I am trying to install SQL Express on Window Home XP and SCC is returning the following error:
The SQL Server Configuration Checker cannot b execute due to WMI configuration on the machine ..... Error 2147942405 (0X80070005).
I tried running the following batch file which I believe resolved the same issue that someone else raised earlier (though I am not sure whether the OS was Home XP)
Will upgrading from XP Home to XP Professional (academic version) help me install SQL express successfully>
The Batch file I ran looks like this:
FIXWMI.CMD ------------------------
@echo on cd /d c: emp if not exist %windir%system32wbem goto TryInstall cd /d %windir%system32wbem net stop winmgmt winmgmt /kill if exist Rep_bak rd Rep_bak /s /q rename Repository Rep_bak for %%i in (*.dll) do RegSvr32 -s %%i for %%i in (*.exe) do call :FixSrv %%i for %%i in (*.mof,*.mfl) do Mofcomp %%i net start winmgmt goto End
:FixSrv if /I (%1) == (wbemcntl.exe) goto SkipSrv if /I (%1) == (wbemtest.exe) goto SkipSrv if /I (%1) == (mofcomp.exe) goto SkipSrv %1 /RegServer
:SkipSrv goto End
:TryInstall if not exist wmicore.exe goto End wmicore /s net start winmgmt :End
I have recently updated from XP to Vista Home Premium. Now when I try to install SQL Serve Express SP2 I get :
"setup has detected problem with .net framework installation and cannot proceed. Microsoft .net framework 2.0 is either not installed or is corrupt."
I have tried to run sfc /scannow to make sure my .NET 2.0 was not corrupted and also was running as an administrator but could not get it installed. Anyone has any ideas?
sql server 2005 standard version on vista home premium is giving following error if i try to browse the Stored procedures on a remote server
TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) ------------------------------ ADDITIONAL INFORMATION: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (Microsoft SQL Server, Error: 64)
System Information
Windows Vista Home Premium
SQL server 2005 standard edition with service pack Everything works fine from my other machine with xp installed on it.. I tried increasing the connection timeout time ans execution time but no success ..
Please Microsoft guys please help its urgent... Thanks in advance...
I am trying to install SQL Server 2005 on Windows Vista Home Premium edition, when I run the Installer I received are the following error message.
IIS Feature Requirement (Warning)
Messages
IIS Feature Requirement
Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
I already configure IIS7 with all feature, but system still generate above mentioned message.
dear friends, I installed Sql ServerExpres SP2 spanish vertion in Vista home basic, I Cant Attach a data base, it reports me the error cant access to Model data base, error 916, and when I try to Create a new data Base it Reports me, Permition denied to create a data base in master, error 262
I am trying to download English Vertion, but When I download it olways try to download me the sqlexpres32_ESN.EXE which have these problems.
I could not install SQL Server 2005 Developer edition on my notebook with os Vista Home Premium. I know about the SP2 thing...but before coming that point, I can not either install the SQL Server 2005... When installing,when the database services point comes it gives an error about user thing...and then installation starts to rollback...
I check the IIS configuration from the net...And see that while activating IIS there is no option for Windows Auth. in Home Premium in Control Panel>Program...>Windows Programs.....etc....
SO ON VISTA HOME PREMIUM is SQL SERVER 2005 Dev. Edition can be installed or not?
I have tried to install SQL Server 2005 Express several times with no success. I have followed the instructions to remove all SQL files on the Programs menu. Then, when I attempt to install it again, it only goes as far as the database where it stops and gives the error message: SQL Server cannot write system databases to C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData because it contains files from a previous installation. To continue, move the databases from the specified folder, or specify a different installation folder. Then run SQL Server Setup again.
It doesn't give options and I can only abort the installation.
Does anyone have a remedy for a technologically challenged person?
I'm green on this networking stuff so any help is greatly appreciated.
I have setup my home computer as a server and assigned a static IP to it. I installed SQL Server 2005 Developer and allowed remote connections to it through the Surface Area Config tool, added port 1433 TCP and 1434 UDP to firewall's exception list, and started the SQL Server Browser service.
Now I can't seem to remote connect to this SQL Server from my office network. Is there something I'm doing wrong here?
Hi, I have Vista Home premium edition and trying to install SQL Server developer edition 2005 as local administrator. I have already enabled IIS 7 and have Office Ultimate 2007 installed. When I run the set up program, I get a warning titled "Program Compatibility Assistant" that my Operating system may not be compatible with the version of sql server I am installing. It says after setup is complete, I should run SP2 of SQL Server 2005 with 3 buttons as "Check for solutions online", "run this program" and "cancel"...
My question, should I select "run this program" and after the setup completes, download SP2 and apply the patch?
I read some articles in forums that sounds like lot of issues to get sql server working on vista. Can some one direct me to correct options. This is my wife's machine so I dont want to experiment too much and blow her machine away. Please help.
I have Vista Home premium installed on my system. I installed SQL server 2005 express SP2. When I am trying to attach Advetureworks database by using following script, i get the following error.I am logged in as administrator.What kind of permission i have to set so that i can install the database.Any help will be appreciated.Script is :
Unable to open the physical file "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAdventureWorksDW_Data.mdf". Operating system error 5: "5(Access is denied.)".
I am installing SQL Server 2005 Express Edition with Advanced Services on Windows XP Home Edition SP2 and received error 29521. I am installing with an account that has administrator rights. The summary.txt file contains: Error String : SQL Server Setup failed to execute a command for server configuration. The error was {Microsoft}{SQL Native Client}{SQL Server}CREATE DATABASE failed. Some file names listed could not be created. Check related errors.. Refer to the server error logs and Setup logs for detailed error information. Error Number : 29521
I have SQL Express 2005 SP2 installed in my Vista Home Premium. I am using SQL Server Management Studio Express to manage .mdf.
When I click "Add..." to attach .mdf database, I have this prompt error message :
The server principal "My-PCMyName" is not able to access the database "model" under the current security context. (Microsoft SQL Server, Error: 916)
I have elevated the rights, "Run as administrator", of my SQL Server Management Studio Express, but still having problem.
I also encounter security error when detaching the existing .mdf : The EXECUTE permission was denied on the object 'sp_detach_db', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)
Hi. I've been trying to install Sql Server 2005 express on Vista Home Premium. After the initial files install, I get an error message that says the WMI configuration is not correct. (I'm not at home, so I can't post the exact error code at the moment). Does anyone have any ideas on how I can fix this? Thanks in advance.
Hi I am interested in taking MCTS exam 70-431 for sql server 2005 implementation and maintainance. I have been reading the hardware requirements for the instalation of sql server versions and realise that enterprise and developer editions have same minimum requirements for the operation system. I understand that the Developer Edition includes all the functionality of SQL Server 2005 Enterprise Edition, but it is licensed for use as a development and test system, not as a production server.
Also I undestand that the developer edition supports the Windows XP Home Edition with SP2 or later but the enterprise edition does not support this operating system. The evaluation/trial version is for the enterprise edition. Can I use the developer version of sql server 2005 for my practice exercises instead of using the trial version? I have all hardware requirements for the trial enterprise version except that I am using Microsoft windows Xp home edition version 2002 with SP2. I am trying to see if I can use the developer version of sql server 2005 as it is cheaper for me to buy this software than buying the new operating system for my computer. According to the microsoft book for the MCTS exam 70-431 there is a section which states that before you begin you should have Microsoft Windows Server 2003 running on your computer on an NTFS file system (NTFS) partition. Will I still be ok to use the book and be able to do all the tests in the book if i am using the developer version of sql server 2005 with my Microsoft windows Xp home edition than using the trial version which comes with the book?
Hello Reporting Services 2005 users or Reporting Services Team, I have done everything to get pass this error but no luck. My setup is :- WIndows 2003 Standared Edition SP1 Sql Server :- Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1) Reporting Services starting SKU: Standard. From the Reporting Services Configuration Manager: I can see all other things configured except Encryption Keys(blue sign) Initialization(Grey sign) and Execution Acct(Yellow sign) My windows Service Identity is using : NT AuthorityNetworkService Builtin Acct :NetworkService
Web Service Identity :- ASP.NET Service Acct :- NT AuthorityNetworkService
DataBase Setup :- Credentials Type :- Service Credentials
I have also done everything from here thanks to Göran http://stevenharman.net/blog/archive/2007/03/21/Avoiding-the-401-Unauthorized-Error-when-Using-the-ReportViewer-in.aspx
and
http://support.microsoft.com/default.aspx?scid=kb;en-us;896861 and
http://forum.k2workflow.com/viewtopic.php?t=619&
If you guys any solution for this please let me know. I was wondering could this be a scale-out deployment issue ?
I also get the error when setting up the DataBase Setup : Although saving the database connection info succeeded the The report server cannot access internal info about this deployment to determine whetherthe current con fig is valid for this editionThis could be a scale-out deployment and that the feature is not supported by this editionTo continue use a diff report server database or remove the encription keys
My Error log file is below:- w3wp!webserver!5!16/05/2007-14:52:46:: i INFO: Reporting Web Server started w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file. w3wp!resourceutilities!5!16/05/2007-14:52:46:: i INFO: Reporting Services starting SKU: Standard w3wp!resourceutilities!5!16/05/2007-14:52:46:: i INFO: Evaluation copy: 0 days left w3wp!resourceutilities!5!16/05/2007-14:52:46:: i INFO: Running on 1 physical processors, 2 logical processors w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds w3wp!library!5!05/16/2007-14:52:48:: i INFO: Call to GetPermissions:/ w3wp!library!5!05/16/2007-14:52:48:: i INFO: Catalog SQL Server Edition = Standard w3wp!library!5!05/16/2007-14:52:48:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server. w3wp!library!5!05/16/2007-14:52:48:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server. w3wp!library!5!05/16/2007-14:52:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server. w3wp!library!5!05/16/2007-14:52:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server.
