MS SQL Server :: Sql2005 Sp2 64 Bit Surface Area Error When Rying To Access It Locally On Op Sys 2003 R Sp2 64bit

Cannot Access Surface Area Config

Jan 26, 2007

Hi,

I'm posting this in the Setup forum as I think the problem relates to my SQL Server Configuration. Being new to server management pls ask for more info if I don't explain this clearly enough, I'm running out of idea.

Here's the set up:

Windows Server 2003 Web Edition SP2
SQL Server 2005 Enterprise Edition SP1

When I try to run apps I get the following message:

SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

I've found some great notes on the TechNet forums explaining this error and how to resolve it by configuring the Surface Area Tool... remote connections etc

But, this is where I draw a blank as I cannot access the Surafce Area Configuartion for Services and Connections because certain components are not installed, or I do not have admin rights. I definitly have the admin rights, but have no idea where to start looking for aforementioned components.

During the SQL Server install I recevied the warning:

SQL Service Edition System Compatibility - Some components of this edition of SQL Server are not supported on this Op system.

It sounds pretty generic and doesn't offer anymore details, but could this be effecting it?

I've also noticed that when I open SQL Server Configuration Manager and click on SQL Server 2005 Services nothing appears in the right-hand panel??? I'm sure there should be???

I've been all over TechNet & Books online and cannot find any reference for what I'm experiencing.

Any help or guidance will be greatly appreciated!

Thanks!

View 1 Replies View Related

Surface Area Configuration Error Message

Dec 14, 2006

Hi Dear

I have been trying to add SQL database to my web application and have to configure the SQL to allow remote accee.

I would like to start the Database Engine Service when I click on start button to start the service it dissplay following message:

An error occurred while performing this operation

Severa; time I restart the computer still, When I try it is same problem.

thank for yout help.

View 3 Replies View Related

How To Resolve An Indefinite Wait State On Update Command In SQL2005 (64bit 2003 Server)?

Jun 16, 2006

I am in the process of moving a SQL2000 database to a SQL2005 database.

Porting from: SQL200, Windows Server 2000(SP4) (32 bit dual processor)
to:SQL2005, Windows Server 2003(SP1) (x64 bit dual processor)

After porting the database from SQL2000 to SQL2005 (no changes) running the same update statement from Management Studio on the 2003 Server and and Query analiser on the 2000 Server.

SQL2000 completes the command in 2 minutes SQL2005 is still running after 60 minutes.

SQL2000 is the live/production system with users connected, the SQL2005 is in a test environment with no other processors running.

When the problem first showed up the SQL2005 activity monitor displayed CXPACKET wait type on 2 processes with the same pid number. I now no longer have any wait type being displayed but my wait time is increasing rapidly. No block is reported.

I assume that I have an CXPACKET lock problem.

Am I correct that I have a CXPACKET problem and if so what is the resolution?

The update statement is as follows...

update BI_LENDING_TRANSACTIONS
set [Balance Movement Month] = M.[Balance Movement Month]
from BI_LENDING_TRANSACTIONS as T,
BI_BALANCE_MOVEMENT_DATES as M,
BI_COMPANIES as C
where (T.[Transaction Date] >=
(SELECT DATEADD(d, - 70, minDate) from (select min([Transaction Date]) minDate
from p_BI_LENDING_TRANSACTIONS) t1)
OR
T.[Transaction Date] >= C.[MostRecentSnapShotDate] or
T.[Value Date] = T.[Balance Movement Month] ) and
T.[Value Date] <= C.[MostRecentSnapShotDate] and
T.[Value Date] >= T.[Transaction Date] and
T.[Company_Code] = M.[Company_Code] and
T.[Value Date] > M.[SnapShotFromDate] and
T.[Value Date] <= M.[SnapShotToDate] and
C.[Company_Code] = M.[Company_Code]

View 1 Replies View Related

Surface Area Configuration

Apr 14, 2008

Dear All,
i'm trying to publish a maintenance plan in sql server 2005.

but soon after right click and selecting a new maintenance plan, it is displaying an alert with "AgentXP's component" is turned off.

please let me know how to ON those services. i've read and followed the instructions but i was unable to find where exactly to start.

please guide me in this regard

my version of OS is sql server 2000 professional

my version of sql server is :Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Vinod
Even you learn 1%, Learn it with 100% confidence.

View 1 Replies View Related

Surface Area Configuration

Feb 28, 2007

Hi, we are having a strange problem when trying to configure the surface area of my sql server 2005. When we open the tool the only nodes that appears are: Reporting Services and Integration Services. But the Database Engine node is not showing. What do we have to do to access the Database Engine node and configure Remote Connection.

Any help would be extremely appreciated...

View 12 Replies View Related

Admins, Surface Area Configuration

Apr 16, 2008

Up til now i've been working with Access, i have only got a few weeks experience with SQL, so dont eat me.
I set up a SQL Database, and placed it into my site, etc, set up all the connection strings. It connects fine, but cannot log in. It tells me;
Cannot open database "C:USERSJAREDDESKTOPSTYXSTYX - BUILD 2APP_DATASTYXDB.MDF" requested by the login. The login failed.Login failed for user 'Webdev01Jared'.
I'm running Vista (x86), and SQL Server 2005 Express SP2, and i'm aware that Vista by default does not automatically enable remote access in SQLExpress for local admins.
So i go into Surface Area Configuration. I've read about it, and it's two steps, Click "Add New Administrator", then select the priveleges in the left box and click the button to put them in the right box. Simple enough, and it works, sure, click the button, it moves across, done.
But. Hit OK. It's done nothing, i still cant connect, and the cherry on top; open up the SAC again to check and there is nothing in the right box. It's exactly how it was before i changed it. The problem is definitely this, and not the account, as i can log in for SQL Management Studio just fine, with the same windows authentication credentials.
Thanks in advance.

View 3 Replies View Related

Surface Area For Features Not Connecting

Oct 4, 2005

Hello, I've installed SQLServer2k5 Sept CTP with the following config: W2K SP4 Pro, SQL2K5 Std Sept CTP complete clean install. Everything works except SAC for features. I get the error below when trying to start it. SAC for Services & Connections connects without problem and has local & remote connections via both TCP/IP and Named Pipes enabled for the server, and local & remote connections enabled for analysis services. All SQL2K5 components & services are started in the Services control panel. I've looked at port useage, wondering if some other process is using the port that SAC for features is pinging, but since SAC for Services & Connections works fine that doesn't seem to be culprit.
I also get an error when running the Tuning Advisor, saying it can't connect, but demoted that to just a warning by closing some extraneous connections to the servere (had >10 open). Still get a warning, but it doesn't prevent the Tuning Advisor from completing.
I've tried turning on and off various services, from Remote Registry Service to IIS, but no luck. Anyone know what else I chould check to troubleshoot this? Thanks!
Failed to connect to server localhost

View 1 Replies View Related

Surface Area Config Problem . . .

Jun 29, 2007

Being very new to SQL Server, I have to ask - when I try to connect to SQL Server 2005 using TCP/IP I cannot. To accomplish this I was directed to use the Surface Area Configuration utility.

When I do this, I do not see the Database Engine the docks reffer to - any help/comments/suggestions?

Thanks,

Chris

View 1 Replies View Related

Problems Using The SQL Server Surface Area Configuration

Jul 19, 2007

I am currently running a Windows Vista Enterprise OS platform using SQL Express, whenever i add a user to the administrator group using the SQL Server Surface Area Configuration UI, each time i click on the link to add New Administrator, the previous administrator i just added still appears on the left - just as if i never added this user previously.

Is there a way around this issue? or is this a SQL Express problem, because i also tried doing it with SQL Server Enterprise edition on a Win2K3 SP2 box and it gives the same results.

Feedback is greatly appreciated.

Thanks

View 1 Replies View Related

~ Regarding SQL Server 2005 Surface Area Configuration ~

Nov 9, 2006

Sorry for the annoying. I would like to the configuration settings for the surface area. There's an option which able to let us change computer (whether is local computer or remote computer). Let say I put my own computer's name (Hans as example) for configuration as the remote compute, it's work fine to me. However, if I put my remote computer's name, it displays this error message to me.

Error :

Computer Tomato does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again.

I am sure that the remote computer is working since I am able to ping the remote computer and test on telnet as well. But why it seems that surface area can't detect my remote computer. Hope can get some resistance from everyone here. Thanx alot.

Best Regards,

Hans

View 1 Replies View Related

Database Mail && Surface Area Configuration

Feb 5, 2008

I want to send mails from SQL Server 2005 Management Studio Express for which I referred to the article at http://www.databasejournal.com/features/mssql/article.php/3626056. I could successfully do the steps from step 1 to step 6 listed at the above URL. In fact, when I sent a test mail (as cited in step 6), SQL Server displays the message Mail queued though the mail didn't get delivered. The mail server address I am using is smtp.mail.yahoo.co.uk.

But when I expand the Management node in the Management Studio Express GUI, I don't find Database Mail as a child node. In fact, there are only 2 child nodes under the Management node - SQL Server Logs & Activity Monitor.

Why isn't Database Mail listed under the Management node? What am I missing here?

Also when I open Surface Area Configuration & then click Surface Area Configuration for Services and Connections, the following error gets generated:

Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again. (SQLSAC)

Additional Information:

The type initializer 'System.Management.ManagementPath' threw an exception. (System.Management)
Unable to cast COM object of type 'System.Management.WbemDefPath' to interface type 'System.Management.IWbemPath'. The operation failed because the QueryInterface call on the COM component for the interface with IID '(38C15AF2-736C-477E-9E51-238AF8667DCC)' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). (System.Management)
When I click Surface Area Configuration for Features, it generates the error cited above but from the first bulleted list.

How do I overcome this error? I confirmed that Windows Management Instrumentation is running by opening Services from Control Panel ---> Administrative Tools.

I am on WinXP Pro SP2. Please note that I also have SQL Server 7.0 installed in my machine which is a standalone m/c.

Thanks

View 1 Replies View Related

Failed To Connect To Localhost When Trying To Use Surface Area Configuration

Feb 13, 2008

Hello all, I hope someone can help me with this.

This is a new SQL Server 2005 cluster that we just installed for the first time, with SP2. I am trying to use a stored procedure with xp_cmdshell to run a script to backup the databases. I get the following error: locked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', see "Surface Area Configuration" in SQL Server Books Online.

So I started Surface Area Configuration on the local SQL Server itself, and clicked on "Surface Area Configuration for Features". I then got the following error:
"Failed to connect to localhost. (Mirosoft.SqlServer.ConnectionInfo)
Additional information: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

I am logged onto the server as a user with Admin privs; I installed SQL Server using that id. I am logged in via remote connection, so I know it allows remote connections... and I am logged into the server itself when I try to run the tool, so I don't understand why it's saying that it's trying to connect remotely.

Has anyone else ever experienced this problem? Thanks for any help you can give.

Best, Amy

View 13 Replies View Related

Missing Some Components In SQL Server 2005 Surface Area Configuration

Feb 29, 2008

I was studying the SQL Server 2005 Surface Area Configuration tool to see how i could increase security.

I cannot find some of the components in “Surface area Configuration of Features�?.

For example DAC appears to be missing. This is a dedicated administrator connection that allows an administrator to connect to a server.

Is this because I have SQL 2005 express instead of the professional version or could it even be to do with the operating system (XP home)

Only the following components are listed under "Database Engine":

Ad Hoc Remote Queries
CLR Integration
Native XML Web Services
OLE Automation
Service Broker
Xp_cmdshell

Thanks

View 1 Replies View Related

I Can't Find Database Engine Under MSSQLSERVER From Surface Area Configuration

Jun 8, 2008

The operation system is windows xp, and before i installed the SQL SERVER2005 the SQL SERVER2000 had installed.
the course of installing the SQL SERVER2005 has no error at all.
but i can not find the Database Engine under MSSQLSERVER from surface area configuration
==============
thank you in advance for any help

View 2 Replies View Related

SQL2005 64bit, Snapshot Creation Error

Oct 16, 2007

I'm running SQL Server 2005 SP2 64bit under Windows Server 2003 64 bit
The system is the replication distributor as well. Transactional replication.

But I can't create the snapshot!

I have run snapshot.exe repeteadly with all parameters in a command prompt and it crashes at various BCP percentages.
The error is like this:
2007-10-16 00:38:56.32 [10%] Bulk copied snapshot data for article 'Dictionary (part 14 of 20)' (1656 rows).
2007-10-16 00:38:56.32 [10%] The replication agent had encountered an exception.
2007-10-16 00:38:56.32 Source: Replication
2007-10-16 00:38:56.32 Exception Type: Microsoft.SqlServer.Replication.NativeSqlConnectionException
2007-10-16 00:38:56.32 Exception Message: Data conversion failed
2007-10-16 00:38:56.32 Message Code: 02007-10-16 00:38:56.32
2007-10-16 00:38:56.32 Call Stack:
2007-10-16 00:38:56.32 Microsoft.SqlServer.Replication.NativeSqlConnectionException: Data conversion failed
2007-10-16 00:38:56.32 at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.ThrowNativeBcpOutException(CConnection* pNativeConnectionWrapper)
2007-10-16 00:38:56.32 at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.BcpOut(String strBcpObjectName, String strBcpObjectOwner, String strBaseBcpObjectName, Boolean fUnicodeConversion, String strDataFile, String strLoadOrderingHint, String strWhereClause)
2007-10-16 00:38:56.32 at Microsoft.SqlServer.Replication.Snapshot.SqlServer.BcpOutThreadProvider.DoWork(WorkItem workItem)
2007-10-16 00:38:56.32 at Microsoft.SqlServer.Replication.WorkerThread.NonExceptionBasedAgentThreadProc()
2007-10-16 00:38:56.32 at Microsoft.SqlServer.Replication.MainWorkerThread.AgentThreadProc()
2007-10-16 00:38:56.32 at Microsoft.SqlServer.Replication.AgentCore.BaseAgentThread.AgentThreadProcWrapper()
2007-10-16 00:38:56.33 [10%] Bulk copied snapshot data for article 'Dictionary (part 15 of 20)' (1487 rows).
2007-10-16 00:38:56.33 [10%] Bulk copying snapshot data for article 'Dictionary (part 20 of 20)'

the fact that BCP continues to copy data after the error makes me believe the crash occurs somewhere else.

How can I isolate the offending table?
Can I capture the BCP commands issued?

Any insight will be appreciated.

View 5 Replies View Related

Alter Failed Trying To Modify Surface Area Configuration Xp_cmdshell - Help Needed

May 9, 2007

I installed SQL Server 2005 Enterprise Edition (64-bit) and then applied SQL SP2. When I launch the "SQL Server 2005 Surface Area Configuration" and choose "Surface Area Configuration for Features" I'm trying to enable xp_cmdshell.

After ticking the checkbox, and clicking Apply, I receive the error below. Anyone have any ideas on how to fix this?

===================================

Alter failed. (Microsoft.SqlServer.Smo)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Configuration&LinkId=20476

------------------------------
Program Location:

at Microsoft.SqlServer.Management.Smo.ConfigurationBase.Alter(Boolean overrideValueChecking)
at Microsoft.SqlSac.Public.Smo.SetSetting(Credentials credentials, DatabaseFeature feature, Int32 value)
at Microsoft.SqlSac.MainPanel.UserControlSSxp_cmdshell.ProcessOK(HashKey givenKey, String machineName)
at Microsoft.SqlSac.MainPanel.FormFeatures.commitDBChanges()
at Microsoft.SqlSac.MainPanel.FormFeatures.commitChanges()

===================================

Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
Program Location:

at Microsoft.SqlServer.Management.Common.ServerConnection.GetStatements(String query, ExecutionTypes executionType, Int32& statementsToReverse)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(String cmd)
at Microsoft.SqlServer.Management.Smo.ConfigurationBase.DoAlter(Boolean overrideValueChecking)
at Microsoft.SqlServer.Management.Smo.ConfigurationBase.Alter(Boolean overrideValueChecking)

View 7 Replies View Related

Access 2003 Projects Don't Work With SQL2005

Apr 25, 2008

Hi All,

Just installed a new version of SQL2005 on a brand new Application Server.

However, when i fired up Access 2003, it gives me some chaos about how Access isn't compatible with SQL2005. Fantastic lack of backward compatibility straight out the box.

Ok, so I do as it says and download all the updates.

Try again... Still won't allow me.

Wen't to Control Panel > Data Sources and confirmed the Native Client is in there. Added a System DSN for the new Server.

Tried Access again, still not working?? What the...

Why can't I create a new project in Access 2003, and edit it from my desktop instead of sitting on the server for every table modification? I hate designing tables on the SQL studio.

Any clues or help would be great. I'm just disappointed at the moment, on how this is holding up my database projects.

Thanks,

Chris.

View 1 Replies View Related

Sql Server 2005 Sql Server Surface Area Configuration Classical Problem

Feb 18, 2008

hi ; everybody
i have almost installed sql server 2005 enterprise edition on windows xp sp2 and i havent connected to any server .i have taken error:40 with my all attempts.tcp/ip protocol have been enabled on sql server configuration manager.i have tried to start sql server surface area configuration but every my attempt have been resulted a fault which is below.
[No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)]
i dont suppose that i did something wrong when i setupped.because i read every article on the internet about how to make setup.also; i setupped numbers of times on my pc.
but i didnt accomplished.
i thank for any help.please; give your solution explicitly.

View 8 Replies View Related

SQL Configuration Manager And SQL Server Surface Area Configuration Tools

May 2, 2007

I have just finished installing SQL 2005 Ent Edition on Win 2000 Adv Server, SQL2005 SP2, and SP2 Hotfix KB934458. After the installation, I could see and configure all services via SQL Configuration Manager and SQL Server Surface Area Configuration tools. This worked for a couple of days and now both configuration tools no longer detect SQL2005 components. SQL Server Surface Area Configuration issued an error that said "No SQL Server 2005 components were found on specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLAC)". SQL Configuration Manager did not list any installed services. I don��t know what caused this. Anyone has any idea? Please help! Below is the Installation Report which shows installed components.

===================================

The following components are installed on this server

DEV

Analysis Services

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Database Engine

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Reporting Services

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

QA

Analysis Services

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Database Engine

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Common components

Integration Services

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Notification Services

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Workstation Components

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

===================================

View 1 Replies View Related

Connecting Surface Area Configuration To Server On Clustered Server

May 8, 2006

I've run into a problem after upgrading production servers running under Microsoft Cluster Server, Windows Enterprise Server 2003 SP1, and SQL Server 2005 SP1 Enterprise Edition.

Once I completed the upgrade and applied the patch, I needed to examine the values set in the Features component of the Surface Area Configuration tool. The tool attempts to connect to localhostinstancename, but reports the following error:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error:26 - Error Locating Server/Instance Specified)(Microsoft SQL Server)

I'm logged into the virtual server via Remote Desktop, but the SAC tool thinks I'm logged into the physical server supporting the virtual server. I seem to be caught between a rock and a hard place here, as I can't enable remote connections without first gaining access on the server itself.

Any help will be greatly appreciated.

View 3 Replies View Related

BCP -- Insert Record Error (SQL2005-Window 2003)

Aug 21, 2006

Hi All,

When we to inset record into the tables through BCP we are getting following errors.

C:> bcp ACCT.dbo.dtpro out C: estdtpro_TA.dat -T-n
C:>bcp ACCT.dbo.Semiaa out C: estSemiaa_TA.dat -T -n

BCP out works fine only BCP in have problems.

Please can you let me know how to resolved this problem.

===========
Exp - 1
===========

C:> bcp ACCT.dbo.dtpro in C: estdtpro_TA.dat -T-n

Starting copy...
SQLState = HY000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP data-file

0 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 1

===========
Exp - 2
===========

C:>bcp ACCT.dbo.Semiaa in C: estSemiaa_TA.dat -T -n

Starting copy...
SQLState = HY000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP data-file

0 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 1

============
Exp-3
============

C:>bcp ACCT.dbo.SemiH in C: estSemiH_TA.dat -T -n

Starting copy...SQLState = HY000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP data-file
SQLState = 42000, NativeError = 7339
Error = [Microsoft][SQL Native Client][SQL Server]OLE DB provider 'STREAM' for l
inked server '(null)' returned invalid data for column '[!BulkInsert].Created'.

BCP copy in failed

Thanks in Advance

View 12 Replies View Related

SQL2005 64bit

Feb 22, 2008

I have an SQL2005 db residing on a 64bit server.I can load and run my App, provided it is installed on the server.However when I try to run from a Client's PC I get timeout errors.

Initially the error was Remote connections not allowed,but I have overcome this by ensuring SQLbrowser was running and that AllClient and Server Prodtocols were enabled.

I now keep getting a message the timeout has expired.

Do I need to do more in a 64bit environment.

Please help !

View 1 Replies View Related

Installing 64bit SQL Server On X64 Windows 2003

Oct 2, 2007

Hi there,

We've got a Windows 2003 (64 bit edition) box to use as our Database server.

I installed SQL Server 2005 (Standard Edition) on the machine, but I have a feeling it has installed the 32 bit version and not the 64 bit version.

The reason I think this is that the MSSQL directory is under the 32 bit program files directory and not the 64 bit directory, and also when I look at the service properties it says it's running from WOW6432 registry entry.

Is there a separate disc for the 64bit version? Does the installer automatically work out which version to install or is there some sort of switch I have to do to tell it to install the 64 bit version.

Many thanks for your time.

Simon

View 3 Replies View Related

ODBC Driver For Windows 2003 64bit

Feb 7, 2007

Hi All,

I have installed windows 2003 R2 64bit on one of the system, but my devlopment team pointed out that there is no odbc driver available.

I check it for odbc driver on OS cd but i do not found any relevant files/packages, can any one tell me from where I can download the ODBC driver for windows 2003 64bit OS.

Thanks & Regards

Varian

View 6 Replies View Related

Windows 2003 64bit Running SQL 2000 SP4

Sep 28, 2006

I have been running Windows 2003 64bit and SQL2000 SP4 for over 2 months with out any issues.

Sadly we had a server crash "NTldr missing or corrupted"

now when the one engineer looked at it he suggested to reload the server with Windows 2003 32 bit version as there were known compatibility problems between 2003 64bit and SQL 2000 32bit but that you can install SQL 2000 32bit onto a Windows 2003 64 bit server.

Now i dont really believe this statement nor can i find any documentation supporting this. I believe this server might have crashed due to a new patch that was released the last 2 or 3 week either on Windows or SQL. Does anyone know where i can verify what patches was released?

Maybe someone else can share their thoughts with me.

View 3 Replies View Related

Problem Installing SQL 2k 32bit On Windows 2003 64bit X86 SP1

Jun 28, 2006

I've been having no luck trying to install SQL 2k 32bit on Windows 2003 64bit x86 SP1 - I've found several articles regarding needing to put SP4 on the 64bit OS, but my problem is the SQL 2k 32bit ",,x86setupsetupsql" won't run.

I consistantly receive a "...(localuserdir)Local.ins. Unable to load installaion instructions. Error 703."

And of course, the SP4 setup won't run because there is not an existing SQL Service to upgrade.

Anyone come up against a similar problem?

Thanks!

View 1 Replies View Related

None-Domain Server Cannot Access SQL2005 Data On Windows 2003 Domain Server

Sep 26, 2006

I'm trying to run a test from my test environment which is a non-domain Windows 2000 server to access my domain 2003 with SQL2005. I have install 2005 tools to try to access the SQL server.

- I have try following the KB265808 - no success.
- Reading alot of blogs and it seems all are pointing to the same problem. "Remote access" but the settign is enabled.Error Message:

TITLE: Connect to Server
------------------------------

Cannot connect to ardsqldatawh.

------------------------------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476

Question: Could Windows 2003 security be blocking access? I'm using sa account to access.

Also, sa account does not seems to work for remote access. It is ok when accessing locally.

Any help would be appreciated.
949jc

View 1 Replies View Related

VBA Access 2003 Error 2749

Mar 24, 2008

How can I avoid the error?

I keep getting this error:
----------------------------------------------------------------------------------------------------------------------------------------------
Run-time error '2749':

There isn't enough memory to complete the Automation object operation in the OLE object.

----------------------------------------------------------------------------------------------------------------------------------------------

Here is the code:
----------------------------------------------------------------------------------------------------------------------------------------------
Private Sub cmdLoadOLE_Click()

Dim MyFolder As String
Dim MyExt As String
Dim MyPath As String
Dim MyFile As String

MyFolder = Me.SearchFolder__
' Get the search path.
MyPath = MyFolder & "" & "*.jpg"
' Get the first file in the path containing the file extension.
MyFile = Dir(MyPath, vbNormal)

Do While Len(MyFile) <> 0

'[fldID] = CInt("4869")
[fldID] = CInt(Replace(MyFile, ".jpg", ""))
[fldOLE].Class = "MSPhotoEd.3"
[fldOLE].OLETypeAllowed = acOLEEmbedded
[fldOLE].SourceDoc = MyFolder & "" & MyFile
[fldOLE].Action = acOLECreateEmbed
[fldOLE].Action = acOLEClose

' Check for next OLE file in the folder.
MyFile = Dir

' For Access 97 only, use the following line of code:
DoCmd.RunCommand acCmdRecordsGoToNew

Loop

End Sub

----------------------------------------------------------------------------------------------------------------------------------------------

View 4 Replies View Related

Slow SQL 2005 64bit Standard Edition Performance On Windows Server 2003

Apr 2, 2008

Greetings,

We are having major performance issues with Microsoft SQL 2005 64bit Standard Editions performance on Windows Server 2003. We have an SSIS package running very slowly (and other sql tasks) on our two quad core cpu system with 8gb of ram and running a 500gb mirrored SCSI (Raid 1) drive system. The database running on the server is about 11gb.

Does anybody have any suggestion we could try to increase the performance of the server? I've run a defrag several times which helps a little but I was hoping I could do something else to increase the performance.

Thank you.

View 7 Replies View Related

Transact SQL :: Surface Some Access Data On Database?

Jun 22, 2015

surface some data stored in an Access database via SQL Server, ultimately to be consumed by SharePoint.

I understand how to push existing tables to SQL Server as new tables. In my case, what I am hoping to do is to link an Access query with a table in SQL Server, and have that table be updated each time the query is run (or even each time the database is updated).

View 3 Replies View Related

Win 2003 X64 - SSIS Error Importing Xls And Access Data

Dec 14, 2005

I am having a problem importing data from xls and access into my SQL2005 DB using SSIS. Would appreciate any help in getting this resolved. Environment: Xeon 64 bit processor machine/Win 2003 64 bit (x64)/SQL 2005 64 bit Some of the resources that I have dug up so far have pointed to Jet Engine SP8 and WOW64. A search on the box shows this: C:WindowsSysWOW64Msjet40.dll �� File version is 4.0.9025.0 Not sure what is missing. The following is the error from the import from xls. The one from access is very similar. ================================================================================== Task Import abc_xls Validation has started [DTS.Pipeline] Information: Validation phase is beginning. Progress: Validating - 0 percent complete [Excel Source [1]] Error: The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. [DTS.Pipeline] Error: component "Excel Source" (1) failed validation and returned error code 0xC020801C. Progress: Validating - 50 percent complete [DTS.Pipeline] Error: One or more component failed validation. Error: There were errors during task validation. Validation is completed [Connection manager "Excel Connection Manager"] Error: An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".

View 41 Replies View Related

Cast COM Object Error On OleDb Destination (Access 2003)

Mar 20, 2007

Trying to do a update/insert from SQL 2005 query to Access 2003 linked table.

In the Script Transformation I get this error.

Unable to cast COM object of type 'System.__ComObject' to class type 'System.Data.OleDb.OleDbConnection'. Instances of types that represent COM components cannot be cast to types that do not represent COM components; however they can be cast to interfaces as long as the underlying COM component supports QueryInterface calls for the IID of the interface.

Destinatoin Oledb connection is Native OLEDB Jet 4 to Access 2003 database.

Private sqlConn As OleDb.OleDbConnection

Private sqlCmd As OleDb.OleDbCommand

Private sqlParam As OleDb.OleDbParameter

Private connstring As String

Public Overrides Sub AcquireConnections(ByVal Transaction As Object)

connMgr = Me.Connections.ConnectionOLE

'sqlConn = CType(connMgr.AcquireConnection(Nothing), SqlConnection)

connstring = connMgr.ConnectionString

sqlConn = CType(connMgr.AcquireConnection(Nothing), OleDb.OleDbConnection)

End Sub

Any help would be appreciated.

View 3 Replies View Related