-
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
-
Nov 25th, 2012, 11:31 PM
#13
Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor
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
#14
Thread Starter
Frenzied Member
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
#15
Thread Starter
Frenzied Member
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 02:24 PM.
-
Dec 3rd, 2012, 02:30 PM
#16
Addicted Member
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
#17
Thread Starter
Frenzied Member
Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor
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
#18
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
#19
Re: installing sqlserver 2000 On Windows 7 pc with 64 bit Microprocessor
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
#20
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
#21
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
#22
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
|