SQL7 On Windows XP Home
Jul 20, 2005
I just got Visual Studio 6 Enterprise which includes SQL Server
7. However, when I try to install SQL7 (Standard Edition ?) on
Windows XP Home it only installs the client components and not
the server component. The install routine claims this is because
of the version of Windows I am using.
Now I know that IIS isn't supposed to be installable on Windows
XP Home but it is with a fairly straight forward hack, so what I
was wondering was is there a way to get SQL7 Standard installed
on Windows XP Home (maybe with a similar sort of hack)?
Failing that (and assuming the SQL7 in VS6EE is "Standard") does
SQL7 Desktop work on Windows XP Home? If so where can I get it
(haven't seen one so far on eBay)?
Regards PLST
View 1 Replies
ADVERTISEMENT
Mar 17, 2007
Hi everyone,
I€™m quite new to SQL Server so maybe this is an easy question but I haven€™t found the answer after 3+ hours of Googling and experimenting.
I have a simple set up €“ two computers named HELEN and DELORES, both running Win XP Pro, SP2. These machines are connected via a home network and both belong to the same Workgroup. There€™s no Domain involved. HELEN is running SQL Server Express while DELORES is the €śclient€?, running SQL Server Management Studio Express. I am using €śWindows Authentication€? and Named Pipes to allow DELORES to work with the SQL Server Express instance on HELEN.
I have a general understanding of €śWindows Authentication€? and I was hoping someone could fill in the gaps. I realize €śWindows Authentication€? uses the underlying Windows User Accounts on the server to validate incoming connections.
I€™m sometimes having a problem in connecting SQL Server Management Studio Express (running on DELORES) to the SQL Server Express instance (running on HELEN). This problem may be due to a lack of understanding of Windows User Accounts.
I€™ve found that if I use the exact *same* username *and* passwords on both machines, SQL Server Management Studio Express has no problem connecting to HELEN€™s SQL Server Express instance. If I change the username and/or password on only one of the machines, the connection fails. Also, if I keep the usernames the same on both machines but I delete the passwords, the connection fails again.
I realize I can set up a user account on HELEN. Do I then have to set up the same user account (with the same non-blank password) on Delores? So far, this is the method that€™s been successful. Is it possible for me to tell SQL Server Management Studio Express to use a particular account (username/password) when connecting to HELEN via Named Pipes? If so, how is that specified?
I admit to my confusion. Any help would be greatly appreciated.
Robin
View 1 Replies
View Related
Feb 17, 2008
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?
SQL 2000 1.0, SQL 2002, SQL 2003........?
View 10 Replies
View Related
Mar 17, 2007
Hi everyone,
I€™m quite new to SQL Server so maybe this is an easy question but I haven€™t found the answer after 3+ hours of Googling and experimenting.
I have a simple set up €“ two computers named HELEN and DELORES, both running Win XP Pro, SP2. These machines are connected via a home network and both belong to the same Workgroup. There€™s no Domain involved. HELEN is running SQL Server Express while DELORES is the €śclient€?, running SQL Server Management Studio Express. I am using €śWindows Authentication€? and Named Pipes to allow DELORES to work with the SQL Server Express instance on HELEN.
I have a general understanding of €śWindows Authentication€? and I was hoping someone could fill in the gaps. I realize €śWindows Authentication€? uses the underlying Windows User Accounts on the server to validate incoming connections.
I€™m sometimes having a problem in connecting SQL Server Management Studio Express (running on DELORES) to the SQL Server Express instance (running on HELEN). This problem may be due to a lack of understanding of Windows User Accounts.
I€™ve found that if I use the exact *same* username *and* passwords on both machines, SQL Server Management Studio Express has no problem connecting to HELEN€™s SQL Server Express instance. If I change the username and/or password on only one of the machines, however, the connection fails. Also, if I keep the usernames the same on both machines but I delete the passwords, the connection fails again.
I realize I can set up a user account on HELEN. Do I then have to set up the same user account (with the same non-blank password) on Delores? So far, this is the method that€™s been successful. Is it possible for me to tell SQL Server Management Studio Express to use a particular account (username/password) when connecting to HELEN via Named Pipes? If so, how is that specified?
I admit to my confusion. Any help would be greatly appreciated.
Robin
View 6 Replies
View Related
Jul 20, 2005
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
View 1 Replies
View Related
Dec 26, 2007
hi,
Can we install SQL Server 2005 on MS Windows Vista Home Edition???
Please guide..
Thanks
View 4 Replies
View Related
Mar 8, 2006
Hi,
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
Any suggesstions will be geatly appreciated.
View 4 Replies
View Related
Jun 27, 2006
Hi all,
I have to deal with a private network of laptops which are all equiped with preinstalled "Windows XP home"
I've installed SQLExpress on one of these, but I cannot connect on it from the rest of the laptops. (I've successfuly done this with "Windows XP profesional" though, and local connections work fine as well).
I've already setup the SQLExpress to accept conections throuigh TCP/IP but I can not think of something else. (Security comes to mind, but I do not know how to resolve it on "Windows XP Home").
Thank you
Ioannis
View 6 Replies
View Related
Dec 4, 2007
I wanted to install SQL Server 2005 Express Edition, instead of installing .Net Framework 2.0, I installed .Net Framework 3.5. When I tried to install SQL Server 2005 Express Edition I received the following error:
SQL_ERROR (-1) in OdbcStatement::execute_batch
sqlstate=42000, level=16, state=2, native_error=7404, msg=[Microsoft][SQL Native Client][SQL Server]The server could not load DCOM.
Error Code: 0x80071cec (7404)
Windows Error Text: Source File Name: libodbc_statement.h
Compiler Timestamp: Wed Jun 14 16:28:15 2006
Function Name: OdbcStatement::execute_batch@sysdbupg.sql@56
Source Line Number: 91
I then decided maybe I do need .net framework 2.0, but when I try to install it it says it's already included with the OS.
But the "Programs and Featuers" only list .Net Framework 1.1 and .Net Framework 1,1 Hotfix (KB92979).
I uninstalled .Net Framework 3.5 and tried to install .Net Framework 2.0 again, but it still says it's included in the OS.
After uninstalling .Net Framework 3.5, I tried to install SQL Server 2005 Express Edition, but still received the above error message.
Is .Net Framework 2.0 included with Windows Vista Home Edition?
If it is, any ideas in solving the Server 2005 Express Edition installation error?
Thanks in advance for your help!
View 2 Replies
View Related
Nov 19, 2007
Hi Experts,
Can anyone help me to identify the problem? The situation of my problem is : My company network in clients side is running either Window XP Pro or Window Xp Home.The problem occur when i access from Window XP Home to Server (Window Server 2003) an error pop up Sql Express Error 18452. It is worked fine in WIndow XP Pro version.
Thanks for anyone provide me a solution.
View 15 Replies
View Related
Feb 19, 2008
Hi, I'm having a problem installing SQL2005 Developer on Windows Vista.
At the System Configuration check page, I'm getting the IIS Feature Requirement item telling me IIS is not installed or disabled. This is not the case.
I have read article http://support.microsoft.com/kb/920201 and switched on the IIS components as specified.
I've tried installing with Firewall, virus checker etc switched off. Every time I get the same problem. This is an issue, as I specifically need Reporting Services installed.
Has anyone managed to solve this problem ?
View 6 Replies
View Related
Mar 8, 2007
Hi Every One,
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.
View 18 Replies
View Related
Jul 20, 2005
We are running SQL 7 on a Windows NT Server. If you copy a 25Mb filefrom this machine to a W2K server, the file copy takes over 5 minuteson a 100Mpbs switched network.Copying the same file to another NT server takes only seconds, andcopying the same file to the W2K server from the 2nd NT server, (whichis not running SQL) takes only seconds also.Has anyone any ideas as to why file copying between this machine and aW2K one will take so long. It is repliacted on 5 further w2K machines.
View 1 Replies
View Related
Dec 21, 2007
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?
Thanks
gifty
View 3 Replies
View Related
Dec 5, 1998
How can I copy a SQL 7 database from one server to another? Please tell me all the ways because I've tried the obvious and it doesn't work. (backup and restore - won't go from one server to another, DTS transfer object Wizard - does a whole pile of errors and doesn't do stored proceedures and trigures). Thanks for help in advance. Also, what is the email address to post to the listserv and where is the FAQ for SQL7? Most of my listserv's tell you where to post right at the bottom of the digest I get - any chance you guys would do that with this list? Thanks again.
View 6 Replies
View Related
Dec 12, 2007
Is it Possible adding Windows (activi directry users) from SQL Server which is running Windows authotication.?
View 4 Replies
View Related
Jun 23, 2006
I am attempting to write a Windows service that watches a database for uploaded files to import. When a new file is found, the corresponding SSIS package is run from the file system with variables passed through. I started development as a Windows app and copied the functionality to a service.
The app runs fine. The service does not. I get a "Failure" each time a package is executed. Everything is identical behind the scenes with the obvious exceptions that OnStart and OnStop handlers are buttons in the app. I added a script task at the beginning of one of the SSIS packages to notify me that it is even running at all. It doesn't even hit that initial task.
Again, the app will run all packages just fine. The data is imported and the results return as "Success."
The following is the code executing the package. Any help is appreciated. I've been banging my head on this one for a few days now. (Is there a tag to format a code sample?)
Dim pkgLocation As String
Dim pkg As New Package
Dim app As New Application
Dim pkgResults As DTSExecResult
pkgLocation = sPackageFolder & PackageName & ".dtsx"
pkg = app.LoadPackage(pkgLocation, Nothing)
Dim vars As Variables = pkg.Variables
vars("ImportId").Value = ImportId
vars("ProductionServer").Value = ProductionServer
vars("ProductionDatabase").Value = ProductionDatabase
vars("SourceFileName").Value = FileName
vars("SourceFilePath").Value = FilePath
pkgResults = pkg.Execute()
View 3 Replies
View Related
Apr 14, 2008
Long story short -
Have two C# applications - one WinForms desktop app, the other a WinForms smart device app. Both use SQL Server Compact CE 3.5 to store data locally. Both work just fine.
Now the desktop app needs to open and update the .SDF file that is stored on the Windows Mobile device. (Device will be docked via USB.)
What format would the path to the .SDF look like that the WinForms application would need to specify in order to open it?
Thanks for reading.
View 3 Replies
View Related
Mar 26, 2008
Hallo there,
I just upgraded from Windows XP Pro to Windows Vista Bussiness and tried to reinstall SQL Server 2005 Developers Edition. After the installation i downloaded (using microsoft windows update) and installed all the service packs for sql and vista available.
My problem is when i open sql server management studio and try to connect to my default instance using windows authentication and database engine, an 18456 error occurs.
I enabled all the protocols and all the ports
I disabled windows firewall and antivirus (eset nod32)
I installed all service packs available
I have also installed Visual Studio 2005 without installing sqlexpress
But nothing happens!
Please i am very desperate, any information will be gratefully accepted.
This is my installation Information
Code Snippet
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 7.0.6001.18000
Microsoft .NET Framework 2.0.50727.1434
Operating System 6.0.6001
Thank you in advance,
Patonios
View 3 Replies
View Related
Mar 19, 2007
Hi there,
I'm new here and fairly new to .NET and C# too.
I've received a couple of complains about a website I've been working on the
past year or so: http://www.ipcamerademos.com/
I can open and browse the website fine, in both MS Internet Explorer and
Firefox. But some people are getting some error opening up the website (home
page):
Server
Error in '/' Application.
View 5 Replies
View Related
Dec 1, 2005
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.
View 3 Replies
View Related
Oct 5, 2005
Hi All,
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.
Thanks,
Tim
View 2 Replies
View Related
Mar 10, 2007
Hi all:
How to install a sql server 2005 in a computer with windows Xp Home Edition?
Thanks
View 3 Replies
View Related
Dec 12, 2007
I got google on the other tab but I am home with my Norton firewall and SQL Server 2005 and sqlwb.exe just tried to make an internet connection. wtf?
View 4 Replies
View Related
Feb 9, 2007
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
View 2 Replies
View Related
Jul 20, 2005
Hello there!I am trying to install MS SQL 2000 Server on Windows XP Home edition.I found in Microsoft that the above installation is possible.But when i run the installation, i am getting a black screen that iscloses after a second. Nothing else happens.Any ideas how to troubleshoot this?Thank you
View 4 Replies
View Related
Dec 3, 2007
Whe installation have to start service sql : impossible to start service (WIN XP HOME)
View 4 Replies
View Related
Apr 18, 2007
Using System Role Assignment I grant a domain user account "System Administrator" & "System User" within Reporting Services.
Then I connect via IE7 to Report Server with the domain account that has been granted the above rights. The page comes up but the "Contents" and "Properties" tabs are missing. This user can use "Site Settings" and perform admin though.
If I assign the users domain account to the local Administrator group on the Win 2003 Server, then when they reconnect to Reporting Services the missing tabs appear.
We are a development shop, need some of our qa testers and developers to have admin rights within Reporting Services but don't want to grant them local Administrator rights on the server. This could also be an issue upon deployment at customer sites.
So how to get round this. I have been trying ACL's on the Reporting Services directorys, ASP.Net security etc but with no success.
PS: Everything was sweet before SP2
View 1 Replies
View Related
Oct 5, 2006
Hi,
I have SQL Server 2005 Express and XP Home sp/2. There's just me, the one computer, (i.e. one user and no nowork), but I am connected to broadband Internet. I have the SQL Server installed with its defaults, so it and its various parts are all Network Services (except VSS which is a Local System service). I've read, and read, but still do not really understand it all. Can someone please just tell me: is this the safest set of services I could use?
I also use Aqua freeware to import my data to the SQL Server, and Aqua requires connection via the TCP/IP port and for the Browser to be on. How vulnerable am I doing this?
Thanks in advance,
jessj
View 3 Replies
View Related
Mar 24, 2008
Hi there,
Could you please fill me in on some possible reasons and solutions as to why the report server home page appears blank?
Thanks!
View 5 Replies
View Related
Feb 29, 2008
Hi,
I have an sql express server which contains a single database. Three users access this database using a C# application I have writen. I use Integrated Security for these three users.
The problem is that one of my users wishes to use my application from home.
What are my options in letting this user use my application from home?
Thanks for your help,
Barry.
View 1 Replies
View Related
Sep 20, 2007
Hi,
We're creating an installer package for SQL Express 2005 and I'm using the built-in setup project in VS 2005 to create my MSI.
Everything appears to be working well, excpet that on Windows XP Home the SQL Express package is exiting with an error code 70002. I've googled for several days now and simply can't find any help on the 70002 exit code. Can anyone help ?
The command line arguments (I've split them onto seperate lines for clarity) we're passing to "sqlexpr32.exe" are : -
/qn
INSTANCENAME=OurInstance
SAPWD="OurPassword"
ADDLOCAL=SQL_Engine,SQL_Data_Files,Client_Components,Connectivity
SQLBROWSERAUTOSTART=1
SQLACCOUNT="NT AUTHORITYSYSTEM"
SQLBROWSERACCOUNT="NT AUTHORITYSYSTEM"
AGTACCOUNT="NT AUTHORITYSYSTEM"
ASACCOUNT="NT AUTHORITYSYSTEM"
RSACCOUNT="NT AUTHORITYSYSTEM"
SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0
SQLAUTOSTART=1
View 3 Replies
View Related
