Results 1 to 22 of 22

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

Hybrid View

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Jan 2009
    Location
    Watch Window(Shift+f9)
    Posts
    1,879

    Question 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

  2. #2
    Addicted Member
    Join Date
    Oct 2008
    Location
    Califorina
    Posts
    235

    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

  3. #3
    PowerPoster JuggaloBrotha's Avatar
    Join Date
    Sep 2005
    Location
    Lansing, MI; USA
    Posts
    4,286

    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)
    Currently using VS 2015 Enterprise on Win10 Enterprise x64.

    CodeBank: All ThreadsColors ComboBoxFading & Gradient FormMoveItemListBox/MoveItemListViewMultilineListBoxMenuButtonToolStripCheckBoxStart with Windows

  4. #4

    Thread Starter
    Frenzied Member
    Join Date
    Jan 2009
    Location
    Watch Window(Shift+f9)
    Posts
    1,879

    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?
    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
    Last edited by firoz.raj; Nov 15th, 2012 at 04:27 PM.

  5. #5
    PowerPoster JuggaloBrotha's Avatar
    Join Date
    Sep 2005
    Location
    Lansing, MI; USA
    Posts
    4,286

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

    Quote Originally Posted by firoz.raj View Post
    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
    Currently using VS 2015 Enterprise on Win10 Enterprise x64.

    CodeBank: All ThreadsColors ComboBoxFading & Gradient FormMoveItemListBox/MoveItemListViewMultilineListBoxMenuButtonToolStripCheckBoxStart with Windows

  6. #6
    Addicted Member
    Join Date
    Oct 2008
    Location
    Califorina
    Posts
    235

    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

  7. #7

    Thread Starter
    Frenzied Member
    Join Date
    Jan 2009
    Location
    Watch Window(Shift+f9)
    Posts
    1,879

    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

  8. #8
    PowerPoster JuggaloBrotha's Avatar
    Join Date
    Sep 2005
    Location
    Lansing, MI; USA
    Posts
    4,286

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

    Quote Originally Posted by firoz.raj View Post
    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
    Currently using VS 2015 Enterprise on Win10 Enterprise x64.

    CodeBank: All ThreadsColors ComboBoxFading & Gradient FormMoveItemListBox/MoveItemListViewMultilineListBoxMenuButtonToolStripCheckBoxStart with Windows

  9. #9

    Thread Starter
    Frenzied Member
    Join Date
    Jan 2009
    Location
    Watch Window(Shift+f9)
    Posts
    1,879

    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

  10. #10
    PowerPoster JuggaloBrotha's Avatar
    Join Date
    Sep 2005
    Location
    Lansing, MI; USA
    Posts
    4,286

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

    Quote Originally Posted by firoz.raj View Post
    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?
    Currently using VS 2015 Enterprise on Win10 Enterprise x64.

    CodeBank: All ThreadsColors ComboBoxFading & Gradient FormMoveItemListBox/MoveItemListViewMultilineListBoxMenuButtonToolStripCheckBoxStart with Windows

  11. #11
    King of sapila
    Join Date
    Oct 2006
    Location
    Greece
    Posts
    6,597

    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.
    ἄνδρα μοι ἔννεπε, μοῦσα, πολύτροπον, ὃς μάλα πολλὰ
    πλάγχθη, ἐπεὶ Τροίης ἱερὸν πτολίεθρον ἔπερσεν·

  12. #12
    Smooth Moperator techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,531

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

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

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  13. #13
    Smooth Moperator techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,531

    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
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  14. #14

    Thread Starter
    Frenzied Member
    Join Date
    Jan 2009
    Location
    Watch Window(Shift+f9)
    Posts
    1,879

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

    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 .

  15. #15
    PowerPoster JuggaloBrotha's Avatar
    Join Date
    Sep 2005
    Location
    Lansing, MI; USA
    Posts
    4,286

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

    Quote Originally Posted by firoz.raj View Post
    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:
    Currently using VS 2015 Enterprise on Win10 Enterprise x64.

    CodeBank: All ThreadsColors ComboBoxFading & Gradient FormMoveItemListBox/MoveItemListViewMultilineListBoxMenuButtonToolStripCheckBoxStart with Windows

  16. #16

    Thread Starter
    Frenzied Member
    Join Date
    Jan 2009
    Location
    Watch Window(Shift+f9)
    Posts
    1,879

    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 .Name:  SqlServer2008_Ins_Issue.jpg
Views: 244
Size:  50.2 KB
    Last edited by firoz.raj; Oct 4th, 2013 at 02:59 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width