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
ADVERTISEMENT
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
Mar 18, 2008
I get this problem when tryoing to connect to the surface area configuration for services & connections
As well as for features.
However I can connect via another computer and change the options accordingly but I just can't do it locally from the server ?
Does any one know why please, the links in the message don't help ?
===================================
An exception occurred in SMO while trying to manage a service. (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.InnerWmiException&LinkId=20476
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Smo.Wmi.WMIProxy.ExecProcess(Object request)
at Microsoft.SqlServer.Management.Smo.Wmi.WMIProxy.ProcessRequest(Request req)
at Microsoft.SqlServer.Management.Smo.Wmi.WmiSmoObject.EnumChildren(String childTypeName, WmiCollectionBase coll)
at Microsoft.SqlServer.Management.Smo.Wmi.ServiceCollection.InitializeChildCollection()
at Microsoft.SqlServer.Management.Smo.Wmi.ServiceCollection.get_Count()
at Microsoft.SqlSac.MainPanel.FormFeatures..ctor(String machineName, Form callingForm)
===================================
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.Wmi.WMIProxy.ExecProcess(Object request)
===================================
------------------------------
Program Location:
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()
at Microsoft.SqlServer.Management.Smo.Wmi.WmiBase.BuildDataTable(ManagementObjectCollection listManagementObject)
at Microsoft.SqlServer.Management.Smo.Wmi.WmiBase.BuildResult(ManagementObjectCollection listManagementObject)
at Microsoft.SqlServer.Management.Smo.Wmi.WmiBase.GetData(EnumResult erParent)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
Hmm A tad strange.
View 3 Replies
View Related
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
Oct 2, 2007
We have a 64bit installation of SQL Server (SSIS, SSAS) running and working fine. There is a requirement to install 64bit SSRS on this existing setup.
The problem is: While running the SQL Server Setup wizard, the Reporting Services checkbox remains greyed out. In other words, there isnt an option to select SSRS for installation.
So the question is: Is it even possible to install 64bit SSRS on an existing 64bit SQL server installation - given that SSRS wasnt installed during the first pass.
PS: The SQL Server is SP2 on a Windows Server 2003 configured as an App Server.
View 9 Replies
View Related
Jun 6, 2007
I just installed the 64bit Vista and than wanted to install the 64bit SQL 2005 Std. Server on it.
Note: I downloaded my license from https://licensing.microsoft.com/eLicense/L1033/ProductDetail.Asp?SKU=228-05338.
Installing from SQLSTDSEL.ISO file results in the warning that for the REPORT- Server the .NET version has to be 32bit.
Stopping the installation at this point and try to install from SW CD SQL Svr Standard Edtn 2005 64Bit X64 English #1 x64 MLF.x11-57664 + SW CD SQL Svr Standard Edtn 2005 64Bit X64 English #2 x64 MLF.x11-57665 does not give the above error but on the other hand installs no server at all since somehow the installation routine is not working at all.
Installing now - after at least analysis server and reports server are 64bit and installed - from the first mentioned ISO results in the installation of the DB- Server.... but as a 32bit installation.
Now I wonder what did not work out - so maybe someone here has an idea if and how this problem is solveable.
View 1 Replies
View Related
Dec 15, 2005
hi
i try to restore a bak file from another sql2005 server to my sql2005 server, but it show the error message as below :
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
Cannot open backup device 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupackup.bak'. Operating system error 5(error not found).
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3201&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
pls some one can help me ???
thanks
chaus
View 62 Replies
View Related
Oct 12, 2007
Can you open/use a database created in SQL2005 in SQL2005 Express?
Thanks for the help!
Max
View 4 Replies
View Related
Dec 27, 2005
I just upgraded my SQL 2000 server to SQL2005. I forked out all that money, and now it takes 4~5 seconds for a webpage to load. You can see for yourself. It's pathetic. When I ran SQL2000, i was getting instant results on any webpage. I can't find any tool to optimize the tables or databases. And when I used caused SQL Server to use 100% cpu and 500+MB of ram. I can't have this.Can anyone give me some tips as to why SQL 2005 is so slow?
View 3 Replies
View Related
Jan 4, 2007
Hi
We have Sql2005 x64 bit standard edition server installed in windows 2003 64 bit editio server,
currently due to buisness requirements we need to have sql2005 x64 bit enterprise edition, please let me know how do i do the upgrade or change.
is it possible to retain all our custom settings in the standard edition after changing to enterprise edition.
This has to be done for our production and very critical, please help
Thanks
Samuel I
View 4 Replies
View Related
Sep 19, 2007
I am unable to install 32-bit SQL Server Integration Services on the server due to something that was left behind by the 64-bit version.
I've uninstalled SQL Server 2005 64-bit and when I try to install the 32-bit version of Integration Services, I get this error: "Failed to install and configure assemblies C:Program Files (x86)Microsoft SQL Server90DTSTasksMicrosoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2146233087 Error message: Unknown error 0x80131501 Error descrition: FATAL: Could not find component 'Microsoft.SqlServer.Dts.Task.MessageQueueTask.ServCompMQTask' we just installed."
I can't seem to figure out how to resolve this problem with the COM+ and I can't remember if Integration Services is required.
Can anybody please advise?
View 1 Replies
View Related
Jul 8, 2007
Hello,
I have a vb program that include a dts package that has been saved to vb with sql2000 dts wizard and works very good.
Now that I upgrade my website to sql2005, this vb dts package doesn't work.
The error I get is:
Microsoft Data Transformation Services (DTS) Package
Invalid STDGMEDIUM structure
(Microsoft Data Transformation Services (DTS) Package (80040066): Invalid STDGMEDIUM structure
) (Microsoft SQL-DMO (ODBC SQLState: 42000) (80004005): [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'.)
I searched in the internet how to make dts package in sql2005 and save it to vb and found no information about it.
What Can I do to get the vb code of the dts package I create in sql2005 or how do i migrage the sql2000 vb dts package code to sql2005?
Thanks,
Kubyustus
View 4 Replies
View Related
Aug 20, 2007
Dear Expert sorry for disturbing you again....
please tell me what is 32 bit and what is 64 bit databases in sql server? is that based on versions line 7.0 , sql server 2000, yukon and katmai like that or based on creation? please explain me
thank you very much
Vinod
Even you learn 1%, Learn it with 100% confidence.
View 6 Replies
View Related
Jun 21, 2006
I run SQL Server 2005 on a Windows 2003 64-bit server. I have created a package where I run an execute t-sql statement task. In the t-sql I have the following:
select * from
OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="c: est.mdb";User ID=Admin;Password=').pubs.dbo.data
and I get the following error:
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.
View 8 Replies
View Related
Sep 14, 2006
We have SQL 2000 but are getting new 64bit servers, can we upgrade to a 64bit version of SQL 2000 or do we need to go to 2005?
I assume the 32bit SQL 2000 will run on x64 hardware?
Craig
View 4 Replies
View Related
Nov 1, 2007
Hi, is here someone who can send me new dll libary. Itīs very important. Thanks ALL
View 1 Replies
View Related
Oct 30, 2007
We have an ASP 2.0 application built using SQL Server 2005, on a 32 bit system. We are going to bring in a much faster server and move the applicatioin to the new server. Since we are moving to a faster server, we are also considering putting a 64bit version of SQL on the new machine and running as 64 bit.
Now the rookie questions:
1) If we do this do we need to do anthing special with our procs/functions, i.e. do we need to recompile everything?
2) From an asp perspective, do we need to do anything to our pages/code?
3) what other issues do we need to be cognizant of?
thanks in advance for the advice
View 3 Replies
View Related
Apr 22, 2008
Hey guy's I am trying to develop something on a 64bit Vista machine.
However, the SQL server 2005 import wizard is having a tough time importing my data because this machine does not have IIS.
I tried to install the regular version and it would not let me based on my system.
suggestions?
View 4 Replies
View Related
Aug 30, 2007
I'm sure this has been discussed in the forums before, but I'll ask anyways. I'm replacing our GP server next year to one that will run SQL2k5 64-bit. The current server is only capable of 32bit SQL. I know with some databases changing from x64 to x32 is a bad idea...will SQL Server support it?
Thanks
View 3 Replies
View Related
Dec 10, 2006
I have found that orig tested 64 bit on our 64bit windows 2003server...about 1 year ago...and company decided to use sql 32 bit on the64bit osmy question and any information is very welcomeis there any things in need to know about awe withmemory above 4g ...whilst using 32 bit sql on a 64bit osi want to increase the memory on the server buti really don't know what im up against since this ismixed system 32 bit sql and 64 bit osthanksmike
View 4 Replies
View Related
Mar 4, 2007
Dose any one have a simple workaround to implement a connection fromSQL 2005 SSIS 64 bit to Oracle 10 G
View 3 Replies
View Related
Aug 22, 2007
Hello,
We have a sql2005 server, wich have 10 databases mirrored. Yesterday we had the following error:
Date 21-08-2007 14:13:18
Log SQL Server (Current - 22-08-2007 13:00:00)
Source Server
Message
Resource Monitor (0x2d18) Worker 0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 88080 KB. Approx CPU Used: kernel 234 ms, user 109 ms, Interval: 60000.
The error cause that one of our databases generated an automatic failover.
Who know what doe'st mean the error?
Could be a memory problem?
Windows 2003 Server R2, Standar x64 SP2
SQL 2005 Standar x64 SP2
4GB RAM,
DELL PowerEdge 2950,
Intel XEON CPU, 1.86 ghz,
thank
View 1 Replies
View Related
Dec 24, 2005
I would like to install MS SQL Management Express, and I would like to make sure I am downloading the right files.
Could you tell me how I can find out whether my PC is 32bit or 64bit?
Many thanks
W aka Gauguin
View 3 Replies
View Related
Aug 10, 2007
Hello all,
I'm going to be upgrading our server hardware that runs SQL2000std, and would like to move to a 64bit windows server 2003 on a 64bit server.
Right now we running it on a windows 20003 server.
with what I read I think I can run SQL2000 std. w/SP4 on a windows 2003 64bit server but would like some one to confirm that for me.
thanks
for your help,
Jason
View 1 Replies
View Related
Sep 18, 2007
Hi All
Can I use Log shipping From 64bit to 32bit in SQL Server2000?
Thanks~
View 1 Replies
View Related
Dec 28, 2007
Having looked at the complexities of transforming data from Oracle in a 64Bit Environment to SQL 2005, will SSIS 2008 run nativley in 64Bit. I understand that SSIS 2005 ran in 32Bit, even when in a 64Bit environment, causing great issues in accessing Oracle. Oracle released an update to compensate for this, however can someone please clarify whether SQL 2008 will have the same issues, or will SSIS 2008 be able to speak with Oracle on a 64Bit level.
Regards
View 3 Replies
View Related
Nov 13, 2006
I have some production boxes on Win 2000 32-bits OS and some production servers have been upgraded to Win2003 64-bit OS runing SQL Server 2005. There are also a number of Win2003 32-bit OS running SQL 2005.
The issue is that when linking the 64-bit production servers to the 32-bit boxes running SQL 2005 / Win 2003 OS, the linking seems to succeed, but I am unable to see a number of entries in sys.objects. Typically, these objects are User Stored Procedures.
Moreover, the linking seemed to have worked, but data extraction does not take place between the servers. However, there are no errors. The objects (user stored procs) exist on the 64-bit side, but linking does not actually happen.
Microsoft KB has addressed this in SQL 2000 case in this KB article, but has not suggested a solution for SQL 2005.
Any ideas? Has anyone else encountered this?
Thanks.
View 1 Replies
View Related
Aug 20, 2003
We have an STD SQL 2k machine which has mounted around 900 databases already. And the limitation is 1024 databases.
according to BOL, "each instance of the SQL server database engine has its own set of system and user databases that not shared between instances.
questions:
1. Does it mean with one default instance and 2 named instances, we could 'break' the 1024 databases limitation to 1024 * 3 = 3072?
2. Does it mean if we upgrade to SQL 2000 32 enterprise or 64 enterprise that would increase the # of databases of 1024 to ...ex 2000?
thanks
David
View 1 Replies
View Related
May 2, 2006
I can't seem to get SQL Server to run on my 64 bit box running Windows XP Pro 64-bit. Is there a fix for this? I really need SQL Server.
View 5 Replies
View Related
Apr 4, 2008
I have SQL 2005 Enterprise 64bit SP2 on windows 2003 EE 64bit SP2 w/24gig memory. My problem is that it wont use more than 110mb of memory according to task manager processes and performance. I've tried messing with the min and max and rebooting each time I make the change and sill nothing. Currently Ive changed it back to default. The server shows up as 24gig so it is seeing the memory. Any ideas? I thought 64bit was supposed to be better about this kind of thing.
Also, AWE has always been unchecked as this is a 64bit box.
View 20 Replies
View Related
May 26, 2008
I m swagatika and working on a s/w company.I am facing some problem in MS SqlServer2005.
my problem is:-
My project is running on SqlServer2005 which is 32 bit support.
But i want to change my project on SqlServer2005 which will be support to 64 bit .
What are the steps i follow to change 32 bit to 64 bit.
can anybody help me?
View 4 Replies
View Related
Apr 24, 2007
This may seem like a completely foolish question, but is there any issue in using the 32bit workstation components (on XP) to connect to the 64bit server-side components? New to SQL2K5 and never had any issues using the 2K workstation/server components together.
Thank you!
View 3 Replies
View Related
Nov 15, 2007
Hi,
I am currently in the process of migrating a BIS DB rom SQL 2000 to SQL 2005. This has involved migrating a whole load of DTS to SSIS. This gone, on the whole, pretty well.
However, I still have one package that doesn't work. This package exports some data to text files AND a to a couple of Excel files. However, the Excel part is not working. I get the following errors:
[Excel Destination [130]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "xls_DirectMail_CampaignFile2" failed with error code 0xC0202009.
[Connection manager "xls_DirectMail_CampaignFile2"] Error: SSIS Error Code DTS_E_OLEDBERROR. 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".
Now, I am guessing that this is because there is no MS Office installation on the server. Would this be correct?
What would be the minimum software requirement to get this working?
Would simply installing Excel be enough?
Thanks,
Simon
View 3 Replies
View Related
