Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
therain
Starting Member
2 Posts |
 Posted - 2002-11-30 : 08:40:08
|
| i have a win xp proffesional edition earlier when i installed sql server 7.0 .i was able to install the server components (ie the standard edition for server) ...also i was able to set the username and password for teh sql server during installation ...also i could see the sql server agent running .but recently there was a problem with the sql server connection....when i opened the sql server enterprise manager ,i found some of my databases (ie other than the built in databases) as suspected ...so i uninstalled the sql server ....again i installed ..but this time i got a message sayin that the server(standard) edition cant be set up on this workstation (strange how my server got converted into a workstation....) ..so i had the only option to install the desktop (client) edition .....now i didnt have the option to set the user name and password ....anyways the installation was done ...but i could not see the sql server agent running .now when i opened the sql server enterprise manager , i wasnt abel to connect .,..i get a message sayin "connection failed...either sql server not found or not connected " i m very confused ...kindly help ..i have also scanned the entire hard disk by norton antivirus with the latest updated definitions ..but it reported no viruses ...how did i my server version of winxp got converted into workstation ...? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-11-30 : 09:00:28
|
| There is no "server" version of Windows XP; your computer did not get "converted" to anything. The installation may have mis-identified the operating system as a server (perhaps Windows 2000 Server) The discrepency could be why the databases were suspect. After the reinstall it now properly recognizes the operating system as WinXP and only allows you to install the version(s) that run on XP, as described in this document:http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.aspYou may need to uninstall the SQL Server software again and reinstall it. Afterwards, you may also need to update the MDAC components (WinXP needs MDAC 2.7 or higher, SQL Server may install a lower version) You can get the latests MDAC components here:http://www.microsoft.com/data/download.htmI'm not familiar with XP enough to know where the Services control panel is, but you can always start SQL Server and SQL Agent using the Service Manager that is installed along with SQL Server (under the Start Menu group for SQL Server) |
 |
|
|
therain
Starting Member
2 Posts |
Posted - 2002-12-02 : 02:59:28
|
| i have again uninstalled and installed ..i also have mdac 2.5 installed ....still no success i still m not able to connect to the sql server 7.0....and regarding 2.7 mdac .. the follo info was on the miscrosoft page 2.7 RTM Refresh Release Microsoft Data Access Components 2.7 RTM Refresh (2.70.9001.0) Now Available This Web release is the Refresh release of Microsoft Data Access Components (MDAC) 2.7 RTM. This download installs the same version of the MDAC components that are installed Windows XP. Due to issues with clustering, this release is currently NOT supported on SQL Server 7.0 Clustered Servers or SQL 6.5 Clustered Servers. MDAC 2.7 RTM Refresh does not include Microsoft Jet, the Microsoft Jet OLE DB Provider, the Desktop Database Drivers ODBC Driver, or the Visual FoxPro ODBC driver. See Knowledge Base article Q271908 for more information. so i think if i install 2.7 it wont be of any use ..as i have sql server 7.0 and if MDAC 2.7 RTM Refresh does not include Microsoft Jet, the Microsoft Jet OLE DB Provider, the Desktop Database Drivers ODBC Driver, or the Visual FoxPro ODBC driver.. then this mdac will hinder my applications which require microsoft jet oledb ,etc...kindly help ... |
|
|
|
|
|
|
|
|
sql server not found