-
Nov 15th, 2012, 08:37 AM
#1
Thread Starter
Frenzied Member
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
#2
Addicted Member
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
#3
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
#4
Thread Starter
Frenzied Member
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.
-
Nov 15th, 2012, 05:04 PM
#5
Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor
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.
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
#6
Addicted Member
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
#7
Thread Starter
Frenzied Member
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
#8
Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor
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
#9
Thread Starter
Frenzied Member
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
#10
Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor
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
#11
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
#12
Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor
You have to create the database first.... THEN import into it...
-tg
-
Dec 3rd, 2012, 03:19 PM
#13
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:36 PM
#14
Thread Starter
Frenzied Member
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 .
-
Dec 3rd, 2012, 04:12 PM
#15
Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor
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:
-
Oct 4th, 2013, 02:54 PM
#16
Thread Starter
Frenzied Member
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 .
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|