installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor

Printable View

Nov 15th, 2012, 08:37 AM
firoz.raj

installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor

hi,Friends i have been trying to install sqlserver 2000 .at windows 7 with Configuration of Computer .intel core i3 pc 64 bit . but it says the version of this file is not comatible with the version of windows you are running. check your computer's system information to see whether you need and x86(32-bit) or x64(64-bit) version of the program,and then contact the software publisher.

Attachment 93269
Nov 15th, 2012, 01:44 PM
smendoza

Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor

It's not supported on win7, and it looks like its hit or miss if it will install. Why install 2000? why not 2005 or higher?

http://support.microsoft.com/kb/2028963
Nov 15th, 2012, 03:19 PM
JuggaloBrotha

Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor

Sql Server 2000 is more than 12 years old now & considering you're running Windows 7 you should seriously consider running Sql Server 2008 (or 2012) even if it's the Express edition (which is free)
Nov 15th, 2012, 04:23 PM
firoz.raj

Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor

Quote:

It's not supported on win7, and it looks like its hit or miss if it will install. Why install 2000? why not 2005 or higher?

Even i tried to install sql server management studio 2005 . on 64 bit machine .i am getting the following Error message.
let me know please . any help would be highly appreciated. Attachment 93287
Nov 15th, 2012, 05:04 PM
JuggaloBrotha

Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor

Quote:

Originally Posted by firoz.raj

Even i tried to install sql server management studio 2005 . on 64 bit machine .i am getting the following Error message.
let me know please . any help would be highly appreciated. Attachment 93287

Management Studio 2005 runs on Win7 x64 machines (I have it installed on both of mine). You have to use the command prompt to run the installer in a x64 admin mode for it to work, which is a pain I know.

Quote:

Originally Posted by MSDN Social

For Windows 7 64 bit you have to use the 64 bit CMD prompt (I didn't even know there was a separate version) and then run this as administrator. So I did the following…
1. Right click on desktop and click NEW – SHORTCUT
2. Create shortcut to C:\Windows\SysWOW64\cmd.exe
3. Right click on the new shortcut and Run AS ADMINISTRATOR
4. Enter full path and file name:
e.g. C:\Users\[YOUR NAME]\Downloads\SQLServer2005_SSMSEE_x64.msi
Where [YOUR NAME] is the windows user you are using.

Error installing SQL Server Management Studio Express on Windows Vista RC1
Nov 15th, 2012, 05:09 PM
smendoza

Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor

I would look through the Installer logs, they will give you more info on what failed. Another thing you can do if you don't feel like looking through the logs is to do a clean install. When I worked as tech support our software used ms sql 2000 and 2005. When trying to upgrade or install 2005 after 2000 was installed sometimes it required a clean install. Meaning cleaning all the reg keys out etc.

the error logs are in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\ since you tried to install 2005 I think it will be \80\ or \90\ instead of 100
Nov 23rd, 2012, 02:54 PM
firoz.raj

Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor

Hi Friends, i have installed Sql server management studio express 2005 . but when i w.c on database to export the ms access
database in my sqlserver . i did not get any option like import/Export .any idea . let me know please .

Attachment 93531
Nov 23rd, 2012, 03:25 PM
JuggaloBrotha

Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor

Quote:

Originally Posted by firoz.raj

Hi Friends, i have installed Sql server management studio express 2005 . but when i w.c on database to export the ms access
database in my sqlserver . i did not get any option like import/Export .any idea . let me know please .

I've been using Mgmt Studio for quite a few years and I do not know of a way to do an import of data from an Access database, but I do know in the access databases you can make a vba script that will create a "Create Table" sql statement that you can paste into a new query window in Mgmt Studio, then you can create linked tables in the Access database to the sql server tables and do a bunch of "Insert Into <sql server table> Select * From <Access table>" and that will "copy" all of the records from access into Sql Server.

For the vba script to make the create table statements check this out: Automatically Generate SQL from existing MS Access table - Stack Overflow
Nov 23rd, 2012, 03:32 PM
firoz.raj

Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor

following way seeems to be tedious way . any other GUI Way to import *.mdb database in sql server express 2005

Code:

Dim db As Database Dim tdf As TableDef Dim fld As DAO.Field Dim ndx As DAO.Index Dim strSQL As String Dim strFlds As String Dim strCn As String Dim fs, f Set db = CurrentDb Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.CreateTextFile("C:\Docs\Schema.txt") For Each tdf In db.TableDefs If Left(tdf.Name, 4) <> "Msys" Then strSQL = "strSQL=""CREATE TABLE [" & tdf.Name & "] (" strFlds = "" For Each fld In tdf.Fields strFlds = strFlds & ",[" & fld.Name & "] " Select Case fld.Type Case dbText 'No look-up fields strFlds = strFlds & "Text (" & fld.Size & ")" Case dbLong If (fld.Attributes And dbAutoIncrField) = 0& Then strFlds = strFlds & "Long" Else strFlds = strFlds & "Counter" End If Case dbBoolean strFlds = strFlds & "YesNo" Case dbByte strFlds = strFlds & "Byte" Case dbInteger strFlds = strFlds & "Integer" Case dbCurrency strFlds = strFlds & "Currency" Case dbSingle strFlds = strFlds & "Single" Case dbDouble strFlds = strFlds & "Double" Case dbDate strFlds = strFlds & "DateTime" Case dbBinary strFlds = strFlds & "Binary" Case dbLongBinary strFlds = strFlds & "OLE Object" Case dbMemo If (fld.Attributes And dbHyperlinkField) = 0& Then strFlds = strFlds & "Memo" Else strFlds = strFlds & "Hyperlink" End If Case dbGUID strFlds = strFlds & "GUID" End Select Next strSQL = strSQL & Mid(strFlds, 2) & " )""" & vbCrLf & "Currentdb.Execute strSQL" f.WriteLine vbCrLf & strSQL 'Indexes For Each ndx In tdf.Indexes If ndx.Unique Then strSQL = "strSQL=""CREATE UNIQUE INDEX " Else strSQL = "strSQL=""CREATE INDEX " End If strSQL = strSQL & "[" & ndx.Name & "] ON [" & tdf.Name & "] (" strFlds = "" For Each fld In tdf.Fields strFlds = ",[" & fld.Name & "]" Next strSQL = strSQL & Mid(strFlds, 2) & ") " strCn = "" If ndx.Primary Then strCn = " PRIMARY" End If If ndx.Required Then strCn = strCn & " DISALLOW NULL" End If If ndx.IgnoreNulls Then strCn = strCn & " IGNORE NULL" End If If Trim(strCn) <> vbNullString Then strSQL = strSQL & " WITH" & strCn & " " End If f.WriteLine vbCrLf & strSQL & """" & vbCrLf & "Currentdb.Execute strSQL" Next End If Next f.Close
Nov 23rd, 2012, 07:34 PM
JuggaloBrotha

Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor

Quote:

Originally Posted by firoz.raj

following way seeems to be tedious way . any other GUI Way to import *.mdb database in sql server express 2005

Code:

Dim db As Database Dim tdf As TableDef Dim fld As DAO.Field Dim ndx As DAO.Index Dim strSQL As String Dim strFlds As String Dim strCn As String Dim fs, f Set db = CurrentDb Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.CreateTextFile("C:\Docs\Schema.txt") For Each tdf In db.TableDefs If Left(tdf.Name, 4) <> "Msys" Then strSQL = "strSQL=""CREATE TABLE [" & tdf.Name & "] (" strFlds = "" For Each fld In tdf.Fields strFlds = strFlds & ",[" & fld.Name & "] " Select Case fld.Type Case dbText 'No look-up fields strFlds = strFlds & "Text (" & fld.Size & ")" Case dbLong If (fld.Attributes And dbAutoIncrField) = 0& Then strFlds = strFlds & "Long" Else strFlds = strFlds & "Counter" End If Case dbBoolean strFlds = strFlds & "YesNo" Case dbByte strFlds = strFlds & "Byte" Case dbInteger strFlds = strFlds & "Integer" Case dbCurrency strFlds = strFlds & "Currency" Case dbSingle strFlds = strFlds & "Single" Case dbDouble strFlds = strFlds & "Double" Case dbDate strFlds = strFlds & "DateTime" Case dbBinary strFlds = strFlds & "Binary" Case dbLongBinary strFlds = strFlds & "OLE Object" Case dbMemo If (fld.Attributes And dbHyperlinkField) = 0& Then strFlds = strFlds & "Memo" Else strFlds = strFlds & "Hyperlink" End If Case dbGUID strFlds = strFlds & "GUID" End Select Next strSQL = strSQL & Mid(strFlds, 2) & " )""" & vbCrLf & "Currentdb.Execute strSQL" f.WriteLine vbCrLf & strSQL 'Indexes For Each ndx In tdf.Indexes If ndx.Unique Then strSQL = "strSQL=""CREATE UNIQUE INDEX " Else strSQL = "strSQL=""CREATE INDEX " End If strSQL = strSQL & "[" & ndx.Name & "] ON [" & tdf.Name & "] (" strFlds = "" For Each fld In tdf.Fields strFlds = ",[" & fld.Name & "]" Next strSQL = strSQL & Mid(strFlds, 2) & ") " strCn = "" If ndx.Primary Then strCn = " PRIMARY" End If If ndx.Required Then strCn = strCn & " DISALLOW NULL" End If If ndx.IgnoreNulls Then strCn = strCn & " IGNORE NULL" End If If Trim(strCn) <> vbNullString Then strSQL = strSQL & " WITH" & strCn & " " End If f.WriteLine vbCrLf & strSQL & """" & vbCrLf & "Currentdb.Execute strSQL" Next End If Next f.Close

In the Express & Standard editions of Mgmt Studio 2005 I don't know of any better way of doing this. Maybe the Pro edition has it?
Nov 24th, 2012, 07:15 PM
sapator

Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor

I've just checked my sql 2005 version (9.0.4053) it has import, export wizard and there is a prompt for access databases.So it's probably the express edition problem.
Nov 24th, 2012, 07:24 PM
techgnome

Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor

You have to create the database first.... THEN import into it...

-tg
Nov 25th, 2012, 11:31 PM
JuggaloBrotha

Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor

Quote:

Originally Posted by sapator

I've just checked my sql 2005 version (9.0.4053) it has import, export wizard and there is a prompt for access databases.So it's probably the express edition problem.

Yes, the Express edition does not have an import feature like that, I logged into my work computer tonight and I did notice that the SSMS Standard does have it.
Nov 26th, 2012, 04:05 AM
firoz.raj

Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor

Where i will run the following code in ms access so that it will create the tables in sqlserver 2005 Express edition .

Code:

Dim db As Database Dim tdf As TableDef Dim fld As DAO.Field Dim ndx As DAO.Index Dim strSQL As String Dim strFlds As String Dim strCn As String Dim fs, f Set db = CurrentDb Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.CreateTextFile("C:\Docs\Schema.txt") For Each tdf In db.TableDefs If Left(tdf.Name, 4) <> "Msys" Then strSQL = "strSQL=""CREATE TABLE [" & tdf.Name & "] (" strFlds = "" For Each fld In tdf.Fields strFlds = strFlds & ",[" & fld.Name & "] " Select Case fld.Type Case dbText 'No look-up fields strFlds = strFlds & "Text (" & fld.Size & ")" Case dbLong If (fld.Attributes And dbAutoIncrField) = 0& Then strFlds = strFlds & "Long" Else strFlds = strFlds & "Counter" End If Case dbBoolean strFlds = strFlds & "YesNo" Case dbByte strFlds = strFlds & "Byte" Case dbInteger strFlds = strFlds & "Integer" Case dbCurrency strFlds = strFlds & "Currency" Case dbSingle strFlds = strFlds & "Single" Case dbDouble strFlds = strFlds & "Double" Case dbDate strFlds = strFlds & "DateTime" Case dbBinary strFlds = strFlds & "Binary" Case dbLongBinary strFlds = strFlds & "OLE Object" Case dbMemo If (fld.Attributes And dbHyperlinkField) = 0& Then strFlds = strFlds & "Memo" Else strFlds = strFlds & "Hyperlink" End If Case dbGUID strFlds = strFlds & "GUID" End Select Next strSQL = strSQL & Mid(strFlds, 2) & " )""" & vbCrLf & "Currentdb.Execute strSQL" f.WriteLine vbCrLf & strSQL 'Indexes For Each ndx In tdf.Indexes If ndx.Unique Then strSQL = "strSQL=""CREATE UNIQUE INDEX " Else strSQL = "strSQL=""CREATE INDEX " End If strSQL = strSQL & "[" & ndx.Name & "] ON [" & tdf.Name & "] (" strFlds = "" For Each fld In tdf.Fields strFlds = ",[" & fld.Name & "]" Next strSQL = strSQL & Mid(strFlds, 2) & ") " strCn = "" If ndx.Primary Then strCn = " PRIMARY" End If If ndx.Required Then strCn = strCn & " DISALLOW NULL" End If If ndx.IgnoreNulls Then strCn = strCn & " IGNORE NULL" End If If Trim(strCn) <> vbNullString Then strSQL = strSQL & " WITH" & strCn & " " End If f.WriteLine vbCrLf & strSQL & """" & vbCrLf & "Currentdb.Execute strSQL" Next End If Next f.Close
Dec 3rd, 2012, 02:15 PM
firoz.raj

Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor

Hi Friends, i want to make the list of store servers like the following way . as i have been using sql server 2005 Now. in sql server 2000 sql server enterprise manager was available . but in sql server 2005 enterprise manager is not available. but as much as i heard ssis is a replacement of sql server enterprise manager . so is this way we can configure the sql servers list like the following . if so then how ? let me know please . any help would be highly appreciated .
Attachment 93859
Dec 3rd, 2012, 02:30 PM
smendoza

Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor

Are you looking for an IDE for mssql 2005? If that's the case use SQL Server Management Studio http://www.microsoft.com/en-us/downl...s.aspx?id=8961
Dec 3rd, 2012, 02:55 PM
firoz.raj

Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor

Quote:

Are you looking for an IDE for mssql 2005? If that's the case use SQL Server Management Studio http://www.microsoft.com/en-us/downl...s.aspx?id=8961

i have already installed sql server management studio . but i did not see that i want .as i read somewhere ssis is a replacement for sql server enterprise manager .where i can configure servers and all those things which can be done Attachment 93865through sql server enterprise manager. so sql server management studio and ssis is same things .

Attachment 93865
Dec 3rd, 2012, 03:19 PM
techgnome

Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor

SSIS and SSMS are not the same thing... SSMS is more closely related to the old SQL Server Enterprise Manager tool... SSIS has actually been split off and it developed/maintained through different editi0ons of Visual Studio. You can invoke SSIS packages through SSMS, but that's just as a simple front end activation...

-tg
Dec 3rd, 2012, 03:34 PM
JuggaloBrotha

Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor

Quote:

Originally Posted by firoz.raj

Hi Friends, i want to make the list of store servers like the following way . as i have been using sql server 2005 Now. in sql server 2000 sql server enterprise manager was available . but in sql server 2005 enterprise manager is not available. but as much as i heard ssis is a replacement of sql server enterprise manager . so is this way we can configure the sql servers list like the following . if so then how ? let me know please . any help would be highly appreciated .

Sql Server Management Studio (SSMS) replaces both Enterprise Manager & Query Analyzer.
Sql Server Integrated Services (SSIS) is the replacement for DTS packages.

They are completely different things.
Dec 3rd, 2012, 03:36 PM
firoz.raj

Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor

Quote:

You can invoke SSIS packages through SSMS, but that's just as a simple front end activation...

How should i activate SSIS Through ssms ? . let me know please .
Dec 3rd, 2012, 04:12 PM
JuggaloBrotha

Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor

Quote:

Originally Posted by firoz.raj

How should i activate SSIS Through ssms ? . let me know please .

You create a job on the server and create a step to execute the SSIS package. Check out the screenshots half way down this page:sql server - How to schedule SSIS package to run as something other than SQL Agent Service Account - Stack Overflow

Particularly this one:
http://i.stack.imgur.com/6TP6t.png
Oct 4th, 2013, 02:54 PM
firoz.raj

1 Attachment(s)

Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor

Hi,Friends

i have already FrameWork 3.5 has Installed at My 64 Bit Laptop. But when i Run the SQL Server 2008 setup .
Microsoft .Net Framework 3.5 SP1 Installation Has Failed .Inside the Microsoft.Net\Frameword Folder it shows V3.5 .
Sql Server 2008 requires .net Framework 3.5 SP1 to be Installed .Attachment 105505