installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor-VBForums
Results 1 to 22 of 22

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

  1. #1

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

    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
    226

    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
    3,811

    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)

  4. #4

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

    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 03:27 PM.

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

    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

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

    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,771

    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
    3,811

    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

  9. #9

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

    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
    3,811

    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?

  11. #11
    King of sapila
    Join Date
    Oct 2006
    Location
    Greece
    Posts
    3,791

    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.
    Slow as hell.

  12. #12
    PowerPoster
    Join Date
    May 2002
    Posts
    24,106

    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
    PowerPoster JuggaloBrotha's Avatar
    Join Date
    Sep 2005
    Location
    Lansing, MI; USA
    Posts
    3,811

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

    Quote Originally Posted by sapator View Post
    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.

  14. #14

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

    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

  15. #15

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

    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
    Last edited by firoz.raj; Dec 3rd, 2012 at 01:24 PM.

  16. #16
    Addicted Member
    Join Date
    Oct 2008
    Location
    Califorina
    Posts
    226

    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

  17. #17

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

    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
    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

  18. #18
    PowerPoster
    Join Date
    May 2002
    Posts
    24,106

    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??? *

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

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

    Quote Originally Posted by firoz.raj View Post
    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.

  20. #20

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

    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 .

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

    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:

  22. #22

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

    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: 14
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
  •  



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.