Sql Server 2000 IA64 Bit Prolblem
Dec 21, 2006
Dear all
I am running Itanium server 64Bit on cluster Mode with Sql Server 2000 Sp4 64 BIT ia version ported.
the itanimum has a 8gb of ram and 4 Processors.
it has one instance and 3 databases.
users connected about 200 Users.
But the processor load is going about 100% in itanium where in xeon about 30% only on the same databses
The database i copied from Xeon based server and ported on the itaminum server.
In normal Xeon server takes 2 Minutes for indexing . In itanimum it is taking more than 4 Hours for the same table.
Is any one can help with what sort of SP_configure script is advisible and best practices for itanumum server.
Plesae give me some best practices
thanks in advances
regards
Tamilvel
tamilve
IT head
View 2 Replies
ADVERTISEMENT
Mar 21, 2007
Hi, I have the option of buying MS SQL Server 2005 Standard Edition IA64 with 5 CLT part number 228-04025, however will it work on the following spec server;
2.8Ghz P4
1Gb Ram
120Gbide hard drive
running Windows 2003 standard edition
If it helps you can call me on +44 (0) 1285 644091 or simon@310k.co.uk
Thanks
Simon
View 5 Replies
View Related
Jan 4, 2008
Hi,
I want to install SQL server 2005 trial version from Microsoft, How do I know which excecutable to tale from these below?
Self-extracting executables:
X86 Executable
X64 Executable
IA64 Executable
Thanks
View 6 Replies
View Related
Nov 4, 2007
Dear,
I have application create by MsAccess
and connect with Sql Server 2000 in x86
and now we transfer system to
HP rx3600 Intel Itanium
- Install Windows 2003 Server Enterprise (for Itanium)
- Install Sql Server 2005 Standard Edition (IA64)
and now we try to create ODBC connection
from client for testing.
But we can't not done it.
Anybody can tell us
how to create connection to sqlserver 2005 (ia64)
Regards,
Tee+
View 1 Replies
View Related
Jun 27, 2006
My Desktop OS is Windows XP Prof. Edition with SP2.
Which executable(X84 / X64 / IA64 ) is compatible with XP Pro SP2 ?
View 3 Replies
View Related
Aug 15, 2007
I have Two Dell dual Itanium 64 with 16 Gb of Ram each Running a default and a named instance of SQL. The Issue is that I have a bottleneck somewhere and noticed that the memory usage for sqlservr.exe is never over 120000k. I have adjusted till I'm blue in the face to get this memory to expand. My question is does this sound reasonable? Or I should look at other possible bottlenecks?
View 1 Replies
View Related
Sep 5, 2006
I have a 32 bit development/playbox SQL 2005 SSIS that can see and run 32 bit OLE DB drivers from Teradata. Granted I have the same issues as others where a table or a view would work and not a query or a variable query. The alternative is to use Linked Server and OPENQUERY.
But our real development box is a 64 bit IA 64 using 64 bit SQL 2005. Non of the Teradata.com drivers would work/show up in the dropdown box of the Connection Manager since they are 32 bit. One option is to use the 64 bit Teradata ODBC drivers and then use the .Net ODBC connection instead. Linked server doesn't work either because the SQL 2005 is 64 bit and it is looking for 64 bit drivers.
Has anyone have any experience with 64 bit SQL 2005 and Teradata?
Looked at other 3rd party vendors such as ETI but their documentation excludes IA 64 (Itanium).
Planning to try again using the 64 bit ODBC and .Net Adapter but I'm interested to hear if someone (MSFT & NCR) would have a real solution for 64 bit.
Thanks
Anatole
View 4 Replies
View Related
Jan 24, 2008
Ok Here is the story with hopefully all the details.
I had a single node cluster Itanium server running W2k3 IA 64 Ent. SP2 with 2 x sql2000 ent sp4 and 1 sql2005 sp1 instances installed and a clustered file share.
All is well with them.
I attempted to add an additional node to my cluster which started out fine but when I tried to run the sql2000 setup to add this node, there are no warning or errors. Its a silent failure.
I tried many different scenarios but the results are the same. I evicted the node and then tried to run the setup on the evicted node. The setup ran without error. I tried to run setup on my single node cluster and it fails in the same manner. I read and read and from the sqlstp.log this is what I find. Does anyone have a clue what is wrong? i have check all my permissions but I can't put my finger on what it could be.Help Help.
1
<Func Name='InitDataFolder'
<EndFunc Name='InitDataFolder' Return='0' GetLastError='18'>
<Func Name='DetectComputers'>
1
<Func Name='DetectVersionOnMachine'>
NYCTDB04 D:SQL Server ENT 2000 - 64 BitSetupIA64inn 1
<Func Name='InsertVersionRecord'>
NYCTDB04 MSSQLSERVER 0 8.00.760 1033 0 3 1804890536 Enterprise Edition (64-bit) 2099209 1 NYCTDB41 0 1
<EndFunc Name='InsertVersionRecord' Return='0' GetLastError='183'>
<Func Name='InsertVersionRecord'>
NYCTDB04 BIZTALK 1 9.00.2047.00 1033 0 -1 -1 (64-bit) 133124 0 0 1
<EndFunc Name='InsertVersionRecord' Return='0' GetLastError='183'>
<Func Name='InsertVersionRecord'>
NYCTDB04 MYOFFICE 2 8.00.760 1033 0 3 1804890536 Enterprise Edition (64-bit) 2230280 1 NYCTDB42 0 1
<EndFunc Name='InsertVersionRecord' Return='0' GetLastError='183'>
<Func Name='InsertVersionRecord'>
NYCTDB04 SHARED_TEMP 3 8.00.760 1033 0 3 1804890536 Enterprise Edition (64-bit) 2230276 0 0 1
<EndFunc Name='InsertVersionRecord' Return='0' GetLastError='183'>
<EndFunc Name='DetectVersionOnMachine' Return='0' GetLastError='183'>
<Func Name='InsertComputerNameRecord'>
NYCTDB04 0 50010 539101189
<EndFunc Name='InsertComputerNameRecord' Return='0' GetLastError='183'>
<EndFunc Name='DetectComputers' Return='0' GetLastError='0'>
<Func Name='DetectIpResources'>
<Func Name='InsertIpResourceRecord'>
_sql$IpResources 0 144.210.119.64 255.255.255.224 Public
<EndFunc Name='InsertIpResourceRecord' Return='0' GetLastError='183'>
<EndFunc Name='DetectIpResources' Return='0' GetLastError='183'>
<Func Name='DetectGroupResources'>
<Func Name='EnumerateGroupResources'>
SQL 2000 Shared Group(NYCTDB41) NYCTDB04 Disk Q: 0
<Func Name='GetDiskResourceLetters'>
SQL 2000 Shared Group(NYCTDB41) Disk V 0
<Func Name='InsertDiskResourceRecord'>
Disk V 0 V SQL 2000 Shared Group(NYCTDB41)
<EndFunc Name='InsertDiskResourceRecord' Return='0' GetLastError='183'>
<EndFunc Name='GetDiskResourceLetters' Return='0' GetLastError='183'>
<Func Name='GetDiskResourceLetters'>
SQL 2000 Shared Group(NYCTDB41) Disk W 1
<Func Name='InsertDiskResourceRecord'>
Disk W 1 W SQL 2000 Shared Group(NYCTDB41)
<EndFunc Name='InsertDiskResourceRecord' Return='0' GetLastError='183'>
<EndFunc Name='GetDiskResourceLetters' Return='0' GetLastError='183'>
<Func Name='GetVSInfo'>
SQL 2000 Shared Group(NYCTDB41) NYCTDB04 0
<Func Name='EnumVSIPResources'>
NYCTDB41
<Func Name='InsertIpResourceRecord'>
NYCTDB41 0 144.210.119.88 255.255.255.224 Public
<EndFunc Name='InsertIpResourceRecord' Return='0' GetLastError='183'>
<EndFunc Name='EnumVSIPResources' Return='0' GetLastError='183'>
<Func Name='EnumVSResourceOwners'>
NYCTDB41
<Func Name='InsertVSNodeInfoRecord'>
NYCTDB41 NYCTDB04
<EndFunc Name='InsertVSNodeInfoRecord' Return='0' GetLastError='183'>
<EndFunc Name='EnumVSResourceOwners' Return='0' GetLastError='183'>
<Func Name='InsertVSInfoRecord'>
SQL 2000 Shared Group(NYCTDB41) 0 NYCTDB41 MSSQLSERVER 1 D:Program FilesMicrosoft SQL Server V:Program FilesMicrosoft SQL Server ipgnasharedsql.service ipgnasharedsql.service
<EndFunc Name='InsertVSInfoRecord' Return='0' GetLastError='183'>
<EndFunc Name='GetVSInfo' Return='0' GetLastError='183'>
<Func Name='InsertGroupResourceRecord'>
SQL 2000 Shared Group(NYCTDB41) 0 0 NYCTDB04
<EndFunc Name='InsertGroupResourceRecord' Return='0' GetLastError='183'>
<EndFunc Name='EnumerateGroupResources' Return='0' GetLastError='183'>
<Func Name='EnumerateGroupResources'>
Cluster Group NYCTDB04 Disk Q: 1
<Func Name='GetDiskResourceLetters'>
Cluster Group Disk Q: 0
<Func Name='InsertDiskResourceRecord'>
Disk Q: 0 Q Cluster Group
<EndFunc Name='InsertDiskResourceRecord' Return='0' GetLastError='183'>
<EndFunc Name='GetDiskResourceLetters' Return='0' GetLastError='183'>
<Func Name='InsertGroupResourceRecord'>
Cluster Group 1 1 NYCTDB04
<EndFunc Name='InsertGroupResourceRecord' Return='0' GetLastError='183'>
<EndFunc Name='EnumerateGroupResources' Return='0' GetLastError='183'>
<Func Name='EnumerateGroupResources'>
SQL 2005 Biztalk Group(NYCTDB40) NYCTDB04 Disk Q: 2
<Func Name='GetDiskResourceLetters'>
SQL 2005 Biztalk Group(NYCTDB40) Disk T 0
<Func Name='InsertDiskResourceRecord'>
Disk T 0 T SQL 2005 Biztalk Group(NYCTDB40)
<EndFunc Name='InsertDiskResourceRecord' Return='0' GetLastError='183'>
<EndFunc Name='GetDiskResourceLetters' Return='0' GetLastError='183'>
<Func Name='GetDiskResourceLetters'>
SQL 2005 Biztalk Group(NYCTDB40) Disk U 1
<Func Name='InsertDiskResourceRecord'>
Disk U 1 U SQL 2005 Biztalk Group(NYCTDB40)
<EndFunc Name='InsertDiskResourceRecord' Return='0' GetLastError='183'>
<EndFunc Name='GetDiskResourceLetters' Return='0' GetLastError='183'>
<Func Name='GetVSInfo'>
SQL 2005 Biztalk Group(NYCTDB40) NYCTDB04 2
<Func Name='EnumVSIPResources'>
NYCTDB40
<Func Name='InsertIpResourceRecord'>
NYCTDB40 0 144.210.119.90 255.255.255.224 Public
<EndFunc Name='InsertIpResourceRecord' Return='0' GetLastError='183'>
<EndFunc Name='EnumVSIPResources' Return='0' GetLastError='183'>
<Func Name='EnumVSResourceOwners'>
NYCTDB40
<Func Name='InsertVSNodeInfoRecord'>
NYCTDB40 NYCTDB04
<EndFunc Name='InsertVSNodeInfoRecord' Return='0' GetLastError='183'>
<EndFunc Name='EnumVSResourceOwners' Return='0' GetLastError='183'>
<EndFunc Name='GetVSInfo' Return='1168' GetLastError='203'>
<EndFunc Name='EnumerateGroupResources' Return='1168' GetLastError='183'>
<EndFunc Name='DetectGroupResources' Return='1168' GetLastError='183'>
<EndFunc Name='PerformDetections' Return='1168' GetLastError='0'>
View 1 Replies
View Related
Dec 12, 2006
We've run into an issue running against the SQL Native Client ODBC driver (version 2005.90.2047.0) on Windows 2003 Server (Itanium). The "INFO: ODBC 64-Bit API Changes in MDAC 2.7" article (http://support.microsoft.com/kb/298678) doesn't say that the returned value for SQL_ATTR_CONCURRENCY changed to a 64-bit value, but if you request this attribute from the SQL Native Client driver, a 64-bit value is returned. The ODBC spec still indicates that SQL_ATTR_CONCURRENCY is a SQLUINTEGER value, which is 32-bit, even on a 64-bit platform.
This is easy to see by using the ODBC Test utility in the Windows SDK for ia64, "C:Program FilesMicrosoft SDKBinWin64ia64odbcte32.exe". If you connect to the SQL Server driver and then simply call SQLGetStmtAttr(SQL_ATTR_CONCURRENCY), you'll see that the *StringLengthPtr argument returns 8 bytes, when it should only return 4.
Note that we've also seen the same behavior with SQL_ATTR_ROW_BIND_TYPE as well as other statement attributes defined to return SQLUINTEGER values.
Has anyone else run into this?
Thanks,
Chris
View 3 Replies
View Related
Jul 14, 2006
Just an FYI for those scheduling SSIS packages on 64bit Itaniums.
This came to light when using a 32 bit OLEDB driver on a 64bit Itanium.
When manually executing the package on the server through SQL Management
Studio, we got the expected results. However, when we scheduled the
package as a job, it failed every time. The error was:
"The AcquireConnection method call to the connection manager 'ConnectionName' failed with error code 0xC0202009€?.
We tried everything to fix this, but nothing worked. Finally we found
that when manually running the package, SQL Management Studio was calling the
32bit version of dtexec.exe, while the Agent calls the 64bit version of
dtexec.exe. The fix is to not use the "SQL Server Integration
Services Package" type in the job step, but use "Operating system
(CmdExec)" type. Then in the command box, call the 32bit (x86)
version of dtexec.exe.
Example:
C:Program Files (x86)Microsoft SQL Server90DTSBinnDTExec.exe /DTS
"File SystemSSIS Packages[PackageName]" /SERVER [SQLSERVERNAME]
/DECRYPT [password] /MAXCONCURRENT " -1 " /CHECKPOINTING OFF
/REPORTING V
View 1 Replies
View Related
Aug 30, 2007
Hi, pls can anyone help me out with this? I'm installing SQL2005 SP2 over an Itanium machine with W2003 SP2 but it keeps on failing on those features. Client components got installed with no problems. I've installed SQL2005-SP2 over x86 and x64 (not Itanium) machines many times before successfuly. I've been investigating this issue for several days with no luck so I'm a bit clueless at the moment. As I'm using Administrator account I think it is not file permission related.
Summary says "Unable to install Windows Installer MSP file".
let me know if further info is nedeed.
Many thanks.
View 3 Replies
View Related
Feb 24, 2005
Hello, i have a question that the sql server 2000 is install in window 2000 server. If i want to update to window 2003. Is that any problem in sql server 2000. I am worry about whether we will have problem after update. What i need to do? Many thanks.
View 5 Replies
View Related
Feb 28, 2008
Hi All,
I would like to know, how the datetime will be stored in the sqlserver datetime column.
Because some time i am giving the date in dd/mm/yyyy and sometime mm/dd/yyyy.
while give the date in mm/dd/yyyy works fine but not in the another case. and also while i execute a query on query analyser it shows the datetime in
yyyy/mm/dd format.
So anyone can please tell me how the dates will be stored in the datetime column of sqlserver database?
Thanks in Advance.
Regards,
Dhanasekaran. G
View 2 Replies
View Related
Sep 14, 2004
I am currently running SQL Server 2000 Standard on my production system, and I am looking to upgrade the system to Windows 2000 Adv. Server. I would also like to upgrade SQL Server 2000 Standard to SQL Server 2000 Enterprise to utilize more than 2GB of memory. Can anyone tell me what is the best way to upgrade the system, and please provide some feedback on your experiences with the upgrade. Thanks in advance.
View 2 Replies
View Related
Jul 20, 2005
We are experiencing a problem with Sql Server 2000 linking to anAccess 97 file. We have two machines that link to this .mdb file, andwe recently upgraded one to newer hardware, SP3a, MDAC 2.8, etc. Thelink on this upgraded machine no longer works, giving this message:Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.[OLE/DB provider returned message: Cannot open a database created witha previous version of your application.]OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'IDBInitialize::Initialize returned 0x80004005: ].The link on the older machine still works. We decided to tryconverting a copy of the file to Access 2000 to see if the newerpatches/drivers/whatever no longer supported 97. We set up a link onboth machines to this file, and they both work. However, on theupgraded machine, the following error is receievedServer: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.[OLE/DB provider returned message: System resource exceeded.]OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'ICommandText::Execute returned 0x80004005: ].when making 1-3 connections to the the linked server, while the oldermachine supports at least 7 simultaneous queries connecting to thelinked server and still hasn't produced that error.Does anyone have any idea if there is a known issue with linking toAccess 97/2000 files under MDAC 2.8, Jet 4.0, etc? Any light anyonecan shine on this subject would be greatly appreciated.
View 1 Replies
View Related
Jul 20, 2005
What is the limitation of memory that SQL Server 2000 Standard can usewhen running on a Windows 2000 Advanced Server platform?
View 1 Replies
View Related
Sep 15, 2006
Hi, I need to know if somebody knows like making the update of Standard SQL 2000 to Enterprise. Greetings.
View 3 Replies
View Related
Mar 15, 2006
Thanks in advance. What is maximum SQL Server database (*.mdf) file size with SQL Server 2000 as part of Microsoft Small Business Server 2000? (Database files were limited to 10 GB in SBS 4.5 with SQLServer 7.0... has this changed?).
View 1 Replies
View Related
May 21, 2005
Can you install Sql Server 2000 Developer Edition with MSDE 2000 release A already installed?
View 2 Replies
View Related
Feb 17, 2004
My objective is to use Enterprise Manager to move (copy) my SQL db from the server to my windows desktop computer.
I downloaded MSDE and am having trouble installing it, no doubt because I do not understand the documentaion (ReadMeMSDE2000A.htm).
When I try to run setup, I get that message that says:
"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same."
Considering my purpose, do I need a "strong" SA password? If not, how do I get around it? If yes, how do I set it up?
I am a Mac user so I have poor windows skills, please make it as painless as possible for me, thanks!
Ron
View 3 Replies
View Related
Feb 16, 2006
venu writes "Hi,
Am very new to MS SQL adminstration
Can anybody help me out how to work on Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A just for the practice.
The activity which am going to workout on MSDE is below.
How to install SQL(on XP)
How the layout will be(like if i insall MSDE what are all Application will be and how they depends on each other)
How to create/delete tables if so, how can we do it either by GUI or CUI
just i need a clarifications reg same
Thank you,
venu"
View 1 Replies
View Related
Jul 23, 2005
Hi,Simple question: A customer has an application using Access 2000frontend and SQL Server 2000 backend. Data connection is over ODBC.There are almost 250 concurrent users and is growing. Have theysqueezed everything out of Access? Should the move to a VB.Net frontendtaken place ages ago?CheersMike
View 4 Replies
View Related
Oct 8, 2007
Hi,
Just upgraded some development desktops to Vista Business. However we need
to still connect to some older remote windows 2000/SQL 2000 servers.
Trying to setup an ODBC system DSN on our Vista Business local desktop we get the
following errors -
-START ERROR WINDOW-
Connection Failed:
SQLState: '01000'
SQL Server Error: 772
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
(SECDoClientHandshake()0.
Connection failed:
SQLState: '08001'
SQL Server Error: 18
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SSL Security Error
-END ERROR WINDOW-
Any help greatly appreciated as this is stopping us from making
database/table connections etc. We've checked the firewall setup and all is well there.
PS - we can still connect fine using XP or windows 2000 desktops and their
local DSNs.
View 8 Replies
View Related
May 27, 2008
Parameter
Access 2000/XP
SQL Server 7.0
SQL Server 2000
MSDE 2000
Number of instances per server
n/a
n/a
16
16
Number of databases per instance / server
n/a
32,767
32,767
32,767
Number of objects per database
32,768
2,147,483,647
2,147,483,647
2,147,483,647
Number of users per database
n/a
16,379
16,379
16,379
Number of roles per database
n/a
16,367
16,367
16,367
Overall size of database (excluding logs)
2 GB
1,048,516 TB
1,048,516 TB
2 GB
Number of columns per table
255
1024
1024
1024
Number of rows per table
limited by storage
limited by storage
limited by storage
limited by storage
Number of bytes per row
(Excluding TEXT/MEMO/IMAGE/OLE)
2 KB
8 KB
8 KB
8 KB
Number of columns per query
255
4,096
4,096
4,096
Number of tables per query
32
256
256
256
Size of procedure / query
64 KB
250 MB
250 MB
250 MB
Number of input params per procedure / query
199
1,024
2,100
2,100
Size of SQL statement / batch
64 KB
64 KB
64 KB
64 KB
Depth of subquery nesting
50
32
32
32
Number of indexes per table
32
250 (1 clustered)
250 (1 clustered)
250 (1 clustered)
Number of columns per index
10
16
16
16
Number of characters per object name
64
128
128
128
Number of concurrent user connections
255
32,767
32,767
5
View 1 Replies
View Related
May 19, 2008
Hi, I am trying to edit some data from a SQL2000-datasource in ASP.NET 2.0 and have a problem with a column that has bit-data and is used for selection. SQL2005 works fine when declaring <SelectParameters> <asp:Parameter DefaultValue="TRUE" Name="APL" Type="boolean" /> </SelectParameters>When running this code with SQL2000, there are no error-msgs, but after editing a record the "APL"-column looses its value of 1 and is set to 0. Looks like an issue with type-conversion, we've hit incompatibilities between SQL200 and 2005 with bit/boolean several times before. So, how is this done correctly with SQL2000? (I've tried setting the Type to "int16" -> err. Also setting Defval="1" gave an err) ThanksMichael
View 2 Replies
View Related
Jul 23, 2005
I've created a small company database where the tables reside in a SQLServer database. I'm using Access 2000 forms for a front end.I've got a System DSN set-up to SQL Server and am using links withinAccess 2000 to get to the SQL Server tables.My forms worked fine until I made a few minor changes to the databaseschema on SQL Server (e.g. added a foreign key, or added a column).After that, all the links break - I click on a table link and get anerror msg like "invalid object name."Deleting the links after a schema change and re-adding the links seemedto fix the problem. The forms I'd already created seemed to work fineafter re-creating the links.But then I got more advanced with my forms. I have it set up so thatfor certain entry fields, the combobox gets populated with values froma table (the description appears in the drop-down and the correspondingprimary key value gets populated in the table). I created a number offorms using this technique, entered data, and everything worked fine.Made a small schema change and it broke everything -- not the actualtable links, but the functionality for the drop-downs. My values nolonger appeared, and this was true for forms that accessed tables whoseschemas did not change.This is driving me nuts. Is there any way to keep my forms frombreaking each time I make a small schema change?Thanks.- Dana
View 5 Replies
View Related
Jul 20, 2005
Hello,I received the error message below when i'm trying to install SQLServer 2000 standard edition into a Windows 2000 Professionaleworkstation.Error :Microsoft SQL server 2000 Standard Edition server components is notsupported on this operating system. Only client components will beavailable for installation.Any request modification ?Best regards,Thanks
View 1 Replies
View Related
Sep 7, 2007
I've just started getting this EXCEPTION_ACCESS_VIOLATION (0xc0000005) on machines using Windows 2000 sp4 connecting to SQLServer. This is crashing JVMs (multiple Sun versions and BEA also) in the Java VM frame (outside our code). This has just started recently - perhaps with the last set of patches? Has anyone else seen this or know what I could do to get more information? Could this be related to updates to named pipes?
Thanks!
-Brian Temple
View 5 Replies
View Related
Oct 18, 2004
Hi,
I worked on a project in ASP.NET using SQL server 2000 as the back end. Its a conversion application that I rewrote in ASP.NET using C#. I need to import the old data in Access db into SQL server 2000 and I have very little knowledge about doing it. The data in not a direct one -one transformation. There are considerable changes to the Database design and data types. Any help and suggestions wud be really helpful. Also, any article links wud be great.
Thanks
View 1 Replies
View Related
Mar 13, 2001
We have a SQL Server 7.0 system in NT 4.0 environment. We upgraded our users to Access 2000 and started to work with this. Now we installed a new
server which is Windows 2000 based and the domain is different from
the SQL servers domain. We then installed Access 2000 on Windows 2000
to use with terminal server. But I noticed that there was a problem
with the program. I then looked at the program which was written on Access 2000 and saw that the tables and views can't be seen. The program runs but
I can't see the views and tables. Another thing is access disconects from SQL Server when I want to see the tables. So what can be the problem.
In one part there is an Access 2000 on Windows 2000 server. On the other part SQL Server 7.0 on Windows NT 4.0. And Access can't see the tables in SQL server.
View 1 Replies
View Related
May 9, 2002
I have a public mailbox that gets information mailed to it (in a pre-determined format).
Is there a way for that info to be put into a table in SQL Server without any user interaction (something running on the exchange server)?
I hope I've given enough info.
Thanks for any and all help!
Ron
View 1 Replies
View Related
May 13, 2006
I am trying to install microsoft sql server 2000 enterprise edition on a windows 2000 advance server. I keep getting error message
A previous program installation created pending file operations on the installation machine. You must restart the computer before running . I have restarted machine and no change.
What does error message mean and what is solution?
View 2 Replies
View Related
Nov 22, 2004
I have installed the SQL Server 2000 developer that came with Office XP Developer. I now have a copy of SQL Server 2000 Standard. What will happen if I try to install the standard version? Will I loss any of my current database logins or settings, etc...?
Thank you for any help,
View 1 Replies
View Related
